Using the Bank Reconciliation window

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.

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.

Tip: You can also access General Ledger functions by clicking .

Click .

The Create New Bank Statement Control window is displayed.

Select the bank account to reconcile using the Bank Code drop-down list, if you have more than one bank account.

Either:

enter the statement control details using details from the bank statement
accept the current control details if importing using a bank file.

Note: Most of the details are usually populated from the previous bank reconciliation.

Click .

The Bank Reconciliation window is displayed.

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. 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.
Manual Match	Option used to match individual transactions on the left and right panes.
Multi Match	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 ). 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
	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 ).
	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.
	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. Tip: Click the button repeatedly to move the entry up the desired number of lines.
	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. 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. Also see the Tick & Match field covered earlier.
	Match the selected transactions if the Selected values are equal on the left and the right panes. 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. Tip: You can also press Alt+M to match selected transactions.
	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. Synergetic automatically matches transactions when you import a file.
	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.
	Find an unpresented general ledger transaction in the left pane using the Find Entry window. To find an unpresented general ledger transaction: Enter one or more search criteria. Click . The first matching entry is highlighted.
	Load transactions from a bank file and automatically match them with general ledger transactions. See Reconciling bank accounts using imported bank files (on page ).
	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: select a current bank reconciliation for a different bank account create a new bank reconciliation.
	Abandon the current bank reconciliation. For example, you may want to start the reconciliation again. The Abandon Bank Statement window is displayed. Type ABANDON and click .
	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. When you click , the Bank Reconciliation report is spooled to your default Synergetic printer. You can then reconcile the next bank account statement or bank file.
	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.

Unpresented grid area fields (left pane)

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. Note: You cannot use the Reconciled flag to match transactions if Manual Match or Multi Match is selected. Select transactions and use the button. Also see the 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)

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 and 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

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)

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.
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)

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. 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. See Reconciling transactions not yet brought to account (on page ).
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. 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. 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.