Skailit - QuickBooks Online Refresher Course

๐ŸŽฏ Purpose

This course refreshes and strengthens your practical knowledge of QuickBooks Online, helping you maintain accuracy, efficiency, and confidence in real-world bookkeeping tasks.

๐Ÿš€ Outcome

By the end of this course, you will confidently manage transactions, perform reconciliations, correct errors, apply tax rules, and interpret financial reports in QuickBooks Online.

๐Ÿ“˜ Module 1: Accounting Fundamentals Refresher

Master the core Canadian accounting principles essential for confident use of QuickBooks Online. Strong fundamentals ensure accurate transaction classification, reliable financial reports, and CRA compliance.

1.1 Why Accounting Fundamentals Matter in QuickBooks Online

QuickBooks Online automates many tasks, but success depends on correct accounting logic. Misclassifying transactions leads to inaccurate financial statements and incorrect tax filings with the Canada Revenue Agency (CRA).

Canadian Business Essentials:

  • HST/GST Compliance: Tax handling varies by province (13% HST in Ontario, 5% GST + PST in BC, etc.)
  • CRA Requirements: Maintain books and records for 6 years minimum
  • Currency: All amounts in Canadian Dollars (CAD $)
  • Bank Integration: Connects with RBC, TD, Scotiabank, BMO, CIBC, Desjardins
  • Input Tax Credits (ITCs): Recover HST/GST paid on business expenses
Key Principle: Garbage In โ†’ Garbage Out. Clean data = trustworthy reports.

1.2 The Accounting Equation

Assets = Liabilities + Equity

This equation must always balance. Every transaction affects at least two accounts.

Common Canadian Examples (CAD $):

  • Purchase equipment $8,000 cash โ†’ Assets: Equipment โ†‘$8,000 | Bank โ†“$8,000
  • Invoice $3,000 + 13% HST โ†’ Assets: AR โ†‘$3,390 | Revenue โ†‘$3,000 | HST Payable โ†‘$390
  • Pay supplier bill $1,500 โ†’ Liabilities: AP โ†“$1,500 | Assets: Bank โ†“$1,500
  • Owner invests $10,000 โ†’ Assets: Bank โ†‘$10,000 | Equity: Capital โ†‘$10,000

Correcting Classification Errors

Common Mistake: Recording $8,000 office supplies as Equipment (asset) instead of Office Supplies (expense)

Impact: Assets overstated $8,000, Expenses understated $8,000, Net income overstated $8,000

Correction (if last month is closed):
DO NOT reopen closed period. Post adjusting entry in CURRENT period:

Debit: Office Supplies Expense $8,000
Credit: Equipment $8,000
Memo: "Reclassify office supplies from March 2026"

Simulation: Journal Entry in QBO

+ New โ†’ Journal Entry
Date: Apr 15, 2026 | No.: ADJ-APR-001

ACCOUNT DEBIT CREDIT
Office Supplies Expense 8,000.00
Equipment 8,000.00
โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
TOTALS 8,000.00 8,000.00 โœ“

[Save and close]

1.3 Accrual vs Cash Basis Accounting

QBO records transactions the same way โ€” you choose the view when running reports.

Aspect Cash Basis Accrual Basis
Revenue When cash received When earned (invoiced)
Expenses When cash paid When incurred (billed)
CRA Requirement Allowed for small businesses Required for corporations
Best For Simple operations True profitability picture

Real-World Example

Scenario: Invoice client $50,000 on December 28, 2025. Client pays January 15, 2026.

Accrual Accounting: Revenue recognized December 2025 (when earned/delivered)
โ€ข Dec P&L: $50,000 revenue
โ€ข Dec Balance Sheet: $50,000 Accounts Receivable
โ€ข Jan P&L: $0 revenue (already recorded)

Cash Accounting: Revenue recognized January 2026 (when cash received)
โ€ข Dec P&L: $0 revenue
โ€ข Jan P&L: $50,000 revenue

Switching Reports in QBO

Reports โ†’ Profit and Loss
Accounting method: [โ–ผ Accrual] โ† Click to switch
    โ€ข Accrual โœ“
    โ€ข Cash

Same data, different view!

Key Differences:

  • Cash basis matches actual cash flow, simpler for tax filing
  • Accrual basis matches revenue with expenses (matching principle), shows true profitability
  • Many Canadian businesses use accrual for management, cash for tax filing (if CRA-approved)

1.4 Chart of Accounts โ€“ Organizing Transactions

Purpose: The Chart of Accounts organizes and categorizes all financial transactions systematically. It determines how data flows into Balance Sheet and Profit & Loss reports.

Five Main Account Types:

  • Assets (what you own): Bank, Accounts Receivable, HST Receivable (ITCs), Equipment, Inventory
  • Liabilities (what you owe): Accounts Payable, HST Payable, Credit Cards, Payroll Liabilities (CPP, EI)
  • Equity (owner's interest): Owner's Capital, Retained Earnings, Drawings
  • Income: Sales Revenue, Service Income, Interest Income
  • Expenses: Rent, Salaries, Office Supplies, Utilities, Depreciation

Sample Canadian Chart of Accounts

ASSETS
1010 Bank - RBC Chequing
1200 Accounts Receivable
1300 HST Receivable (ITCs)
1700 Equipment
1750 Accumulated Depreciation (contra-asset)

LIABILITIES
2000 Accounts Payable
2100 HST Payable
2200 CPP Payable
2210 EI Payable

EQUITY
3000 Owner's Capital
3100 Owner's Drawings

INCOME
4000 Sales Revenue
4100 Service Income

EXPENSES
6000 Rent Expense
6500 Office Supplies
6900 Salaries & Wages

1.5 Double-Entry Bookkeeping โ€“ Debits and Credits

Every transaction has equal debits and credits. Total debits always equal total credits.

Account Type Increase Decrease Normal Balance
Assets Debit Credit Debit
Liabilities Credit Debit Credit
Equity Credit Debit Credit
Revenue Credit Debit Credit
Expenses Debit Credit Debit
Accounts with CREDIT Balances:
โ€ข Revenue (all income accounts)
โ€ข Liabilities (Accounts Payable, HST Payable, Loans, CPP/EI Payable)
โ€ข Equity (Owner's Capital, Retained Earnings)
โ€ข Accumulated Depreciation (contra-asset)

Accounts with DEBIT Balances:
โ€ข Assets (Bank, AR, Equipment, HST Receivable)
โ€ข Expenses (all expense accounts)
โ€ข Owner's Drawings (contra-equity)

Transaction Examples with HST

1. Customer Invoice ($2,500 + 13% HST)
Debit: Accounts Receivable $2,825
Credit: Service Income $2,500
Credit: HST Payable $325
2. Office Supplies Purchase ($1,000 + 13% HST)
Debit: Office Supplies Expense $1,000
Debit: HST Receivable (ITC) $130
Credit: Bank $1,130
3. Rent Bill (no HST)
Debit: Rent Expense $3,500
Credit: Accounts Payable $3,500

1.6 Trial Balance and Error Detection

A Trial Balance lists all accounts with their debit or credit balances. Total debits must equal total credits.

Trial Balance Can Still Balance With These Errors:

  • Double-posting: Transaction entered twice (both debit and credit duplicated)
  • Wrong account: Office Supplies coded as Equipment (both debits, balance maintained)
  • Classification error: Revenue recorded as liability (credits balance)
  • Complete omission: Entire transaction missing (debit and credit both absent)
  • Offsetting errors: Two errors canceling each other out

Sample Trial Balance

Toronto Business Inc.
Trial Balance - March 31, 2026

ACCOUNT DEBIT CREDIT
โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
Bank - RBC 45,280.00
Accounts Receivable 12,450.00
Equipment 36,000.00
Accum Depreciation 3,000.00
Accounts Payable 8,750.00
HST Payable 4,225.00
Owner's Capital 50,000.00
Service Income 82,500.00
Salaries Expense 35,000.00
Rent Expense 10,500.00
Office Supplies 2,800.00
โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
TOTALS 142,030.00 148,475.00

โš ๏ธ OUT OF BALANCE - Investigation needed!

1.7 Reconciled Transactions โ€“ Critical Rule

NEVER Delete Reconciled Transactions

Consequences of deleting:
โ€ข Breaks reconciliation integrity
โ€ข Creates discrepancies in financial reports
โ€ข Makes future reconciliations impossible
โ€ข Violates CRA audit trail requirements
โ€ข Could indicate fraud or poor record-keeping

Correct approach:
โ€ข VOID the transaction (preserves history)
โ€ข Create adjusting journal entry in current period
โ€ข Add detailed memo explaining correction
โ€ข Attach supporting documentation

QBO Warning Example

โš ๏ธ This transaction has been reconciled

Deleting will cause:
โ€ข Reconciliation to become unbalanced
โ€ข Discrepancies in financial reports
โ€ข Audit trail issues

Recommended: VOID instead of DELETE

[Cancel] [Void Transaction] [Delete Anyway]

โœ“ Always choose VOID

1.8 Prepaid Expenses and the Matching Principle

Prepaid expenses are assets that become expenses over time. Properly allocate costs to match the periods benefited.

Example: Annual Insurance

January 1: Pay $12,000 for annual insurance

Initial Entry:
Debit: Prepaid Insurance (Asset) $12,000
Credit: Bank $12,000

Monthly Adjustment (each month-end):
Debit: Insurance Expense $1,000
Credit: Prepaid Insurance $1,000
Memo: "Monthly insurance expense (1/12 of annual)"

Month-by-Month Impact

Date Prepaid Insurance Monthly Expense
Jan 1 $12,000 $0
Jan 31 $11,000 $1,000
Feb 28 $10,000 $1,000
Dec 31 $0 $1,000

Why adjust monthly? To match the expense with the period it benefits, giving accurate monthly profitability.

Setting Up Recurring Entry in QBO

+ New โ†’ Journal Entry

โ˜‘ Make Recurring
Template: Monthly Insurance Adjustment
Type: Scheduled
Interval: Monthly on last day
Occurrences: 12

QBO creates this automatically each month!

1.9 Key Accounting Principles for Canadian Businesses

Core Principles:

  • Going Concern: Assume business continues operating
  • Matching Principle: Match expenses with revenue they generate
  • Consistency: Use same methods period to period
  • Materiality: Focus on significant items
  • Economic Entity: Separate personal and business transactions
  • Full Disclosure: Provide complete information (use memos, attachments)

Canadian-Specific Best Practices:

  • Maintain records for 6 years (CRA requirement)
  • Properly track HST/GST for Input Tax Credits
  • Reconcile bank accounts monthly
  • Never mix personal and business funds
  • Categorize bank feeds weekly (minimum)
  • Attach receipts to QBO transactions
  • Use sub-accounts for better organization
  • Review Audit Log monthly

1.10 Quick Self-Check

Q1: Company invoices $50,000 in December, receives payment in January. When is revenue recognized under accrual accounting?

โœ“ December (when earned/invoiced)

Q2: Office supplies ($8,000) incorrectly recorded as Equipment last month (closed). How to correct?

โœ“ Journal entry in current period: Debit Office Supplies Expense, Credit Equipment

Q3: Which accounts have credit balances?

โœ“ Revenue, Liabilities, Equity, Accumulated Depreciation

Q4: What is the Chart of Accounts used for?

โœ“ To organize and categorize all financial transactions systematically

Q5: Why never delete reconciled transactions?

โœ“ Breaks reconciliation integrity and causes report discrepancies

Q6: Annual insurance $12,000 paid Jan 1. Monthly expense?

โœ“ $1,000 per month ($12,000 รท 12)

Q7: Can trial balance be balanced with errors present?

โœ“ Yes - double-posting, wrong accounts, omissions can still balance

โœ“ Module 1 Complete

You've learned:

  • Accounting equation and transaction impacts
  • Accrual vs cash accounting (CRA context)
  • Chart of Accounts organization
  • Double-entry bookkeeping and debits/credits
  • Trial balance and error detection
  • Prepaid expense adjustments
  • How to correct errors properly
  • Why to never delete reconciled transactions
  • Canadian accounting principles and best practices

โ† Back to All Modules