Bank Reconciliation for Small Business
The complete Canadian guide to bank reconciliation. Step-by-step process, the 8 most common discrepancies, how to reconcile in QuickBooks and Xero, the CRA audit connection, the dollar cost of not reconciling, and the monthly checklist that takes 20 minutes. Written by a licensed Ontario CPA.
What Is Bank Reconciliation and Why Does It Matter?
Bank reconciliation is the process of comparing your business's internal accounting records (your books) with your bank statement to verify that every transaction is accounted for and that the two balances match. When they do not match, the difference must be identified, explained and corrected before the books are closed for the month.
Bank reconciliation is the single most important internal control in small business accounting. It catches errors, detects fraud, identifies missing transactions, prevents duplicate entries and ensures that the financial statements your CPA uses to prepare your T1 or T2 tax return accurately reflect reality. A business that does not reconcile its bank accounts monthly is flying blind — and CRA auditors know it.
Under Section 230 of the Income Tax Act, every Canadian business must maintain adequate books and records. CRA considers reconciled bank statements to be a fundamental component of "adequate" records. When CRA audits a small business and discovers unreconciled bank accounts, they treat every unexplained deposit as unreported income and every unexplained withdrawal as a personal benefit — both of which increase your tax liability with penalties and interest.
How to Do a Bank Reconciliation — 7 Steps
Get Your Bank Statement
Download or access the bank statement for the month being reconciled. Note the ending balance and the statement period dates.
Get Your Book Balance
Open your accounting software (QBO or Xero) and note the cash account balance as of the same end date. This is your "book balance."
Compare Transactions
Match every transaction in your books to the corresponding transaction on the bank statement. Check the date, amount and payee for each match.
Identify Outstanding Items
List cheques you have written that have not yet cleared the bank (outstanding cheques) and deposits you have recorded that have not yet appeared on the statement (deposits in transit).
Record Missing Items
Add any bank transactions not yet in your books: bank fees, interest earned, NSF charges, automatic payments, Interac e-Transfer receipts and merchant processing fees.
Adjust and Balance
Adjust the book balance for outstanding items and missing transactions. The adjusted book balance must equal the adjusted bank balance. If it does not, there is an error to find.
Document and Close
Save the reconciliation report in your accounting software. Attach the bank statement. Mark the month as reconciled. This documentation is what CRA reviews on audit.
Review and Repeat
Review the reconciliation for reasonableness. If the difference was large, investigate root cause. Repeat monthly — never skip a month.
8 Most Common Bank Reconciliation Discrepancies
| # | Discrepancy | What It Means | How to Fix It |
|---|---|---|---|
| 1 | Outstanding cheques | Cheques you have written and recorded in your books but the payee has not yet cashed them | List as a reconciling item — they will clear in the next period. Investigate cheques outstanding over 6 months (stale-dated) |
| 2 | Deposits in transit | Deposits you have recorded but the bank has not yet processed (common with weekend deposits) | List as a reconciling item — confirm they clear in the first few days of the next statement |
| 3 | Bank fees and charges | Monthly service charges, wire transfer fees, NSF charges, merchant processing fees not yet recorded in your books | Record as a bank charge expense. Set up a recurring entry if the fee is the same each month |
| 4 | Interest earned | Bank interest credited to the account but not yet recorded in your books | Record as interest income. Small amount but must be reported on your T2 |
| 5 | Automatic payments | Pre-authorized debits for insurance, loan payments, subscriptions or CRA instalments not recorded | Record each as an expense. Set up recurring transactions in QBO or Xero to prevent this monthly |
| 6 | Duplicate entries | The same transaction recorded twice — common when importing bank feeds and also entering manually | Delete the duplicate. Review your bank feed matching rules to prevent recurrence |
| 7 | Wrong amounts | A transaction recorded at $1,250 in your books but the bank shows $1,520 — data entry error or invoice discrepancy | Correct the entry to match the bank. Investigate the source document to determine which amount is correct |
| 8 | Unidentified deposits | A deposit appears on the bank statement with no matching entry in your books — could be a customer payment, intercompany transfer or personal deposit | Identify the source. If business income, record it. If personal, record as a shareholder loan repayment. CRA treats unexplained deposits as unreported income |
CRA and Unexplained Deposits: On audit, CRA's standard procedure is to request bank statements and compare total deposits to reported revenue. Every deposit that cannot be traced to a recorded income source, a loan, a shareholder contribution or an intercompany transfer is treated as unreported income. This is the number one reassessment trigger for Canadian small businesses. Monthly bank reconciliation that identifies and documents every deposit is the only reliable defence against this audit technique.
How to Reconcile in QuickBooks Online vs. Xero
| Step | QuickBooks Online | Xero |
|---|---|---|
| Access reconciliation | Accounting → Reconcile → Select account | Accounting → Bank Accounts → Reconcile |
| Enter statement details | Enter statement ending date and ending balance from your bank statement | Enter statement ending date and ending balance |
| Match transactions | Tick each transaction that appears on both your bank statement and QBO. Green checkmark = matched | Tick each transaction that matches. Xero shows running difference in real time |
| Add missing transactions | Click "Add" to record bank fees, interest or other items directly from the reconciliation screen | Click "Create" to add adjustments inline during reconciliation |
| Review difference | QBO shows "Difference" at the top — must be $0.00 to finish | Xero shows "Reconcile" button only when difference is $0.00 |
| Complete reconciliation | Click "Finish Now" — QBO locks the reconciled period to prevent accidental changes | Click "Reconcile" — Xero locks the period and marks transactions as reconciled |
| Reconciliation report | Available under Reports → Reconciliation Reports — save as PDF | Available under Accounting → Bank Accounts → Reconciliation Report |
Bank Feeds Save Time: Both QBO and Xero connect directly to Canadian banks and import transactions automatically. With bank feeds enabled, most transactions are already in your software before you start reconciliation — you are primarily verifying matches and catching exceptions rather than entering every transaction manually. We configure bank feeds for every bookkeeping client on day one. Bookkeeping Services →
The Dollar Cost of Not Reconciling Your Bank Accounts
| Consequence | How It Happens | Typical Cost |
|---|---|---|
| Unreported income reassessment | CRA flags unexplained deposits as unreported income. Without reconciliation, you cannot document the source | $5,000–$25,000 per audit (additional tax + 8% interest + possible gross negligence penalty) |
| Duplicate expense claims | Same expense entered manually and via bank feed. Without reconciliation, the duplicate is never caught | $500–$3,000 per year in overstated deductions reversed on audit |
| Undetected fraud or theft | Unauthorised withdrawals, credit card misuse or employee embezzlement invisible without reconciliation | $1,500–$10,000+ per year (median small business fraud loss in Canada) |
| Missed bank fees eroding cash | Monthly service charges, NSF fees and merchant processing fees accumulate unnoticed | $200–$600 per year in untracked bank charges |
| Year-end cleanup cost | 12 months of unreconciled transactions require a bookkeeper to reconstruct the entire year | $2,000–$5,000 for annual cleanup vs. $100–$300/month for monthly bookkeeping |
| Incorrect HST filing | Missing revenue or duplicate expenses flow into wrong HST collected and ITCs claimed on the GST/HST return | $1,000–$8,000 in CRA HST reassessments + interest |
| Cash flow surprises | Without reconciliation, your book balance does not reflect actual available cash. Cheques bounce, payroll fails | $42 NSF fee per bounced item + damaged supplier and employee relationships |
How Often Should You Reconcile?
| Reconciliation Frequency | Best For | Time Required |
|---|---|---|
| Monthly (recommended) | Every Canadian small business — catches errors while fixable, satisfies CRA expectations | 20–45 minutes for most small businesses |
| Weekly | High-volume businesses (restaurants, retail, e-commerce) with 200+ transactions per month | 10–15 minutes per week |
| Quarterly | Not recommended — too long between checks, errors compound, CRA considers this inadequate for active businesses | 2–3 hours per quarter (errors harder to trace) |
| Annually | Never acceptable — CRA treats annual-only reconciliation as evidence of inadequate record-keeping | 6–12 hours + $2,000–$5,000 bookkeeper cleanup cost |
The 20-Minute Monthly Rule: A business with bank feeds connected in QBO or Xero and fewer than 100 monthly transactions can complete a full bank reconciliation in 20 minutes. That is 20 minutes per month to prevent thousands in CRA reassessments, catch fraud early, maintain accurate cash flow and have audit-ready books. There is no higher-ROI task in small business accounting.
Monthly Bank Reconciliation Checklist
- Download or access the bank statement for the month just ended
- Open the reconciliation screen in QBO (Accounting → Reconcile) or Xero (Bank Accounts → Reconcile)
- Enter the statement ending date and ending balance
- Match every transaction — tick each item that appears on both the bank statement and your books
- Identify and record any bank fees, interest or automatic payments not yet in your books
- Investigate any transactions on the bank statement not in your books — identify the source and record
- Investigate any transactions in your books not on the bank statement — confirm as outstanding cheques or deposits in transit
- Delete any duplicate entries
- Verify the difference is $0.00 before completing
- Save the reconciliation report as PDF and attach the bank statement
- Reconcile all business credit cards using the same process
- Review the shareholder loan account for any personal withdrawals or repayments during the month
Bank Reconciliation and CRA Audits — What You Need to Know
CRA auditors follow a standard procedure when auditing a Canadian small business. The first documents they request are bank statements and the corresponding reconciliation reports. They perform their own bank deposit analysis — totalling all deposits and comparing to reported revenue. Every deposit that exceeds reported revenue by more than a reasonable threshold triggers a detailed inquiry.
If you have monthly bank reconciliations with every deposit identified and documented (customer payment, loan proceeds, shareholder contribution, intercompany transfer, HST refund), the CRA auditor can verify your revenue quickly and move on. If you do not have reconciliations, the auditor must trace every deposit manually — and any deposit they cannot trace is treated as unreported income. The reassessment includes the tax on the "unreported" amount plus interest at 8% compounded daily plus a potential gross negligence penalty of 50% under Section 163(2).
Shareholder Loan and Bank Reconciliation: CRA also uses bank deposit analysis to identify shareholder loan transactions. If the owner deposits personal funds into the business account and the deposit is not documented as a shareholder loan contribution, CRA may treat it as unreported business income. If the owner withdraws funds and the withdrawal is not documented as salary, dividends or a shareholder loan, CRA may assess a Section 15(1) benefit. Monthly reconciliation that identifies every personal deposit and withdrawal as a shareholder loan transaction prevents both reassessment scenarios.
Frequently Asked Questions — Bank Reconciliation
Stop Guessing Your Cash Balance. Let a CPA Reconcile It.
Gondaliya CPA provides monthly bookkeeping with bank reconciliation from $100/month. T2 filing included FREE. CRA audit support included FREE.