Skip to content
Self-Employment Tax Tracker cover: a sample sheet with income, business costs and net profit and a bar chart, beside the Dashboard, Income and Expenses tabs

Self-Employment Tax Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Freelancers, contractors and sole traders use this self-employment tax tracker to see what they earned after costs and how much to keep back. The Income tab logs every payment by date, client, service and amount. The Expenses tab records each business cost by category. The Dashboard totals income, costs and net profit, and charts income by service and costs by category. The Set aside tab takes a percentage you choose and works out the amount to keep.

Enter each payment when it arrives and each cost when you pay it, so the totals stay current. Pick the set-aside percentage with a tax professional, since the correct percentage turns on your full return. Move the set-aside amount into a separate account at each payday instead of waiting until the year ends, when the money is harder to hold back.

Useful for

  • Know how much of each payment to keep for tax
  • See which services bring in the most income
  • Track business costs against income each month

What's included

  • 5 tabs: Dashboard, Income, Expenses, Set aside, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Income: a table
  • Expenses: a table
  • Set aside: a ready-to-fill form
  • 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 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

Is the set-aside percentage a tax rate?

No. It is a saving habit you choose, and it can be higher or lower than the tax you finally owe. The sheet multiplies net profit by the percentage, so it shows a planned amount rather than a calculated bill. Check current IRS rules or a tax professional for the actual figure.

Does net profit here match my tax return?

It is a practical estimate: the income you received minus the business costs you logged. Tax returns use their own rules for timing, deductions and adjustments, so the figures can differ. Use the sheet to plan, then rely on your tax professional's calculation.

What happens in a month with a loss?

Enter the costs as they are and the Dashboard shows the lower net figure. The Set aside tab uses zero when net profit is below zero, so a loss sets nothing aside. Keep the loss recorded so the year's totals stay complete.

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