# Multistate Sales Tax Nexus Tracking Worksheet

> Source: https://netray.co/tools/multistate-sales-tax-nexus-tracking-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Track sales and transaction counts by state against your economic nexus thresholds, and see which states are close to triggering registration.

## Category

compliance-legal

## Region

United States

## Audience

- Controller
- Tax manager
- ERP administrator

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### State

**Key:** state

**Type:** text

#### Registration status

**Key:** status

**Type:** select

**Options:**

- Registered
- Not registered
- Pending
- Physical presence only

#### Trailing 12 month sales into state

**Key:** sales

**Type:** number

**Format:** currency

#### Transaction count

**Key:** txns

**Type:** number

**Format:** integer

#### Sales threshold

**Key:** sales_limit

**Type:** number

**Format:** currency

**Help:** Enter the threshold currently published by the state.

#### Transaction threshold (0 if none)

**Key:** txn_limit

**Type:** number

**Format:** integer

#### Percent of sales threshold

**Key:** sales_pct

**Type:** number

**Expr:** if(gt(sales_limit,0), sales / sales_limit * 100, 0)

**Format:** percent

#### Percent of transaction threshold

**Key:** txn_pct

**Type:** number

**Expr:** if(gt(txn_limit,0), txns / txn_limit * 100, 0)

**Format:** percent

#### Worst case percent

**Key:** watch

**Type:** number

**Expr:** max(if(gt(sales_limit,0), sales / sales_limit * 100, 0), if(gt(txn_limit,0), txns / txn_limit * 100, 0))

**Format:** percent

**Rows:**

**State:** Texas

**Status:** Registered

**Sales:** 4200000

**Txns:** 310

**Sales limit:** 500000

**Txn limit:** 0

**State:** Ohio

**Status:** Not registered

**Sales:** 410000

**Txns:** 96

**Sales limit:** 100000

**Txn limit:** 0

**State:** California

**Status:** Not registered

**Sales:** 380000

**Txns:** 41

**Sales limit:** 500000

**Txn limit:** 0

**State:** Illinois

**Status:** Registered

**Sales:** 760000

**Txns:** 120

**Sales limit:** 100000

**Txn limit:** 0

**State:** Arizona

**Status:** Not registered

**Sales:** 55000

**Txns:** 12

**Sales limit:** 100000

**Txn limit:** 0

**Totals:**

#### Total sales tracked

**Key:** sales

**Agg:** sum

**Format:** currency

#### Highest percent of any threshold

**Key:** watch

**Agg:** max

**Format:** percent

#### States tracked

**Key:** state

**Agg:** count

**Format:** integer

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use the worksheet

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### Does every state use the same threshold?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

sales tax nexus tracking spreadsheet, economic nexus tracker excel, state nexus threshold worksheet, multistate sales tax nexus template, manufacturer sales tax nexus, wayfair nexus tracking, nexus study template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json