Profit and loss statement template

Twelve months, one yearly total and formulas that do the adding up for you.

Tally the receipt with a download arrow

Download the template (.xlsx)

A profit and loss statement shows what your business earned, what it spent and what was left over for a period. This free Excel template lays that out month by month from January to December, with live formulas for total revenue, total expenses and net profit.

What’s in the template

Section What it does
Revenue Sales, service revenue and other income, plus blank rows
Cost of sales The direct cost of what you sold
Gross profit Revenue minus cost of sales
Expenses Nineteen common expense lines, plus blank rows
Net profit Gross profit minus expenses

Every month has its own column. The Total column adds up each line across the year, and the highlighted rows add each month down. Blank rows sit inside the formulas, so a line you add there is counted automatically.

How to use it

  1. Fill in your business name and the year.
  2. Change the expense labels to match your own chart of accounts. If you need a starting list, use our chart of accounts template.
  3. At the end of each month, enter that month’s totals from your bookkeeping. Leave the highlighted rows and the Total column alone, since those are formulas.
  4. Enter amounts before sales tax.
  5. Read across as well as down. A rent line that doubles in March is worth a look even when the year seems fine.

If your fiscal year doesn’t start in January, retype the month headings in your own order. The formulas don’t depend on them.

What the formulas calculate

  • Total revenue: the sum of the revenue lines.
  • Gross profit: total revenue minus total cost of sales.
  • Total expenses: the sum of the expense lines.
  • Net profit: gross profit minus total expenses. A loss shows in brackets.

How this connects to your tax return

The statement isn’t a tax form, but it feeds one. Sole proprietors report business income on Form T2125, with a separate form for each business. Corporations report income statement items using GIFI codes, CRA’s standard codes for financial statement items, on Schedule 125.

Your profit in this template and your income for tax won’t always match. Tax rules treat some items differently, and capital cost allowance replaces book amortization. Take the figures to your tax preparer as a starting point.

Common mistakes

  • Counting GST/HST as revenue. Tax you collect isn’t income to a registrant using regular accounting. CRA’s T2125 instructions for the 2025 tax year start from gross sales including GST/HST, then remove the GST/HST. The quick method has its own treatment.
  • Treating equipment as an expense. CRA says you can’t claim expenses you incur to buy capital property. You recover the cost over several years instead.
  • Including owner draws. CRA says salaries or drawings paid to you or your partners aren’t deductible, and they don’t belong in wages.
  • Claiming personal costs. CRA says you can’t deduct personal expenses, so a phone used for both only counts for its business part.
  • Mixing cash and accrual. An invoice sent in March and paid in May is a March sale if you keep your books on the accrual basis. Pick one method and stick with it.
  • Overwriting a formula. If a total looks wrong, check whether someone typed over it. Download a fresh copy and compare the formula.

Sources

Want these numbers kept up to date for you? We do monthly bookkeeping for small businesses.

General information, checked November 2026. Rules change, and your situation may differ.

Want help with this?

Tell us what you’re working on and where you need help. Choose an email reply or a callback.

Ask about this guide

Questions

What is a profit and loss statement?

It's a report of revenue minus expenses over a period, which leaves your net profit or loss. It's also called an income statement.

Should GST/HST be included in my revenue?

Not if you're a registrant using regular accounting. CRA's T2125 instructions for 2025 start with gross sales including GST/HST, then take the GST/HST back out. The quick method works differently.

Can I buy equipment and show it as an expense this month?

Not for tax. CRA says you can't deduct the full cost of depreciable property in the year you buy it. You deduct the cost over several years.

Do owner draws go on the profit and loss statement?

No. CRA says salaries or drawings paid to you or your partners aren't deductible. They're withdrawals of profit, so they belong in equity.

Keep reading

Have a question about your situation?

Send us an inquiry. You can choose an email reply or a callback.

Book a call