Skip to main content

Bank Reconciliation

Updated over a month ago

Before you run Bank Reconciliation, you must enter a statement, either manually or automatically. You can report on unreconciled statement items or cash book transactions using the Bank Statement Report or Unreconciled Report.

If you do not want to import bank transactions and do a three way match of payments and receipts, but instead want to have a payment reconciliation and manually tick off cleared cheques.

There are two ways to run bank reconciliation:

  • Automatically using Auto Bank Reconciliation: Coins ERP+ runs a process that matches cheques on your statement with Cash Book transactions with the same cheque number and amount (or the same date and amount if relaxed reconciliation is enabled), or which have a corresponding statement transaction type that is configured to reconcile automatically. Any other transactions remain unreconciled; you will need to reconcile them individually.

  • Reconcile individual transactions using Bank Reconciliation or Single Page Bank Reconciliation: For each transaction on your bank statement, you select the corresponding cash book transactions and match them to the statement items.

You can combine both methods. For example, you can reconcile automatically, then match any un-reconciled items individually.

Configuration

Use the Statement Transaction Types tab in Bank Accounts to set up the transaction types used on statements for each bank account. You can mark specific transaction types to be reconciled automatically (in which case during auto reconciliation, Coins ERP+ creates cash book and General Ledger journals that correspond to transactions of this type).

Did this answer your question?