QuickBooks Shopify Integration Not Working? Every Fix

Six failure classes cover nearly every break. Find yours in five minutes, then apply the fix — and learn which one fix never holds.

---

The last order in QuickBooks is from Tuesday. It's Friday. You didn't change anything, nobody touched anything, and yet your QuickBooks Shopify integration is not working — again — three days before you need clean numbers for a sales tax filing.

If this feels familiar, it probably is. Most people who land on this page have already reconnected the integration once before, watched it work for a few weeks, and assumed the problem was solved. Then it broke a different way — which is exactly why the last fix didn't hold.

Two things before the fixes. First, a disclosure: we make a competing paid sync tool, so our bias exists. Product talk stays out of the troubleshooting entirely — it appears once, clearly labeled, at the very end. Second, a reframe: the lie that keeps people stuck on this page is "I must have set it up wrong." You almost certainly didn't. Sync breakage isn't one problem with one fix — it's six distinct failure classes, each with its own symptoms, cause, and repair. Diagnose first, then fix.

The Five-Minute Triage: Auth, Data, or Config?

Every sync failure answers one of three questions. Answer them in order to find your section.

1. Is anything syncing at all? Find the most recent transaction the connector created in QuickBooks. If everything stopped on a specific date, you have a connection problem — lost authorization (Class 1), or a Shopify-side change that broke it (Class 6).

2. Is data arriving, but incomplete or late? Missing orders, or everything showing up a day later than you expect: a data-flow problem (Class 2).

3. Is data arriving, but wrong? Revenue looks doubled, fees are invisible, or income lands in strange accounts: a configuration problem (Classes 3, 4, and 5).

Symptom	Likely class
Nothing has synced since a specific date	1 — Authorization expired
Stopped right after you changed apps, themes, or plans	6 — App/theme change
Some orders missing, or arriving late	2 — Missing or delayed orders
Revenue looks roughly doubled	3 — Duplicates
Income matches deposits, but no fee expenses anywhere	4 — Fees lumped into deposits
Sales landing in "Uncategorized Income" or odd accounts	5 — Mapping drift

Jump to your class. Each one gives you the symptoms, the actual cause, and fix steps you can run yourself.

Class 1: The Connection Dropped (Auth Expiry)

Symptoms: the sync stopped completely on a specific date. Nothing failed loudly — orders just stopped appearing. The connector's settings may show the store disconnected or ask you to reauthorize.

Why it happens: the integration runs on an authorization token granted when you first connect. Tokens get revoked more often than anyone expects: a password change, a staff account deactivated, a permissions change, a routine security event on either side. The person who originally connected the integration leaving your team is the classic silent killer — their credentials go, and the connection goes with them.

The fix:

1. Reauthorize in the connector's settings. Disconnect and reconnect the store, approving all requested permissions.
2. Use the right account. Reconnect as the store owner or company admin — not a staff login that might be deactivated later. This one habit prevents most repeat auth failures.
3. Check your email filters. Most connectors send a disconnect notice. If it went to spam, you lost days of syncing without knowing. Whitelist the sender.
4. Backfill the gap. Reconnecting does not always re-sync the disconnected window. Note the break date and the reconnect date, then check whether those orders came through — if not, the Class 2 fixes cover recovering them.

Prevention: dedicate an admin account to the integration, and put a monthly two-minute check on your calendar: does the newest order in QuickBooks match the newest in Shopify?

Class 2: Orders Missing or Delayed

Symptoms: totals don't tie to your Shopify reports. Specific orders are absent, or everything shows up a day or more after the sale.

Why it happens: three separate causes hide under this one symptom.

• Sync frequency. Many connectors sync on a schedule — daily batches rather than real time. A "delay" may just be the schedule working as designed.
• Scope. Connectors often sync a subset of order types by design. POS sales, draft orders, or orders from additional sales channels may be excluded.
• Boundaries. A sync that started mid-month usually doesn't reach backward, and a timezone mismatch between Shopify and your QuickBooks company file can push orders near midnight into the wrong day.

The fix:

1. Check the sync schedule in the connector's settings and confirm the delay isn't just the configured cadence. Trigger a manual sync if the option exists.
2. Find the pattern in the missing orders. Pull five of them up in Shopify. Same channel? Same date range? Same payment method? A pattern means a scope limit, not a malfunction.
3. If it's a scope limit, record the excluded orders another way — typically a monthly journal entry for that channel's totals — and accept that the connector won't carry them.
4. If it's a gap window (from an auth drop or a mid-month start), look for a historical import or date-range re-sync option in the connector's settings. No option means the gap gets entered manually, once.
5. Align timezones between your Shopify store settings and QuickBooks so day-boundary orders land in the right period.

Class 3: Duplicate Transactions (Bank Feed + Connector Overlap)

Symptoms: revenue in QuickBooks is roughly double what you actually sold. Orders or payouts appear twice. Your P&L looks fantastic and completely wrong.

Why it happens: this is the most common configuration failure, and it isn't a bug in anything. The connector records your Shopify sales in QuickBooks. Then your bank feed imports the Shopify payout deposit — the same money — and if you click Add instead of Match, QuickBooks creates a second income entry on top of the first. Every Add doubles a payout.

The fix:

1. Change the habit first: from today, never Add a Shopify payout from the bank feed. Always Match it to the transaction the connector already created. Add creates income; Match confirms income that already exists.
2. Clean up the existing duplicates. Find deposits that were Added where the connector had already recorded the sales; undo or exclude them, then Match properly. Work month by month, recent first.
3. Check for a second syncer. Two connectors running at once — an old app you never uninstalled plus a new one — or the same date range imported twice will also duplicate. One tool, one source of truth.
4. Verify with one payout. Trace a single recent payout: one set of sales entries, one deposit, matched together. If that chain is clean, your cleanup worked.

Class 4: Fees Lumped Into Deposits

Symptoms: income in QuickBooks matches your bank deposits almost exactly — which sounds good until you notice it's lower than what Shopify says you sold, and no Shopify fee expense exists anywhere in your P&L.

Why it happens: Shopify pays you net — sales minus refunds minus processing fees, as one lump deposit. If the integration records that lump as income, the fees vanish into it: net deposits booked as gross revenue, which misstates both income and expenses and can distort the sales figure your tax filings build on. The full anatomy of that gap is in Shopify fees in QuickBooks.

The fix:

1. Look for fee-handling options in the connector's settings. If the connector can break payouts into sales, refunds, and fees, turn that on and map the fee line to a "Merchant Processing Fees" expense account.
2. If it can't, gross up manually. Once a month, pull Shopify's payout report, total the fees, and post a journal entry: increase sales by the fee amount, book the same amount to fee expense. Net income doesn't change — but revenue and expenses both become true.
3. Fix the history that matters. At minimum, correct the current tax year the same way, one entry per month.

An honest flag: if step 1 came up empty, that's not a misconfiguration — it's a ceiling. Hold that thought for the section after the fixes.

Class 5: Wrong Accounts and Mapping Drift

Symptoms: sales appearing in "Uncategorized Income." A new payment method's revenue landing somewhere strange. Books that were accurate at setup and have gotten slowly wronger since.

Why it happens: mapping — which Shopify money goes to which QuickBooks account — gets configured once, at install, against the store you had then. Stores drift: a new payment gateway, gift cards, a new sales channel, a renamed account in your chart of accounts. Anything the mapping doesn't recognize falls into the connector's default account, and defaults are where accuracy dies quietly.

The fix:

1. Open the mapping section in the connector's settings and walk every line: each Shopify money category — sales, refunds, fees, taxes, gateways — against the QuickBooks account it posts to.
2. Hunt the catch-alls. Anything routed to a generic default or "Uncategorized" account is unmapped drift. Assign it a real account.
3. Reclassify the strays. With the map fixed, find historical transactions in the wrong accounts and move them — QuickBooks' reclassify tooling or your bookkeeper can batch this.
4. Review the map quarterly, and add a launch-checklist step: new gateway, channel, or product type means checking the map that week.

Class 6: Sync Stopped After an App or Theme Change

Symptoms: the break correlates with a change — you installed or removed a Shopify app, switched themes, changed Shopify plans, or added a checkout or order-editing app.

Why it happens: Shopify apps can share permissions, alter order data, or change how orders are created. Uninstalling one app can revoke access another depended on. Order-editing and upsell apps can produce order shapes the connector doesn't expect and silently fails on.

The fix:

1. Build the timeline. Match the date syncing stopped against your change log — Shopify keeps a store activity record, and your app install history is in the admin.
2. Reconnect first. A permissions disturbance looks exactly like Class 1, and the Class 1 fix — full reauthorization with an admin account — resolves most of these.
3. Test with one order. If orders touched by one specific app fail while others sync, you've isolated it.
4. Escalate with specifics. Contact the connector's support and the app's support with the break date, example order numbers, and the timeline. Specific evidence turns a two-week ticket into a two-day one.

When Your QuickBooks Shopify Integration Is Not Working by Design

Now the honest part. Look at the class you just fixed and ask: was that a you problem or a tool problem?

You-problems get fixed once and stay fixed. The Add-vs-Match habit. The mapping review nobody scheduled. The integration connected under an ex-employee's login. Disconnect emails going to spam. None of these recur if you adopt the prevention steps — and no tool, at any price, fixes them for you.

Tool-ceilings come back no matter what you do. Fees that can't be broken out of deposits per payout. Order types or channels the connector doesn't carry, ever. Sync cadence you can't change. No way to backfill a gap without manual entry. If your "fix" turned into a monthly ritual — a recurring journal entry, a recurring cleanup, a recurring manual import — you didn't fix the integration. You became part of it.

Neither verdict is an insult. A free or entry-level connector doing exactly what it was built for, at your volume, is a perfectly good answer — plenty of stores should fix the habit, keep the tool, and stop reading here. The distinction matters because the two verdicts have opposite next steps: one is a calendar reminder, the other is a migration.

If This Is Your Third Time on This Page

If you've bookmarked this post, the bookmark is the tell. Troubleshooting a sync once is maintenance. Troubleshooting it every month is a subscription paid in Sunday nights.

If you're there, three reads, in order:

• QuickBooks Shopify Connector Review — what the free connector does well and precisely where it stops, so you can name your ceiling instead of guessing.
• Outgrowing the Free QuickBooks Connector — how to migrate to a heavier sync tool without re-doing your history.
• Best Shopify Accounting Software — the full field of what you'd migrate to, including the tools that beat ours on specific jobs.

And the disclosure from the top, cashed in: we make LedgerPort, a paid Shopify and WooCommerce → QuickBooks sync built around the ceilings in this post — payout journals with fees broken out per deposit, mapping you control, and sync gaps you can see and repair instead of discover at tax time. The free plan covers 30 orders a month — enough to run one real payout through and check whether Class 4 disappears from your life. If it doesn't, you've lost five minutes, and you already triaged faster than that today.