0 / 24 done on this device
Stage 4 · Lesson 3 of 4 · GUIDE · 10 min

Bank reconciliation, step by step

In any accounting app

By the wpdailylive editorial team · Part of Accounting and bookkeeping, the complete guide

Key takeaways

  1. What it proves: Reconciliation checks your records match the bank statement.
  2. Match first: Accept the correct suggested matches, then categorise what is left.
  3. Investigate leftovers: Look into differences promptly rather than forcing a match.
  4. The final test: Your closing balance must agree with the statement.
  5. Make it weekly: Ten minutes every Friday beats three hours at month end.

Reconciliation checks that every transaction in your books matches your bank. It's how you catch missing income, duplicate bills and errors before they become tax problems.

  1. 01Open the reconcile screenBank transactions on one side, suggested matches on the other.
  2. 02Accept correct matchesInvoices paid, bills paid, transfers between accounts.
  3. 03Categorise the restCreate a rule for anything that repeats, like software subscriptions.
  4. 04Investigate leftoversDuplicates, missing invoices or personal spending.
  5. 05Check the balanceThe statement balance in your app should equal your bank's.
WORKFLOW · MONTHLY RECONCILIATION6 steps
  1. TRIGGEROpen the bank account
  2. STEPMatch suggested transactions
  3. STEPCreate entries for the rest
  4. STEPRecord transfers between accounts
  5. CONDITIONStatement balance matches?Yes → Done for the monthNo → Look for missing or duplicate items
  6. GOALReconciled

Common differences and how to fix them

DIFFERENCELIKELY CAUSEFIX
Payment in bank but no matchInvoice not recorded, or paid to wrong invoiceFind or create the invoice and match
Same transaction twiceDuplicate importDelete one
Card processor payout lower than salesFees deductedRecord fees via clearing account
Transfer between accounts unmatchedOnly one side recordedRecord as a transfer, not income or expense
Balance off by a small amountBank charges or interestAdd the missing entry

Month-end sign-off

  • •Every account reconciled to the statement date
  • •No unexplained items older than 30 days
  • •Statement balance matches the software balance
  • •Lock the period once your accountant agrees

Bank reconciliation example

AMOUNT
Bank statement closing balance$18,642.30
Add: deposit in transit+$1,284.00
Less: outstanding cheque−$950.00
Adjusted bank balance$18,976.30
Book balance$19,021.30
Less: bank fee not recorded−$45.00
Adjusted book balance$18,976.30
Difference$0.00

Find a reconciliation difference fast

IF THE DIFFERENCE…LOOK FOR
Equals one transactionA missing or duplicate entry
Is twice a transactionAn entry with the wrong sign
Divides by 9Swapped digits
Is small and regularBank fees or interest

Common mistakes to avoid

✕ Forcing a balance with adjustmentsFind the real cause.
✕ Reconciling only once a yearDo it monthly.
✕ Ignoring payment processor accountsReconcile them too.
PEOPLE ALSO ASK
What is a bank reconciliation?

Checking that the balance in your books matches your bank statement, explaining any differences.

How do I reconcile a bank account?

Match each statement line to your books, add missing items like fees, list timing differences and check the adjusted balances agree.

Why doesn’t my bank reconciliation balance?

Missing or duplicate entries, wrong signs, typos, bank fees or timing differences.

What is a deposit in transit?

Money recorded in your books that the bank hasn’t processed yet.

How often should I reconcile?

At least monthly; weekly for busy accounts.

Tools we recommend for this stage

Some links are partner links: we may earn a commission at no cost to you. It never changes what we recommend. How we make money

Reviews of tools in this lesson