BasisBasis
Transactions

Bank Reconciliation

Import your bank statement and match each bank transaction against GL entries. Identify timing differences and uncleared items. Finalize once the difference is zero.

Menu: Transactions → Bank Reconciliation · Route: /bank-reconciliation

Bank reconciliation list

Reconciliation Process

The process has two stages: Import the bank statement, then Match each statement line to a GL entry.

Step 1 — Import a Bank Statement

Click New / Import Statement on the Bank Reconciliation list page.

  1. Select the Bank / Cash Account to reconcile (only Cash and Bank sub-type accounts are shown).
  2. Enter a Statement Reference (e.g., "BCA January 2026") to identify this reconciliation.
  3. Set the From Date and To Date covering the statement period.
  4. Enter the Opening Balance (the balance at the start of the period from your bank statement).
  5. Enter the Closing Balance (the balance at the end of the period from your bank statement).
  6. Add statement lines: click Add Line and enter each transaction's date, description, and amount (positive = deposit, negative = withdrawal).
  7. Click Import Statement. You are taken directly to the matching work page.
Bank reconciliation import

Import fields

FieldStatusNotes
Bank / Cash AccountRequiredThe GL account matching your bank account. Only Cash and Bank accounts shown.
Statement ReferenceRequiredA unique name for this statement import, e.g., "BCA Jan 2026".
From Date / To DateRequiredThe period covered by the bank statement.
Opening BalanceOptionalBalance at start of period per bank statement. Used to compute the difference.
Closing BalanceOptionalBalance at end of period per bank statement.
Statement LinesOptionalIndividual transactions from the statement. Amount: positive = inflow, negative = outflow.

Step 2 — Match on the Work Page

The work page shows the bank statement lines on the left and unreconciled GL entries on the right. Four stat cards at the top show Opening Balance, Statement Movement, Closing Balance, and the current Difference.

  1. Click a statement line on the left panel to select it (highlighted in blue).
  2. Click the matching GL entry on the right panel. The pair is matched and both items are marked as reconciled.
  3. Continue matching until all statement lines are paired.
  4. The Difference card shows: Closing Balance − Opening Balance − net GL movement. When this reaches zero, the Finalize button becomes active.
  5. Click Finalize to lock the reconciliation. Finalized statements cannot be edited.
docs/bank-reconciliation-work.png
If a GL entry doesn't match any statement line (timing difference — e.g., a cheque issued but not yet cleared), leave it unmatched. It will appear as an outstanding item on future reconciliations.
Once a reconciliation is finalized it is locked. If you need to correct an error, create a new reconciliation for the same account covering the corrected period.
  • Payments — GL entries that appear on the right panel as outflows
  • Receipts — GL entries that appear on the right panel as inflows
  • Contra Entries — inter-bank transfers visible in reconciliation
  • Journal Entries — any direct bank account adjustments