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.
...
- transactions.
Expand | ||
---|---|---|
| ||
To open |
...
the Bank Reconciliation |
...
window: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
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.
Tip: Click the button repeatedly to move the entry up the desired number of lines. | |||||||||||||||||||
Move the selected transaction after the next transaction.
Tip: Click the button repeatedly to move the entry down the desired number of lines. | |||||||||||||||||||
| Remove the selected transaction from the right pane, so that it is no longer reconciled.
Tip: You can also double click on the entry in the right pane to remove it. | ||||||||||||||||||
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.
Either match:
| |||||||||||||||||||
| 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.
To find an unpresented general ledger transaction:
| ||||||||||||||||||
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.
For field descriptions, see Manually creating bank transactions to match to a G/L bank transaction (on page ). | ||||||||||||||||||
| Display the Select Current Bank Statement Control window.
You can:
| ||||||||||||||||||
| Abandon the current bank reconciliation. For example, you may want to start the reconciliation again.
Type ABANDON and click . | ||||||||||||||||||
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)
Anchor | ||||
---|---|---|---|---|
|
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 | ||||
---|---|---|---|---|
|
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
Anchor | ||||
---|---|---|---|---|
|
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 | ||||
---|---|---|---|---|
|
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)
Anchor | ||||
---|---|---|---|---|
|
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.
See Reconciling transactions not yet brought to account
| ||||||||||||
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:
|
Opening the Details tab