Skip to content
Home Office Deduction Worksheet cover: a sample sheet with home square feet, office share and home costs logged and a bar chart, beside the Dashboard tab

Home Office Deduction Worksheet

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

This worksheet suits freelancers and remote workers who use part of their home for paid work. The Rooms tab lists each room with its square feet and a Use column, and only space marked Office only feeds the office share. The Expenses tab logs rent or mortgage interest, utilities, internet, insurance, repairs and office supplies, and the Dashboard shows the office share, the total costs and the business part of each one.

Measure each room once and update the sizes if you move furniture or change rooms. Write down why each space is used for work, because that note is what you will want if the figures are questioned later. Method and limits change over time, so confirm the approach with a tax preparer before you claim anything.

Useful for

  • Working out the business share of rent or mortgage interest
  • Totaling home office costs for a tax preparer
  • Checking how much of the house a home office really uses

What's included

  • 4 tabs: Dashboard, Rooms, Expenses, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Rooms: a table
  • Expenses: 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 Rooms 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

What counts as a home office for tax purposes?

In general, a space used regularly and only for your business, such as a room with a desk that is not used for family life. Shared spaces like kitchens usually do not count. Read the current IRS guidance for the details that apply to your work.

How is the business share worked out here?

The sheet divides the square feet marked Office only by the total square feet of the home. That share is applied to each home cost. Office supplies are counted in full because they are bought for the work, not for the whole house.

Can I hand this worksheet to my tax preparer?

Yes. Print the Dashboard or share the file with your preparer. They can check the room sizes and costs and decide which approach and amounts suit your return.

  • #tax-tracker
  • #home-office-deduction
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tax tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…