Marketplace Facilitator Sales Tax in QuickBooks: The Double-Count Trap

If you sell on Amazon, Etsy, Walmart, eBay, or other marketplaces in the U.S., there's a specific accounting trap to check when settlement records and marketplace tax reporting are not reconciled. It costs sellers money in two directions: paying tax that isn't owed, and recording revenue that doesn't exist.

The trap is marketplace facilitator sales tax and how it shows up in your books.

What marketplace facilitator laws actually do

Starting around 2018, states began passing laws that shift sales tax collection responsibility from the seller to the marketplace for sales transacted on the marketplace. Every state with a statewide sales tax, plus DC, has a marketplace-facilitator framework. Effective dates, thresholds and reporting rules vary; Alaska local jurisdictions require a separate review.

In practical terms: if a customer in California buys your product on Amazon, Amazon (not you) is responsible for:

1. Collecting California sales tax
2. Remitting it to California
3. Filing the California sales tax return

The facilitator is responsible for collecting and remitting covered California marketplace sales tax, but that does not erase your reporting obligations. CDTFA says registered marketplace sellers still report total sales, including facilitated sales, then apply the appropriate treatment. Nexus thresholds, registration, informational reporting, income taxes and gross-receipts taxes are separate questions.

This is good news for compliance. It's bad news for your books, because the cash flow doesn't reflect this.

The flow that breaks bookkeeping

Here's what actually happens in your Amazon Seller Central:

1. Customer pays $107 ($100 product + $7 sales tax)
2. Amazon collects all $107
3. Amazon remits $7 to the state directly
4. Amazon takes its referral fee (15%) and FBA fees ($3-7)
5. The order contributes roughly $78-82 to settlement ($100 minus an illustrative $15 referral fee and $3-7 FBA fee); rates vary by category, and the bank deposit is a multi-order settlement, not necessarily this one order

Your bank shows a multi-order settlement deposit; this order's share is roughly $78-82 in the illustration. Your Seller Central shows: $100 product sale + $7 tax + Amazon's fees.

Two separate errors to check:

• Recording a $107 debit to clearing and a $107 revenue credit overstates product revenue by $7 in this illustration.
• Recording $107 to clearing, $100 to revenue and $7 to a tax payable is initially balanced, but leaves a false payable if the facilitator-remittance clearing entry is omitted.

Fee deductions are a separate posting. Reconcile each entry to the settlement statement rather than combining both errors into one unbalanced example.

That liability sits there forever, slowly growing every month. Eventually someone notices the books are wrong.

A historical 2021 bookkeeping account raised a possible mismatch between a tax export and tax already remitted by a marketplace. That is a reconciliation failure mode to test, not a verified current TaxJar limitation. Match the current export to facilitator statements before recognizing a payable.

The right way: separate accounts, separate flows

The fix is structural. You need to design the chart of accounts to separate marketplace and direct sales, and to handle marketplace facilitator tax as a pass-through.

Recommended chart of accounts for ecommerce

Revenue accounts:

• 4000: Direct (Shopify) Sales
• 4100: Marketplace Sales (Amazon)
• 4110: Marketplace Sales (Etsy)
• 4120: Marketplace Sales (Walmart)

Sales tax collected is not sales revenue. Account numbers are illustrative; choose the correct account type and reconciliation workflow.

Liability accounts (sales tax):

• 2200: Sales Tax Payable (Direct/DTC), what you owe
• 2210: Marketplace Facilitator Sales Tax (Pass-Through), temporary holding for what marketplace handles

Cost of revenue accounts:

• 5000: COGS
• 5100: Amazon Referral Fees
• 5110: Amazon FBA Fulfillment Fees
• 5120: Amazon Storage Fees
• 5130: Amazon Advertising
• 5200: Etsy Fees
• 5300: Shopify Payment Processing Fees

The marketplace facilitator entry

For an Amazon sale of $100 + $7 marketplace facilitator tax:

Net effect: $100 revenue recorded, $0 sales tax liability, $7 cleared in and out. When the settlement deposit hits the bank (this order's roughly $78-82 share, net of fees), reconcile it and the fee entries against Amazon Clearing.

The pass-through should net to zero after each settlement is fully posted. A balance during the settlement cycle can be timing; reconcile persistent balances against the facilitator statement before correcting them.

The DTC entry (where sales tax IS your liability)

For a Shopify direct sale of $100 + $7 sales tax (you collect, you remit):

When you remit the $7 to the state via your sales tax software:

Net: real liability tracked, real payment recorded, accounts reconcile.

The integration tools that help (and the ones that don't)

Three tools dominate ecommerce-to-QuickBooks/Xero integration:

Before relying on any of these tools, confirm in its current settings where marketplace facilitator tax maps. Keep it separate from direct Sales Tax Payable and reconcile the pass-through to the settlement, including any timing balance. A combined or incorrect tax mapping can create double-counting.

"Nightmare Bookkeeping Setup. The numbers were all off. Couldn't figure out why, but upon further research, this may just be a common 'glitch'... Now I'm scared about using Tax-o-mate, A2X and Link My Books because I feel like the numbers won'[t match]" (Amazon seller, r/AmazonSeller)

The tools work. The defaults don't. Setup matters.

Reconciliation discipline (monthly, not annual)

Every month, your ecommerce bookkeeper should:

1. Run a marketplace facilitator pass-through balance check, should be close to $0 (small variances are normal due to settlement timing)
2. Reconcile direct sales tax liability to expected remittance per your sales tax software
3. Verify Amazon Clearing / Shopify Clearing / Etsy Clearing accounts clear within 1-2 settlement cycles
4. Investigate any aged items in clearing accounts older than 30 days

If these four things don't happen monthly, your books drift quietly until tax season, when the drift gets discovered the hard way.

Common Ecommerce Reconciliation Errors to Check

These are concrete failure modes to test in ecommerce books:

1. All sales tax in one liability account, marketplace + DTC mixed, can't tell what's owed
2. No separation between Amazon, Shopify, Etsy revenue, can't see channel profitability
3. Marketplace fees lumped into "Operating Expenses", distorts COGS and gross margin
4. FBA inventory reimbursements booked as sales, overstates revenue
5. Chargebacks recorded as expenses instead of contra-revenue, distorts everything downstream
6. No clearing accounts, settlements posted directly to bank, fee detail lost
7. Refunds netted into revenue, can't track refund rate as a separate metric

Each requires settlement-level reconciliation, appropriate account mapping and clear responsibility for tax treatment. A general bookkeeper can learn the workflow; prior marketplace experience alone does not prove it is configured correctly.

When to call Level

Most general bookkeepers can clean up your direct/non-marketplace books. Ecommerce bookkeeping with marketplace integration is a specialty. Depending on the signed engagement, Level can support $1-20M DTC and marketplace brands with the chart of accounts redesign, A2X / Link My Books configuration, monthly reconciliation, and tax-provider coordination across applicable states. Tax filing itself requires the signed filing scope or your tax provider.

If your books don't cleanly answer "what was my Amazon-only gross margin last month?" or "how much sales tax do I actually owe vs. what marketplaces handled?" That's the gap.

FAQ

Do I need to register for sales tax in marketplace facilitator states? Registration is state-specific. Marketplace tax collection does not universally remove seller registration, nexus or reporting requirements. California registered sellers still report total sales including facilitated sales; review DTC nexus and each applicable state separately.

What's the difference between A2X and Link My Books? Compare each current plan at your order volume, per-channel tax mapping and settlement-level detail during a demo. Test supported channels, settlement completeness, tax mappings and exception handling on a representative period. This page does not establish that either tool is universally simpler or superior.

Can my general bookkeeper learn this? Yes, if they're willing to invest the time. Twenty to forty hours is an illustrative training-and-setup budget, not a measured learning-time distribution. Validate it against channel count, settlement history and the exception backlog; assign a competent reviewer before changing tax entries.

Should I switch from QuickBooks to Xero for ecommerce? Not based on this issue alone. Both QuickBooks Online and Xero handle marketplace facilitator accounting fine if set up correctly. The choice usually comes down to other factors (multi-currency, app ecosystem, accountant familiarity).

Related reading:

• Sales Tax Nexus After Wayfair: 6 States That Hurt Most
• Why Your 1099-K Doesn't Match Seller Central
• Ecommerce Bookkeeping That Actually Works