Bank reconciliation is one of those tasks that sounds more intimidating than it is. At its core, it's simply checking that the money your records say you have matches the money the bank says you have — and explaining any difference. Done regularly, it's quick and protects you from errors, fraud, and nasty surprises at year-end. Left to pile up, it becomes a dreaded month-end scramble.
This guide explains what bank reconciliation is, why it matters, the exact steps to follow, and how to deal with the differences you'll inevitably find.
What bank reconciliation actually is
Bank reconciliation is the process of comparing the transactions in your own accounting records against the transactions on your bank statement for the same period, and making sure the two agree. Where they don't, you identify why — and either correct your records or note a legitimate timing difference.
Think of it as a checkpoint. Your books are your internal view of what happened; the bank statement is the external, authoritative record. When they match, you can trust your financial reports. When they don't, something needs looking at.
Why it matters
- It catches errors. Duplicate entries, transactions recorded for the wrong amount, and payments that were never recorded all surface during reconciliation.
- It detects fraud early. An unfamiliar transaction on the bank statement that isn't in your records is exactly the kind of thing reconciliation is designed to flag.
- It keeps your reports honest. Your profit and loss statement and balance sheet are only as accurate as the data behind them. Unreconciled accounts mean decisions made on unreliable numbers.
- It keeps you audit-ready. Reconciled records with a clear trail demonstrate that your books are well-maintained — something auditors, lenders, and investors all want to see.
How often should you reconcile?
The right frequency depends on how many transactions you process:
- Monthly is the minimum for most small businesses, and aligns naturally with your bank statement cycle.
- Weekly suits growing businesses with moderate volume — it catches problems before they accumulate.
- Daily makes sense for high-volume or cash-heavy operations, where catching discrepancies quickly is worth the effort.
The golden rule: don't let it fall more than a couple of weeks behind. The longer you wait, the harder it is to remember what each transaction was for.
The step-by-step process
- Gather your records. You need your bank statement for the period and your accounting records (or bank ledger) covering the same dates.
- Check the opening balance. Confirm the starting balance in your records matches the closing balance from your last reconciliation. If it doesn't, resolve that first — everything downstream depends on it.
- Match each transaction. Go through the bank statement line by line and tick off each transaction against your records. Most will match cleanly.
- Identify what's on the statement but not in your books. Bank fees, interest, and direct debits you forgot to record are common. Add these to your records.
- Identify what's in your books but not on the statement. These are usually timing differences — payments you've recorded that haven't cleared the bank yet.
- Investigate anything unexpected. A transaction you don't recognise on either side needs explaining before you move on. Never skip an unfamiliar item.
- Confirm the adjusted balances match. After accounting for timing differences and adding missing items, your records and the bank statement should agree. If they do, you're done. If they don't, the difference points to an error still to be found.
- Document it. Note the date, who did it, and anything unusual. This creates the audit trail.
Common discrepancies and how to handle them
Deposits in transit
You've recorded a customer payment on the last day of the period, but it hadn't cleared the bank by the statement date. It's real money — it just hasn't shown up on the statement yet. Add it to the bank side of your reconciliation; it'll clear next period.
Outstanding payments
You've written or scheduled a payment and recorded it, but it hasn't been taken from your account yet. Like deposits in transit, this is a timing difference, not an error. Subtract it from the bank side.
Bank fees and interest
Charges and interest often appear on the statement without you having recorded them, because you only find out when the statement arrives. Add them to your records so they're reflected going forward.
Your books show £11,925. The bank statement shows £12,450 — a £525 difference. Investigating reveals:
| Item | Effect |
|---|---|
| Deposit in transit | +£1,200 (not yet on statement) |
| Two outstanding payments | −£1,750 (not yet cleared) |
| Bank fee on statement | −£25 (not yet in books) |
Adjusting the books for the £25 fee gives £11,900. Adjusting the bank balance: £12,450 + £1,200 − £1,750 = £11,900. Both sides now agree. Reconciled.
Good habits that make it easier
- Reconcile every payment channel separately. Credit cards, PayPal, Stripe, and Square each need their own reconciliation — they're effectively separate accounts.
- Use a dedicated business account. Mixing personal and business transactions turns reconciliation into a sorting exercise.
- Record transactions promptly. The closer to real-time your records are, the fewer surprises at reconciliation time.
- Separate duties where you can. Having someone other than the person who records transactions do the reconciliation reduces the chance of errors — or fraud — going unnoticed.
- Keep your documentation. Financial records are typically retained for around seven years. Store reconciliations in a structured, dated format.
Reconciling exported transactions?
If you're matching a bank or processor export against your ledger, ReconFiles lines up two CSV files in seconds — free and private.
Try the reconciliation tool →The bottom line
Bank reconciliation is a financial health check. The process is always the same: compare your records to the statement, explain every difference, and confirm the adjusted balances agree. The businesses that find it painless are simply the ones that do it often — little and often beats a giant quarterly catch-up every time.