Bank reconciliation in QuickBooks Online Canada is the process of matching your QuickBooks records to your bank statement. A successful reconciliation means every deposit, payment, and fee in your bank statement corresponds to a transaction in QuickBooks — and nothing is missing from either side.
Why Reconciliation Matters
Reconciliation catches errors before they compound: a client payment recorded in QuickBooks that never actually cleared the bank, a bank fee charged that you forgot to record, or a duplicate expense entry. A monthly reconciliation keeps your books accurate and your tax records defensible.
Before You Start
- Have your bank statement for the period ready (download from your bank’s portal)
- Know the opening and closing balance for the period from your bank statement
- Ensure your QuickBooks bank feed is up to date (all transactions imported and reviewed)
Step-by-Step: Reconciliation in QuickBooks Online Canada
- Go to Accounting → Reconcile from the left navigation menu
- Select your business bank account from the Account dropdown
- Enter the Statement Ending Date (last day of the bank statement period)
- Enter the Ending Balance from your bank statement
- Verify the Beginning Balance matches last month’s closing balance — if it does not, the prior reconciliation has an error that must be fixed first
- Click Start Reconciling
Matching Transactions
QuickBooks displays all recorded transactions for the period. Your goal: check off every transaction that appears on your bank statement.
- Check each deposit in QuickBooks against each deposit on your bank statement
- Check each payment/expense in QuickBooks against each charge on your bank statement
- Bank fees that appear on your statement but are not in QuickBooks: click Add to create the expense on the spot
- Payments on your statement that don’t appear in QuickBooks: add them through the banking menu before returning to reconciliation
Resolving the Difference
The Difference shown in the top-right corner should reach $0.00. If it does not:
- Check for the exact dollar amount: Search your QuickBooks transactions and your bank statement for that exact amount — you likely missed one transaction or double-checked one
- Compare totals by type: Are your total deposits matching? Total payments? Narrow down which type has the discrepancy
- Cheques/EFTs outstanding: If a payment was recorded in QuickBooks but has not cleared the bank yet, it should not be checked off — it will appear in the next period’s reconciliation when it clears
- Undeposited funds: Client payments received and deposited in QuickBooks but not yet cleared can create timing differences — these are normal and self-correct when the deposit clears
Finishing the Reconciliation
When the Difference shows $0.00, click Finish now. QuickBooks generates a reconciliation report showing all matched transactions. Save or download this report — it is your audit documentation.
Frequently Asked Questions
How often should I reconcile my bank account in QuickBooks?
Monthly is the standard. Monthly reconciliation keeps errors small and manageable. Quarterly reconciliation allows larger discrepancies to accumulate and is harder to diagnose. Some freelancers reconcile weekly if transaction volume is high, but monthly is sufficient for most sole proprietors.
What if my opening balance doesn’t match?
An opening balance mismatch means a prior reconciliation has been disturbed — a transaction was added, edited, or deleted after it was previously reconciled. QuickBooks shows a warning in these cases. Use the Reconciliation Discrepancy Report (Reports menu) to identify which transaction changed. Correct the underlying transaction, not the opening balance.
Do I need to reconcile my credit card separately?
Yes. If you track your business credit card in QuickBooks, reconcile it separately against your credit card statement, just as you do your bank account. The process is identical: select the credit card account, enter the statement closing balance, and match transactions. This ensures all business card charges are captured and nothing is missing.