You check your bank balance on your phone, it looks fine, and you move on with your day. That habit works fine until a bounced e-transfer, a duplicate supplier charge, or a bank fee you never noticed throws your books off by a few hundred dollars, and you don’t find out for weeks. Bank reconciliation is the fix. It’s a simple, repeatable check that keeps what your bank says you have in sync with what your books say you have, and it takes most small businesses under half an hour a month. Of everything on a bookkeeping to-do list, this is one of the few habits that pays for itself almost right away.
This guide covers what bank reconciliation actually is, how often you should do it, and the exact steps to follow, whether you’re doing it by hand in a spreadsheet or letting software handle the matching for you.
What Bank Reconciliation Actually Means
Bank reconciliation is the process of comparing your bank account’s transaction history against the transactions recorded in your own books (your invoicing tool, spreadsheet, or bookkeeping software) and confirming they match, dollar for dollar, transaction for transaction. When they don’t match, reconciliation is how you find out why, before the gap grows or before you file a GST/HST return, a corporate tax return, or a loan application built on numbers that are wrong without you knowing it.
It’s different from just glancing at your balance. Your bank balance can look close enough while it’s hiding a cancelled cheque still sitting in your books, an e-transfer fee you forgot to log, or a customer payment that bounced. Reconciliation forces every transaction to be accounted for on both sides. That’s why accountants treat it as a non-negotiable step, not a nice-to-have.
How Often You Should Reconcile Your Business Bank Account
Most small businesses in Canada should reconcile at least once a month, ideally right after the bank statement closes. If you run a high volume of transactions, say a busy retail store, a restaurant, or a business where several staff are making purchases, reconciling weekly makes errors far easier to catch while you can still remember what a charge was for.
Waiting until tax time to reconcile a full year at once is the single most common bookkeeping mistake small business owners make. By then, receipts are gone, memories have faded, and a $40 discrepancy from March is nearly impossible to track down among twelve months of transactions.
Put reconciliation on a recurring calendar reminder tied to your bank’s statement date, not the calendar month end. Reconciling against a fully closed statement, rather than transactions still marked pending, avoids chasing timing differences that resolve themselves in a day or two anyway.
How to Reconcile Your Bank Account in 6 Steps
The process is the same whether you’re using a spreadsheet or software. Only the amount of manual matching changes.
- Gather your bank statement and your books for the same period. Pull the official statement from your bank (PDF or CSV) and your recorded transactions for that same date range.
- Start from the ending balances on both sides. Note your bank statement’s closing balance and your books’ closing balance for the period. This is the gap you’re about to explain.
- Match transactions one by one. Go line by line through the bank statement and confirm each deposit and withdrawal appears in your books with the same amount and date.
- Flag anything that doesn’t match. This includes bank fees, interest earned, cheques that haven’t cleared yet, and deposits still in transit. List each one separately rather than lumping them together.
- Record what was missing from your books. Bank fees, interest, and e-transfer charges usually show up on the statement before you’ve logged them. Add these entries to your books now.
- Confirm the adjusted balances match. Once every flagged item is accounted for, your adjusted bank balance and your adjusted book balance should be identical. If they’re not, the difference is your starting point for step 3 again.
“A reconciliation that doesn’t balance right away isn’t bad news. It just found you something specific to fix, instead of leaving you with a vague feeling that something’s off.”
Common Discrepancies and What They Usually Mean
Most mismatches fall into a small number of predictable categories. Knowing the usual suspects makes tracking down a discrepancy much faster.
| Discrepancy | Likely Cause | How to Resolve |
|---|---|---|
| Bank balance higher than books | A cheque you wrote hasn’t been cashed yet | No action needed, it will clear on its own in a future period |
| Books show a payment, bank doesn’t | Deposit in transit or an e-transfer still processing | Confirm timing and recheck once the next statement arrives |
| Small, recurring differences | Bank fees, interest, or currency conversion charges | Log the fee or interest entry directly in your books |
| Amount matches but appears twice | A duplicate entry or a duplicate charge from a vendor | Delete the duplicate or dispute the double charge with your bank |
| Transaction missing entirely | Manual entry error or a receipt that was never logged | Trace back to the original receipt or invoice and record it |
Red Flags a Reconciliation Can Catch Early
Beyond simple typos, regular reconciliation is one of your best defences against problems that get much more expensive the longer they go unnoticed.
A transaction you don’t recognize at all is worth investigating right away. Not a timing issue, not a fee, but a charge or withdrawal you genuinely can’t trace to anything your business did. It can point to a compromised card, an unauthorized subscription, or outright fraud, and the sooner you catch it, the better chance your bank has of reversing it.
Reconciliation also surfaces slower problems: a subscription you forgot to cancel, a supplier who’s been raising prices without telling you, or a pattern of NSF fees pointing to a cash flow timing issue worth fixing before it grows. If you’re already paying attention to the gap between profit and cash in the bank, reconciliation is what keeps that cash flow picture accurate instead of wishful.
Making Reconciliation Faster With the Right Tools
None of this requires any special financial training. It just requires consistency. If you’re reconciling manually today, a simple spreadsheet with your statement transactions in one column and your book entries in another, sorted by date, gets you most of the way there. The habit matters more than the tool.
That said, manual matching is exactly the part of bookkeeping that software exists to remove. Once your bank account is connected, transactions can be matched automatically, discrepancies get flagged for you instead of buried in two separate lists, and the whole monthly check turns into a quick review rather than a line-by-line hunt. This is a core part of solid small business bookkeeping, not a separate chore bolted onto it. Get reconciliation right and every other number in your books becomes trustworthy too.
Nikmani is built for Canadian small businesses specifically, with automated bookkeeping, GST/HST/PST/QST tracking, and bank feeds on the way to make matching transactions close to automatic. You can start with the free Basic plan for invoicing and expense tracking, or see the full plans and pricing to find the level of automation that fits where your business is right now.
Whatever tool you use, the underlying discipline is the same: check your numbers against reality on a fixed schedule, resolve what doesn’t match while it’s still fresh, and treat every reconciled month as one less thing to worry about at tax time.