🏦 Module 5: Banking & Reconciliation
Master how to connect and manage bank feeds, properly categorize transactions, and perform accurate bank reconciliations in QuickBooks Online.
Monthly reconciliation is one of the most critical tasks for reliable bookkeeping.
5.1 Connecting Your Bank Account to QBO
QuickBooks Online can automatically import transactions from your bank and credit card accounts via bank feeds.
Steps to Connect a Bank Account:
- Go to Banking (left menu)
- Click Link account or Connect account
- Search for your bank (RBC, TD, BMO, Scotiabank, CIBC, Desjardins, etc.)
- Sign in with your online banking credentials
- Select which account(s) to connect
- Choose the matching Chart of Accounts (your Bank account in QBO)
- QBO downloads recent transactions (usually 90 days)
Canadian Banks: Most major Canadian banks connect directly to QBO:
RBC, TD, Scotiabank, BMO, CIBC, National Bank, Desjardins, Tangerine, Simplii, and many credit unions.
Benefits of Bank Feeds:
- Automatic daily transaction downloads
- Reduces manual data entry
- Catches missed transactions
- Faster reconciliation process
- Real-time cash position visibility
5.2 Reviewing and Categorizing Bank Feed Transactions
Every downloaded transaction must be reviewed and either matched or added to your books.
Three Actions for Bank Feed Transactions:
| Action |
When to Use |
What It Does |
| Match |
Transaction already entered (invoice, bill, expense) |
Links downloaded transaction to existing entry |
| Add |
New transaction not yet recorded |
Creates new transaction (Expense, Deposit, etc.) |
| Transfer |
Money moved between your own accounts |
Records transfer (not income/expense) |
Banking Tab - For Review Screen:
Banking → Bank - RBC Chequing → For Review (15)
DATE DESCRIPTION AMOUNT ACTION
──────────────────────────────────────────────────────
Mar 25 OFFICE DEPOT #45678 - $184.20 [Match/Add]
Suggested: Office Supplies
Mar 26 CUSTOMER ABC PAYMENT +$2,825.00 [Match]
Found: Invoice INV-2026-045
Mar 27 TD BANK SERVICE FEE - $15.00 [Add]
Suggested: Bank Charges
Mar 28 TRANSFER TO SAVINGS - $500.00 [Transfer]
To: TD Savings Account
[Accept all] [Accept selected]
Categorization Tips:
- Match customer payments to existing invoices (clears AR)
- Match vendor payments to existing bills (clears AP)
- Add bank fees as Bank Charges expense
- Add interest earned as Other Income
- Transfer between accounts - never categorize as income/expense
- NSF fees - Bank Charges, plus reverse the customer payment
Review Promptly: Categorize transactions weekly (minimum) to avoid backlog.
Uncategorized transactions don't appear on financial reports!
5.3 Creating Bank Rules for Automation
Bank Rules automatically categorize recurring transactions, saving massive amounts of time.
How to Create a Rule:
- In Banking tab, find a transaction to automate
- Click the transaction → Create rule
- Set conditions (description contains, amount equals, etc.)
- Choose action: Category, Payee, HST, etc.
- Enable auto-add if you want QBO to categorize automatically
- Save rule
Sample Bank Rule:
Rule Name: Bell Canada Monthly Internet
When transaction meets ALL these conditions:
• Description contains: "BELL CANADA"
• Money out
• Amount is approximately: $80
Do this:
• Transaction type: Expense
• Category: Utilities - Internet & Phone
• Payee: Bell Canada
• HST: 13% ON
• Auto-add: Yes
[Save rule]
Good Rules to Create Early:
- Bank service fees → Bank Charges expense
- Recurring subscriptions (software, services) → Appropriate expense
- Utility companies → Utilities expense
- Regular suppliers → Appropriate category with HST
- Payroll deposits → Salaries expense
- Loan payments → Loan Payable (principal) + Interest Expense
5.4 Bank Reconciliation – The Most Important Monthly Task
Why Reconcile?
• Ensures your books match your actual bank balance
• Catches errors, missing transactions, and fraud
• Required for accurate financial statements
• CRA expects reconciled accounts for audits
• Identifies timing differences (outstanding cheques, deposits in transit)
Reconciliation Process:
- Go to Accounting → Reconcile
- Select the bank/credit card account to reconcile
- Enter Statement Ending Date from bank statement
- Enter Ending Balance from bank statement
- Click Start reconciling
- Checkmark transactions that appear on bank statement (cleared)
- Investigate any differences
- When Difference = $0.00, click Finish now
Reconciliation Screen:
Reconcile: Bank - RBC Chequing
Statement ending date: Mar 31, 2026
Ending balance: $42,150.00
Beginning balance: $45,280.00
+ Deposits and credits: $12,450.00
- Withdrawals and debits: $15,580.00
═══════════════════════════════════════
Cleared balance: $42,150.00
Statement ending balance: $42,150.00
───────────────────────────────────────
Difference: $0.00 ✓
[Finish now] [Save for later]
CRITICAL RULE: Never mark transactions as cleared manually in the register.
Always reconcile through the Reconciliation tool. Manual changes break reconciliation integrity!
5.5 Common Reconciliation Differences & Solutions
Timing Differences (Normal):
Outstanding Cheques: Written but not yet cashed
• Show in QBO but not on bank statement
• Don't checkmark these — they'll clear next month
Deposits in Transit: Deposited but not yet processed by bank
• Show in QBO but not on bank statement
• Don't checkmark — will appear on next statement
Reconciliation Scenario:
Given Information:
Bank statement ending balance: $25,000
QBO book balance: $30,000
Outstanding cheques: $4,000
Deposits in transit: $2,500
Bank service fee (not recorded): $500
Adjusted Bank Balance:
Bank statement: $25,000
+ Deposits in transit: + $2,500
- Outstanding cheques: - $4,000
═══════════════════════════════════
Adjusted bank balance: $23,500
Adjusted Book Balance:
QBO book balance: $30,000
- Bank service fee: - $500
+ Interest earned (example): + $12
- NSF cheque (example): - $420
- Correction needed: - $5,592
═══════════════════════════════════
Adjusted book balance: $23,500
✓ Both adjusted balances match!
Common Differences & Fixes:
- Bank fees not recorded → Add as expense: Bank Charges
- Interest earned not recorded → Add as income: Interest Income
- NSF (bounced) cheques → Reverse customer payment, add NSF fee
- Duplicate entries → Delete or exclude one copy
- Missing transactions → Add them in QBO
- Incorrect amounts → Edit transaction to correct amount
- Transactions in wrong month → Check dates, may need journal entry
Recording Bank Fees During Reconciliation:
During reconciliation, click [Add transaction]
Transaction type: Expense
Date: Mar 31, 2026
Payee: RBC
Account: Bank Charges
Amount: $15.00
Memo: Monthly service fee - March 2026
[Save]
Transaction automatically marked as cleared ✓
5.6 Reconciliation Best Practices
- Reconcile monthly as soon as bank statement available (don't wait!)
- Never skip a month — catching up later is painful
- Start with smallest difference first when troubleshooting
- Check for duplicate transactions (common with bank feeds)
- Verify opening balance matches last reconciliation's ending balance
- Don't force it — find and fix the actual difference
- Print/save reconciliation report for permanent record
- Attach bank statement PDF to reconciliation in QBO
- Never delete reconciled transactions (use void or adjusting entries)
- Reconcile all accounts — bank, credit cards, line of credit, PayPal
Never Make These Mistakes:
❌ Manually marking transactions "R" in register
❌ Deleting reconciled transactions
❌ Creating adjusting entry without finding real difference
❌ Skipping months "I'll catch up later"
❌ Reconciling to wrong statement or wrong date
These break reconciliation integrity and cause cascading problems!
5.7 Credit Card Reconciliation
Credit cards should be reconciled just like bank accounts.
Credit Card Reconciliation Process:
- Connect credit card to bank feeds (if available)
- Go to Accounting → Reconcile
- Select Credit Card account
- Enter statement ending date and balance
- Checkmark cleared transactions (purchases and payments)
- Add any fees or interest charges
- Reconcile to $0.00 difference
- Finish
Credit Card Payment Entry:
Paying credit card bill:
Use Transfer (NOT Expense)
Transfer from: Bank - RBC Chequing
Transfer to: Credit Card - Scotiabank Visa
Amount: $2,450.00
Date: Apr 5, 2026
Effect: Decreases bank, decreases credit card liability
(Not an expense — expenses already recorded when charged)
5.8 Troubleshooting Reconciliation Issues
When Difference Won't Clear:
| Issue |
Solution |
| Difference = transaction amount |
Missing transaction or incorrectly cleared |
| Difference = even dollar amount |
Likely missing fee or round number transaction |
| Difference divisible by 9 |
Transposed digits (e.g., $54 vs $45) |
| Opening balance wrong |
Previous reconciliation changed or deleted transaction |
| Duplicate deposits/payments |
Check for same transaction entered twice |
Step-by-Step Troubleshooting:
- Verify statement ending date and balance entered correctly
- Check opening balance matches last reconciliation
- Sort transactions by amount, look for matches to difference
- Review recent changes to previously reconciled periods
- Compare number of deposits/withdrawals to bank statement
- Look for duplicates in transaction list
- Run Reconciliation Discrepancy Report
- If stuck, save and revisit with fresh eyes
5.9 Banking Reports
Key Banking Reports:
- Reconciliation Reports: Shows cleared vs uncleared transactions
- Deposit Detail: All deposits with dates and sources
- Check Detail: All cheques written
- Missing Checks: Identifies gaps in cheque numbers
- Voided/Deleted Transactions: Audit trail of changes
- Transaction List by Date: All transactions chronologically
- Reconciliation Discrepancy: Shows changes to reconciled transactions
Accessing Reconciliation Report:
Reports → Accountant Reports
→ Reconciliation Reports
Select account: Bank - RBC Chequing
Select statement ending date: Mar 31, 2026
Report shows:
• Beginning balance
• Cleared transactions (deposits & withdrawals)
• Ending balance
• Uncleared transactions
• Register balance
[Export to PDF] [Email] [Print]
5.10 Quick Self-Check
Q1: What's the correct way to clear transactions in QuickBooks Online?
✓ Through the Reconciliation tool (never manually in register)
Q2: Bank statement shows $25,000. Books show $30,000. Outstanding cheques $4,000, deposits in transit $2,500, bank fee $500 (not recorded). What are adjusted balances?
✓ Bank adjusted: $23,500 ($25,000 + $2,500 - $4,000)
Book adjusted: $29,500 ($30,000 - $500)
Q3: What should you do with bank service fees during reconciliation?
✓ Add as new transaction: Expense → Bank Charges
Q4: How often should you reconcile bank accounts?
✓ Monthly, as soon as statement is available
Q5: What are common causes of reconciliation differences?
✓ Timing differences, missing transactions, duplicates, bank fees, misclassified transactions
Q6: How do you record credit card payment?
✓ Transfer from Bank to Credit Card (not an Expense)
Q7: Why is monthly reconciliation critical?
✓ Catches errors, prevents fraud, ensures books match reality, required for accurate financial statements
✓ Module 5 Complete
You've learned:
- How to connect Canadian banks to QBO
- Reviewing and categorizing bank feed transactions
- Creating bank rules for automation
- Complete bank reconciliation process
- Reconciliation scenario with calculations
- Common differences and how to fix them
- Outstanding cheques and deposits in transit
- Bank fees, interest, NSF entries
- Credit card reconciliation
- Troubleshooting reconciliation issues
- Critical: Never manually clear transactions or delete reconciled items
← Back to All Modules