Grid Fields Bank Reconciliation

Grid Fields

Use this portion of the Bank Reconciliation tab to select deposits and withdrawals for reconciliation. The grid includes all transactions that affect the balance of the general ledger cash account.

For more information on the grid, refer to Reconcile Process for more information.

Reconcile All

Select this check box if you want all transactions in the grid included in the reconciliation. When you select this option, the system automatically adds a checkmark to each transaction in the grid.

Select this check box again if you want to remove checkmarks from all transactions in the grid.

Find [Column Title]

This field defaults to Document ID; however, if you click any underlined grid column title, the field label changes to reflect your selection. You can then search for entries based on the field label. For example, if you know the entry transaction code, click the Tran Code column title and the find field label changes to Find Tran
Code.

Enter the first few letters or numbers to search for (or select from a drop-down list if one displays), and then select the Find button. The items that are the nearest match to your entry display in the grid below. Click column titles to sort the list further.

Refresh

Click to update entries in the grid. Typically, you select this button after you complete Bank Statement Information fields. For example, if you enter starting and ending check numbers, selecting the Refresh button causes checks with those numbers to display in the grid below.

Use the Page field and the Go button to display additional pages when the list of entries in the grid is longer than one page.

Reconcile

Click a box to add or remove the checkmark and add or remove that transaction from the reconciliation process. Refer to the Reconcile All check box above. Checked transactions are included while unchecked transactions are excluded from the reconciliation.

Tran Code

The transaction code that describes the transaction. Click this column title to sort the list and change the Find field.

Document ID

The identification of the document used to generate the transaction. For example, a document identification that starts with JE is a journal entry document. Click this column title to sort the list and change the Find field.

Date

The date of the document used to generate the transaction. Click this column title to sort the list and change the Find field.

Description

The description of the document used to generate the transaction. For journal entries that affect cash, the journal entry identification displays as the description. Click this column title to sort the list and change the Find field.

Deposit

The total amount of funds deposited for a deposit, interest, or adjustment. If the transaction resulted in a deposit to the account, an amount appears. Otherwise, the field displays $0.00. Click this column title to sort the list and change the Find field.

Withdrawal

The total amount of funds withdrawn for a check, direct deposit advice, service charge, or adjustment. If the transaction resulted in a withdrawal from the account, an amount appears. Otherwise, the field displays $0.00. Click this column title to sort the list and change the Find field.