🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Bookkeeping / Office Administration › QuickBooks for Bookkeeping & Office Administration › Lesson 8
BUS-BOOK55-02 · Lesson 8 · 14 clock hours · practice

Financial Reports and Business Analysis

Objective. Students will generate and correctly interpret a Profit & Loss, Balance Sheet, and Statement of Cash Flows, and use at least two financial ratios to write a one-page business-health summary for a simulated client.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Financial Reports Matter

A bookkeeper's most visible work product is not the data entry — it is the finished financial report that a business owner, lender, or investor reads to make decisions. QuickBooks Online (QBO) can produce these reports in seconds, but speed is worthless if you cannot explain what the numbers mean. This lesson teaches you to generate the three core financial statements, export and format them professionally, calculate two key ratios, and translate everything into plain language a client can act on.

The Three Core Financial Statements

Profit & Loss (Income Statement)

The Profit & Loss report (P&L) shows revenue, cost of goods sold, gross profit, operating expenses, and net income for a specific period. In QBO, navigate to Reports → Profit and Loss. Set the date range and, for comparison, select the prior period column. Read the report top to bottom: revenue minus cost of goods sold equals gross profit; gross profit minus operating expenses equals net income (or net loss). A side-by-side comparison immediately highlights which line items changed and by how much.

Balance Sheet

The Balance Sheet is a snapshot on a single date. It lists assets on one side and liabilities plus equity on the other. The accounting equation — Assets = Liabilities + Equity — must always hold. In QBO, navigate to Reports → Balance Sheet and set the "as of" date to the last day of the period. Pay close attention to current assets (cash, accounts receivable, inventory) and current liabilities (accounts payable, credit cards, short-term loans), because those two groups drive the current ratio you will calculate later.

Statement of Cash Flows

Net income and cash in the bank are not the same thing. A profitable business can still run out of cash if customers pay slowly or if the owner buys equipment. The Statement of Cash Flows explains how cash moved during the period across three activities: operating (day-to-day business), investing (buying or selling long-term assets), and financing (loans, owner contributions, and draws). In QBO, navigate to Reports → Statement of Cash Flows. Positive operating cash flow is a healthy sign; consistent negative operating cash flow is a warning even if the P&L shows profit.

Exporting to Excel and Formatting for Clients

Once each report is on screen, click the Export icon (spreadsheet symbol) and choose Export to Excel. Open the file, remove any QBO header clutter, apply consistent number formatting (comma separator, two decimal places for currency), bold totals, and add a descriptive title block with the client name, report name, and period. Save each report as a separate tab in one workbook labeled with the client name and date. A professional presentation builds trust and reflects the standards expected of a Certified Bookkeeper.

Data accuracy comes first. Before exporting, verify that the QBO file is fully reconciled and that no uncategorized transactions remain. Presenting a report with unclassified items to a client is a material error.

Two Essential Financial Ratios

Current Ratio

The current ratio measures short-term liquidity — whether a business can pay its near-term bills.

> Current Ratio = Current Assets ÷ Current Liabilities

A ratio above 1.0 means current assets exceed current liabilities. A ratio below 1.0 signals a potential cash crunch. Compare the result to the industry benchmark provided in your scenario packet; what is "healthy" varies by sector (retail, service, construction).

Gross Profit Margin

Gross profit margin shows how efficiently a business converts sales into profit before operating expenses.

> Gross Profit Margin = (Gross Profit ÷ Total Revenue) × 100

A declining margin may mean rising supply costs, excessive discounting, or pricing problems. Again, compare to the industry benchmark — a margin that looks low in isolation may be normal for that trade.

Writing the Business-Health Memo

A one-page business-health memo translates numbers into narrative. Use the memo template provided. Structure it in three sections:

1. Overview — state the period, the key findings at a high level.

2. Detail — cite specific line items (e.g., "Utilities expense rose 18% month-over-month") and ratio results with benchmark comparisons.

3. Recommendation — propose one concrete corrective action tied directly to the data (e.g., "Because the current ratio has fallen below the industry benchmark of 1.5, we recommend reducing the outstanding accounts payable balance by accelerating collections on invoices over 30 days.").

Be precise with figures, avoid jargon a non-accountant cannot understand, and never speculate beyond what the data supports.

Accuracy and Professional Responsibility

Financial reports are used to make real business decisions — credit applications, tax filings, and payroll planning all depend on correct figures. Double-check every number you export. If a figure looks unusual, trace it back to its source transactions before reporting it. This habit is not just good practice; it is an ethical obligation recognized by the AIPB Certified Bookkeeper standards. Presenting knowingly inaccurate reports can expose both the client and the bookkeeper to legal and financial harm.

Workspace Safety Note

This lesson is entirely computer-based. Maintain an ergonomic workstation: monitor at eye level, wrists neutral, and take short breaks to prevent repetitive-strain injury. Secure all client files — whether on screen or printed — according to your firm's data privacy policy. Shred any printed drafts containing client financial data rather than placing them in general recycling.

Key terms9

Profit & Loss (P&L)A financial statement summarizing revenues, costs, and expenses during a specific period to show net income or net loss.
Balance SheetA financial snapshot on a specific date showing total assets, total liabilities, and owner's equity, which must satisfy the equation Assets = Liabilities + Equity.
Statement of Cash FlowsA financial statement that explains how cash entered and left a business during a period, categorized as operating, investing, and financing activities.
Current RatioA liquidity ratio calculated as Current Assets divided by Current Liabilities; indicates whether a business can meet its short-term obligations.
Gross Profit MarginA profitability ratio calculated as Gross Profit divided by Total Revenue, expressed as a percentage; measures how efficiently revenue is converted to gross profit.
Current AssetsAssets expected to be converted to cash or used within one year, such as cash, accounts receivable, and inventory.
Current LiabilitiesObligations due within one year, such as accounts payable, short-term loans, and credit card balances.
Operating Cash FlowThe cash generated or used by a business's core day-to-day operations, as reported in the Statement of Cash Flows.
Industry BenchmarkA standard or average ratio value typical for businesses in a specific industry, used to evaluate whether a company's financial performance is in a healthy range.

Worked examples4

1. The sample company's Balance Sheet shows Current Assets of $42,500 and Current Liabilities of $28,000. Calculate the current ratio and determine whether it meets the scenario packet's industry benchmark of 1.5.
  1. Write the formula: Current Ratio = Current Assets ÷ Current Liabilities
  2. Substitute the values: Current Ratio = $42,500 ÷ $28,000
  3. Divide: $42,500 ÷ $28,000 = 1.518 (rounded to three decimal places)
  4. Compare to the benchmark: 1.518 is greater than 1.5, so the company meets the benchmark.
Answer: Current Ratio = 1.52 (rounded to two decimal places). The company meets the industry benchmark of 1.5, indicating adequate short-term liquidity.
2. The sample company's P&L shows Total Revenue of $85,000 and Cost of Goods Sold of $51,000. Calculate the gross profit margin.
  1. Calculate Gross Profit: $85,000 − $51,000 = $34,000
  2. Write the formula: Gross Profit Margin = (Gross Profit ÷ Total Revenue) × 100
  3. Substitute the values: ($34,000 ÷ $85,000) × 100
  4. Divide first: $34,000 ÷ $85,000 = 0.4
  5. Multiply by 100: 0.4 × 100 = 40%
Answer: Gross Profit Margin = 40%. For every dollar of revenue, the company retains $0.40 after paying direct costs.
3. Last month the same company had Total Revenue of $80,000 and Cost of Goods Sold of $44,000. Calculate last month's gross profit margin and determine whether the margin improved or declined compared to this month's 40%.
  1. Calculate last month's Gross Profit: $80,000 − $44,000 = $36,000
  2. Apply the formula: ($36,000 ÷ $80,000) × 100
  3. Divide: $36,000 ÷ $80,000 = 0.45
  4. Multiply by 100: 0.45 × 100 = 45%
  5. Compare: Last month was 45%; this month is 40%. The margin decreased by 5 percentage points.
Answer: Last month's Gross Profit Margin was 45%. The margin declined 5 percentage points month-over-month, which should be flagged in the business-health memo as a concern requiring investigation into rising costs or lower pricing.
4. A client's Statement of Cash Flows shows Net Income of $12,000, but Operating Cash Flow is −$3,500. How do you explain this discrepancy in the business-health memo?
  1. Recognize that net income is an accrual-basis figure that includes revenue earned but not yet collected and expenses recorded but not yet paid.
  2. Identify that negative operating cash flow means the business consumed more cash in day-to-day operations than it generated, despite showing a profit on the P&L.
  3. Look for the most likely causes reported in the cash flow statement: a large increase in accounts receivable (customers owe money not yet collected) or a decrease in accounts payable (the business paid suppliers faster than it collected from customers).
  4. Draft memo language: 'Although net income is $12,000, operating cash flow is negative $3,500. Accounts receivable increased significantly this period, indicating that earned revenue has not yet been collected. We recommend implementing a collections follow-up process for invoices over 30 days to convert receivables to cash.'
Answer: The gap between positive net income and negative operating cash flow is most likely caused by uncollected accounts receivable. The memo should explain this in plain language and recommend a corrective action such as a structured collections process.

The math in this lesson1

Learners compute the current ratio from current assets ÷ current liabilities and compare to 1.5.
6.RP.3
In class: In a completed sample company file, run the Profit & Loss (current month vs. prior month), Balance Sheet (as of period end), and Statement of Cash Flows; export all three to Excel and format for client presentation. · Using the exported data, calculate current ratio and gross profit margin; compare values to industry benchmark figures provided in the scenario packet. · Write a one-page business-health memo addressed to the fictional owner, citing specific line-item changes and recommending one corrective action based on the ratios.
Materials: QBO sample company file, Excel, ratio formula reference sheet, industry benchmark handout, memo template, printer
Check: Instructor scores memo on a 10-point rubric (correct report figures, accurate ratio calculations, clear recommendations); pass = 8/10 points.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

QuickBooks Certified User — Reports
1. In QuickBooks Online, which navigation path produces the Profit & Loss report?
AIPB Certified Bookkeeper — Financial Reporting & Analysis
2. A company's Balance Sheet shows Current Assets of $30,000 and Current Liabilities of $20,000. What is the current ratio?
AIPB Certified Bookkeeper — Financial Reporting & Analysis
3. A business reports Total Revenue of $120,000 and Cost of Goods Sold of $78,000. What is the gross profit margin?
AIPB Certified Bookkeeper — Financial Statements
4. Which section of the Statement of Cash Flows reflects cash received from customers and cash paid to suppliers?
AIPB Certified Bookkeeper — Financial Statements
5. A company's net income is $15,000 but its operating cash flow is −$5,000. What is the most likely explanation?
Microsoft Office Specialist — Excel Data Formatting
6. When exporting a QBO report to Excel for client presentation, which of the following steps best ensures professional quality?
AIPB Certified Bookkeeper — Financial Reporting & Analysis
7. The current period gross profit margin is 38% and the prior period was 46%. The industry benchmark is 42%. Which statement BEST describes this situation in a business-health memo?
AIPB Certified Bookkeeper — Ethics & Professional Responsibility
8. According to AIPB Certified Bookkeeper standards, what is a bookkeeper's ethical obligation when a financial report contains figures that appear unusual before it is presented to a client?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →