Matching two or more G/L transactions to a bank transaction

In the following example, two general ledger (G/L) transactions have been entered but only have one corresponding entry on the bank statement. To reconcile these transactions:

create a bank statement transaction
match the two G/L transactions to the bank statement transaction.

Bank Reconciliation window (cut down)

To match two or more general ledger transactions to a bank transaction:

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.
Get the statement for the bank account.
Enter the statement control fields using details from the bank statement.

Note: Most of the details are usually populated from the previous bank reconciliation.
Click .
The Bank Reconciliation window is displayed.
Identify the entry on the bank statement that corresponds to the G/L transactions.
Click .
The Create Bank Statement Transaction window is displayed.
Enter the details of the bank statement transaction.

Note: See descriptions for the fields and buttons below.
Click .
The transaction is added to right pane.
Select the Multi Match option.
Select the corresponding transactions on the left and right panes.
The button is enabled if the Selected values are equal.
Click .
The matched transactions are highlighted in green.
Continue reconciling transactions and close off. See Reconciling bank accounts using bank statements.

Create Bank Statement Transaction window key fields and buttons

Fields

Field	Description
Transaction Date	Date that the transaction was applied to the bank account.
Description	Description of the bank transaction to distinguish individual transactions. Tip: Include a suitable suffix to the Description field, such as Part 1, to distinguish transactions if several bank transactions are being added.
Amount	Amount of the deposit or withdrawal expressed in dollars and cents. Enter withdrawals as negative amounts.
Cheque Number / Ref	Depending on the transaction, you can optionally add either the: cheque number EFT reference number.
BSB	Six digit Bank State Branch number that uniquely identifies the bank, State and branch.
Account Number	Unique number that identifies the bank account of the debtor or creditor.

Buttons

Button	Description
	Add the manually-entered transaction to the right pane, using the details entered on the Create Bank Statement Transaction window.
	Click when you have finished adding each manually-entered transaction to the right pane. You can then match the manually-entered transaction(s) to the corresponding general ledger transaction(s).

Button

Description

Add the manually-entered transaction to the right pane, using the details entered on the Create Bank Statement Transaction window.

Create Bank Statement Transaction (populated) n.b. graphics output problem

Click when you have finished adding each manually-entered transaction to the right pane.

You can then match the manually-entered transaction(s) to the corresponding general ledger transaction(s).

Last modified: 5/03/2013 12:39:48 PM