Page Comparison

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.
Image RemovedImage Added

Expand

title	Opening the Bank Reconciliation window

To open the Bank Reconciliation window:

Select Module > General Ledger > Bank Reconciliation from the main menu.
The Select Current Bank Statement Control window is displayed.
Image RemovedImage Added
Tip: You can also access General Ledger functions by clicking Image Removed Image Added.
Click Image RemovedImage Added.
The Create New Bank Statement Control window is displayed.
Image RemovedImage Added
Select the bank account to reconcile using the Bank Code drop-down list, if you have more than one bank account.
Image RemovedImage Added
Either:
• enter the statement control details using details from the bank statement
• accept the current control details if importing using a bank file.
Image RemovedImage Added
Note: Most of the details are usually populated from the previous bank reconciliation.
Click Image Removed Image Added.
The Bank Reconciliation window is displayed.
Image RemovedImage Added

Bank Reconciliation window key fields and buttons
Fields

Field	Description
Unpresented	Display the unpresented general ledger bank transactions in the left pane. Image Removed Image Added
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. Image Removed Image Added You can match general ledger entries with bank entries when these values are equal. For an example, see Manually creating bank transactions to match to a G/L bank transaction (on page ).
Tick & Match	Option used to manually reconcile individual general ledger transactions, which are then added to the right pane. In the following example, a general ledger transaction is being ticked (reconciled) and matched manually using the bank statement. Image Removed Image Added
Manual Match	Option used to match individual transactions on the left and right panes.
Multi Match	Image Removed Image Added Option used to either match several transactions on: The right pane with an individual transaction on the left pane. See Manually creating bank transactions to match to a G/L bank transaction (on page ). The left pane with an individual transaction on the right pane. See Matching two or more G/L transactions to a bank transaction (on page )transaction. Both panes. See Matching two or more G/L transactions to two or more bank transactions (on page ). Note: There are limits to how many G/L transactions or bank statements may be included in a multi-matched statement. See Synergetic Financial Configuration - General tab in the Finance manual.

Buttons

Button	Description
Image RemovedImage Added	Add bank statement transactions manually. These can be used to add one or more bank transactions that correspond to a general ledger transaction. See Manually creating bank transactions to match to a G/L bank transaction (on page ). Image Removed Image Added
Image RemovedImage Added	Delete the selected manual bank statement transactions, if allowed. Note: You cannot delete reconciled transactions, items in red and NYBTA items from a previous bank reconciliation. Manually-entered transactions are initially displayed in a black font while reconciled transactions are displayed in a blue font. In the following example, transactions 8 and 9 were entered manually and either can be deleted. Image Removed Image Added
Image RemovedImage Added	Move the selected transaction before the next transaction. You can change the order of the transactions so that they match the order on the bank statement. In the following example, the 5th entry is being moved before the 4th entry. The Ord fields are renumbered accordingly. Image Removed Image Added Tip: Click the button repeatedly to move the entry up the desired number of lines.
Image RemovedImage Added	Move the selected transaction after the next transaction. You can change the order of the transactions so that they match the order on the bank statement. In the following example, the 4th entry is being moved after the 5th entry. The Ord fields are renumbered accordingly. Image Removed Image Added Tip: Click the button repeatedly to move the entry down the desired number of lines.
Image RemovedImage Added	Remove the selected transaction from the right pane, so that it is no longer reconciled. Image Removed Image Added Tip: You can also double click on the entry in the right pane to remove it.
Image RemovedImage Added	Reconcile the selected transaction and add it to the right pane. Image Removed Image Added Also see the Tick & Match field covered earlier.
Image RemovedImage Added	Match the selected transactions if the Selected values are equal on the left and the right panes. Image Removed Image Added Either match: A single general ledger transaction with a single bank statement transaction. See Reconciling transactions not yet brought to account (on page ). Several transactions to a single transaction. See Manually creating bank transactions to match to a G/L bank transaction (on page ). This button is disabled if the Selected values are different. Image Removed Image Added Tip: You can also press Alt+M to match selected transactions.
Image RemovedImage Added	Reverse the match between the corresponding entries in the left and right panes. Image Removed Image Added
Image RemovedImage Added	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. Synergetic automatically matches transactions when you import a file.
Image RemovedImage Added	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. Tip: You can refresh the grid by right-clicking and selecting Refresh Grid. Image Removed Image Added
Image RemovedImage Added	Find an unpresented general ledger transaction in the left pane using the Find Entry window. Image Removed Image Added To find an unpresented general ledger transaction: Enter one or more search criteria. Click Image Removed Image Added. The first matching entry is highlighted. Image Removed Image Added
Image RemovedImage Added	Load transactions from a bank file and automatically match them with general ledger transactions. See Reconciling bank accounts using imported bank files (on page ).
Image RemovedImage Added	Display the bank reconciliation hints. Image Removed Image Added
Image RemovedImage Added	Change the bank statement control details on the Create Bank Statement Transaction window. Image Removed Image Added For field descriptions, see Manually creating bank transactions to match to a G/L bank transaction (on page ).
Image RemovedImage Added	Display the Select Current Bank Statement Control window. Image Removed Image Added You can: select a current bank reconciliation for a different bank account create a new bank reconciliation.
Image RemovedImage Added	Abandon the current bank reconciliation. For example, you may want to start the reconciliation again. The Abandon Bank Statement window is displayed. Image Removed Image Added Type ABANDON and click Image Removed Image Added.
Image RemovedImage Added	Close off the current bank reconciliation if the bank account is reconciled for the selected period. Tip: You can tell that the current bank reconciliation is reconciled if the following two messages are displayed at the bottom of the window: B/S Reconciled and G/L Reconciled. The following dialog window is displayed. Image Removed Image Added When you click Image Removed Image Added , the Bank Reconciliation report is spooled to your default Synergetic printer. You can then reconcile the next bank account statement or bank file.
Image RemovedImage Added	Close the Bank Reconciliation window if you need to continue doing other tasks. You can return to the reconciliation by selecting the bank reconciliation control from the Select Current Bank Statement Control window. Image Removed Image Added

Unpresented grid area fields (left pane)
Image RemovedImage Added

Field	Description
G/L Date	Date of the posting in the general ledger.
Chq No	Cheque number. The cheque number is blank for transactions not involving a cheque.
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. If Tick and Match is selected: select to reconcile the transaction and add it to the right pane clear this field to unreconcile it and remove it from the right pane. Image Removed Image Added Note: You cannot use the Reconciled flag to match transactions if Manual Match or Multi Match is selected. Select transactions and use the Image Removed Image Added button. Also see the Image Removed Image Added button above.
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)
Image RemovedImage Added

Field	Description
Ord	Order of the bank transaction. It is optional whether you move the transactions into the same order as the bank statement. It depends on the policy at your organisation. See the Image Removed Image Added and Image Removed Image Added buttons above.
Date	Date the deposit or withdrawal occurred against the bank account.
Chq No	Cheque number of any cheque payments. This is blank for transactions that do not involve a cheque.
Description	Description for the: reconciled general ledger transaction manually-entered bank transaction bank transaction not yet brought to account.
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
Image RemovedImage Added

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. Note: Reconciled transactions have the Reconciled flag selected. If a reconciled transaction is selected, the Reconciled field of all matching transactions is highlighted green.
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)
Image RemovedImage Added
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. The total does not include greyed out transactions. That is, unpresented general ledger transactions after the closing date. Image Removed Image Added
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. The total does not include greyed out transactions.
Unpresented Total	Calculated sum of the following fields: Unpresented deposits Unpresented withdrawals.
NYBA	Not Yet Brought to Account total. See Reconciling transactions not yet brought to account (on page ).
B/S Closing Bal	Closing balance of the bank account on the closing date. See Closing Bal in the B/S Reconciliation area below.
Variance	Calculated difference between the following fields: Actual G/L Bank Bal Calc'd G/L Closing Bal. The following message is highlighted in green when this field is zero: G/L Reconciled.
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: B/S Closing Bal Unpresented Total NYBA.

Bank Reconciliation window B/S Reconciliation area (below right pane)
Image RemovedImage Added
If the bank statement is reconciled the following message is highlighted in green: B/S Reconciled.

(on page ).

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. In the following example, a deposit of $2350 has appeared on the bank account. We cannot reconcile it today as we do not have a corresponding general ledger entry. This will be resolved when details come through from the debtor who has paid by EFT before sending in their fees slip. Once this transaction is reconciled the NYBA total drops to zero. Image Removed Image Added See Reconciling transactions not yet brought to account
Anchor
H_20804	H_20804
Total	Net amount calculated as the sum of the following fields: Reconciled dep Reconciled w/d NYBA.
Opening Bal	Opening balance of the bank account on the opening date. This is entered on the Create New Bank Statement Control window. Image Removed Image Added See: Reconciling bank accounts using bank statements (on page ) Reconciling bank accounts using imported bank files (on page ).
Diff	Calculated difference between the following fields: Closing Bal Calc'd Closing Bal. The following message is highlighted in green when this field is zero: B/S Reconciled.
Closing Bal	Closing balance of the bank account on the closing date. This is entered on the Create New Bank Statement Control window. Image Removed Image Added See: Reconciling bank accounts using bank statements (on page ) Reconciling bank accounts using imported bank files (on page ).
Calc'd Closing Bal	Calculated closing balance determined by summing the following fields: Opening Bal Total.

Versions Compared

Old Version 3

New Version Current

Key