Bank Reconciliation for Canadian Small Business

Bank reconciliation is the process of matching your internal bookkeeping records against your bank statement to confirm they agree. For Canadian small businesses, it's not optional — the CRA expects your books to match your financial records, and discrepancies are a red flag in any audit.

Most business owners reconcile once a month, immediately after the bank statement closes. Done consistently, reconciliation takes 15 to 30 minutes. Done after six months of neglect, it can take days.

What Reconciliation Actually Does

Your accounting software (QuickBooks, Xero, Wave) tracks every transaction you record. Your bank tracks every transaction that actually cleared. These two records should match — but they rarely match perfectly at any given moment because of:

• Outstanding cheques — written but not yet cashed by the recipient
• Deposits in transit — recorded in your books but not yet processed by the bank
• Bank fees and interest — charged by the bank but not yet entered in your software
• NSF (non-sufficient funds) items — a cheque you deposited that bounced
• Errors — a transaction entered for the wrong amount

Step-by-Step: Monthly Bank Reconciliation

Step 1 — Gather your documents

You need your bank statement for the period and your accounting records showing transactions for the same period. Most banks provide PDF statements; many also offer direct bank feeds that import transactions automatically into QuickBooks or Xero.

Step 2 — Match cleared transactions

Go through each transaction on your bank statement and mark it as "cleared" in your accounting software. Most software has a dedicated reconciliation module that makes this a tick-box exercise. Any transaction on your bank statement that doesn't appear in your books must be added now.

Step 3 — Identify outstanding items

Any transaction in your books that doesn't appear on the bank statement is outstanding. List all outstanding cheques and deposits in transit.

Step 4 — Adjust and compare

Apply the reconciliation formula. If the adjusted bank balance equals your book balance, the reconciliation is complete. If not, find the difference.

Step 5 — Investigate differences

Common causes: a transposed digit (e.g., $962 entered as $692), a duplicate entry, or a transaction recorded in the wrong account. A difference divisible by 9 almost always indicates a transposition error.

Why the CRA Cares About Reconciliation

The CRA's audit process starts by comparing your reported revenue to your bank deposits. If your deposits significantly exceed your reported revenue, auditors will demand an explanation. Clean monthly reconciliations create a clear paper trail that shows every deposit is accounted for — either as income, a loan, a transfer between accounts, or another non-taxable source.

Unreconciled books also tend to hide errors in GST/HST — missed input tax credits (ITCs), incorrectly coded expenses, or GST/HST collected but not remitted. These errors compound over time and become expensive to fix.

Reconciling Credit Card and Loan Accounts

Bank reconciliation applies to every balance sheet account, not just your chequing account. Your business credit card, line of credit, and any loans should also be reconciled monthly against the lender's statement. Many business owners skip this step, and it's where double-counted expenses and incorrect balances hide.

How Long Must You Keep Reconciliation Records?

The CRA requires you to keep all supporting documents for six years from the end of the tax year they relate to. This includes bank statements, cancelled cheques, and your reconciliation worksheets. Digital copies are accepted as long as they are complete, legible, and accessible.