ReconFiles

Guide4 min read

Bank reconciliation explained: a step-by-step guide for small finance teams

What bank reconciliation actually is, why it matters, the exact steps to follow each period, and the common discrepancies — deposits in transit, outstanding payments, timing differences — and how to handle them.

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

How often should you reconcile?

The right frequency depends on how many transactions you process:

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

  1. Gather your records. You need your bank statement for the period and your accounting records (or bank ledger) covering the same dates.
  2. 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.
  3. Match each transaction. Go through the bank statement line by line and tick off each transaction against your records. Most will match cleanly.
  4. 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.
  5. 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.
  6. Investigate anything unexpected. A transaction you don't recognise on either side needs explaining before you move on. Never skip an unfamiliar item.
  7. 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.
  8. 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.

Worked example

Your books show £11,925. The bank statement shows £12,450 — a £525 difference. Investigating reveals:

ItemEffect
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

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.