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.
Headline figures, charts and an action list of what to fix first, then the tabs where the work happens. Shown here with the worked example that comes with your download.

Real screenshot of the Overview tab. Every figure is calculated by the workbook.
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.
Practical guides on the problem this system solves. Free to read, no sign-up.
A step-by-step bank reconciliation in Excel: the layout, matching formulas, adjusting both balances, ageing open items and the review that makes it a control.
Read the guide →Match bank, ledger or supplier transactions in Excel with a matching key, COUNTIFS and XLOOKUP, including repeated amounts, and list what is left unmatched.
Read the guide →How to run balance sheet reconciliations every month: account ownership, risk rating, the evidence each account needs, handling reconciling items and review.
Read the guide →Run the free check on your own numbers today. If it finds gaps, this system closes them every period.
12 questions on how strong your close controls are. Free to use online.
Use the free toolClose 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 →