All articles

Accounting & Finance

How to do a bank reconciliation: a step-by-step guide

What a bank reconciliation is, why it matters, and how to do one step by step in accounting software or a spreadsheet, with a worked example and fixes for the most common differences.

Genvora teamPublished 5 min read
Close-up of a printed statement full of figures

Part of our guide: Bookkeeping basics for small businesses: a complete beginner's guide ›

A bank reconciliation is a check that your books agree with your bank. You compare every transaction in your accounting records with your bank statement, explain any differences, and fix anything that's wrong. It sounds tedious, and it can be if you leave it for months. Done monthly, it usually takes under an hour and catches problems while they're still easy to fix.

The short version

  • Reconciling means making sure the balance in your books matches the balance on your bank statement, and explaining any difference.
  • Most differences are timing: payments that have left your books but not yet cleared the bank, or the other way round.
  • Real errors include duplicates, missing transactions, wrong amounts and bank fees nobody recorded.
  • Do it monthly for every bank, card and payment account, including PayPal and Stripe.
  • Accounting software with bank feeds does most of the matching for you.

Why it matters

  • It catches errors: duplicated entries, typos and transactions recorded in the wrong account.
  • It spots fraud or unauthorized payments quickly, while your bank can still help.
  • It makes sure your profit figures are real, which matters for tax.
  • It gives you an accurate cash balance to make decisions with.
  • It makes year end far quicker and cheaper.

Step by step

  1. 1Get your bank statement for the period, usually a calendar month, and note the closing balance.
  2. 2Open your accounting records for the same account and period, and note the balance your books show.
  3. 3Match each transaction on the statement to one in your books. In software, this is usually suggested automatically.
  4. 4List anything on the statement that isn't in your books, such as bank fees, interest, direct debits or payments you forgot to record. Add them.
  5. 5List anything in your books that isn't on the statement yet, such as checks or payments that haven't cleared. These are timing differences.
  6. 6Adjust: the bank balance, minus outstanding payments, plus deposits in transit, should equal your book balance.
  7. 7Investigate any difference that's left. Don't force the numbers to match.
  8. 8Mark the period as reconciled, so it can't be changed accidentally.

A worked example

At the end of March, a business's bank statement shows a closing balance of 8,400. Its accounting records show 7,935. Here's how the reconciliation works:

ItemAmount
Bank statement balance8,400
Less: supplier payment made March 31, not yet cleared- 600
Add: customer payment banked March 31, not yet on statement+ 150
Adjusted bank balance7,950
Book balance before adjustments7,935
Add: interest received, not recorded in books+ 30
Less: bank fees, not recorded in books- 15
Adjusted book balance7,950

Both adjusted balances agree at 7,950, so the account is reconciled. The interest and fees are added to the books; the timing differences will clear in April.

Common differences and how to fix them

DifferenceLikely causeFix
Book balance higher than bankUnrecorded fees or direct debits, or a payment recorded twiceAdd the missing items; delete the duplicate
Bank balance higher than bookUnrecorded deposits, interest, or a payment that bouncedRecord the missing income; check for reversed payments
Difference equals one transactionA missing or duplicated entrySearch for that exact amount
Difference divisible by 9Two digits swapped, such as 54 entered as 45Check entries for transposed numbers
Opening balance doesn't matchLast month wasn't reconciled, or was changed afterwardsReconcile the earlier period first

Using software

With bank feeds, software like QuickBooks or Xero imports every transaction and suggests matches to invoices and bills you've recorded. Your job becomes checking each suggestion, creating entries for anything new, and confirming the closing balances agree. Watch for two traps: accepting suggested matches without looking, and bank feeds that drop or duplicate transactions. Always compare the final balance with the actual statement, not just the feed.

Reconciling in a spreadsheet

If you don't use accounting software yet, you can still reconcile. Put your bank statement transactions in one column and your own records in another, tick off each pair that matches, and list whatever is left on each side. The unticked items are your timing differences and errors. Add the two adjustments to your balances, as in the example above, and check they agree. It's slower than software but follows exactly the same logic.

Signs your books haven't been reconciled

  • The cash balance in your accounting software is nowhere near what's in the bank.
  • Customers show as owing money they paid months ago.
  • The same supplier bill appears twice, once paid and once unpaid.
  • Your profit looks far higher or lower than your bank balance suggests.
  • Your accountant's year-end bill is larger than expected because of clean-up work.

Don't forget other accounts

Reconcile every account money passes through: credit cards, savings accounts, loan accounts, and payment platforms such as PayPal, Stripe and Square. Payment platforms are a common blind spot, because they deduct fees before paying out, so the amount that reaches your bank is less than the sale.

Credit card reconciliations

Business credit cards work the same way, with one twist: the statement balance is money you owe, not money you have. Match every charge to a receipt, check refunds have been recorded, and confirm that payments you made to the card appear in both the card account and the bank account. A card payment recorded only once is one of the most common reasons both accounts fail to reconcile.

How often to reconcile

Monthly is the minimum for most businesses, ideally within a week or two of the month end. Businesses with lots of transactions often reconcile weekly. It's one of the main steps in our month-end close checklist.

Frequently asked questions

What if I can't find the difference?

Check the opening balance first, then look for the exact difference amount, half of it (an entry posted the wrong way round), or a number divisible by 9 (swapped digits). If it's tiny and you've spent a long time looking, your accountant may post a small adjustment, but find the cause if you can.

Do I need to reconcile if I use bank feeds?

Yes. Feeds bring in transactions, but they can miss or duplicate items, and they don't check that each one is categorized correctly.

Can I reconcile months I've missed?

Yes. Start with the earliest unreconciled month and work forwards one month at a time. Our catch-up bookkeeping guide covers this.

Who should do the reconciliation?

Ideally someone other than the person who makes payments, as a basic check against errors and fraud. In very small businesses, the owner reviewing a bookkeeper's reconciliation does the same job.

Want reconciliations done every month?

Our outsourced bookkeeping team reconciles every account monthly and flags anything unusual. Start with our bookkeeping basics guide, or book a call.

14d → 5d
Month-end close
12 → 1
Systems

See it in practice · Healthcare

Healthcare practice scaled bookkeeping across 12 locations

Read the story ›

Curious how your own site scores?

Run our free website audit. Simple report, about 10 seconds, no sign-up.

Run free audit
All articles