Skip to content
Sales Tax Tracker cover: a sample sheet with sales before tax, tax collected and remitted so far and a bar chart, beside the Dashboard, Rates and Sales tabs

Sales Tax Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

This tracker suits small sellers who charge sales tax in more than one place, from online shops to market stalls and in-person sales. The Rates tab holds the rate for each jurisdiction, the Sales tab works out the tax on each sale and marks exempt sales as No, and the Remittances tab records each payment. The Dashboard totals sales, tax collected and the amount still to remit, with charts of tax by place and sales by channel.

Update the Rates tab before you begin, using the rate for each place and filing period, since the sample rates here are invented. Log sales as they happen, and check the Dashboard total against your sales system before each filing. Keep the confirmation number on every remittance row so each payment is easy to trace.

Useful for

  • Tracking tax on online and market sales
  • Preparing figures for a monthly or quarterly filing
  • Spotting exempt sales that should not be taxed

What's included

  • 5 tabs: Dashboard, Rates, Sales, Remittances, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Rates: a table
  • Sales: a table
  • Remittances: 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 Rates 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 does the tax column work out each sale?

It multiplies the sale amount by the rate for that place, found on the Rates tab. If the Taxable column says No, the tax is zero. Change a rate there and every sale in that place updates to match.

Where do I find the correct sales tax rate?

Ask the tax office for each place where you sell, and look again each period, because rates can change. The rates in this file are invented for practice and must be replaced before you rely on any figure.

What if one sale is taxed in two places?

Add one row for each place and split the sale amount between them, so each part uses its own rate. Give both rows one invoice number, which makes them simple to pair up afterward.

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