Understanding Shopify Sales Tax in QuickBooks Online (QBO)

1. How Shopify Handles Sales Tax

Shopify collects sales tax at checkout based on your customers’ locations and your Shopify tax settings, which are generally based on nexus rules and marketplace facilitator laws.

• Shopify records the total sales tax collected on each order.
• Shopify does not automatically break down sales tax by state or jurisdiction when sending data to QBO unless you use an advanced connector like A2X or Synder.

2. How QBO Sees It by Default

If you sync Shopify with QBO using the native Shopify app:

• Sales often appear as a summarized daily journal entry or invoice.
• The sales tax portion may post to a liability account (for example, “Shopify Sales Tax Payable”) rather than QBO’s automated Sales Tax Center.
• This means detailed breakdowns by state, such as “CA Sales Tax” versus “NY Sales Tax,” may not appear in QBO reports.

3. Best Practice: Use QBO’s Sales Tax Center Correctly

To handle multi-state tax rates properly, you have two options:

Option A Manual Control (Simpler but Manual)

1. Turn on Automated Sales Tax (AST) in QBO.
2. Set up your nexus states under “Taxes → Sales Tax Settings.”
3. When importing Shopify sales, manually edit the invoice or sales receipt to select the correct tax agency if syncing gross sales.
4. Periodically reconcile the total collected from Shopify reports against QBO’s “Sales Tax Payable.”

Option B Use an Integration That Maps Taxes Correctly (Recommended for Multi-State Sellers)

Use apps like A2X for Shopify, Synder, or Webgility. These tools:

• Sync gross sales, refunds, discounts, and taxes accurately.
• Map Shopify tax lines directly to QBO tax agencies.
• Prevent duplicate or missing tax entries.
• Work well with multiple nexus states.

4. Common Mistakes to Avoid

• Do not record Shopify payouts as “Sales” because they are net deposits (gross sales minus fees and taxes).
• Do not create separate “Shopify Sales Tax Payable” accounts manually unless you are tracking taxes outside QBO.
• Avoid using both Shopify’s tax summary and QBO’s tax tracking simultaneously, as this can result in double-counting.

5. Monthly Reconciliation Tip

1. In Shopify, go to Reports → Taxes Finance Report and export tax collected by state.
2. In QBO, verify that your Sales Tax Payable balances match the Shopify report.
3. Adjust or create a journal entry if there is a mismatch, often caused by refunds or timing differences.

Example

Suppose you sold $10,000 in products and collected:

• $500 CA sales tax
• $200 NY sales tax

In Shopify:

• Total payout to bank = $10,000 + $700 tax – $300 fees = $10,400

In QBO:

• Record gross sales of $10,000
• Record sales tax payable of $700, split by agency if using QBO tax center
• Record Shopify fees of $300 as an expense
• The deposit matches the bank amount of $10,400