Multistate Sales Tax Nexus Tracking Worksheet
A manufacturer that ships to customers across the US can owe sales tax registration in states where it has no plant or office. This worksheet lets you log trailing sales and order counts per state against each state's economic nexus threshold and shows how close you are.
| State | Registration status | Trailing 12 month sales into state | Transaction count | Sales threshold | Transaction threshold (0 if none) | Percent of sales threshold | Percent of transaction threshold | Worst case percent | |
|---|---|---|---|---|---|---|---|---|---|
840% | 0% | 840% | |||||||
410% | 0% | 410% | |||||||
76% | 0% | 76% | |||||||
760% | 0% | 760% | |||||||
55% | 0% | 55% |
Thresholds shown are examples only. States change dollar and transaction limits, and some measure by calendar year instead of trailing 12 months. Confirm each value with the state revenue department before relying on it. This worksheet is a tracking aid, not tax advice.
Automate nexus tracking from your ERP data
Optional: we can set up a read-only report that refreshes state sales and transaction counts for you.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per state where you ship taxable or potentially taxable goods. Pull trailing 12 month sales and invoice or transaction counts from your ERP sales order or invoice history, grouped by ship-to state. Enter the current threshold published by that state. The computed columns show percent of each threshold, and the worst case column picks the higher of the two. Sort or review any row above roughly 80 percent first, because registration lead time and look-back exposure matter.
- Group by ship-to state, not bill-to state
- Use gross sales as the state defines it, which may include exempt sales
- Refresh monthly, not once a year
- Record physical presence separately, because it creates nexus at any volume
What creates nexus
Physical presence nexus comes from offices, plants, warehouses, inventory, employees, installers or field service technicians in a state. Economic nexus, following the 2018 South Dakota v. Wayfair decision, arises when sales or transactions into a state exceed a threshold even without presence. Many states use 100,000 dollars in sales, some use 200 transactions, and a few use higher dollar amounts. Because rules differ and change, the sheet keeps thresholds as editable inputs rather than hardcoded values.
Reading the result and a worked example
In the sample rows, Ohio shows well over 100 percent of a 100,000 dollar sales threshold and is not registered. That row is the action item: review whether the sales were taxable or exempt, then consider registration and a voluntary disclosure for past periods. California at 76 percent is on watch. Texas and Illinois are already registered, so they are tracked for completeness. Manufacturers should remember that sales of manufacturing equipment or resale goods may be exempt, but the sale still counts toward the threshold in many states.
Common mistakes
The most common error is tracking only taxable sales when the state counts gross sales. The second is ignoring field service visits and installation crews, which create physical presence. The third is using calendar year totals when the state uses a rolling 12 months. Finally, teams forget marketplace and drop ship activity. Export this sheet to Excel to share with your outside tax adviser before a nexus study.
Frequently Asked Questions
Does every state use the same threshold?
No. Many states use 100,000 dollars of sales, some add or substitute a transaction count, and a few such as Texas and California use 500,000 dollars. Thresholds and measurement periods change, so always confirm with the state revenue department.
Do exempt sales count toward economic nexus?
In many states, yes. States often count gross sales into the state, which can include sales later claimed as exempt. Check each state's rule, because a few exclude certain sales such as sales for resale.
What if I cross a threshold and have not registered?
Talk to a qualified tax adviser. Options often include registering going forward and a voluntary disclosure agreement to limit look-back periods. Timing and penalties vary by state.
Can I pull the data from my ERP?
Yes. Summarize posted invoices by ship-to state and rolling 12 month window from your sales or AR tables, then paste the totals into the sheet or export it to Excel.
If your ERP already holds ship-to and invoice data, the same threshold check can run as a scheduled query. We can build a read-only report on your ERP that refreshes this view.
Related Tools
Sales Tax Exemption Certificate Request Letter Template
A fill-in letter that asks a customer for a valid exemption or resale certificate, or tells a vendor you are claiming an exemption.
Compliance & ContractsTexas Manufacturing Exempt Purchase Log Worksheet
Log purchases you treat as exempt from Texas sales and use tax, with the certificate given, support on file and the tax avoided.
Compliance & ContractsDomestic Origin Supplier Affidavit Template
A fill-in declaration a supplier signs to state country of manufacture and the share of domestic content for listed part numbers.
More Compliance & Contracts tools
See all- USMCA Certification of Origin Template
- USMCA Regional Value Content (RVC) Calculator
- US State Economic Nexus Sales Thresholds Reference
- US Business Tax Forms for Manufacturers Reference
- Prop 65 Warning Compliance Checklist
- Prop 65 Exposure vs MADL Calculator
- UCC Article 2 Sale of Goods Key Provisions Reference
- SAP SoD Residual Risk Score Calculator
- SAP Firefighter ID Usage Review Log