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.
| State | Period | Frequency | Gross sales | Exempt sales | Taxable sales | Tax collected | Tax due | Due date | Filed on | Confirmation |
|---|---|---|---|---|---|---|---|---|---|---|
| TX | Jan 2026 | Monthly | $42,600.00 | $3,100.00 | $39,500.00 | $3,258.75 | $3,258.75 | 2026-02-20 | 2026-02-17 | TX-88412 |
| TX | Feb 2026 | Monthly | $39,800.00 | $2,700.00 | $37,100.00 | $3,060.75 | $3,060.75 | 2026-03-20 | 2026-03-16 | TX-90377 |
| FL | Q1 2026 | Quarterly | $11,200.00 | $0.00 | $11,200.00 | $784.00 | $784.00 | 2026-04-20 | 2026-04-14 | FL-55170 |
| WA | 2026 | Annual | $2,400.00 | $0.00 | $2,400.00 | $0.00 | $0.00 | 2027-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 serviceWhat 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.
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.