The Bank Reconciliation window consists of several areas:
...
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. O_20764 | | |||||||
Delete the selected manual bank statement transactions, if allowed. O_20785 | O_20785 | | ||||||
Move the selected transaction before the next transaction. O_20774 | O_20774Tip: Click the button repeatedly to move the entry up the desired number of lines. | |||||||
Move the selected transaction after the next transaction. O_20773 | O_20773 | Tip: Click the button repeatedly to move the entry down the desired number of lines. Anchor | O_20761 | O_20761 | | |||
Remove the selected transaction from the right pane, so that it is no longer reconciled. O_20772 | O_20772 | Tip: 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. O_20802 | O_20802 | Either match:
Anchor | | |||||
O_20770 | | Reverse the match between the corresponding entries in the left and right panes. O_20805 | O_20805 | Anchor | O_20765 | O_20765 | | |
Automatically match manually | 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. Anchor | | ||||||
O_20766 | | 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. O_20806 | O_20806 | Anchor | O_20767 | | ||
Find an unpresented general ledger transaction in the left pane using the Find Entry window. O_21372 | O_21372 | To find an unpresented general ledger transaction:
| ||||||
Load transactions from a bank file and automatically match them with general ledger transactions. Anchor | | O_20756 | O_20756||||||
Display the bank reconciliation hints. O_21371 | Anchor | O_9143 | O_9143 | | ||||
Change the bank statement control details on the Create Bank Statement Transaction window. O_20786 | O_20786 | For field descriptions, see Manually creating bank transactions to match to a G/L bank transaction (on page ). Anchor | O_20757 | O_20757 | on page ). | |||
Display the Select Current Bank Statement Control window. O_21373 | O_21373 | You can:
Anchor | O_17091 | O_17091 | ||||
Abandon the current bank reconciliation. For example, you may want to start the reconciliation again. O_20808 | Type ABANDON and click . | |||||||
Close off the current bank reconciliation if the bank account is reconciled for the selected period. | ||||||||
O_10556 | O_10556 | | Close the Bank Reconciliation window if you need to continue doing other tasks. O_20769 | O_20769Control window. |
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. O_20759 | O_20759 | and Anchor | O_20760 | O_20760 | buttons above. | |
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 O_20812 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. O_20792 | O_20792 | |
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) O_20790 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. O_20793 | O_20793 | 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:
|
...