What Is Bank Reconciliation? The Complete Guide for 2026
Your bank keeps its version of events. You keep yours. Bank reconciliation is where you sit them both down and make them agree.
Bank reconciliation is the process of comparing an organisation's internal accounting records against its bank statement to verify that every transaction is accounted for and the closing balances agree. ReconcileIQ automates this process using a C++ matching engine that handles over 5,000 transactions per second.
What bank reconciliation actually is
Bank reconciliation is the process of checking that your accounting records match your bank statement. That's it. Everything else is commentary.
More specifically: you take the balance your bank says you have, you take the balance your own books say you have, and you work out why those two numbers are different. Then you either fix the difference or confirm that it's a timing issue that will sort itself out.
The two numbers are almost never identical on any given day. That's normal. Your books might show a payment you made yesterday, but the bank hasn't processed it yet. Or the bank has charged you a fee that you haven't recorded. The point of reconciliation is to account for every single one of those differences so you know, with certainty, how much money you actually have.
Think of it as a cross-reference. Your bank keeps its version of events. You keep yours. Bank reconciliation is where you sit them both down and make them agree.
If you've ever checked your bank balance online, noticed it didn't match what you expected, and then scrolled through recent transactions trying to figure out why - congratulations. You've done an informal bank reconciliation. The formal version is the same thing, just more thorough and with a paper trail.
Why it matters
If that sounds tedious, that's because it is. But so is checking your parachute before jumping out of a plane, and nobody questions the value of that.
Here's what happens when you don't reconcile:
You make decisions based on wrong numbers
Suppose your books show £14,200 in the bank, so you approve a £6,000 equipment purchase. But your actual bank balance is £9,800 because three client payments you recorded last week bounced, and you never noticed. You've just overdrawn your account.
Fraud goes undetected
A 2024 report from the Association of Certified Fraud Examiners found that the median small business fraud case runs for 18 months before detection. Regular reconciliation is one of the most basic controls that catches unauthorised transactions early. If someone is siphoning £200 a month from your account, you'll spot it when the bank statement shows a payment you never made.
Year-end becomes a nightmare
Every accountant has a horror story about a client who shows up in January with a carrier bag full of receipts and twelve months of unreconciled bank statements. Fixing a year's worth of discrepancies in one go is exponentially harder than fixing a month's worth each month. Small errors compound. By month twelve, you're not reconciling - you're doing archaeology.
Tax filings become unreliable. If your records don't match reality, your VAT returns or Self Assessment filings are built on sand. HMRC takes a dim view of that.
You lose track of who's paid you. Without reconciliation, it's easy to miss that a customer's payment bounced or that an invoice is still outstanding. You end up chasing money you've already received, or worse, not chasing money you haven't.
The step-by-step process
Here's how to do a bank reconciliation manually. Even if you use software, understanding the manual process is worth the five minutes, because it means you'll actually understand what the software is doing (and you'll know when it gets something wrong).
Get your two documents ready
You need your bank statement for the period (download from your bank - PDF or CSV) and your cash book or accounting ledger for the same period. Make sure they cover the same date range. Reconciling January's bank statement against February's cash book is a fast track to confusion.
Start with the closing balances
Write down the closing balance on the bank statement (e.g., £12,450.00) and the closing balance in your cash book (e.g., £11,875.00). Difference: £575.00. Your job is to explain every penny of that £575.
Work through the bank statement, line by line
Tick each transaction off against the corresponding entry in your cash book. Anything on the bank statement that's NOT in your cash book needs recording.
Work through your cash book for items NOT on the bank statement
These are usually timing differences: outstanding cheques, deposits in transit, pending card payments.
Adjust both balances and check they match
Build your reconciliation statement (see the worked example below).
Record your adjustments
Any items you discovered need to be properly posted in your accounting system. The bank fee isn't just a reconciliation note - it's a real transaction.
File the reconciliation
Print it, save it, screenshot it - whatever your process is. Your accountant will want to see it. So will an auditor, if it ever comes to that.
Common bank statement items to record
Worked example
Bank statement closing balance: £12,450.00. Cash book closing balance: £11,875.00. Difference: £575.00.
Adjusted Bank Balance
Adjusted Cash Book Balance
Both adjusted balances are £12,175.00. The reconciliation balances. If they don't match, something's been missed - go back through the bank statement and cash book.
Common reconciliation issues and how to resolve them
Timing differences
The most common reason for a mismatch, and the least alarming. You recorded something before the bank did, or vice versa. Outstanding cheques and deposits in transit are the classic examples. These aren't errors - they're just the natural lag between making a transaction and the bank processing it.
Watch out for items that stay on the "outstanding" list month after month. A cheque that's been outstanding for 90+ days probably isn't going to clear. Under UK law, cheques become stale after six months.
Transposition errors
You recorded £1,530 but the actual amount was £1,350. The digits got swapped. There's an old bookkeeping trick for spotting these: if the difference between your two balances is divisible by 9, there's a good chance a transposition error is the culprit. (£1,530 - £1,350 = £180. £180 ÷ 9 = 20. Bingo.)
Duplicates
The same transaction appears twice in your records. This happens more often than you'd think, especially when you're using bank feeds. Your software auto-imports a transaction AND you've already entered it manually. Now it's in there twice.
Bank errors
Rare, but they happen. The bank posts a transaction to the wrong account, processes a payment twice, or applies fees that shouldn't apply. Contact the bank. Get it in writing. Keep the correspondence with your reconciliation records.
Foreign currency transactions
If you receive or make payments in foreign currencies, the amount that actually hits your bank account depends on the exchange rate on the day of processing - not the rate on the day you raised the invoice. Record the actual amount received/paid, and post the difference to a foreign exchange gains/losses account.
How often should you reconcile?
Monthly (the minimum)
If you process fewer than 100 transactions a month and your cash flow is relatively predictable, monthly reconciliation is fine. It aligns with your bank statement cycle, and it's the frequency most accountants expect as a baseline.
Weekly
If you're processing hundreds of transactions, taking card payments, or running payroll mid-month, weekly reconciliation catches problems before they multiply. A discrepancy is much easier to investigate when it happened four days ago rather than four weeks ago.
Daily
High-volume businesses - retailers, e-commerce sellers, hospitality - benefit from daily reconciliation. When you're processing thousands of transactions a week across multiple payment methods, waiting a month is asking for trouble. Daily reconciliation at this scale almost certainly means automated reconciliation.
The Real Rule
Reconcile frequently enough that when something goes wrong, you find it quickly. If you reconcile monthly and a fraudulent payment goes out on the 2nd, you won't catch it until the 30th. Weekly cuts that window to seven days. Daily cuts it to one. The more money flows through your accounts, the more frequently you should reconcile.
Manual vs automated reconciliation
Manual reconciliation
Works fine for small businesses with straightforward banking. One bank account, under 50 transactions a month, no foreign currency - a manual reconciliation in a spreadsheet takes perhaps 30 minutes to an hour.
Pros: No software cost. You understand every transaction intimately. Full control.
Cons: Time-consuming as volume grows. Prone to human error (especially transposition mistakes). Doesn't scale - 500 transactions a month in a spreadsheet is miserable.
Automated reconciliation
Software imports your bank statement and matches transactions against your accounting records automatically, flagging anything it can't match for your review. Most modern accounting platforms (Xero, QuickBooks, Sage, FreeAgent) include some form of bank reconciliation. Dedicated tools like ReconcileIQ handle more complex scenarios - multiple file formats, fuzzy matching on descriptions, and tolerance for timing differences - which helps when your bank and your books describe the same transaction in completely different ways.
Pros: Dramatically faster (minutes instead of hours). Reduces human error. Makes daily reconciliation practical. Handles high volumes without breaking a sweat.
Cons: Requires some setup. Still needs human review of unmatched items. Costs money (though usually far less than the time it saves).
Which should you choose?
If you have one bank account and fewer than ~50 transactions a month, manual is fine. Above that, the time cost of manual reconciliation starts to outweigh the cost of a tool. And once you're juggling multiple bank accounts, payment processors, or currencies, manual reconciliation goes from tedious to genuinely impractical.
Bank reconciliation for different business types
Bank reconciliation is universal, but the specific challenges vary by industry.
E-commerce
E-commerce reconciliation is, frankly, a headache. The core problem: the amount a customer pays is not the amount that lands in your bank account. Between payment processor fees (Stripe takes 1.4% + 20p per transaction in the UK, for example), platform fees (Amazon, eBay, Etsy all take their cut), refunds, chargebacks, and settlement batches that lump hundreds of transactions into a single bank deposit - matching individual sales to bank entries is like solving a puzzle where someone's hidden half the pieces.
E-commerce Tip
Reconcile against payment processor reports (Stripe dashboard, PayPal activity, Amazon settlement reports), not individual orders. Match the processor payout to the bank deposit first, then reconcile the individual transactions within the processor's own report.
Restaurants and hospitality
Cash plus cards plus tips plus third-party delivery apps equals a reconciliation puzzle. Cash sales are recorded by the till but don't appear on the bank statement until deposited. Tips paid by card are included in the card settlement, but they belong to staff and need separating. Deliveroo, Uber Eats, and Just Eat all settle on their own schedules with their own fee structures.
Hospitality Tip
Reconcile daily, even if it's just a rough cash-vs-till check. A £50 cash discrepancy is easy to investigate today; a £600 discrepancy accumulated over a month could be anything.
Professional services
Generally simpler than retail, but with its own quirks. Client deposits received before work begins shouldn't be recorded as revenue until earned. Disbursements made on behalf of clients flow through your bank account but aren't your expenses. Large timing differences between invoicing and receipt are normal with net-30 or net-60 terms.
Landlords and property
Multiple properties through one bank account means tracking which income and expenses relate to which property. If you use a letting agent, they collect rent, deduct fees and maintenance costs, and send you the net amount. Your bank shows one deposit; the agent's statement shows gross rent, fees, and deductions. You need both to reconcile properly.
Common mistakes and how to avoid them
Reconciling against the wrong period
If your bank statement runs to the 25th but your books run to the 30th, you're comparing apples to oranges. Align your periods.
Not investigating old outstanding items. An outstanding cheque from three months ago isn't "just a timing difference" anymore. Something has gone wrong. Investigate anything outstanding for more than two months.
Ticking items off without checking amounts. It's tempting to match by description alone. "That £300-ish payment to British Gas looks about right." Don't do this. Check the exact amount. £312.47 vs £312.74 is a £0.27 difference that will cascade through everything.
Doing it all at year-end. The single most common mistake small businesses make. Reconciling twelve months in one sitting is soul-destroying, error-prone, and expensive if you're paying your accountant to do it. Monthly at minimum.
Adjusting the wrong side. When the bank charges a fee you haven't recorded, you adjust your cash book - NOT the bank statement balance. The bank statement is a fact. Your books are what need updating. The only time you adjust the bank side is for genuine timing differences or actual bank errors.
Ignoring small differences. "It's only £2.35 out - close enough." No. Reconciliation means the balances match exactly. A small unexplained difference might be a rounding issue you can track down in thirty seconds. Or it might be the visible tip of a larger error where two mistakes partially cancel each other out. Find it. Fix it.
Quick checklist
Use this for each reconciliation. Tick every item.
- Bank statement and cash book cover the same date range
- Starting balance matches the previous reconciliation's closing balance
- Every bank statement transaction has been ticked off against the cash book
- All bank fees and interest recorded in the cash book
- All direct debits and standing orders accounted for
- Outstanding cheques listed and deducted from bank balance
- Deposits in transit listed and added to bank balance
- Any bounced payments or chargebacks reversed in the cash book
- Adjusted bank balance equals adjusted cash book balance (to the penny)
- All old outstanding items from previous reconciliations reviewed
- Adjusting entries posted to accounting system (not just noted)
- Completed reconciliation saved/filed with supporting documents
- Any unresolved discrepancies documented with follow-up actions
A process worth protecting
Bank reconciliation isn't glamorous. Nobody has ever called it exciting, and if they did, you'd be right to worry about them. But it's the single most effective routine check on the accuracy of your financial records.
A business that reconciles regularly knows where its money is. One that doesn't is guessing - and eventually, guessing catches up with you.
Whether you reconcile with a spreadsheet, your accounting software's built-in tools, or a dedicated reconciliation platform, the principle is identical: make the bank's numbers and your numbers agree, investigate every difference, and keep a record that proves you did.
Do it consistently, do it thoroughly, and month-end stops being something you dread.
Reconciling hundreds of transactions?
When manual matching stops being practical, automated reconciliation picks up the slack. Upload a bank statement and a ledger export, and let the matching engine do the cross-referencing.
Try ReconcileIQ freeFrequently Asked Questions
What is bank reconciliation?
Bank reconciliation is the process of comparing an organisation's internal accounting records against its bank statement to verify that every transaction is accounted for and the closing balances agree. It identifies timing differences, errors, and missing entries.
How often should I reconcile my bank account?
Most UK businesses should reconcile at least monthly, ideally within the first week after the month ends. High-volume businesses or those with many cash transactions benefit from weekly or even daily reconciliation.
What causes bank reconciliation differences?
The most common causes are timing differences (cheques not yet cleared, pending deposits), bank charges not yet recorded in the books, direct debits or standing orders missed from the ledger, and data entry errors.
Can bank reconciliation be automated?
Yes. Tools like ReconcileIQ automate the matching process by comparing transaction amounts, dates, and descriptions across both datasets. Automated reconciliation can process thousands of transactions in seconds with higher accuracy than manual methods.