Bank reconciliation is the most underrated discipline in bookkeeping. It catches errors, deters fraud, surfaces missing income, and turns a chaotic year-end into a routine review. Yet most small businesses either skip it or do it once a quarter when the panic kicks in. This guide shows you how to reconcile properly, in ten minutes a week.
What reconciliation actually does
It compares two records of the same thing — your bank statement and your bookkeeping software — and confirms they agree to the penny. If they don't, the difference is investigated until it's explained. Done weekly, this is a low-effort check. Done annually, it becomes archaeology.
The three things reconciliation catches
- Missing transactions. A direct debit your software didn't pick up, a refund the bank processed late, a card payment that hasn't synced.
- Duplicate transactions. Common when a manual entry meets an auto-feed entry for the same payment.
- Miscoded transactions. The amount matches the bank, but the category is wrong — and only a human eye spots that.
The weekly ten-minute routine
Pick a fixed day — most of our clients use Monday morning. Open your cloud bookkeeping software, go to the bank account, and work through the unreconciled feed entries:
- Match each line to the correct customer, supplier, or category.
- Apply bank rules where transactions repeat (more on this below).
- Reconcile to the closing balance on the statement.
- Investigate any transaction you don't recognise — fast, while you can still remember the week.
For most SMEs, fewer than 50 lines per week. Done in a coffee.
Bank rules: the multiplier
Bank rules automate the boring 80%. Set a rule that says "any payment containing 'GOOGLE' and under £100 codes to Software Expense, 20% VAT" and Xero or QuickBooks will pre-classify every future Google bill. Spend an hour building rules in month one, and your weekly reconciliation drops to five minutes. We help clients build rule libraries on every implementation we do — see how we approach this in our bookkeeping service.
The five rules that pay for themselves
- Bank fees auto-code to bank charges, no VAT.
- HMRC payments auto-code to the relevant liability (VAT, PAYE, Corporation Tax).
- Director personal spending auto-code to Director's Loan if you sometimes use the wrong card.
- Recurring subscriptions (Adobe, Microsoft, Slack) auto-code to Software with 20% VAT.
- Card refunds auto-code to a refunds clearing account so they don't inflate income.
What "reconciled" actually means in software
In Xero and QuickBooks, "reconciled" means a transaction has been matched, coded, and confirmed. The little tick mark is the audit trail. Pay attention to partially reconciled periods — they look done but have stragglers. Always reconcile to a real statement, not to the running balance shown on the cloud dashboard, because feeds can lag or duplicate.
When the numbers don't agree
If your reconciled balance and the bank statement disagree, work through this checklist:
- Check for duplicate entries (most common cause).
- Check for transactions with the wrong date.
- Check for unmatched transfers between accounts.
- Check for foreign currency rounding (Wise, Stripe, PayPal especially).
- Check for old unreconciled items dragging from prior months.
If you still can't find it after 20 minutes, stop digging and ask your accountant. It's almost always one of the five above.
Reconciling non-bank accounts
Bank reconciliation gets the attention, but the same discipline applies to credit cards, loan accounts, PayPal, Stripe, Wise, and any merchant account. Each is a separate ledger that needs to match its statement. We see businesses with clean bank reconciliations but unreconciled Stripe accounts hiding £20k of mis-coded fees. If you take card payments, treat the Stripe or GoCardless reconciliation as equally important.
Why this matters for tax
A VAT return drawn from unreconciled books is unreliable. So is a corporation tax return, a financing application, or any KPI you try to make a decision on. Reconciliation isn't admin — it's the truth check that everything else depends on. Our VAT compliance team won't file a return from books that haven't been reconciled, and most reputable accountants take the same stance.
The director's role
If your bookkeeper handles reconciliation, you don't need to do it. But ask for a monthly "reconciliation status" report: are all accounts reconciled, are there old unreconciled items, and what's the explanation. A bookkeeper who can't answer that confidently is a red flag.
Reconcile weekly, build rules in month one, and your books will tell the truth all year. Skip it and your year-end becomes a forensic exercise. The choice is genuinely that simple.