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.
...
| Expand | ||
|---|---|---|
| ||
To open |
...
the Bank Reconciliation |
...
window: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
.gif)
...
|
...
|
...
|
...
|
...
|
...
|
.gif)
...
|
.gif)
...
|
...
|
...
|
...
|
...
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. |
|
.gif)
. | |
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 |
.gif)
|
.gif)
|
|
Buttons
Button | Description |
|---|
| Add bank statement transactions manually. |
.gif)
. |
| |
| Delete the selected manual bank statement transactions, if allowed. |
.gif)
|
.gif)
| Move the selected transaction before the next transaction. |
.GIF)
|
.gif){kind=spacer}
| Move the selected transaction after the next transaction. |
.gif)
|
.gif){kind=spacer}
Tip:
| Remove the selected transaction from the right pane, so that it is no longer reconciled. |
.gif)
|
.gif)
| Reconcile the selected transaction and add it to the right pane. |
.gif)
|
| Match the selected transactions if the Selected values are equal on the left and the right panes. |
.gif)
|
|
|
|
.gif)
Reverse the match between the
| 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. |
.gif)
.gif)
| 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. |
.gif)
|
.gif)
Find an unpresented
| Find an unpresented general ledger transaction in the left pane using the Find Entry window. |
.gif)
|
.gif)
|
.gif)
| Load transactions from a bank file and automatically match them with general ledger transactions. |
. |
Display the bank
| Display the bank reconciliation hints. |
| |
| Change the bank statement control details on the Create Bank Statement Transaction window. |
.gif)
|
. |
| Display the Select Current Bank Statement Control window. |
|
.gif)
| |
| 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. |
|
.gif)
Unpresented grid area fields (left pane)Anchor
).gif)
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)Anchor
.gif)
Field | Description |
|---|---|
Ord | Order of the bank transaction. |
See the
and . | |
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. |
LegendAnchor
.gif)
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)Anchor
.gif)
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. |
.gif)
. | |
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)Anchor
below right pane).gif)
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. |
.gif)
. | |
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:
|