Skip to content
The title slide and first slides of the Canada Self-Employed Expense Tracker template

Canada Self-Employed Expense Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Canadian freelancers, contractors and sole proprietors use this tracker to prepare the business section of their return. The Income tab lists invoices with GST or HST charged. The Expenses tab sorts costs into fourteen lines that follow the self-employed form, with sales tax paid, business share and the claimable amount. The Shares tab turns kilometres and floor area into vehicle and home percentages, and the Dashboard shows net income and costs by line.

Record every payment when it arrives and every cost as you pay it. Choose the expense line carefully so the totals map straight to the form later. Fill in the Shares tab from your logbook and a measured workspace, then type those percentages on the rows that need them. At year end, give the line totals and the sales tax difference to your accountant or enter them in your tax software.

Useful for

  • Sort costs by line before filing
  • See net income as the year goes on
  • Compare GST/HST collected with GST/HST paid

What's included

  • 5 tabs: Dashboard, Income, Expenses, Shares, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Income: a table
  • Expenses: a table
  • Shares: a ready-to-fill form
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Income tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track business expenses for a Canadian self-employed return?

For each cost, record the date, vendor, amount, sales tax and expense line, and keep the receipt. The Expenses tab does this and totals each line on the Dashboard, ready to compare with the form.

How is my vehicle's business share calculated?

Divide business kilometres by total kilometres from a logbook kept for the year. The Shares tab does the division, and you type the result in the vehicle rows. Check current CRA rules on logbooks.

Is GST/HST part of my expense?

Registrants usually claim sales tax paid as an input credit rather than as part of the cost, so a separate column here holds it. Ask an accountant how it applies to you.

  • #tax-tracker
  • #canada-self-employed-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…