Sales Tax Nexus Templates: 5 Checklists for State Rules and Audit Records

Online seller reviews a state research worksheet, sales-channel report, and audit-ready tax records folder
Keep the source, calculation, and next action together so you can explain the decision later.

Quick answer

Five small worksheets can make a sales tax nexus review easier to repeat: a state rule sheet, a threshold calculation, a marketplace split, a product taxability note, and a registration and filing log. Keep links to current agency sources in each one. The worksheets organize your work. They do not decide whether you owe tax.

If you run an online store, the hard part is rarely finding one number. It is remembering what the number means, which sales went into it, where the rule came from, and what changed since the last review. A single spreadsheet can become a mystery when someone opens it six months later.

These templates are built to leave a trail another person can follow. Keep your source links, the dates you checked them, the original reports, and any professional advice together. State rules change, so treat each worksheet as a working record, not a permanent answer.

This is general U.S. business information. It is not tax or legal advice. Your state, products, sales channels, and activities determine what applies. Ask a qualified tax professional or the relevant state agency when the answer affects registration or a filing position.

Before you build the file

Make a folder for each tax year and use a state subfolder when you are registered or actively monitoring a threshold. Save original exports separately from your analysis. Do not overwrite a report to make a total match.

Set a monthly reminder. On that day, export orders by destination state, save marketplace reports, update your threshold worksheet, and list questions that need a second look. A monthly habit is easier to manage than a year-end scramble.

Template 1: State rule and source sheet

Make one copy for each state you sell into. Record what the state says in its own words, then link directly to the agency page. If you use a state chart to find the rule, save the chart date and the state source you checked afterward.

FieldWhat to write down
State and agencyState name, department, and tax account contact
Physical presence reviewPeople, inventory, office, events, or other activity to check
Threshold measureExact term used by the agency, such as gross sales or taxable sales
Measurement periodCurrent year, prior year, rolling period, or other wording from source
Transactions includedCategories the agency says count, with the source section
Marketplace treatmentWhat the state says about marketplace and direct orders
Registration and start dateAgency’s current instruction and any question for an advisor
Returns and account closureFiling frequency, zero-return direction, and cancellation process
Checked by and dateYour name, reviewer, link, and the next review date

Do not fill gaps with a guess. Write “not confirmed” and add an owner and due date. That one phrase is better than a confident cell built on a rule from another state.

Template 2: Monthly threshold calculation

Keep the raw sales report and the calculation side by side. Every state has its own measure and window, so include the period definition at the top of the sheet. The threshold figure alone is not enough.

PeriodDirect salesMarketplace salesReturns or adjustmentsState-defined totalSource or note
[Month or period][Amount][Amount][Amount and treatment][Formula based on state rule][Report file and rule link]
[Following period][Amount][Amount][Amount and treatment][Formula based on state rule][Report file and rule link]

Keep excluded sales visible in a separate column. Note why they are excluded and link the reason to an agency source or reviewed tax advice. If your report cannot separate marketplace orders, write that down and ask the platform how to export them.

Use an alert that says “review the state rule” rather than “register now.” A threshold alert is a signal for a human review. It does not account for physical presence, product taxability, effective dates, or every state-specific condition.

Template 3: Marketplace and direct-sales reconciliation

Marketplaces can collect tax on orders they facilitate, while you keep separate duties for your own site or other channels. State laws also differ on whether marketplace orders count in a seller’s threshold calculation. A reconciliation sheet helps you see both the sales total and the collection activity.

ChannelGross salesTaxable sales per reportTax shown as collectedRemitter namedRecord to save
Online store[Amount][Amount][Amount][Seller or service][Order export and tax report]
Marketplace A[Amount][Amount][Amount][Marketplace or seller][Marketplace settlement report]
Wholesale or other[Amount][Amount][Amount][Seller or buyer certificate][Invoice or exemption record]

Compare the marketplace settlement total with your order export. Write down the date range and whether the report reflects order date, shipment date, or payout date. Those dates may not line up. Keep the tax report and settlement statement even if the platform remits the tax.

Texas is one example of why the worksheet needs separate columns. The Texas Comptroller says a remote seller includes marketplace sales in its safe-harbor calculation, even when the marketplace collects tax. California has its own threshold and marketplace rules. Neither state example is a shortcut for another state.

Template 4: Product taxability and SKU review

Use one line for each product type, not just one line for the whole store. A digital download and a physical item may be treated differently. Bundles and services can raise their own questions.

SKU or typeWhat the buyer receivesDelivery and bundle detailsState sourceWorking statusReviewer
[SKU][Plain description][Physical, digital, service, or bundle][Agency link and section][Confirmed, open, or advisor review][Name and date]
[SKU][Plain description][Physical, digital, service, or bundle][Agency link and section][Confirmed, open, or advisor review][Name and date]

Keep product language factual. “Kitchen storage set with two containers” is more useful than a marketing label. If the agency page does not cover the product, leave the working status open. AI can help summarize the source, but a human needs to confirm the classification.

Template 5: Registration, returns, and follow-up log

Once you decide to register, track the account separately from the threshold. A permit does not mean the work is over. You may have recurring returns, payments, notices, or a closure request to manage.

DateEventOwnerNext actionEvidence savedStatus
[Date][Threshold review, registration, return, notice][Person][Action and due date][File path or link][Open or complete]
[Date][Threshold review, registration, return, notice][Person][Action and due date][File path or link][Open or complete]

Save the submitted application, confirmation number, permit, filed return, payment receipt, and any state response. If sales later fall, do not turn collection off until the state’s account and return instructions are clear. The state may still expect a return until the account is formally changed.

A short worked example

Jordan sells desk accessories through a small online store and a marketplace. She makes one state folder for each state under review. Each month, she saves the order report, marketplace settlement file, and dated tax agency page in that folder.

Her Texas worksheet shows $390,000 in direct sales and $125,000 in marketplace sales in the preceding 12-month period. She does not subtract marketplace orders just because the platform collected the tax. The Texas Comptroller’s current remote-seller page explains how to check the state total and what happens after the safe-harbor amount is exceeded.

Jordan asks her tax advisor to check the report period, sales categories, and timing. The advisor confirms what to do next. She records the advice, applies for the permit, and saves the confirmation. For another state, she uses that state’s worksheet and source. She does not reuse the Texas calculation rule.

Use AI to check the records, not make the call

A language model can compare rows, find missing dates, group questions, and draft a summary of a source you give it. It may also misread a threshold or miss a rule that changed. Keep the raw files and have a qualified person review every decision that affects registration, tax collection, or a return.

Using only the attached state agency page and the sales report for [state and period], fill the blank fields in this worksheet. For each field, quote the source sentence and give the page section or link. Do not decide whether the seller has nexus, classify a product, or recommend a filing position. Mark missing evidence as “open question” and create a list for my tax advisor. Do not include customer names, street addresses, or payment details.

Before sharing a file with any AI service, check the company’s data rules. Remove customer information and use an approved business account. A tax report can contain sensitive details even when it looks like ordinary bookkeeping.

Keep the five sheets together

  • State rule sheet, with a current state agency link
  • Monthly calculation, with the raw report and formula
  • Marketplace reconciliation, with the platform’s collection records
  • SKU review, with product descriptions and taxability sources
  • Registration and return log, with dates, owners, and confirmations

For a recurring process, assign a person to each step. One person can prepare a report while another reviews it. If you are the only person in the business, set a calendar reminder to review the source again before filing. A small review step can catch a stale threshold, an omitted channel, or an unanswered state notice.

Get the prompts and the companion guides

The Sales Tax Nexus prompt book is designed to help online sellers organize reports, ask better research questions, and prepare a cleaner handoff to a tax professional. Pair these worksheets with the nexus prompt guide, the pre-filing gaps checklist, the records workflow, and the seller Q&A.

Five questions about the worksheets

Can I use one state rule sheet for every state?

No. Thresholds, sales measures, marketplaces, product rules, and filing instructions vary. Make a separate sheet for each state.

Should marketplace sales appear in my threshold calculation?

Check that state’s current rules. Some states tell sellers to include marketplace sales, even when the marketplace collects tax. Keep those sales separately visible.

Do these templates tell me when I must register?

No. They help you collect the facts and sources. A qualified tax advisor or state agency should confirm the result for your situation.

Can AI fill in the forms for me?

AI can help organize provided information and point out blanks. It should not decide nexus, product taxability, collection dates, or return positions.

What should I keep if I have no tax due?

Save the reports, state rule, calculation, marketplace records, filed returns, and any advice explaining your decision. Follow the state’s record-retention instructions.

Sources and limits

Last reviewed: November 16, 2026. These worksheets are internal planning aids, not government forms. They are not tax or legal advice. Check the current law and agency instructions in every state where you sell.


Leave a Comment

Item added to cart.
0 items - $0.00