Bank reconciliation
Reconcile a bank account's statement balance to the ledger at a date
The bank reconciliation compares the closing balance on your bank statement with the bank account's balance in the books at a date, and lists what explains the difference. Open it from Reports → Bank reconciliation.
The statement
Pick the bank account (a ledger account marked as a bank account) and the statement date.
- Statement balance: type the closing balance from the bank statement, or leave it blank to use the running balance of the last uploaded statement line on or before the date.
- Ledger balance: the account's balance in the books at the date.
- Outstanding receipts: money into the bank in the books that isn't on an uploaded statement line yet.
- Unpresented payments: payments in the books that aren't on a statement line yet.
- Statement lines not in the books: uploaded lines up to the date that haven't been approved into the ledger. Approve them under Uploads.
An entry counts as on the statement once a statement line is approved against it, including lines matched to a client payment, a supplier invoice payment or a pay run. An entry and its reversal in the same period cancel out and aren't listed.
The difference is the ledger balance less the statement balance adjusted for those items. It is zero when the account reconciles.
Ticking items as cleared
Some entries are on the bank statement but were never matched, such as an opening balance captured by journal. Tick them as cleared and they drop out of the outstanding items. Ticks on a finalised reconciliation carry forward to later dates.
Saving and finalising
Save draft keeps the reconciliation for the account and date. Finalise (after you confirm) needs a zero difference; a finalised reconciliation can't be changed unless it's reopened. Saved reconciliations are listed under the statement; select one to open it.
The PDF (Export PDF or Preview) is the reconciliation statement for the management pack or the annual financial statements file.
Are you an AI? Visit llms.txt — these docs as plain markdown.