Skip to content
Tax Deduction Tracker cover: a sample sheet with total paid, business part and receipts missing and a bar chart, beside the Dashboard and Deductions tabs

Tax Deduction Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

Freelancers, sole traders and owners of one-person firms use this tax deduction tracker to keep business costs organized through the year. The Deductions tab holds one row per expense with the date, payee, category, amount paid, business-use percentage, business part, receipt status and a note. The Dashboard totals what was paid and the business part, counts missing receipts, and compares the two amounts by category in a bar chart.

Enter each cost the moment it is paid, while its receipt is still easy to find. Set a business-use percentage only when you can explain how you reached it, such as hours used for work or the floor area of a home office, and write that basis in the note. Clear the red rows each month, then send the category totals to your tax professional before the appointment.

Useful for

  • Keep receipts and business shares in one place all year
  • Total each category before a tax appointment
  • Find expenses that still need a receipt copy

What's included

  • 3 tabs: Dashboard, Deductions, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Deductions: 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 Deductions 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 does the business use percentage mean?

It is the share of an expense you used for business. A phone plan used sixty percent for work gives a business part of sixty percent of the bill. Pick a figure you can justify with a record, and check current IRS rules for how business use must be shown.

Which expenses can I deduct?

Whether a cost is deductible depends on your type of business, how the item was used and current IRS rules, so this tracker does not decide it. Use the categories to sort your costs, then ask a tax professional which ones qualify before you claim them.

How long should I keep receipts?

Keep records for as long as the IRS can ask about the return they support, and check current IRS guidance for the period that applies to you. A digital copy of each receipt saved beside its row keeps the paper and the figures together.

  • #tax-tracker
  • #tax-deduction-tracker
  • #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…