Sales tax tracker

A sales tax tracker keeps each state's sales tax in one place: taxable and exempt sales, tax collected, tax due, the filing due date and proof you paid. This free template works for one state or many, so you can see what you owe before each return and never miss a filing, including the zero returns states still expect.

Updated November 2026

What does the template look like?

Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.

Example rows
StatePeriodFrequencyGross salesExempt salesTaxable salesTax collectedTax dueDue dateFiled onConfirmation
TXJan 2026Monthly$42,600.00$3,100.00$39,500.00$3,258.75$3,258.752026-02-202026-02-17TX-88412
TXFeb 2026Monthly$39,800.00$2,700.00$37,100.00$3,060.75$3,060.752026-03-202026-03-16TX-90377
FLQ1 2026Quarterly$11,200.00$0.00$11,200.00$784.00$784.002026-04-202026-04-14FL-55170
WA2026Annual$2,400.00$0.00$2,400.00$0.00$0.002027-04-15
Total$96,000.00$5,800.00$90,200.00$7,103.50$7,103.50

Why track sales tax by state?

Each state sets its own rates, filing frequency and due dates, and many add local taxes. Once you're registered, most states expect a return every period, even when you sold nothing there. Missed zero returns bring penalties and, eventually, letters. One tracker shows every return due and what's been filed.

How do I know where I owe?

You owe where you have nexus: a physical presence, or sales above a state's economic nexus threshold, often $100,000 a year. Our economic nexus thresholds by state post lists them, and the sales tax permit guide shows how to register.

Is the money I collect mine?

No. Sales tax you collect is held in trust for the state. Many owners set it aside in a separate account the day it comes in. Spending it and coming up short is one of the fastest routes to personal liability for business owners. Our sales tax service files every state for you.

Sources

General information, not tax advice for your situation.

Selling in more than one state?

We check where you owe and file the returns.

See our sales tax service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
What is the difference between tax collected and tax due?

Collected is what customers paid you. Due is what the return says you owe, which can differ for rounding, vendor discounts or use tax.

Do I file if I had no sales?

Yes, in most states, once you're registered. File a zero return by the due date.

How often do I file?

The state sets it, usually monthly, quarterly or yearly, based on how much tax you collect.

Get started

Tell us what's messy. We'll tell you what it takes.

Tell us what you need and get a fixed price before any work starts. No pressure and no contract.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.