Skip to content
Tutorials Center
My learning

Topics

Lesson 26 of 36 ยท Reports and Taxes

Profit and Loss and Balance Sheet Reports

Read and customize the two core QuickBooks reports: Profit and Loss and Balance Sheet. Learn what each shows, how to filter and compare periods, and compute key ratios with a stand-in.

Bookkeeping exists to produce reports you can act on. Two reports matter above all others: the Profit and Loss (also called the income statement) and the Balance Sheet. Together with the cash flow statement they are the financial statements that owners, lenders and accountants read.

QuickBooks cannot run on this site. The steps describe QuickBooks Online (Reports menu); the TryIts are JavaScript stand-ins with made-up figures, not actual report output.

Profit and Loss: performance over a period

The P&L answers: did we make money between two dates? It lists income and expenses for a period, such as a month, quarter or year.

Typical structure:

  1. Income (sales and other revenue)
  2. Cost of goods sold (only if you sell products)
  3. Gross profit = Income - COGS
  4. Expenses (rent, wages, software, advertising)
  5. Net operating income = Gross profit - Expenses
  6. Other income and expenses (interest, one-time gains)
  7. Net income (profit or loss) = the bottom line

Open Reports > Profit and Loss. Key controls at the top:

  • Report period: this month, last quarter, a custom range.
  • Accounting method: Cash or Accrual (see Cash vs Accrual Basis). Always confirm which is selected; the same data gives different numbers.
  • Display columns by: months, quarters, customers, classes or locations, to compare periods or business units.
  • Compare another period (previous period or previous year) with change in dollars and percent.

Click any amount to drill down into the underlying transactions. This is the fastest way to find an incorrectly categorized item: if "Office supplies" is unexpectedly large, click it and scan the list.

Balance Sheet: position on one date

The Balance Sheet answers: what do we own, what do we owe, and what is left for the owner on this date? It is a snapshot, not a period.

Assets = Liabilities + Equity

  • Assets: bank accounts, accounts receivable, inventory, equipment.
  • Liabilities: accounts payable, credit cards, loans, sales tax and payroll taxes owed.
  • Equity: owner investment, retained earnings, current-year net income (and owner draws, which reduce equity).

Choose Reports > Balance Sheet and set Report period to the date you want (it is "as of" that date). A well-kept book has a balance sheet where Total Assets equal Total Liabilities and Equity by construction; the interesting checks are on the accounts themselves:

  • Bank balances agree with reconciled statements.
  • Accounts receivable and payable equal the aging reports (Aging Reports and Cash Flow).
  • Undeposited Funds is near zero.
  • No unexplained Opening Balance Equity (a leftover from setup that should be cleared by your accountant).
  • Payroll liabilities match the payroll reports.

The P&L feeds the balance sheet: this year's net income flows into equity (retained earnings), so the two statements always connect.

flowchart LR
    A["Income - Expenses<br/>(Profit and Loss)"] --> B["Net income"]
    B --> C["Equity (retained earnings)"]
    D["Assets"] --- E["Liabilities + Equity"]
    C --> E

Net income from the P&L ends up inside equity on the balance sheet.

Customizing and saving

Click Customize to change rows and columns, show or hide zero rows, and filter by customer, vendor or class. Click Save customization to add it to Custom reports so a monthly version is one click away. Use Memorized or scheduled reports (in Reports, the Management reports and Custom reports sections, depending on plan) to email reports to yourself or your accountant on a schedule. You can export to Excel or PDF.

Reading reports with ratios

Numbers become meaningful through comparison. Useful measures:

  • Gross margin = Gross profit / Income.
  • Net margin = Net income / Income.
  • Current ratio = Current assets / Current liabilities (a liquidity check; above 1 means you can cover short-term bills).
  • Expense share = one expense line / Income, to spot cost creep.
JS Compute margins from a small P&L

Press Run (or Ctrl + Enter) to see the console output here.

No output.

JS Does the balance sheet balance?

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Note the owner draws are negative equity: taking money out is not an expense, and it does not appear on the P&L.

Common reading mistakes

  • Comparing a cash-basis report one month with an accrual report the next.
  • Reading a profit as cash: profit is not the same as the bank balance (the cash flow report explains the gap).
  • Ignoring "Uncategorized Income/Expense" lines, which mean you skipped categorizing.
  • Looking at the P&L but never the balance sheet; many problems (stuck receivables, loans) appear only there.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which report shows performance over a period of time?

    The P&L covers a date range; the balance sheet is a snapshot as of one date.
  2. 2. What is the accounting equation?

    Everything the business owns is financed by what it owes (liabilities) or what the owner has invested and earned (equity).
  3. 3. Gross profit equals...

    Gross profit is income less the direct cost of the goods sold, before operating expenses.
  4. 4. How do you find which transactions make up a number on a report?

    Clicking an amount opens the transactions behind it, ideal for spotting miscategorized items.

Summary

  • The P&L shows income minus expenses over a period; the balance sheet shows assets, liabilities and equity on a date.
  • Check the accounting method, period and columns before reading either.
  • Net income flows into equity, so the statements are linked.
  • Use drill-down, comparisons, saved customizations and ratios to turn reports into decisions.

Next: Aging Reports and Cash Flow