Sales Tax Nexus Tracker (Economic Nexus by State)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A sales tax nexus tracker shows, state by state, whether a business selling into other states has crossed the economic nexus threshold that obliges it to register and collect sales tax, and whether it has registered. It is the document a controller needs when an auditor, a buyer in due diligence or a new CFO asks which states the company should be collecting in, and the answer is spread across invoices and memory.
The workbook lists 47 jurisdictions with the sales threshold, transaction threshold, test and measurement period each one applies, and a link to the state revenue department. Thirteen thresholds were checked against the state's own page on 18 November 2026; the rest are marked for verification. Live formulas compare your prior and current period sales and transactions with each threshold, show a nexus result and a colour band, and total the sales at risk on a summary sheet.
Who it is for
The controller or tax manager asked by the auditor or the CFO which states the company must collect sales tax in, and whether it is registered there.
What is inside
- 47 rows: the 45 states with a statewide sales tax, the District of Columbia and Alaska (local taxes only)
- 13 thresholds verified against the state revenue department on 2026-11-18; the other 34 rows marked Verify before use
- A source link to the state revenue department on every row
- Live formulas: % of threshold, nexus test (sales only, sales or transactions, sales and transactions) and a Red, Amber or Green band
- Ashcombe Group worked example with sales data in 13 states, plus 16 blank rows for local jurisdictions
- Dropdowns for test, physical presence, registration status and filing frequency
- Summary sheet with 12 live measures, including sales in states where nexus exists but no registration
- How to use sheet that explains the calculation and its limits
How to use it
Open each row marked Verify before use, confirm the threshold on the linked state page, then enter your sales by state.
Files
- XLSXsales-tax-nexus-tracker.xlsx25 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What is economic nexus for sales tax?
Economic nexus is a duty to register and collect a state's sales tax that arises from the amount of sales or the number of transactions into that state, even without an office or staff there. Each state sets its own threshold, test and measurement period, so the same sales can create nexus in one state and not in another.
Are the state thresholds in this tracker current?
Thirteen rows were verified against the state revenue department page on 18 November 2026 and are marked as verified with the link. The other rows carry a commonly published threshold that was not verified for this template and are marked Verify before use. States change thresholds, so check every row against its source before relying on it.
Does physical presence still create nexus?
Yes. Offices, employees, inventory or other property in a state create nexus whatever the level of sales. The tracker has a physical presence column, and a Yes there shows nexus regardless of the sales figures you enter, so the row turns Red until the state registration is in place.



