Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Anchor
O_21379
O_21379
Image Removed Image Added

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

  1. 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.
  2. Click Image Removed Image Added.
    The Create New Bank Statement Control window is displayed.
    Image RemovedImage Added
  3. Select the bank account to reconcile using the Bank Code drop-down list, if you have more than one bank account.
    Image RemovedImage Added
  4. Get the statement for the bank account.
  5. Enter the statement control fields using details from the bank statement.
    Image RemovedImage Added
    Note: Most of the details are usually populated from the previous bank reconciliation.
  6. Click Image Removed Image Added.
    The Bank Reconciliation window is displayed.
    Image RemovedImage Added
  7. Identify the entry on the bank statement that corresponds to the G/L transactions.
  8. ClickImage RemovedImage Added.
    The Create Bank Statement Transaction window is displayed.
  9. Enter the details of the bank statement transaction.
    Image RemovedImage Added
    Note: See descriptions for the fields and buttons below.
  10. Click Image Removed Image Added.
    The transaction is added to right pane.
    Image RemovedImage Added
  11. Select the Multi Match option.
    Image RemovedImage Added
  12. Select the corresponding transactions on the left and right panes.
    The Image Removed Image Added button is enabled if the Selected values are equal.
    Image RemovedImage Added
  13. Click Image Removed Image Added.
    The matched transactions are highlighted in green.
    Image RemovedImage Added
  14. Continue reconciling transactions and close off. See Reconciling bank accounts using bank statements (on page ).


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

Image RemovedImage Added

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

Image Added

ClickImage Removed Image Added 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).