Multichannel sellers live with two kinds of sales tax. On Amazon, Etsy, eBay and Walmart, the marketplace usually collects and remits the tax. On your own website, wholesale orders and in-person sales, you do. If those two streams are not separated and matched to your returns, you risk paying tax twice, under-reporting, or failing an audit over numbers you cannot explain. This guide shows how to reconcile marketplace vs direct sales tax each month with a repeatable process.
Key takeaways
- Marketplace facilitator laws shift collection to the marketplace, but you still need its reports for thresholds, returns and audits.
- Reconcile by state and by period: gross sales, marketplace sales, direct taxable sales, exempt sales and tax collected.
- The tax you collected directly should equal the tax you report; any gap is a liability or an over-collection to explain.
- Some states ask you to report marketplace sales on your return and then deduct them, so a return can show sales but $0 tax.
Why Reconciliation Matters for Multichannel Sellers
Every US sales tax state now has a marketplace facilitator law. Those laws decide who collects, not whether the sales exist. You still need channel-level data because:
- Nexus: many states count marketplace sales toward your economic nexus thresholds.
- Returns: some states require you to report gross sales, including marketplace sales, and claim a deduction.
- Audits: auditors start from your total revenue or bank deposits and ask you to explain every untaxed dollar.
- Cash: without separation, it is easy to remit tax on marketplace sales that the marketplace already paid.
For the rules on who is responsible in each channel, see marketplace vs. direct selling liability and our marketplace facilitator guide.
The Data You Need Before You Start
| Source | What to export | Why you need it |
|---|---|---|
| Amazon Seller Central | Sales tax report from the Tax Document Library | Order-level sales, ship-to state and tax collected by Amazon |
| Etsy, eBay, Walmart and other marketplaces | Order or transaction exports with tax columns | Marketplace sales and tax collected by state |
| Your store (Shopify, WooCommerce, BigCommerce) | Tax and sales reports by state and jurisdiction | Direct sales and tax you collected and must remit |
| Invoicing or ERP system | Wholesale and B2B invoices, exempt flags | Direct sales not processed by your storefront |
| Exemption certificate files | Certificates by customer and state | Support for exempt direct sales |
| Bank and payout statements | Marketplace settlements and processor deposits | Proof that total revenue is complete |
| Filed returns | Returns and payment confirmations by state | What you actually reported and paid |
Use the same date basis everywhere. Marketplaces may report by order date, shipment date or settlement date; pick the one your states require (often the date of sale) and convert other reports to it.
Step-by-Step Reconciliation Process
- Build one master table with one row per state per period and columns for gross sales, marketplace sales, direct taxable sales, direct exempt sales, tax collected directly and tax reported.
- Total revenue check. Sum all channels and compare to your general ledger and bank deposits. Unexplained differences usually mean a missing channel, such as phone orders or a second storefront.
- Split marketplace sales. Move every order where the marketplace collected tax into the marketplace column. Flag marketplace orders where tax was not collected for review.
- Classify direct sales into taxable and exempt, and confirm each exempt sale has a certificate or shipping proof on file.
- Recompute expected tax on direct taxable sales using the correct rate for each ship-to address, then compare it to the tax your storefront actually collected.
- Tie to the return. The tax reported on the return should equal tax collected directly, plus any under-collection you choose to absorb. Check the sales lines match the state’s reporting method for marketplace sales.
- Document the variance and its cause. Correct the next return or amend the prior return when the error is material.
How Marketplace Sales Show Up on Returns
| State approach | What you do | Reconciliation tip |
|---|---|---|
| Marketplace sales excluded from the return | Report only direct sales | Return sales should equal direct sales for that state |
| Report gross, then deduct marketplace sales | Include marketplace sales in gross sales, then claim the marketplace deduction | Gross on the return should equal total sales; net taxable should equal direct taxable sales |
| Marketplace sales count for gross receipts taxes | Report them for the gross receipts tax but deduct them from retail sales tax, as in Washington for B&O tax | Keep the B&O and retail sales tax lines reconciled separately |
Return instructions change, so check each state’s current form before filing. If you sell only through marketplaces and are registered, you may still need to file returns showing $0 due; see zero-return filing requirements.
Worked Example: One State, Two Channels
Example: a home goods seller registered in Georgia, quarterly results
Amazon sales into Georgia: $40,000 → tax collected and remitted by Amazon
Shopify sales into Georgia: $25,000, all taxable, average combined rate 7.4%
Expected tax on Shopify sales: $25,000 × 7.4% = $1,850
Tax actually collected by Shopify: $1,710 → variance $140
Cause found: shipping on 60 orders was not set as taxable, and Georgia generally taxes delivery charges on taxable sales
Fix: correct the store setting, report $1,850 on the return and absorb $140, or document the decision
Without the split, the seller might have reported all $65,000 as taxable and overpaid about $2,960 on sales Amazon had already covered. Check the combined rate for any address with the Sales Tax Calculator, and back out tax from tax-inclusive totals with the Reverse Sales Tax Calculator.
Common Reconciliation Gaps and Fixes
| Gap | Likely cause | Fix |
|---|---|---|
| Total sales lower than bank deposits | A channel is missing, or deposits include non-sales items | Map every deposit source; remove loans, refunds and transfers |
| Direct tax collected lower than expected | Wrong rates, untaxed shipping, missing product tax codes | Fix store settings; see our ecommerce platform setup guide |
| Tax collected on marketplace orders you also remitted | Marketplace sales included in direct taxable sales | Move them to the marketplace column; claim a credit or refund if overpaid |
| Multi-Channel Fulfillment orders without tax | Website orders fulfilled by Amazon are treated as direct sales | Collect tax in your storefront for those orders |
| Refunds not matching | Refund recorded in a different period than the sale | Follow state rules for refund timing; see refunds and returns |
| Exempt sales without support | Certificates not collected | Collect certificates now and track deadlines |
A Monthly Close Checklist
- Download all marketplace and storefront tax reports for the period.
- Update the master table by state, then run the total revenue check.
- Investigate any state where direct tax variance exceeds a set tolerance, such as 1% or $50.
- Update threshold tracking for states where you are not yet registered.
- File returns from the reconciled numbers and save the workpaper with the return.
- Keep the workpapers for at least the audit period, commonly three to four years.
Conclusion
To reconcile marketplace vs direct sales tax, treat marketplace sales as reported but not owed by you, direct sales as fully your responsibility, and the return as the place where both must add up. A simple master table by state and period, checked monthly, prevents double payment and gives auditors a clear trail. Review rates on our state sales tax pages and explore more guides from the Tax Rate Center homepage.
Frequently Asked Questions
Do I report marketplace sales on my sales tax return?
It depends on the state. Some exclude marketplace sales entirely, while others require you to report them in gross sales and then deduct them, so the net taxable amount reflects only your direct sales.
How often should I reconcile marketplace and direct sales?
Reconcile at least as often as you file, and ideally monthly. Monthly reconciliation catches rate and settings errors before they build up across several returns.
What if my store collected less tax than I owe?
You generally owe the correct tax on taxable sales even if you under-collected from customers. Report the full amount, fix the store setting, and document the variance.
Who collects sales tax on Amazon Multi-Channel Fulfillment orders?
MCF orders come from your own website or other channels, so Amazon does not act as the marketplace facilitator. You are responsible for collecting and remitting the tax where you have nexus.
Can I get a refund if I paid tax on marketplace sales twice?
Usually yes. Correct the return through an amendment or the state’s refund claim process within its statute of limitations, and keep marketplace reports showing that the facilitator already remitted the tax.