Bank reconciliation, step by step
In any accounting app
By the wpdailylive editorial team · Part of Accounting and bookkeeping, the complete guide
Key takeaways
- What it proves: Reconciliation checks your records match the bank statement.
- Match first: Accept the correct suggested matches, then categorise what is left.
- Investigate leftovers: Look into differences promptly rather than forcing a match.
- The final test: Your closing balance must agree with the statement.
- 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.
- 01Open the reconcile screenBank transactions on one side, suggested matches on the other.
- 02Accept correct matchesInvoices paid, bills paid, transfers between accounts.
- 03Categorise the restCreate a rule for anything that repeats, like software subscriptions.
- 04Investigate leftoversDuplicates, missing invoices or personal spending.
- 05Check the balanceThe statement balance in your app should equal your bank's.
- TRIGGEROpen the bank account
- STEPMatch suggested transactions
- STEPCreate entries for the rest
- STEPRecord transfers between accounts
- CONDITIONStatement balance matches?Yes → Done for the monthNo → Look for missing or duplicate items
- GOALReconciled
Common differences and how to fix them
| DIFFERENCE | LIKELY CAUSE | FIX |
|---|---|---|
| Payment in bank but no match | Invoice not recorded, or paid to wrong invoice | Find or create the invoice and match |
| Same transaction twice | Duplicate import | Delete one |
| Card processor payout lower than sales | Fees deducted | Record fees via clearing account |
| Transfer between accounts unmatched | Only one side recorded | Record as a transfer, not income or expense |
| Balance off by a small amount | Bank charges or interest | Add 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 transaction | A missing or duplicate entry |
| Is twice a transaction | An entry with the wrong sign |
| Divides by 9 | Swapped digits |
| Is small and regular | Bank fees or interest |
Common mistakes to avoid
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


















