The Bank Reconciliation window consists of several areas:
- A left pane which:
- usually displays unpresented general ledger bank transactions before the closing date entered earlier
- can be used to display presented general ledger bank transactions.
- A totals area below the left pane, summarising the general ledger bank transactions.
- A right pane which displays:
- bank transactions reconciled with corresponding general ledger transactions (in the left pane)
- manually-entered bank transactions, not yet matched to a general ledger transaction
- manually-entered bank transactions, matching several bank entries to one general ledger transaction
- bank transactions not yet brought to account (NYBA).
- A totals area below the right pane, summarising the bank transactions.
Bank Reconciliation window key fields and buttons
Fields
Field | Description |
---|---|
Unpresented | Display the unpresented general ledger bank transactions in the left pane. |
Presented | Display the presented general ledger bank transactions in the left pane. |
Selected | Two values are displayed. Each one totals the selected transactions in the corresponding pane. |
Tick & Match | Option used to manually reconcile individual general ledger transactions, which are then added to the right pane. |
Manual Match | Option used to match individual transactions on the left and right panes. |
Multi Match |
|
Buttons
Button | Description |
---|---|
Add bank statement transactions manually. | |
Delete the selected manual bank statement transactions, if allowed. | |
Move the selected transaction before the next transaction. | |
Move the selected transaction after the next transaction. | |
Remove the selected transaction from the right pane, so that it is no longer reconciled. | |
Reconcile the selected transaction and add it to the right pane. | |
Match the selected transactions if the Selected values are equal on the left and the right panes.
| |
Reverse the match between the corresponding entries in the left and right panes. | |
Automatically match manually-entered bank transactions with the general ledger transactions in the left pane. For example, Synergetic can match transactions based on the common cheque numbers. | |
Refresh the left pane so that the latest general ledger bank transactions are displayed. This is useful if other people are adding entries while you are doing the bank reconciliation. | |
Find an unpresented general ledger transaction in the left pane using the Find Entry window.
| |
Load transactions from a bank file and automatically match them with general ledger transactions. | |
Display the bank reconciliation hints. | |
Change the bank statement control details on the Create Bank Statement Transaction window. | |
Display the Select Current Bank Statement Control window.
| |
Abandon the current bank reconciliation. For example, you may want to start the reconciliation again. | |
Close off the current bank reconciliation if the bank account is reconciled for the selected period. | |
Close the Bank Reconciliation window if you need to continue doing other tasks. |
Unpresented grid area fields (left pane)
Field | Description |
---|---|
G/L Date | Date of the posting in the general ledger. |
Chq No | Cheque number. |
Description | Description from the cheque, EFT or receipts posting. |
Deposits | Amount of the deposit or transaction that increases the bank account current balance. |
Withdrawals | Amount of the withdrawal or transaction that decreases the bank account current balance. |
Reconciled | If selected, this transaction has been reconciled.
|
Posting No | Posting number for the transaction. |
Posting Source | Source of the posting. |
Chq Date | Date of the cheque if the transaction involves a cheque. |
Cancelled | Selected if the cheque has been cancelled. |
GLBTSeq | A unique number to identify the General Ledger Bank Transaction. |
Bank transactions grid area fields and legend (right pane)
Field | Description |
---|---|
Ord | Order of the bank transaction. |
Date | Date the deposit or withdrawal occurred against the bank account. |
Chq No | Cheque number of any cheque payments. |
Description | Description for the:
|
Deposits | Amount if the transaction is a deposit or a transaction that increases the bank account current balance. |
Withdrawals | Amount if the transaction is a withdrawal or a transaction that decreases the bank account current balance. |
Reconciled | If selected, the transaction has been reconciled. |
Legend
Font | Background | Description |
---|---|---|
Red | White | NYBA bank transactions, such as when fees have been paid into the account by EFT before the slip has been received and entered. |
Blue | White | Reconciled transactions. Also includes manually-entered bank transactions that have been matched. |
Black | White | Manually-entered bank transactions that have not been matched. |
White | Blue | Currently selected record. |
Bank Reconciliation window G/L Reconciliation area (below left pane)
If the general ledger bank transactions are reconciled the following message is highlighted in green: G/L Reconciled.
Field | Description |
---|---|
Unpresented deposits | Total amount of unpresented deposits in the left pane prior to the Closing Date specified on the Create New Bank Statement Control window. |
Unpresented withdrawals | Total amount of unpresented withdrawals in the left pane prior to the Closing Date specified on the Create New Bank Statement Control window. |
Unpresented Total | Calculated sum of the following fields:
|
NYBA | Not Yet Brought to Account total. |
B/S Closing Bal | Closing balance of the bank account on the closing date. |
Variance | Calculated difference between the following fields:
|
Actual G/L Bank Bal | Actual general ledger bank closing balance. |
Calc'd G/L Closing Bal | Calculated general ledger bank closing balance. This is the calculated sum of the following fields:
|
Bank Reconciliation window B/S Reconciliation area (below right pane)
If the bank statement is reconciled the following message is highlighted in green: B/S Reconciled.
Field | Description |
---|---|
Reconciled dep | Total amount of reconciled deposits in the right pane. |
Reconciled w/d | Total amount of reconciled withdrawals in the right pane. |
NYBA | Not Yet Brought to Account total. |
Total | Net amount calculated as the sum of the following fields:
|
Opening Bal | Opening balance of the bank account on the opening date. |
Diff | Calculated difference between the following fields:
|
Closing Bal | Closing balance of the bank account on the closing date. |
Calc'd Closing Bal | Calculated closing balance determined by summing the following fields:
|