From Sales Report to State Review: A Nexus Records Workflow


State sales tax gets messy when your reports live in five places. Your store has one number. A marketplace has another. A warehouse may have moved inventory without telling the person who handles tax.

So give the review a simple rhythm. Once a month, pull the records together, label what each number means, and flag the states that need a closer look. This will not decide whether you have a filing duty. It will make that decision easier to check.

Online seller reviewing sales reports, inventory locations, and a state-by-state sales tax checklist
Bring sales, marketplace, and inventory records into one review before deciding what needs attention.

If you need the first-pass questions, read the sales tax nexus prompt guide. Then use the mistakes checklist to catch common record gaps. The Sales Tax Nexus Prompts book has more prompt patterns for organizing state research and audit records.

The 8-step monthly review

StepPull this recordWhat to check
1. Set the review periodCalendar and prior review notesUse each state’s measurement period and note any different reporting cadence
2. Export sales by destinationStore and order management reportsShip-to state, gross sales, returns, exempt sales, and transaction count where relevant
3. Separate sales channelsMarketplace and direct-store reportsKeep facilitated marketplace sales visible as their own line
4. Check physical activityInventory, warehouse, employee, contractor, and event recordsRecord where inventory or business activity occurred, with dates
5. Reconcile the totalsPayment processor, accounting, and platform exportsExplain refunds, cancellations, duplicates, tax collected, and timing differences
6. Compare with current state rulesOfficial department of revenue pages and state guidanceThreshold, period, sales measure, marketplace treatment, registration, and effective date
7. Assign the next actionState-by-state action logMonitor, ask a tax professional, register, update settings, or confirm a current filing task
8. Save the evidenceDated review packetKeep source files, links, reviewer, decision, and next review date together

1. Set the period before you add anything up

Start with the month you are reviewing, but do not assume that a state measures activity by calendar year or uses the same lookback period as the next state. Put the relevant period beside each state in your working sheet.

That small note prevents a common mistake: comparing one state’s current quarter with another state’s trailing twelve months and treating the totals as if they mean the same thing.

2. Export sales by destination

Use the customer’s ship-to state for shipped goods, then preserve the original export. Keep gross sales and refunds separate. If your system reports transaction count, save that too, but do not assume every state uses the same count or includes the same kinds of transactions.

Write down the report name, export date, date range, and filters. A spreadsheet with no source trail is hard to explain six months later.

3. Keep marketplace and direct sales apart

Pull your own store report and each marketplace report separately. Some states require a seller to track marketplace transactions even where a facilitator collects tax. Other states may treat sales differently for a particular threshold or reporting question. The state’s current instructions decide.

California’s guidance, for example, explains when a registered marketplace facilitator is the retailer responsible for collecting and paying tax on facilitated sales of tangible merchandise. It also tells sellers to keep documentation showing the facilitator’s role. That is California guidance. Do not copy its treatment into another state without checking that state’s rules.

4. Record inventory and other physical activity

Ask your warehouse or fulfillment partner where your inventory was stored during the review period. Include the location, dates, product or inventory reference, and report source. Add employee travel, trade shows, installation work, or other activity if it applies to your business.

Do not turn a warehouse address into a legal conclusion. Treat it as a fact to review. California’s online marketplace guidance notes that inventory stored at a California third-party fulfillment center can matter for seller registration. The result elsewhere depends on local law and your exact setup.

5. Reconcile the reports before researching thresholds

Suppose the store shows $48,200 shipped to a state, the payment report shows $46,900, and the marketplace dashboard shows another $12,000. That gap might come from refunds, settlement timing, tax included in totals, or a duplicated export. It might also be a real data problem.

Use this table to chase the difference:

DifferencePossible sourceRecord to compare
Store vs processor totalsRefund timing, fees, or settlement datesOrder-level payments and refunds
Store vs accountingPosting date or chart-of-accounts mappingMonthly close and sales ledger
Marketplace vs storeChannel duplication or separate fulfillmentMarketplace transaction export and order IDs
Sales vs tax collectedExempt, nontaxable, or marketplace-facilitated activityTax detail and state-specific treatment

6. Check the state’s current source

Now compare the cleaned facts with the official agency source. Record the page title, URL, date checked, and any effective date. Check what the state measures, which period it uses, whether marketplace sales are included, and whether inventory or other activity changes the analysis.

The Supreme Court’s South Dakota v. Wayfair decision describes South Dakota’s law and the case before the Court. It is not a single nationwide threshold for every seller. States set their own rules, and the details change. The Streamlined Sales Tax taxability matrix is useful for finding state definitions and administration practices, but confirm important decisions against the relevant state agency.

Texas gives one example of how a state rule can be specific: its Comptroller says the remote-seller safe harbor uses Texas revenue during the previous 12 calendar months and has a current $500,000 threshold. That is Texas’s rule for the described situation, not a general rule to paste into your spreadsheet for every state.

7. Make an action log, not a pile of notes

For each state, capture the question, evidence, source, reviewer, and next step. Keep “not reviewed yet” separate from “no obligation.” A blank cell does not prove that there is nothing to do.

StateQuestion to resolveEvidence on handNext owner and date
Example stateDoes this state include marketplace sales in its threshold measure?Store report, marketplace export, inventory reportTax adviser; verify current agency guidance by Friday

A next step could be checking a threshold, confirming whether a marketplace collects tax, updating a registration record, or asking a tax professional to interpret a tricky fact pattern. The workflow keeps the decision traceable. It does not make the decision for you.

8. Save a review packet you can pick up next month

Keep the original exports, your reconciled summary, screenshots or PDFs of important state pages, and a short note about what changed. Add the reviewer’s initials and the next review date. If you registered or filed, save the confirmation and the state account’s filing schedule.

A practical folder might look like this:

  • 01 Sales: dated direct-store and marketplace exports
  • 02 Physical activity: inventory locations and activity records
  • 03 Reconciliation: notes that explain totals and adjustments
  • 04 State research: agency links, dates checked, and saved guidance
  • 05 Actions: registrations, filings, settings changes, and open questions

Use AI to sort the file, then verify the work

AI can help compare columns, summarize a state agency page, or flag a missing date. Give it a narrow job and keep the source documents open.

Review these de-identified ecommerce sales and inventory records for the period [dates]. Create a state-by-state table with: source file, report date range, direct sales, marketplace sales, refunds, transaction counts if provided, inventory locations, and unresolved differences. Do not decide whether nexus exists or invent any threshold. For every statement about a state rule, quote the official source title and URL I provide. Flag missing data and tell me what to verify with a state agency or tax professional.

Do not upload customer names, payment details, addresses, or other sensitive records to an AI service unless your company has approved that use. Redact first. Then check every number and state-law summary against the original source.

Before you close the review

  • Did I save the date range and filters for every export?
  • Are direct sales and marketplace sales still distinguishable?
  • Did I ask about inventory and physical activity, not just shipped sales?
  • Can I explain the difference between sales and payment totals?
  • Did I check current agency guidance for each state I flagged?
  • Does every open question have an owner and a due date?

The goal is a repeatable file, not a perfect spreadsheet. When a new state or sales channel appears, add it to the next review and check the rule before you act.

Keep building your sales tax workflow

Read the sales tax nexus questions guide for a list of state-specific checks, then use the reusable state research templates to keep each review consistent. The Sales Tax Nexus Prompts book can help you structure the questions you bring to your tax adviser.

Sources

Frequently asked questions

How often should an online seller review sales tax nexus?

A monthly check is a practical routine for catching changes. Still, use each state’s measurement period and filing schedule. Your internal monthly review does not change the legal period a state applies.

Do marketplace sales count toward economic nexus?

It depends on the state’s current law and how it defines the sales measure. Keep channel data separate so you can apply the state’s rule accurately.

Does a fulfillment center create nexus?

Inventory or other physical activity can be relevant. The result depends on the state and the full facts, so save the location records and get the right state-specific review.

What records should I keep for a nexus review?

Keep dated sales reports by state and channel, returns, inventory locations, state research, registrations, returns filed, and review notes that show who checked the file and when.

Can AI tell me when I have nexus?

No. AI can sort records and surface research questions. A person should verify current law and the business facts with official guidance or a qualified tax professional.

1 thought on “From Sales Report to State Review: A Nexus Records Workflow”

Leave a Comment

Item added to cart.
0 items - $0.00