Skailit - QuickBooks Online Refresher Course

9.1 Why Financial Reports Matter in QuickBooks Online

QuickBooks Online makes running reports easy, but the real value comes from understanding what the numbers mean and how to use them.

• Track profitability and trends over time
• Assess financial health and liquidity
• Identify cost control opportunities
• Support tax filing, loan applications, and business planning
• Detect errors or unusual activity early

In QBO, most reports can be viewed on **Accrual** or **Cash** basis instantly — choose Accrual for accurate performance analysis.

9.2 How to Access and Run Reports in QuickBooks Online

Step-by-Step Navigation (2026 interface):

1. From the left menu, click Reports
2. Use the search bar or browse categories: Business overview, Sales, Expenses, Payroll, etc.
3. Click on any report to open it
4. Customize using the top filters: Date range, Columns, Rows, Accounting method (Accrual/Cash)
5. Click Run report
6. Use options like "Save customization", "Export to Excel/PDF", or "Email"

Pro Tip: Add frequently used reports to Favorites by clicking the star icon for quick access.

9.3 The Profit & Loss (Income Statement) Report

The Profit & Loss (P&L) shows revenue, expenses, and net profit/loss over a period of time (month, quarter, year).

• Income / Revenue: Sales, service income, other income
• Cost of Goods Sold (COGS): Direct costs of products/services sold
• Gross Profit: Revenue minus COGS
• Operating Expenses: Rent, salaries, utilities, marketing
• Net Operating Income
• Net Income (Bottom Line)

Simulation: Sample Profit & Loss in QBO

Analysis Tips: Compare to previous periods or budget. Calculate Gross Margin % = (Gross Profit / Revenue) × 100. Watch for rising expense percentages.

9.4 The Balance Sheet Report

The Balance Sheet is a snapshot of what the business owns (Assets), owes (Liabilities), and the owner's equity at a specific date.

It must always balance: Assets = Liabilities + Equity.

• Current Assets: Cash, Accounts Receivable, Inventory, Prepaids
• Fixed Assets: Equipment, vehicles minus Accumulated Depreciation
• Current Liabilities: Accounts Payable, HST Payable, short-term loans
• Long-term Liabilities: Loans due after one year
• Equity: Owner's capital, Retained Earnings, Net Income

Key Metrics to Watch: Working Capital = Current Assets - Current Liabilities. Current Ratio = Current Assets / Current Liabilities (ideal > 1.5).

9.5 Statement of Cash Flows

This report shows how cash moved in and out of the business from three activities:

• Operating Activities: Cash from day-to-day operations
• Investing Activities: Cash used for or from assets (equipment purchases)
• Financing Activities: Cash from loans, owner investments, or repayments

Important Insight: A business can show profit on the P&L but still have negative cash flow (e.g., due to slow collections or heavy inventory purchases).

9.6 Other Important Reports in QBO

• Trial Balance: Lists all accounts and their debit/credit balances
• A/R Aging Summary & Detail: Tracks overdue customer invoices
• A/P Aging: Shows what you owe vendors
• General Ledger: Detailed transaction history per account
• HST/GST Summary (Canada): Shows HST collected vs. Input Tax Credits
• Management Reports (Advanced): Professional packages with P&L, Balance Sheet, and notes

9.7 Customizing Reports in QuickBooks Online

Make reports more useful:

• Change date range or compare to previous period/year
• Group by Customer, Class, Location, or Product/Service
• Filter specific accounts or transaction types
• Add columns for % of income or year-over-year change
• Save customizations as favorites

9.8 Financial Analysis Techniques

Go beyond numbers — analyze trends and ratios:

• Trend Analysis: Compare current month to last month or same month last year
• Vertical Analysis: What % of revenue each expense represents
• Horizontal Analysis: Year-over-year growth or decline
• Ratio Analysis:
  • Gross Margin %
  • Net Profit Margin %
  • Current Ratio
  • Debt-to-Equity Ratio

9.9 Canadian-Specific Reporting (HST Focus)

Use these reports for HST compliance:

• HST/GST Summary Report
• Balance Sheet (to verify HST Payable and ITC balances)
• Taxable Sales reports

Run reports for your CRA filing period (monthly, quarterly, or annual) before remitting net HST.

9.10 Best Practices for Report Analysis

• Run reports on Accrual basis for performance review
• Review reports monthly as part of your close process
• Compare actual vs. budget (if set up)
• Look for red flags: declining margins, rising receivables, negative cash flow
• Export to Excel for deeper charting and forecasting
• Share management report packages with business owners

9.11 Common Reporting Mistakes to Avoid

• Running reports on Cash basis when analyzing profitability
• Not reconciling accounts before running reports
• Ignoring small variances that may indicate bigger issues
• Forgetting to customize date ranges or filters
• Not reviewing supporting detail reports when totals look off

9.12 Extended Self-Check Questions

Q1: What is the main difference between the Profit & Loss and the Balance Sheet?

Answer: P&L shows performance over a period; Balance Sheet shows position at a point in time.

Q2: Why might a profitable business still have cash flow problems?

Answer: Due to slow customer collections, heavy inventory purchases, or large asset investments.

Q3: What report should you run to verify that Assets = Liabilities + Equity?

Answer: The Balance Sheet.

Q4: In Canada, which report helps prepare your HST/GST return?

Answer: GST/HST Summary Report.