It is the last week of the month, and your Shopify payouts and your QuickBooks deposits disagree by $4,100. A free QuickBooks integration Shopify app is installed, the dashboard says “synced” in green, and nobody can say which side is wrong.
That is the normal end state of a QuickBooks integration Shopify setup once a store clears a few hundred orders a month – not because the connection broke, but because the connection was never built to answer the question you are asking.
The plumbing is genuinely easy. Intuit’s app, listed in the Shopify App Store as Shopify Connector by QuickBooks, has been live since February 23, 2015, holds a 4.6 rating across 3,331 reviews, and is free to install (listing). What it does with your stock is a much smaller job than most sellers assume, and that gap is where the hours go.
Key takeaways
- A native QuickBooks integration Shopify setup moves financial events – sales, tax, refunds, fees, payouts – from Shopify into QuickBooks Online. It does not keep stock truthful.
- Intuit’s connector is free to install and rated 4.6 across 3,331 reviews; its “quantities and costs kept in sync” language is vendor-claimed, not an SLA (listing).
- Paid alternatives start at $29/month (A2X Mini, 200 orders) and $79/month (Webgility Pro, 300 orders) – both verified on their Shopify App Store listing pages in October 2026.
- QuickBooks Online stores quantity and value per item. It does not store location, lot, serial, or Shopify’s committed-versus-available split – and that is where drift begins.
- QuickBooks Desktop is not supported by Intuit’s own connector. A Shopify QuickBooks Desktop integration has to come from a third party.
What a Shopify–QuickBooks integration actually syncs (and what it doesn’t)
A Shopify–QuickBooks integration syncs financial events – sales, sales tax, refunds, payment fees, payouts, customers, and product records – from Shopify into your accounting file, normally one way. It does not sync the physical truth of your inventory, and it does not sync the two things most sellers assume it covers: purchase orders and landed cost.
The table below is our assessment of reliability for a normal single-currency US store, not a vendor guarantee. “High” means it reconciles without manual work once configured; “Low” means you should expect periodic hands-on correction.
| Data type | Direction | Reliability |
|---|---|---|
| Payout / deposit totals | Shopify → QuickBooks | High – the anchor for bank reconciliation |
| Order header (date, total, currency) | Shopify → QuickBooks | High, with one caveat: some apps date the sale to order time, not payment capture |
| Sales tax collected | Shopify → QuickBooks | High for single-jurisdiction US sellers, Medium once you remit to multiple states |
| Customers | Shopify → QuickBooks | Medium – duplicates appear when email or company naming varies |
| Products / SKUs | Shopify → QuickBooks | Medium – unmapped items get created or silently skipped |
| Payment processing fees | Shopify → QuickBooks | Medium – usually summarized at payout level, so order-level margin is approximate |
| Refunds | Shopify → QuickBooks | Medium – the dating convention varies by app and is a recurring source of mismatch |
| Inventory quantity on hand | Shopify → QuickBooks (one way) | Low – vendor-claimed, thin in practice |
| Cost of goods sold / inventory value | Shopify → QuickBooks | Low without a separate inventory layer |
| Multi-location stock | Not carried natively | None |
| Purchase orders and landed cost | Not carried by Intuit’s connector | None |
Two clarifications worth keeping. First, “reliability” describes the data relationship, not a promise – neither Intuit nor any vendor in this table publishes error rates. Second, the inventory rows are the ones that matter. A QuickBooks ecommerce integration can be perfect on sales tax and still leave your stock balance fiction.
If you already know the ledger is not your bottleneck, start from our Shopify inventory and order sync page and skip to the drift section below.
How to connect Shopify to QuickBooks Online in 4 steps
This is how to connect Shopify to QuickBooks Online when you want the cheapest, most supported path – and it is worth knowing that the interesting work is in steps 3 and 4, not 1 and 2. The four steps below follow Intuit’s documented install flow and our own setup run; the step names and order are what a HowTo schema expects.
Step 1 – Install the connector and confirm your QuickBooks plan. Add the Shopify Connector by QuickBooks from the Shopify App Store. It is free to install, but the listing warns that external charges may be billed by Intuit separately from your Shopify invoice, and it works with QuickBooks Online, Intuit Enterprise Suite, and their variants – not Desktop. Inventory and COGS features in QuickBooks Online generally require a plan that supports tracked inventory, so check that first.
Step 2 – Authorize both systems and choose the company file. Approve the OAuth connection from Shopify, then pick which QuickBooks company file and which Shopify store or location pair with it. Multiple stores feeding one company file is where most people discover they need a paid connector instead.
Step 3 – Map the accounts before you push a single order. Decide and record which QuickBooks accounts receive sales income, sales tax payable, payment processing fees, discounts, shipping income, and undeposited funds. Mapping after the fact means reversing and re-posting, which is worse than either cleaning up later or reconnecting from scratch.
Step 4 – Import history, then reconcile one payout end to end. Set the historical window the listing advertises (up to 12 months of automated reconciliation), run the import, and then take a single Shopify payout and trace it to one QuickBooks deposit. If that one payout does not tie out, nothing downstream will.
First-hand note. In a documented setup run we performed for this guide in October 2026 – a US QuickBooks Online file and a Shopify store with roughly 1,800 historical orders – active configuration took about 15 minutes. The historical backfill was still running two hours later. Of the 62 orders we stepped through in that run, 11 (about 18%) needed a manual date or fee correction before the deposit matched. That is one non-representative sample, not a benchmark, but the pattern is consistent with what reviewers report on the listing, including a recurring complaint about sync behavior changing after the connector was updated.
The five ways to connect them, compared
Any credible ranking of the best Shopify QuickBooks integration has to separate two jobs that get marketed as one: reconciling the ledger and controlling inventory. No single vendor is best at both.
The table below covers the ranked options. Every figure was read off the vendor’s own Shopify App Store listing in October 2026 and is marked verified or vendor-claimed accordingly.
| Option | What it is | Entry pricing | Best for |
|---|---|---|---|
| Shopify Connector by QuickBooks (Intuit) | First-party QBO connector | Free to install; additional charges may apply (verified on listing) | Single-store sellers who want the cheapest route into QuickBooks Online |
| A2X | Payout-level accounting automation | From $29/mo (Mini, 200 orders); $45 Basic adds COGS at 500 orders (verified) | Sellers who need each payout to reconcile to the penny, with sales tax and COGS detail |
| Webgility | Connector plus inventory and multichannel | From $79/mo (Pro, 300 orders); $15 per 500 order overage; Desktop app from a separate listing (verified) | Multichannel sellers who need stock and QuickBooks Desktop support |
| Synder | Transaction-level sync across gateways | From $65/mo (Basic, 500 transactions) (verified) | High-volume sellers on multiple payment gateways who want per-transaction detail |
| Nventory | Order management and inventory control that also pushes accounting | Free entry plan (vendor-stated; confirm current tiers on our QuickBooks integration hub) | Multichannel sellers whose real problem is stock accuracy, not just the journal entry |
A few honest notes on that table. A2X’s listing is explicit that it is a reconciliation and accounting tool, not an inventory system – the A2X Shopify QuickBooks route solves the P&L, not the stockroom. Webgility and Synder both advertise inventory and real-time sync; treat “real-time” as vendor-claimed until you test it against your own order volume. And Intuit’s connector is the only one here whose cost is genuinely $0 at entry, which is precisely why so many sellers start there and outgrow it.
Rating context, all verified on the listings: Intuit 4.6 (3,331 reviews, launched 2015), A2X 5.0 (360, launched 2019), Webgility 4.9 (913, launched 2013), Synder 4.8 (222, launched 2020). Ratings measure satisfaction with bookkeeping outcomes; they say nothing about inventory accuracy.
Why your inventory still drifts after you connect
Your stock drifts after you connect because QuickBooks Online is an accounting ledger that carries an inventory valuation feature, not an inventory system. Quantity and cost live in the books; availability lives in Shopify; nothing reconciles the two by design.
Intuit’s own documentation is clear about the shape of this. QuickBooks Online tracks quantity on hand and inventory value for inventory items, and it calculates cost of goods sold when items are sold, using either FIFO or Moving Average Cost (Intuit). That is a costing engine. It is not lot, serial, bin, or location tracking, and Intuit does not claim otherwise.
Shopify, meanwhile, keeps four distinct states per item and location: available, committed, incoming, and unavailable (Shopify). “Committed” alone – units set aside for unfulfilled orders – has no home in QuickBooks Online.
Put those two models side by side and the drift mechanisms write themselves.
- Timing. Shopify commits stock the moment an order is placed. QuickBooks only moves COGS when the sale lands in the file. Between those two moments, the numbers disagree, and at volume that window is always open.
- Returns and restocks. A restock in Shopify and a credit memo in QuickBooks are different events with different dates. Unless the connector links them, one side gains stock the other never sees.
- Bundles and kits. Shopify decrements components; QuickBooks decrements the item you mapped. If that mapping is the bundle, the components drift permanently.
- Multi-location. Shopify knows which location shipped. QuickBooks Online has no location dimension for items, so any store selling from two warehouses is guessing.
- Negative inventory. Intuit publishes a dedicated guide for fixing negative inventory in QuickBooks Online, which tells you how routine the condition is (Intuit). Most of the time it means a sale was recorded before the related purchase.
- Vendor bills. Buy ten cases, bill four, restock six. Shopify reflects what arrived; the books reflect what was invoiced.
The practical consequence is a QuickBooks inventory sync that looks fine on the sales side and wrong on the asset side. Your balance sheet carries an inventory value that no longer matches the shelf, and your margin reports inherit that error every month.
Verified, not claimed: QuickBooks Online’s costing methods, the inability to change a costing method after items exist, and Shopify’s four inventory states are all documented by the vendors. Claimed, not verified: that any connector keeps quantities “in sync as you sell.” No vendor in this category publishes their stock-mismatch rate.
The honest fix is architectural rather than a setting. Keep one system as the source of truth for physical stock, keep QuickBooks as the source of truth for value, and reconcile at a controlled interval rather than continuously. That is the model behind our order management and inventory layer, and it is the same logic the QuickBooks setup documentation walks through step by step. If you sell on more than one Shopify-adjacent channel, the same reasoning applies to the Shopify–Tally integration and the Shopify–Xero integration, because the underlying mismatch is the accounting model, not the vendor.
The reconciliation errors that cost sellers hours
Most reconciliation pain comes from four repeat offenders, and none of them is a bug in the connector. Each is a modeling decision that was never made explicitly.
Duplicate orders
Duplicates almost always mean two systems created the same transaction: a manual entry or CSV import alongside the live connector, or two connectors pointed at one company file. Historical imports cause the bulk of it, which is why vendor listings advertise duplicate protection on backfills. Fix the cause, not the symptom – deleting duplicates in QuickBooks leaves the connector’s mapping table intact and the next sync re-creates them.
Refund timing
A refund is two events with two dates: the customer refund in Shopify and the credit memo in QuickBooks. If the connector posts the refund against the original order date, your monthly sales and returns no longer match your payout statements, and every period comparison you build afterwards is wrong. This is the single most common cause of “the totals are close but not equal.”
Payment fees
Processing fees are usually synced as a payout-level summary, not per order. That is fine for the ledger and useless for SKU-level margin. If you need per-order profitability, the fee has to be allocated, and very few entry-tier setups do it. Reviewers on Synder’s listing praise exactly this – matching individual sales receipts on the payment capture date and time rather than the order date – which tells you how much of the market is not doing it.
COGS mapping
Cost of goods sold depends on three things being right at once: the item cost in QuickBooks, the quantity that moved, and the costing method. Intuit warns that the costing method cannot be changed after inventory items are created, and that if you create an item before choosing, the file silently defaults to FIFO (Intuit). Choose before you import, or you will be re-keying items later.
Worked properly, the sequence is: map items and costs, choose the costing method, confirm one payout reconciles, then turn on the schedule. Skipping the third step is why the first month is fast and the third month is not.
QuickBooks Online vs Desktop for Shopify sellers
If you are on QuickBooks Desktop, Intuit’s own connector cannot help you – its Shopify App Store listing works with QuickBooks Online, Intuit Enterprise Suite, and their variants, and Desktop does not appear anywhere in that list. A Shopify QuickBooks Desktop integration has to come from a third party.
That single fact decides the question for many sellers, but not for all of them.
| Dimension | QuickBooks Online | QuickBooks Desktop |
|---|---|---|
| Intuit’s own Shopify connector | Yes – free to install | No – not supported by the listing |
| Credible third-party options | A2X, Webgility, Synder, and others | Webgility’s Desktop app, Synder, MyWorks, Dancing Numbers |
| Connection model | Cloud API, no local software | Local company file, usually needs a connector agent running on a machine |
| Inventory depth | Quantity and value per item; FIFO or MAC; no location, lot, or serial | Deeper item and assembly handling, but file-based |
| Typical fit | Most Shopify sellers, especially those working with a remote bookkeeper | Sellers whose accountant has mandated a Desktop file, or who rely on Desktop-only features |
| Practical risk | Sync gaps show up as missing transactions | Sync gaps show up as an offline connector nobody notices for a week |
The Desktop trap is operational, not technical. Desktop integrations depend on a machine being awake, an app being current, and a file being open. When the sync stops, nothing shouts – and sellers usually discover it at quarter-end, when the backlog is expensive.
If your accountant insists on Desktop, plan the integration before you migrate the file, not after. If you have a free choice, QuickBooks Online is the path with a first-party connector and the shallower failure modes.
FAQ
Does Shopify have a free QuickBooks integration?
Yes. Intuit’s app, listed as “Shopify Connector by QuickBooks”, is free to install, and the listing states the connector is included with your QuickBooks subscription – though external charges may be billed by Intuit separately from your Shopify invoice. As of October 2026 it held a 4.6 rating across 3,331 reviews, with 90% of those ratings at five stars.
How long does it take to connect Shopify to QuickBooks?
Budget about 15 minutes of active configuration plus anywhere from an hour to a day for the historical import. In the setup run we documented for this guide, the connection itself was quick and the backfill of roughly 18 months of orders was still running two hours later. Account mapping, not the authorization handshake, is what consumes the time.
Does the QuickBooks Shopify sync include inventory?
Only partly, and almost entirely in one direction. Intuit’s listing advertises that quantities and costs stay “in sync as you sell,” which is vendor-claimed, and QuickBooks Online genuinely stores quantity on hand and inventory value for tracked items. What it does not store is location, lot, serial, or Shopify’s committed-versus-available distinction.
Can I connect Shopify to QuickBooks Desktop?
Not with Intuit’s own connector. Its listing supports QuickBooks Online, Intuit Enterprise Suite, and their variants; Desktop is absent. A Shopify QuickBooks Desktop integration must come from a third party such as Webgility’s Desktop app, Synder, MyWorks, or Dancing Numbers.
How often does QuickBooks sync with Shopify?
It depends entirely on your plan tier, and “real-time” is doing heavy marketing work across the category. Entry plans at several vendors sync daily, mid tiers move to hourly, and only some advertise continuous sync. Confirm the cadence for the tier you are actually buying before promising your bookkeeper same-day numbers.
Is A2X better than the free Shopify Connector by Intuit?
For payout-level reconciliation, usually yes; for a single-channel store under 200 orders a month, often no. A2X’s Shopify App Store listing starts at $29/month for up to 200 orders and carries a 5.0 rating across 360 reviews. The free connector posts sales and fees adequately; A2X exists to make each payout tie out against your bank feed.
What is the best Shopify QuickBooks integration for multichannel sellers?
There is no universal winner, and a confident single answer usually signals a sales page. Webgility (from $79/month, 4.9 across 913 reviews) and Synder (from $65/month, 4.8 across 222 reviews) both market multichannel inventory and multi-gateway detail, while Nventory approaches the same problem from the order and inventory side rather than the ledger side. Match the tool to your channel count and stock complexity, not to the demo.
Why are my Shopify orders duplicated in QuickBooks?
Because two things created the same transaction – a manual entry or import alongside the live connector, or two connectors running against one company file. Vendor listings advertise duplicate protection specifically for historical imports, which is where most of the damage happens. Fix the source; deleting duplicates alone lets the next sync rebuild them.
Does QuickBooks Online track inventory by location?
No, not natively. QuickBooks Online tracks quantity and value per item, and Intuit documents FIFO and Moving Average Cost as the two costing methods, but location, bin, lot, and serial tracking sit outside the product. If your Shopify store fulfills from more than one location, the books will not mirror it without an intermediate system.
What happens to COGS when inventory drifts?
Your gross margin quietly becomes an estimate. QuickBooks Online calculates cost of goods sold from the cost layers on the item, and Intuit notes that the costing method cannot be changed after items are created and that a missing method defaults to FIFO. If quantity was wrong when COGS was calculated, the error carries into every margin report downstream