Skip to content
The title slide and first slides of the Canada Home Office Expense Calculator template

Canada Home Office Expense Calculator

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Employees who work from home and self-employed Canadians use this calculator to prepare a home office claim. The Space tab covers each room with its area and the area used for work. The Expenses tab holds each household cost with its yearly amount, share and months worked at home, then shows the work portion. The Dashboard sums the costs, the workspace share and the portion by category in a chart.

Measure the work area once and keep the notes with the sheet. Set a lower share for shared costs like rent and heat, and 100 percent for items bought only for work. Count only the months you worked from home. Check the CRA guidance for your situation before you claim, and consult a tax professional if you cannot tell whether you are an employee or in business.

Useful for

  • Work out the workspace share of a home
  • Split rent and utilities between home and work
  • Gather supplies and receipts for a home office claim

What's included

  • 4 tabs: Dashboard, Expenses, Space, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Expenses: a table
  • Space: a table
  • 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 Expenses 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 is the workspace share worked out?

It divides the area used for work by the total area of the home, using the Space tab. The Dashboard shows the result. You can also type a different share on any expense row if a cost follows another rule.

Which costs go on the sheet?

Whatever your own rules and the CRA guidance allow for your case. The categories cover common household bills, but whether each can be claimed depends on your status and the year. For any you doubt, consult a tax professional.

Do I need a form from my employer?

Employees are often asked for a signed form that confirms the work-from-home arrangement. This sheet does not replace it. Read the CRA page for employees and ask your employer for the form if it applies.

  • #tax-tracker
  • #canada-home-office-expense-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…