How to Record Shopify Sales Tax in QuickBooks

Sales tax is one of the most confusing parts of Shopify bookkeeping — and one of the easiest areas to record incorrectly in QuickBooks. The rules changed significantly when states began requiring marketplace facilitators (like Shopify) to collect and remit tax on behalf of sellers. If your QuickBooks records are treating Shopify sales tax as your own tax liability when Shopify is actually handling remittance, your books are wrong.

This guide explains exactly how Shopify handles sales tax, how it appears in your settlement data, and how to record it correctly in QuickBooks Online.

How Shopify Collects and Reports Sales Tax

When a customer checks out on your Shopify store, Shopify calculates the applicable sales tax based on the shipping destination and your store's tax settings. That tax is collected from the customer at the time of purchase.

Where that tax goes next depends on whether you're in a marketplace facilitator state.

Marketplace Facilitator States

As of 2026, most US states have marketplace facilitator laws that require platforms like Shopify to collect and remit sales tax directly to the state — on your behalf. You never receive this money. It flows from the customer through Shopify to the state tax authority.

States with marketplace facilitator laws include California, Texas, New York, Florida, Illinois, Pennsylvania, Ohio, Georgia, and most others. A small number of states still require merchants to handle their own collection and remittance.

What this means for your books: In marketplace facilitator states, the sales tax Shopify collects is not your money. It should not appear as income, and it should not appear as your tax liability in QuickBooks. It is a pass-through amount that Shopify handles entirely.

How Sales Tax Appears in Shopify Payouts

When you download your Shopify payout report, you'll see a Tax line or Sales Tax column. In marketplace facilitator states, this amount is typically excluded from your payout entirely — Shopify collects it, remits it, and you never see it in your bank account.

In states where you're responsible for remittance, the tax amount flows through to your payout, and you're responsible for setting it aside and remitting it to the state on your filing schedule.

This distinction is critical for correct QuickBooks recording.

How to Record Shopify Sales Tax in QuickBooks

Scenario 1: Marketplace Facilitator States (Most US States)

If Shopify is collecting and remitting the tax:

Do not record it as your tax liability. The easiest correct approach is to simply exclude the tax lines from your journal entry entirely. Since Shopify handles remittance and the money never hits your bank account, your books don't need to track it.

If you want to show the gross revenue including tax (for accuracy on your income statement), use this journal entry structure:

Account	Debit	Credit
Bank Account (payout)	$X
Shopify Fees Expense	$X
Sales Returns & Allowances	$X
Sales Revenue (gross, incl. tax)		$X
Sales Tax Collected — Pass-Through		$X

The Sales Tax Collected — Pass-Through account is a liability account that you immediately offset (or zero out) because Shopify remits it. Most bookkeepers skip this level of detail and simply exclude the tax lines — either approach is defensible.

The most common correct approach for marketplace facilitator states: Record revenue net of tax in the settlement journal entry, ignoring the tax lines entirely. Your gross revenue in QuickBooks will be slightly lower than your gross Shopify sales, but your net income will be accurate.

Scenario 2: States Where You Remit Sales Tax Yourself

If your state still requires you to collect and remit sales tax directly:

1. Record tax collected as a liability when it comes in: credit Sales Tax Payable for the tax amount collected during the payout period
2. Don't record it as revenue — it's never your income
3. Remit to the state on your filing schedule, debiting Sales Tax Payable when you pay

Journal entry structure for a payout where you handle remittance:

Account	Debit	Credit
Bank Account (payout)	$4,372.14
Shopify Fees Expense	$218.00
Sales Returns & Allowances	$312.00
Sales Revenue		$4,502.14
Shipping Revenue		$210.00
Sales Tax Payable		$190.00

When you remit the tax:

Account	Debit	Credit
Sales Tax Payable	$190.00
Bank Account		$190.00

Setting Up QuickBooks Online for Shopify Sales Tax

Using QuickBooks Online's Sales Tax Center

If you're in a state where you remit your own tax, QuickBooks Online has a built-in sales tax feature (Taxes > Sales Tax) that can track your liability by jurisdiction and generate filing reminders.

To use it effectively with Shopify:

1. Go to Taxes > Sales Tax > Set up sales tax
2. Add each state or jurisdiction where you have nexus and handle your own remittance
3. When entering journal entries from Shopify payouts, map the tax lines to QBO's sales tax accounts rather than a manual liability account

Important: QuickBooks Online's automated sales tax is designed for businesses using QBO's invoicing features. When you're importing journal entries from Shopify settlements, you'll typically create a manual Sales Tax Payable liability account and manage it outside QBO's automated system. The automated system works better for businesses using QBO for invoicing from the start.

If You're in Marketplace Facilitator States Only

If all your customers are in states where Shopify handles remittance (which is most US sellers):

• You don't need to set up QuickBooks' sales tax feature at all
• No Sales Tax Payable liability account is needed
• Simply exclude the Shopify tax lines from your journal entries
• Your income tax reporting will reflect gross revenue on your 1099-K (which Shopify issues), and your bookkeeping can match net revenue — your accountant will reconcile the difference at year-end

Reconciling Shopify Tax with QuickBooks

At month-end or quarter-end, run the Shopify Tax Report (in Shopify admin: Analytics > Reports > Finances > Taxes). This shows:

• Total sales tax collected by state
• Total tax remitted by Shopify (for marketplace facilitator states)
• Total tax you collected yourself (if applicable)

Compare this against what's in QuickBooks. If you're in marketplace facilitator states and correctly excluding tax from your journal entries, you should see no Sales Tax Payable balance in QuickBooks at any point — which is correct.

If you do see a balance in Sales Tax Payable and you're in marketplace facilitator states, that means tax was incorrectly recorded as your liability — it needs to be cleared.

Common Shopify Sales Tax Mistakes in QuickBooks

Mistake 1: Recording marketplace facilitator tax as income

Some bookkeepers (and some import tools) record the gross order amount including sales tax as revenue, creating inflated income figures. Revenue should be the product + shipping price — not the tax.

Mistake 2: Recording marketplace facilitator tax as your own liability

Recording Shopify-collected-and-remitted tax as Sales Tax Payable in QuickBooks creates a phantom liability. You don't owe this — Shopify already paid it. Clear any incorrectly recorded liability with a journal entry offsetting it against a clearing account.

Mistake 3: Ignoring nexus in non-facilitator states

If you have physical nexus in a state that doesn't yet have marketplace facilitator laws (rare, but some exist), you're still responsible for collecting and remitting. Confirm your nexus positions with a tax professional rather than assuming Shopify handles everything everywhere.

How SettleBooks Handles Shopify Sales Tax

When you upload a Shopify settlement report to SettleBooks, tax lines are automatically identified and handled correctly:

• In marketplace facilitator states, tax lines are flagged as pass-through and excluded from the journal entry by default
• In states where you handle remittance, tax lines are mapped to a Sales Tax Payable liability account in your journal entry
• Category mappings are customizable — if your accountant wants a specific treatment, you can configure it in your account mappings

The result is a balanced journal entry that reflects the correct accounting treatment for your tax situation, ready to import into QuickBooks, Xero, or Sage.

Upload your Shopify settlement report and see how SettleBooks categorizes your tax lines →