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.
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. |
Amount | Amount of the deposit or withdrawal expressed in dollars and cents. |
Cheque Number / Ref | Depending on the transaction, you can optionally add either the:
|
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. |