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.

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
| Step | Pull this record | What to check |
|---|---|---|
| 1. Set the review period | Calendar and prior review notes | Use each state’s measurement period and note any different reporting cadence |
| 2. Export sales by destination | Store and order management reports | Ship-to state, gross sales, returns, exempt sales, and transaction count where relevant |
| 3. Separate sales channels | Marketplace and direct-store reports | Keep facilitated marketplace sales visible as their own line |
| 4. Check physical activity | Inventory, warehouse, employee, contractor, and event records | Record where inventory or business activity occurred, with dates |
| 5. Reconcile the totals | Payment processor, accounting, and platform exports | Explain refunds, cancellations, duplicates, tax collected, and timing differences |
| 6. Compare with current state rules | Official department of revenue pages and state guidance | Threshold, period, sales measure, marketplace treatment, registration, and effective date |
| 7. Assign the next action | State-by-state action log | Monitor, ask a tax professional, register, update settings, or confirm a current filing task |
| 8. Save the evidence | Dated review packet | Keep 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:
| Difference | Possible source | Record to compare |
|---|---|---|
| Store vs processor totals | Refund timing, fees, or settlement dates | Order-level payments and refunds |
| Store vs accounting | Posting date or chart-of-accounts mapping | Monthly close and sales ledger |
| Marketplace vs store | Channel duplication or separate fulfillment | Marketplace transaction export and order IDs |
| Sales vs tax collected | Exempt, nontaxable, or marketplace-facilitated activity | Tax 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.
| State | Question to resolve | Evidence on hand | Next owner and date |
|---|---|---|---|
| Example state | Does this state include marketplace sales in its threshold measure? | Store report, marketplace export, inventory report | Tax 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
- South Dakota v. Wayfair, Inc., U.S. Supreme Court
- California CDTFA, Online Marketplaces and Fulfillment Centers
- Texas Comptroller, Remote Sellers and Marketplace FAQ
- Streamlined Sales Tax, State Taxability Matrix
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”