Skip to content
The title slide and first slides of the Tax Set-Aside Tracker template

Tax Set-Aside Tracker

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

Freelancers, gig workers and small shop owners use this tracker to avoid a surprise tax bill. The Payments in tab records each payment with a set-aside share, works out the amount and has a checkbox for money moved to savings. The Tax payments tab lists the payments you plan to make and those already paid. The Dashboard shows the amount received, set aside, still to move and left in savings once tax is paid.

Choose a set-aside share with your tax professional, then apply it the same day you are paid. Tick the box only when the transfer has cleared. Enter tax payment amounts from your own estimate or from official notices; the sheet holds no rates or limits. If savings fall behind the amount due, raise the share on new payments instead of waiting for the deadline.

Useful for

  • Keep a steady share of each payment for taxes
  • See whether savings cover the next tax payment
  • Show a tax professional what was set aside during the year

What's included

  • 4 tabs: Dashboard, Payments in, Tax payments, How to use
  • Dashboard: a dashboard with 6 summary figures
  • Payments in: a table
  • Tax payments: a table
  • 2 charts 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 Payments in 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 part of every payment should go toward taxes?

The right share varies with income, deductions and location. Pick a figure with a tax professional, enter it as a percentage and adjust it as the year goes on. The sheet applies it to every payment.

How do I track tax savings separately from spending?

Tick Moved to savings for each payment once the transfer is done. The Dashboard compares what is saved with what should be saved, and what remains after tax payments are made.

Does this replace estimated tax calculations?

No. It records what you choose to hold back and compares it with figures you enter. For estimated payments, use the IRS or CRA instructions or ask a tax professional, then record the result on the Tax payments tab.

  • #tax-tracker
  • #tax-set-aside-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…