Shopify QuickBooks integration, and when the standard connector isn't enough

A Shopify QuickBooks integration posts your Shopify sales, refunds, fees and payouts into QuickBooks Online (QBO) or QuickBooks Desktop so your books match your bank. Connector apps handle most stores well. The standard connector isn't enough when you sell B2B on terms, run several stores or currencies, need inventory valued in QuickBooks, or the payout never matches the bank line and nobody can find out why.

The most important decision is how Shopify data should appear in QuickBooks, not which app you use.

What data flows

• Sales: gross sales, discounts, shipping charged, sales tax collected, split by account and, if you need it, by class or location.
• Refunds: full and partial, with or without restock.
• Payment processing fees: per transaction or per payout.
• Payouts: the net amount that arrives in your bank, plus adjustments such as chargebacks and reserves.
• Gift cards: a liability when sold and revenue when redeemed, not revenue at sale.
• Inventory and cost of goods sold: optional, and only if QuickBooks is where you track inventory value.
• B2B invoices: orders placed on payment terms that need a real QuickBooks invoice and a later payment.

Three ways to post Shopify data to QuickBooks

Tools such as A2X focus on summaries per payout. Tools such as Synder can sync transactions individually or as summaries. There are several other connector apps on the Shopify App Store. Compare them on the approaches they support and how they handle your edge cases, not on the feature list.

QuickBooks Online vs QuickBooks Desktop

QuickBooks Online has a documented REST API with OAuth 2.0. Integrations run in the cloud and can post at any time.

QuickBooks Desktop is installed software. Integrations usually go through the QuickBooks Web Connector, which runs on the machine where QuickBooks is installed and periodically polls a web service for work to do. That means the sync only runs when that computer is on and QuickBooks can be reached, and fewer Shopify apps support it. If you are still on Desktop, factor that into the decision.

Where Shopify QuickBooks connectors fall short

• The payout doesn't match the bank. Usually caused by refunds, chargebacks, currency conversion or adjustments that landed in a different payout from the original sale.
• Tax mapping. Multi-state US sales tax, tax-exempt B2B customers, and Canadian GST/HST/PST need to map to the right QuickBooks tax codes or agencies.
• Several stores or currencies feeding one QuickBooks company.
• B2B on payment terms, where the order should become an invoice that is paid later, not a sales receipt.
• Non-Shopify-Payments gateways. PayPal and other providers settle separately, each with its own clearing account.
• Duplicate customers and items created by per-order sync.
• Inventory: most merchants should not try to run perpetual inventory value in QuickBooks from Shopify without a clear process.

How a custom QuickBooks integration works

A custom integration makes sense when you need behaviour that no connector offers. Examples: invoices for B2B orders only, with summaries for D2C; classes by sales channel; a specific treatment for marketplace orders.

1. Source data from Shopify: order, refund and transaction webhooks, plus the GraphQL Admin API for full order detail. For Shopify Payments, payouts and their balance transactions are read from the Admin API so each payout can be broken down into its orders, refunds, fees and adjustments.
2. Mapping rules in config: accounts, tax codes, classes and locations per channel, market or customer type, editable without a deploy.
3. Posting to QuickBooks Online through its API. Each posted entity stores the Shopify ID in a memo or private note field, and the app keeps a local map, so a retry never double-posts.
4. Clearing-account model: sales and fees post to a clearing account and payouts post as a transfer to the bank. The clearing balance per payout should be zero. If it isn't, the payout is flagged.
5. Error queue and reconciliation: failed posts are visible with the QuickBooks error message, and a daily check compares Shopify totals with the amounts posted.

Worked example: what a payout contains

A single Shopify Payments payout usually covers several days of activity. An illustrative breakdown (the numbers are made up):

A connector or custom integration that posts each of these lines, and links the payout transfer to the bank feed line of 2,216.60, turns reconciliation into a one-click match. If a connector only posts sales and the payout, the difference between them lands in a suspense account and someone has to explain it by hand every month.

Decision checklist

• QuickBooks Online or Desktop?
• Per order, daily summary or per payout?
• Which payment providers do you use besides Shopify Payments?
• Do you sell B2B on terms? Do those orders need QuickBooks invoices?
• One store or several? One currency or several?
• Where is inventory value tracked?
• Who reconciles, and how often?

Use the answers to test connectors on a trial before you buy. Put your messiest real month through the connector. If it balances, you are done. If it doesn't, you know exactly what a custom integration needs to fix.