Bank Reconciliation Entry - Field Descriptions

Use this table for reference when completing the fields on this screen.

Field/Button

Description

Header

Bank account

Enter the bank account code. If the code is found, the software automatically brings up the record for editing. If the bank account code is not found, the software automatically proceeds to the new entry based on the bank account.

The software verifies that the entry in this field is a bank account. Entry of a non-bank account code is disallowed. If you are not authorized to use the bank account code you select, an error message will appear and the entry will be cleared.

G/L date

Enter the General Ledger period-end date, or press Enter to accept the default. The corresponding Fiscal year and Period will display to the right of this field.

This date should always be the period-end date. Based on this date, all the transactions for deposits and checks display through this year and period. This allows reconciliation to the period-end date for the General Ledger cash balance. The transactions that are not marked as cleared will be summed for the uncleared amount that is used for reconciling the General Ledger balance.

Statement date

Enter the bank statement date. This date should always be the same as or before the General Ledger date.

Statement reconciliation

Opening balance

The opening account balance defaults from the last posted statement ending balance.

Ending balance

The ending bank account balance (per bank statement) displays.

Calculated balance

The calculated bank account balance (per bank statement) displays.

Difference

The difference between the ending balance (per bank statement) and calculated balance (per reconciliation) displays.

General ledger reconciliation

G/L opening balance

The prior period's ending balance displays in this field.

G/L ending balance

The ending G/L balance displays.

Calculated balance

The calculated bank account balance (per reconciliation) displays.

Difference

The difference between the G/L ending balance and the Calculated balance (per reconciliation) appears.

Deposits / additions summary

Cleared

The total number of cleared and uncleared deposits and amounts will display in this section.

Uncleared

Checks / deductions summary

Cleared

The total number of cleared and uncleared checks and amounts will display in this section.

Uncleared

Details

Select All / Clear All

Click these buttons to select or deselect all deposit lines for reconciliation. Deposit lines may also be marked as cleared individually in the detail grid.

Advanced button

Click this button to open the Advanced Selections window to filter the deposit lines that appear in the listbox.

Selections in this window will remain in effect as long as the Operator remains in the selected bank account.

Refresh button

Click this button to refresh the listbox results. This will allow any adjustments updated in another tab to appear.

Status button

Click this button to display the status of deposit lines on this tab: All, Uncleared, Cleared or None.

Deposits tab

The deposit line transactions will display on this tab. To mark a deposit line as cleared, highlight the applicable transaction line and then select the Cleared check box.

Tip: When clearing checks, use the Space bar to select checks quickly.

Checks tab

Select this tab to display the check line transactions.The functions on this tab will work exactly the same as those on the Deposits tab. Use this window to record or edit the date a reconciled check cleared the bank and the bank clearing account. This date will also appear in the 'Bank cleared' column on this tab.