- Connect Shopify to QuickBooks Online via a bridge (A2X or Link My Books), not a raw payout feed.
- The bridge posts clean, VAT-aware journals per payout that reconcile to the bank deposit.
- Map Shopify tax to the right QuickBooks VAT codes (20%, 0%, PVA for imports); separate UK / EU / RoW.
- QuickBooks is ~25% cheaper than Xero at equivalent tiers and includes multi-currency at Essentials.
- Need it configured? Match with a Shopify-QuickBooks specialist →
Why a bridge beats the raw feed
Same principle as Xero: a Shopify payout into QuickBooks is one net number, gross sales minus refunds, fees and adjustments. Categorise that and you lose gross revenue, lose the fee as a cost, and get VAT wrong (VAT is due on gross, not net).
A bridge (A2X or Link My Books) reconstructs each payout into proper QuickBooks journal lines, applies VAT, and posts a summary that still matches the bank deposit for one-click reconciliation.
A clean Shopify-QuickBooks setup
- QuickBooks Online with a chart of accounts separating sales, fees, refunds and shipping.
- A2X or Link My Books connected to Shopify and QBO, posting a summarised journal per payout.
- VAT codes mapped so Shopify tax flows to the correct QuickBooks codes.
- Bank reconciliation matching each Shopify deposit to the posted journal.
- Class/location tracking if multi-channel, so Shopify margin is separable.
VAT mapping in QuickBooks
- UK standard sales: 20% (standard rate code).
- Zero-rated goods: 0%.
- Imports: QuickBooks' PVA handling, see import VAT.
- EU consumer sales: separated for OSS/IOSS.
As with Xero, Shopify is not a marketplace, so you are always VAT-responsible on Shopify sales and the QBO setup must reflect that.
QuickBooks vs Xero for this
Both work well and both integrate natively with A2X and Link My Books. Differences that matter for a Shopify integration:
- Price: QuickBooks is consistently ~25% cheaper at equivalent tiers, and includes multi-currency from the Essentials tier (Xero needs Premium).
- Accountant network: Xero has the larger UK ecommerce-specialist network.
- Reporting: Xero's custom reporting is more flexible at the high end.
Full breakdown in Xero vs QuickBooks for ecommerce. If you are already on QuickBooks and it works, there is rarely a reason to migrate.
Common mistakes
- Raw payout feed only, destroys VAT accuracy.
- Wrong VAT codes on the bridge mapping.
- Double-counting from running two sync sources at once.
- Burying Shopify/Stripe fees in the net figure instead of recording them as a cost.
- Not separating EU sales, breaks OSS/IOSS.