What it is

A bank reconciliation checks your books against the bank's own statement. It is made on Accounts › Reconciliation (the page is titled "Bank Reconciliation": "Reconcile bank statements with your accounts.").

Each reconciliation is for one bank account and one statement date. It shows:

  • Opening Balance and Closing Balance: the figures you type from the bank statement.
  • Book Balance: worked out by DuctArchitect. It is the opening balance of the bank account's account head, plus every approved voucher on that head up to the statement date.
  • Difference: the closing balance less the book balance. It shows red when it is not zero and green when it is zero.

Bank lines

Every bank transaction on the bank account is a line, either added on Banking or posted from a payment. A line is Pending until a reconciliation ticks it, then Reconciled.

  • A reconciled line is never changed by automatic posting. If its document changes, the voucher shows as out of sync on Not Posted instead.
  • The voucher of a reconciled line cannot be cancelled. "This voucher has a reconciled bank entry. Undo the reconciliation before cancelling it."

Where the opening balance comes from

A bank account has no opening balance of its own. Its opening balance is the one on its account head, in Chart of Accounts. See How account groups, heads, ledgers and bank accounts fit together.

How it moves

  1. Draft: New Reconciliation saves it with the book balance and the difference. No line is ticked yet. The Pending card counts drafts.
  2. Completed: in View, you tick the bank lines that are on the statement and select Complete Reconciliation. The ticked lines become Reconciled. The Reconciled card counts completed reconciliations.

See Reconcile a bank account.

Other moves:

  • Delete a draft: the reconciliation leaves the list. Every reconciled line of that bank account goes back to Pending, not only lines of this reconciliation.
  • A completed reconciliation cannot be deleted or reopened on the screen.
  • Complete with a difference: nothing stops you completing a reconciliation with nothing ticked or with a difference that is not zero. Check the Difference first. See A reconciliation shows a difference, or cannot be undone.

Who is involved

RoleWhat they do
Owner and AdminCreate, complete and delete reconciliations. By default they are the only roles with Accounts Management.
A person given Accounts ManagementOpens the page with View on Accounts vouchers, creates and completes reconciliations with Edit, and deletes drafts with Delete.