Shopify QuickBooks Integration
We connect Shopify and Shopify Plus to QuickBooks Online so the books reconcile themselves — paid orders posted as sales receipts, B2B orders as invoices, Shopify Payments payouts matched to your bank feed, and UK VAT mapped to the right tax codes. Built by engineers who understand the accounting, not just the API.
Our QuickBooks integration process
- Map the books. We agree the mapping first: which QuickBooks income accounts and items receive sales, shipping, and discounts, which tax codes map to UK VAT, and — crucially — whether each order should post as a Sales Receipt or an Invoice. Getting this wrong is what makes QuickBooks integrations untrustworthy.
- Build the connector. Custom middleware over the QuickBooks Online Accounting API (V3), authenticated with OAuth 2.0 and the accounting scope, scoped to your company via realmId. Paid Shopify orders post as Sales Receipts; unpaid or B2B orders post as Invoices with a linked Payment when settled.
- Reconcile payouts. Shopify Payments payouts are grouped and matched to your QuickBooks bank feed with gateway fees split to an expense account, so each deposit reconciles cleanly. Refunds post as Refund Receipts or Credit Memos against the original transaction.
- Verify + support. A real-order replay confirms VAT, fees, and accounts are correct before go-live, plus alerting on failed posts and a scoped support window. Bulk back-fills use batch operations and respect QuickBooks' API throttling so a historical import doesn't get rate-limited.
What's included
- Paid Shopify orders posted to QuickBooks as Sales Receipts; unpaid and B2B orders as Invoices with linked Payments when they settle
- Shopify Payments payout reconciliation — payouts grouped and matched to your QuickBooks bank feed with gateway fees split out
- UK VAT handled correctly — Shopify tax lines mapped to the right QuickBooks tax codes for standard, zero-rated, and export sales
- Refunds posted as QuickBooks Refund Receipts or Credit Memos so returns reconcile against the original sale
- Customer and item/product sync in the direction that matches your source of truth, with multi-currency support where you sell across regions
- Reliable de-duplication — each Shopify order is mapped to its QuickBooks entity ID and checked before posting, plus a reconciliation pass so totals tie back
Integration timeline
Typically 1-3 weeks
Order-to-receipt posting with payout reconciliation for a single-currency UK store is the fast end — 1-2 weeks. Multi-currency, multi-store, or B2B with invoice-and-payment logic and bespoke account mapping is 2-4 weeks. We confirm a window in writing once the account mapping is agreed — the work is in the accounting rules, not the QuickBooks API itself.
FAQ
- How does Shopify connect to QuickBooks Online?
- Through the QuickBooks Online Accounting API (V3), authenticated with OAuth 2.0 using the com.intuit.quickbooks.accounting scope and scoped to your company file via its realmId. A Shopify order becomes a Sales Receipt (if already paid) or an Invoice plus a linked Payment (if on terms), with line items mapped to your QuickBooks items, income accounts, and tax codes. Shopify Payments payouts are then reconciled against your QuickBooks bank feed.
- Should orders post as Sales Receipts or Invoices?
- It depends on whether the order is already paid. A standard D2C order paid at checkout is a Sales Receipt — cash received, no accounts-receivable balance. A B2B order on payment terms is an Invoice, with a Payment linked to it when the customer settles. Posting paid orders as invoices is a common mistake that inflates your accounts receivable with money you've already collected; we map each order to the right transaction type.
- Do I need a connector app like OneSaas or A2X, or a custom integration?
- Intuit's QuickBooks Connector (OneSaas) and summariser apps like A2X are a good fit when your data maps cleanly and you're happy with summarised journals — and we'll recommend one rather than bill you for custom work when that's true. Custom is the honest answer when you need order-level detail, multi-currency, B2B invoice-vs-receipt logic, COGS journals, or UK VAT handling on international sales that the off-the-shelf connector doesn't get right.
- How is UK VAT handled in QuickBooks?
- Shopify tax lines are mapped to the correct QuickBooks Online tax codes during setup, so standard-rated, zero-rated, and export sales each post to the right place and your VAT return is accurate. UK VAT on international and EU sales is the area summariser apps most often get wrong, and it is exactly what we verify in the real-order replay before go-live.
- Does it reconcile Shopify Payments payouts?
- Yes. A Shopify Payments payout is a single bank deposit covering many orders minus fees. We group the orders in that payout and match them to the deposit in your QuickBooks bank feed, splitting the gateway fee to an expense account, so the statement line reconciles in one step instead of being unpicked by hand at month-end.
- How do you prevent duplicate transactions in QuickBooks?
- QuickBooks Online uses optimistic concurrency (a SyncToken) rather than a universal idempotency key, so we de-duplicate by storing the mapping between each Shopify order and its QuickBooks entity ID and checking it before posting. A retried webhook finds the existing record and updates rather than duplicates it, and a scheduled reconciliation pass diffs Shopify orders against QuickBooks so nothing silently drifts.
- How much does a Shopify QuickBooks integration cost?
- Order-to-receipt posting with payout reconciliation for a single-currency UK store typically runs £3K-£8K. Multi-currency, multi-store, or B2B with invoice-and-payment logic and bespoke account mapping is usually £8K-£18K. We share firm pricing in writing once the account mapping is agreed — the cost driver is the accounting complexity, not the integration plumbing.