Bank reconciliation: a step-by-step guide with a worked example

A bank reconciliation is the single most useful check in bookkeeping. It answers one question: does the cash in my books match the cash in the bank, and if not, why not? If you only do one accounting task properly each month, make it this one.

Below I’ll show you exactly how I do it, with a small worked example you can copy.

What a bank reconciliation is

You compare two records of the same bank account: your bank statement, and your own cash book or accounting software. They rarely agree to the cent on the last day of the month, usually for perfectly normal reasons. The reconciliation explains every difference until the two balances agree.

Why the balances differ

Step by step

  1. Gather both records for the same period: the bank statement and your books’ cash account up to the same date.
  2. Note the two closing balances. Write both down before you start ticking anything.
  3. Tick off matching items. Go line by line and mark every transaction that appears in both, with the same amount.
  4. List what’s left in the bank but not in your books, such as fees, interest and automatic payments. Record these in your books.
  5. List what’s left in your books but not in the bank, such as uncleared cheques and deposits in transit. These are timing differences: you don’t change anything, you just list them.
  6. Adjust and compare. Adjusted bank balance = statement balance + deposits in transit − uncleared payments. Adjusted book balance = book balance + bank-only income − bank-only charges ± corrections.
  7. The two adjusted balances must agree. If they don’t, look for errors: transposed digits, duplicates, or a transaction posted to the wrong account.
  8. Save it. Keep the reconciliation with the date and who prepared it. Next month starts from here.

A worked example

At 30 September, the bank statement shows $12,480 and the books show $11,915. After ticking off matching lines, three items are left:

ItemWhere it appearsAmount
Customer payment recorded 30 Sep, banked 1 OctBooks only (deposit in transit)$850
Supplier cheque #1042 not yet clearedBooks only (uncleared payment)$1,400
Monthly bank feeBank only$35

Bank side: $12,480 + $850 − $1,400 = $11,930.

Book side: $11,915 − $35 bank fee = $11,880. That’s $50 short of $11,930.

A $50 gap means something is still wrong. Scanning the ticked items again, a $120 customer receipt was entered as $70. Correcting it adds $50: $11,880 + $50 = $11,930. Both sides now agree, so the reconciliation is done.

Tip: if a difference divides exactly by 9, look for two swapped digits. If it equals one transaction, look for a duplicate or a missing entry.

How often should you reconcile?

At least monthly, for every bank account, credit card and payment platform such as Stripe or PayPal. Busy businesses often reconcile weekly. Small, regular reconciliations take minutes; a year’s worth at once can take days.

Doing it in QuickBooks or Xero

Both programs have a reconcile screen that pulls in bank feed lines and suggests matches. The principle doesn’t change: confirm matches, add bank-only items, and never force a reconciliation to balance by creating an “adjustment” you can’t explain.

Practise it

Lesson 4 of my free course, Bank Reconciliation Step by Step, includes a downloadable template and a practice set with answers.

Frequently asked questions

What if I can’t find the difference?

Check the opening balance first. If last month’s reconciliation was wrong, this month can’t be right. Then compare totals week by week to narrow down where the gap starts.

Do I need to reconcile if I use bank feeds?

Yes. Bank feeds import transactions, but they can duplicate lines, miss them, or be categorised wrongly. The reconciliation is what proves the account is complete.

Behind on reconciliations, or never started? I can bring every account up to date and keep it there. See my bookkeeping services or book a free call.