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:
|
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article