Sales tax records for ecommerce: what to prepare

Published on Beamarc: September 30, 2026.

Sales tax records need to connect what you sold, where you sold it, what was collected and what was filed or remitted. A payment platform or marketplace report is one part of that record, not a complete assessment of every obligation.

This guide focuses on preparing the accounting evidence for a state-specific review. The result depends on your products, locations, channels and current state rules.

Separate physical presence from remote-sales thresholds

Employees, offices, inventory and other in-state activities can affect registration and collection requirements. Remote sales can also create obligations once a state’s economic-nexus threshold is met. Threshold amounts, measurement periods and included sales vary.

Keep a location history for inventory held by FBA, a third-party warehouse or another fulfillment provider. Inventory can be relevant, but warehouse and marketplace exceptions differ by state. Do not assume a single rule applies everywhere.

For example, New Jersey and New York publish separate guidance on remote sellers and registration. Use the relevant state authority’s current rules to document the conclusion for that jurisdiction.

Build a sales-by-state and channel file

• Ship-to state and, where needed, the locality or delivery address.
• Order and invoice reference, transaction date and reporting period.
• Direct-store, marketplace or wholesale channel.
• Gross sales, discounts, returns, shipping and separately stated tax.
• Taxable and exempt sales classifications, with supporting records.
• Who collected the tax and who is responsible for remitting it.
• Relevant exemption certificates and their status.

Reconcile the export to the accounting records and explain cutoff or definition differences. A threshold analysis may use a different sales basis from the financial statements, so retain the bridge between them.

What a state-by-state assessment needs

Prepare a matrix with each jurisdiction, physical activities, sales measure, measurement period, applicable rule and official source. Add existing registration numbers, effective dates, assigned filing frequency, collection settings and the date the conclusion was reviewed.

Direct sales, marketplace sales and exempt transactions may count differently under different rules. Apply the state’s definition rather than copying the same calculation into every row. State and local obligations can also differ.

Marketplace collection does not cover every channel

A marketplace facilitator may collect and remit tax on the transactions it facilitates. Retain its reports and distinguish those amounts from tax you are responsible for remitting on direct or wholesale sales.

Marketplace collection does not by itself resolve every registration, filing, exemption or historical exposure question. Confirm the remaining obligations under the rules of each jurisdiction and your actual sales channels.

Understand what Shopify Tax is configured to do

Shopify can calculate tax when configured. As of October 6, 2026, Shopify states that automated filing is closed to new enrollment and is available only to stores already enrolled, subject to its eligibility and setup requirements. Existing users still need to verify registrations, covered sales, jurisdiction settings, payment funding and filing completion.

Shopify’s current automated-filing guidance describes limits, including sales outside Shopify and past or amended returns. Confirm the coverage for your store; do not assume one automation covers every marketplace, wholesale invoice or historical period.

Reconcile sales tax payable each reporting period

A practical rollforward starts with the opening liability, adds tax collected or otherwise accrued under the applicable rules, subtracts supported refunds, credits and remittances, and arrives at the ending liability.

• Separate marketplace-remitted amounts from amounts your business must remit.
• Compare tax reports with the ledger, allowing for documented reporting-period differences.
• Match filed returns to the sales data used to prepare them.
• Match payments to bank records and retain confirmations.
• Explain amounts carried into the next period and any known exposure not yet resolved.

Tax collected on behalf of a jurisdiction generally belongs in a liability rather than sales revenue. Cash receipt alone does not establish whether your business or a marketplace has the remittance obligation.

Keep a filing calendar and evidence folder

For each active registration, record the assigned frequency, due date, preparer, reviewer, payment method and filing confirmation. Include zero returns where required. A period with no sales does not automatically end an active registration.

Retain filed returns, notices, exemption records, marketplace reports, calculation support and payment confirmations. Review notices for changes to frequency or other requirements.

Escalate gaps before changing settings

• Tax collected without a matching registration: preserve the funds and records, identify the affected periods and obtain advice on registration and remediation. Do not simply turn collection off or recognize the amount as income.
• Registered but missing filings: identify all open periods and notices, then agree a remediation plan.
• Possible historical nexus without collection: quantify the facts and consult a qualified state and local tax adviser before choosing a registration or voluntary-disclosure approach. Eligibility and sequencing matter.
• Wrong product or exemption settings: determine which orders and jurisdictions were affected and assess both under-collection and over-collection.

Do not assume prospective registration resolves earlier exposure. Voluntary-disclosure options, lookback periods, interest and penalties are state-specific.

Assign responsibility explicitly

The accounting team can organize source records, reconcile tax balances and flag missing evidence. Nexus conclusions, registration, return preparation and remediation should have clearly assigned responsibility and an agreed scope.

Beamarc can organize accounting records and reconcile tax balances within the agreed accounting scope. Business and individual tax preparation uses its own engagement letter, scope and fees. Confirm separately whether a particular sales-tax filing, nexus analysis or remediation service is available and whether a specialist is needed.

How Beamarc can help

Beamarc provides bookkeeping, monthly close, financial reporting and accounting advisory. We can discuss the records available, the questions you need answered and the support that fits your business. Scope, responsibilities, timing and fees are agreed before work begins.

Request a consultation.

Related reading

• Multi-channel ecommerce reconciliation: a monthly close
• Shopify payouts vs. sales: reconciling to bank deposits
• Preparing ecommerce records for investor due diligence

Authoritative guidance

• New Jersey: remote seller FAQs
• New York: sales tax registration

General information only. Accounting and tax treatment depend on your facts and reporting framework. This article does not provide assurance or establish a client relationship.