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 2: Company Setup & Chart of Accounts

Proper company setup and a well-organized Chart of Accounts form the foundation of accurate bookkeeping in QuickBooks Online. A clean setup prevents errors, saves time, and produces reliable financial reports for Canadian businesses.

2.1 Initial Company Setup in QuickBooks Online

When creating a new company in QBO, focus on these critical settings:

  1. Company Information: Legal business name, address, phone, and email (appears on invoices and tax forms)
  2. Business Type & Industry: QBO suggests relevant accounts and tax settings based on your selection
  3. Features to Enable:
    • Invoicing and sales tracking
    • Expense tracking and bills
    • Sales tax (HST/GST in Canada)
    • Inventory (if applicable)
    • Projects (for job costing)
  4. Fiscal Year: Most Canadian businesses use January–December (calendar year)
  5. Accounting Method: Accrual (required for corporations) or Cash (allowed for small businesses)

Accessing Company Settings

βš™οΈ Gear Icon β†’ Account and settings

COMPANY TAB:
β€’ Company name, legal name, EIN
β€’ Address, phone, email, website
β€’ Upload logo for invoices

SALES TAB:
β€’ Customize invoice templates
β€’ Default payment terms (Net 30)
β€’ Sales tax settings (HST/GST)
β€’ Products and services

EXPENSES TAB:
β€’ Enable billable expenses
β€’ Purchase orders tracking
β€’ Default bill payment terms

ADVANCED TAB:
β€’ Accounting method (Accrual/Cash)
β€’ First month of fiscal year
β€’ Chart of accounts settings
β€’ Class tracking, Location tracking
β€’ Automation preferences
Canadian Businesses: Ensure HST/GST is properly configured in Sales Tax settings. Choose your province to auto-calculate correct rates (13% ON, 5% AB, 15% NS, etc.)

2.2 The Chart of Accounts – Your Financial Roadmap

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

Two Critical Settings for Every Account:

  • Account Type β€” Controls where the account appears on financial statements (Assets, Liabilities, Equity, Income, Expenses)
  • Detail Type β€” Provides specific categorization within the Account Type (helps with reporting but doesn't change financial behavior)

The Six Main Account Types in QBO:

1. Assets (what the business owns)
  • Bank (chequing, savings accounts)
  • Accounts Receivable (customer invoices not yet paid)
  • Other Current Assets (HST Receivable/ITCs, Prepaid Expenses)
  • Fixed Assets (Equipment, Vehicles, Buildings)
  • Other Assets (Long-term investments)
2. Liabilities (what the business owes)
  • Accounts Payable (vendor bills not yet paid)
  • Credit Card (business credit cards)
  • Other Current Liabilities (HST Payable, Payroll Liabilities - CPP/EI/Income Tax)
  • Long Term Liabilities (Loans, Mortgages)
3. Equity (owner's interest)
  • Owner's Equity / Capital
  • Owner's Drawings (contra-equity)
  • Retained Earnings (auto-generated, cumulative profits)
4. Income / Revenue
  • Sales Revenue (product sales)
  • Service Income (service revenue)
  • Other Income (interest, miscellaneous)
5. Cost of Goods Sold (COGS)
  • Materials, Direct Labor (for product-based businesses)
  • Subcontractors, Shipping costs
6. Expenses
  • Operating expenses (Rent, Utilities, Salaries, Office Supplies)
  • Administrative expenses (Professional Fees, Insurance)
  • Depreciation, Interest Expense

2.3 Sample Canadian Chart of Accounts

ASSETS (1000-1999)
1010 Bank - RBC Chequing Account
1020 Bank - TD Savings Account
1200 Accounts Receivable
1210 Allowance for Doubtful Accounts (contra)
1300 HST Receivable (Input Tax Credits)
1400 Prepaid Insurance
1410 Prepaid Rent
1500 Inventory
1700 Equipment
1710 Vehicles
1750 Accumulated Depreciation - Equipment (contra)
1760 Accumulated Depreciation - Vehicles (contra)

LIABILITIES (2000-2999)
2000 Accounts Payable
2050 Credit Card - Scotiabank Visa
2100 HST/GST Payable
2200 Payroll Liabilities - CPP
2210 Payroll Liabilities - EI
2220 Payroll Liabilities - Income Tax
2300 Loan Payable - BMO
2400 Line of Credit - TD

EQUITY (3000-3999)
3000 Owner's Capital
3100 Owner's Drawings
3900 Retained Earnings (auto-generated)

INCOME (4000-4999)
4000 Sales Revenue - Products
4100 Service Income - Consulting
4200 Service Income - Training
4900 Other Income

COST OF GOODS SOLD (5000-5999)
5000 Materials & Supplies
5100 Direct Labor
5200 Subcontractors

EXPENSES (6000-7999)
6000 Advertising & Marketing
6100 Bank Charges & Fees
6200 Depreciation Expense
6300 Insurance Expense
6400 Interest Expense
6500 Meals & Entertainment (50% deductible)
6600 Office Supplies
6700 Professional Fees - Accounting
6710 Professional Fees - Legal
6800 Rent Expense
6900 Salaries & Wages
7000 Telephone & Internet
7100 Utilities
  7110 Electricity
  7120 Water & Sewer
  7130 Natural Gas
7200 Vehicle Expenses
  7210 Fuel
  7220 Repairs & Maintenance
  7230 Insurance
  7240 Licence & Registration

2.4 Creating New Accounts in QBO

Step-by-Step Process:

  1. Go to Gear Icon β†’ Chart of Accounts
  2. Click New button
  3. Select Account Type (most important choice)
  4. Choose Detail Type (for specific categorization)
  5. Enter Name (be descriptive and consistent)
  6. Add Number (optional but recommended)
  7. Check Sub-account box if grouping under parent
  8. Enter Description (helps other users understand purpose)
  9. Click Save and Close

Simulation: Creating Office Supplies Account

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚ Account β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ Account Type: [Expenses β–Ό] β”‚
β”‚ β”‚
β”‚ Detail Type: β”‚
β”‚ [Office/General Administrative β–Ό] β”‚
β”‚ β”‚
β”‚ Name: Office Supplies β”‚
β”‚ β”‚
β”‚ Number: 6600 β”‚
β”‚ β”‚
β”‚ β˜‘ Is sub-account β”‚
β”‚ Parent: Operating Expenses β”‚
β”‚ β”‚
β”‚ Description: Supplies for daily β”‚
β”‚ office operations β”‚
β”‚ β”‚
β”‚ [Save and Close] [Cancel] β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
Account Type is Critical: It determines where the account appears on financial statements. Changing it later can affect historical reports. Choose carefully!

2.5 Best Practices for Chart of Accounts

Keep It Simple and Organized:

  • Avoid over-complication: Don't create separate accounts for every tiny expense (use one "Office Supplies" instead of "Pens," "Paper," "Staples")
  • Use sub-accounts wisely: Group related items (Utilities parent with Electricity, Internet, Water subs)
  • Follow naming conventions: Be consistent (don't mix "Office Supplies" and "Supplies - Office")
  • Enable account numbers: Helpful for larger businesses and reports
    • 1000-1999: Assets
    • 2000-2999: Liabilities
    • 3000-3999: Equity
    • 4000-4999: Income
    • 5000-5999: Cost of Goods Sold
    • 6000-7999: Expenses

Canadian-Specific Setup:

  • Create HST Receivable (Other Current Assets) for Input Tax Credits
  • Create HST Payable (Other Current Liabilities) for tax collected
  • Set up Payroll Liabilities accounts: CPP Payable, EI Payable, Income Tax Payable
  • Consider separate accounts for different revenue streams if tracking provincial sales

Maintenance Tips:

  • Make accounts inactive instead of deleting (preserves history)
  • Never delete reconciled accounts (breaks audit trail)
  • Review quarterly: Merge duplicates, inactivate unused accounts
  • Consult your accountant before major changes
  • Document custom accounts: Add descriptions so others understand purpose

2.6 Sub-Accounts – Organizing for Better Reporting

Sub-accounts create hierarchy in your Chart of Accounts. They roll up into parent accounts on reports.

Example: Utilities Structure

7100 Utilities (Parent - Expense)
    7110 Electricity (Sub-account)
    7120 Internet & Phone (Sub-account)
    7130 Water & Sewer (Sub-account)
    7140 Natural Gas (Sub-account)

Profit & Loss Display:
Utilities                   $2,450
  Electricity             $850
  Internet & Phone       $120
  Water & Sewer         $180
  Natural Gas           $1,300

When to Use Sub-Accounts:

  • Multiple expense categories under one heading (Utilities, Vehicle Expenses, Professional Fees)
  • Department or location tracking within account types
  • Different product/service lines within revenue
  • Fixed assets by category (Equipment, Vehicles, Furniture)

Creating a Sub-Account:

Chart of Accounts β†’ New

Account Type: Expenses
Detail Type: Utilities
Name: Electricity
Number: 7110
β˜‘ Is sub-account
  Enter parent account: [7100 Utilities β–Ό]

[Save and Close]

2.7 Advanced Features – Classes and Locations

Beyond the Chart of Accounts, QBO Plus and Advanced offer additional tracking dimensions:

Classes (Department/Division Tracking)

  • Track profitability by business line (Consulting, Training, Products)
  • Separate departments (Sales, Operations, Admin)
  • Project types or service categories
  • Generate P&L by Class to see which areas are profitable

Locations (Geographic/Physical Tracking)

  • Multiple office locations (Toronto, Vancouver, Montreal)
  • Retail stores or warehouses
  • Different facilities or buildings
  • Generate reports by Location for each site's performance

Enabling Class/Location Tracking:

βš™οΈ Gear Icon β†’ Account and settings β†’ Advanced

Categories:
β˜‘ Track classes
  β˜ Warn if transaction not assigned a class
  β˜ Assign classes to each row in transaction

β˜‘ Track locations
  β˜ Warn if transaction not assigned a location

[Save]

Then create your Classes/Locations:

Settings β†’ All Lists β†’ Classes β†’ New Class
Examples: Consulting, Training, Products, Admin

Settings β†’ All Lists β†’ Locations β†’ New Location
Examples: Toronto Office, Vancouver Warehouse

2.8 Special Accounts to Understand

Auto-Generated Accounts (Don't Edit These):

Retained Earnings
β€’ Auto-generated equity account
β€’ QBO automatically closes income/expenses here at year-end
β€’ Shows cumulative net income kept in the business
β€’ NEVER post directly to this account β€” it's system-controlled
Opening Balance Equity
β€’ Temporary account created when entering opening balances
β€’ Should be zeroed out by transferring to proper equity accounts
β€’ Don't use for ongoing transactions
β€’ Work with accountant to clean up this account
Uncategorized Income/Expense
β€’ Catch-all when QBO can't determine category
β€’ Review monthly and recategorize all transactions
β€’ Goal: Keep this at zero balance
β€’ High balances indicate poor transaction categorization

Contra Accounts (Negative Balances):

  • Accumulated Depreciation: Contra-asset (credit balance) that reduces asset value
  • Allowance for Doubtful Accounts: Contra-asset for estimated uncollectible receivables
  • Owner's Drawings: Contra-equity (debit balance) that reduces equity
  • Sales Returns & Allowances: Contra-revenue (optional, tracks refunds/discounts)

2.9 Common Setup Mistakes to Avoid

  • ❌ Using personal bank accounts instead of dedicated business accounts
  • ❌ Over-complicating the COA with 100+ accounts for a small business
  • ❌ Not enabling HST/GST during initial setup (hard to fix later)
  • ❌ Deleting accounts that have been reconciled or have historical transactions
  • ❌ Creating duplicate accounts with similar names (Office Supplies vs Supplies - Office)
  • ❌ Wrong Account Type selection (choosing Expense when it should be Asset)
  • ❌ Not using sub-accounts, creating flat messy lists
  • ❌ Making changes without consulting accountant
  • ❌ Not documenting custom accounts with descriptions
Critical: The Account Type determines financial statement placement. Changing it later affects all historical reports. Double-check before saving!

2.10 Account Numbers – Optional but Recommended

Account numbers help organize and sort your Chart of Accounts consistently.

Standard Numbering System:

Range Account Type Examples
1000-1999 Assets 1010 Bank, 1200 AR, 1700 Equipment
2000-2999 Liabilities 2000 AP, 2100 HST Payable
3000-3999 Equity 3000 Capital, 3100 Drawings
4000-4999 Income 4000 Sales, 4100 Service Income
5000-5999 COGS 5000 Materials, 5100 Labor
6000-7999 Expenses 6000 Rent, 7000 Utilities

Enabling Account Numbers:

βš™οΈ Gear Icon β†’ Account and settings β†’ Advanced

Chart of accounts:
β˜‘ Enable account numbers
β˜‘ Show account numbers

[Save]

2.11 Quick Self-Check

Q1: What is the most critical setting when creating a new account?

βœ“ Account Type (determines financial statement placement)

Q2: Should you delete unused accounts from QuickBooks?

βœ“ No β€” make them inactive instead (preserves history)

Q3: What are sub-accounts used for?

βœ“ To group related accounts under a parent for better organization and reporting

Q4: What is the Chart of Accounts?

βœ“ Complete list of categories used to classify and organize all financial transactions

Q5: How do you organize Utilities expenses properly?

βœ“ Create parent "Utilities" account with sub-accounts for Electricity, Water, Internet, etc.

Q6: What account numbers are typically used for Assets?

βœ“ 1000-1999 range

Q7: Why enable HST/GST during initial setup?

βœ“ Ensures proper tax tracking from day one; difficult to fix later

βœ“ Module 2 Complete

You've learned:

  • How to set up a new company in QBO
  • Purpose and structure of Chart of Accounts
  • Six main account types and their uses
  • How to create and organize accounts properly
  • Sub-accounts for hierarchical reporting
  • Classes and Locations for advanced tracking
  • Special accounts (Retained Earnings, contra accounts)
  • Account numbering system
  • Common mistakes to avoid
  • Canadian-specific setup requirements (HST tracking)

← Back to All Modules