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.
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.
At 30 September, the bank statement shows $12,480 and the books show $11,915. After ticking off matching lines, three items are left:
| Item | Where it appears | Amount |
|---|---|---|
| Customer payment recorded 30 Sep, banked 1 Oct | Books only (deposit in transit) | $850 |
| Supplier cheque #1042 not yet cleared | Books only (uncleared payment) | $1,400 |
| Monthly bank fee | Bank 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.
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.
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.
Lesson 4 of my free course, Bank Reconciliation Step by Step, includes a downloadable template and a practice set with answers.
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.
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.