The bank balance and the cashbook agree by coincidence, not by control.
A bank reconciliation that balances doesn't mean every transaction was coded correctly — two errors can cancel each other out and the total still looks clean. That is exactly how a miscoded transaction sits in the cashbook for months without anyone noticing.
This bank reconciliation template covers five bank accounts across eight transaction categories, with an allocation check that confirms every transaction is coded before the reconciliation is treated as clean — and real date fields throughout, so ageing and monthly reporting actually work.
Replaces the single-account bank rec tab that gets copied and renamed every month.
Built for bookkeepers and accountants reconciling several bank accounts to the cashbook every month.
It handles five bank accounts in one workbook. For separate entities, run one copy per entity — the single-organisation licence covers unlimited copies inside your own organisation.
Every system is built as a standard Excel (.xlsx) workbook using formulas only — no macros, no add-ins, nothing to install. Because there are no macros, the files also open in Google Sheets and LibreOffice.
Checkout is processed by Paddle. Within a few minutes of payment clearing, your download links are emailed automatically from info@appiqfinance.com. You get the blank master workbook and a fully worked example.
Report it within 14 days with the file, tab and cell, and we fix it and redeliver — or refund you in full if we can't. See the refund policy for the exact terms.
Close finishes when the file gets sent, not when the numbers are proven right.
View system →The first place a duplicate payment gets caught is the bank statement.
View system →Your cash is sitting in a customer's bank account, and nobody can say for how many days.
View system →