Your bookkeeper sends the month-end note: sales in QuickBooks are short, and nobody knows which orders are missing. The connector said it was working. Shopify says the orders were paid. Somewhere between the two, a week of sales went quiet.
Shopify orders usually stop reaching QuickBooks Online at one of four points: they arrived but sit unconfirmed in the For Review tab, a product didn't match a QuickBooks item, the date falls in a period your books have closed, or the connection dropped and needs reauthorizing. Each leaves a sign you can check in under an hour.
What is this costing you?
Use your own numbers. For last month, note:
- how many hours your bookkeeper spent finding and re-entering missing orders;
- how many days late the month closed because sales didn't tie;
- whether anyone paid sales tax, made a stock decision or quoted a lender from figures that later changed.
The last one is the expensive kind. A missing week of sales is an hour of re-keying if you catch it in the same week, and a reopened period and a nervous conversation if you catch it after the numbers have gone to someone else.
Why does the sync keep breaking?
First, know which kind of connector you have, because they fail in different places.
- Intuit's own app, Shopify Connector by QuickBooks, imports individual sales, individual refunds and payouts. Intuit describes a payout as disbursements "typically covering sales over a 1 day period." Wholesale (B2B) orders come in as invoices.
- Third-party connectors work differently. A2X creates one summary entry per Shopify payout. Synder lets you choose a daily summary or one entry per transaction.
Then look at the usual breaks.
Orders arrived, but nobody confirmed them
With Intuit's connector, imported transactions land in a For Review tab. Intuit's help is clear that they "don't appear on your reports or financial statements" until someone confirms them. A transaction marked Review is missing something, such as the customer or product, and needs a person to fill it in. Busy months fill this tab fast.
A product didn't match
Intuit's connector "attempts to match products by SKU & names with existing ones in QuickBooks Online." If it finds no match, "the product isn't automatically added; you will need to manually create in QuickBooks Online." New products, renamed products and changed SKUs (stock-keeping units) are the usual culprits. Third-party tools report the same problem in their own words: Synder's error list includes "No matching product found in accounting."
The books are closed for that date
Most bookkeepers lock last month once it's reconciled. An order dated inside a locked period can't be posted without someone overriding the lock. Synder lists the error as "Accounting period is closed", with the fix "Reopen period, then retry sync", which is a decision for your accountant, not a default.
The connection dropped
Connections lapse when a password changes, the person who connected the app loses access, or the authorization expires. Synder's guide says to re-authorize the connection and then manually sync any transactions from the disconnection period. QuickBooks shows a red warning icon next to an integration it can't talk to.
Tax, discounts, shipping and gift cards
When a QuickBooks setting for discounts, shipping or automated sales tax is turned off, Intuit's connector falls back to catch-all items such as the "Shopify Discount Item" and "Shopify Sales Tax Item." Orders still arrive, but not where your bookkeeper expects. Gift cards are another source of gaps: Shopify notes that selling a gift card "isn't counted as a sale because it's a liability," so gift card activity shows up differently on each side.
Two tools posting the same sales
If an old connector is still switched on alongside a new one, or someone keys in orders by hand as well, sales arrive twice. Connectors catch some of this (Synder's error list includes "Duplicate transaction detected"), but not when the second copy came from a different tool or a person.
How do you fix it yourself?
- Find the gap first. In Shopify, go to Orders > Export, choose Orders by date, set the month and export. The file is emailed to you and the store owner. For totals, go to Analytics > Reports and open the Total sales breakdown finance report, which Shopify says "includes the values that you'll most likely need when doing your bookkeeping." Compare that with what QuickBooks shows for the same dates.
- Check the connection. In QuickBooks Online, go to Integrations > Manage integrations. You need to be an admin or have Third Party Apps permission. A red warning icon means QuickBooks can't reach the app; Intuit's page points to an option to reconnect, which may mean signing in to Shopify and authorizing again.
- Re-import the gap. After reconnecting, bring in the missing dates. Intuit's connector can import transactions from up to one year back. Third-party tools usually need you to sync the disconnected period by hand.
- Clear For Review. Open the connector's transactions and work through the For Review tab. Fill in anything marked Review, then confirm.
- Create missing products. For each unmatched product, create the item in QuickBooks with the same SKU and name as in Shopify, then re-run the affected transactions.
- Check the closing date, with your bookkeeper. Go to Settings > Account and settings, open the Advanced tab and look at Close the books in the Accounting section. Don't reopen a closed period on your own: whether to post into it, or post the late sales into the current month, is your accountant's call.
- Switch off duplicates. Make sure only one tool is posting Shopify sales, and stop any manual re-keying the connector now covers.
When does doing it yourself stop working?
The steps above fix a broken month. They stop working when:
- the same break comes back every few weeks, because new products, staff changes or tax settings keep outrunning the connector;
- you sell on more than one channel, and each has its own connector and its own failure points;
- the For Review tab grows faster than anyone can confirm it;
- nobody notices the sync has stopped until the bookkeeper does, weeks later.
The last one is the real problem. A sync you have to check by hand at month-end is still a manual job, just a hidden one.
What are your options?
| Option | Good when | Watch for |
|---|---|---|
| Do it yourself | Low order volume, one channel, and a monthly check you actually do | Breaks found weeks late; the fix depends on one person remembering |
| Buy a connector | You want a summary per payout or per day, or more control than Intuit's app gives | Mapping still has to be set up right, and two connectors running at once post sales twice |
| Hire a freelancer | A defined repair, such as remapping tax or cleaning up items | The repair holds until the next product launch or settings change |
| An outside team that learns how you work and builds on your data | The breaks keep returning and you want them caught the day they happen | Needs your bookkeeper's time early on to agree what "matching" means |
What can you hand off, and what should stay with your team?
You can hand off the plumbing: finding every missing order, fixing product and tax mapping, reconnecting and re-importing gaps, and adding a daily check that compares Shopify's orders with what reached QuickBooks and tells someone the same day when they don't match. That is the kind of job Fixes & connections covers, in your own accounts, with notes on what changed and how to undo it.
Keep the accounting decisions with your bookkeeper or accountant: whether sales post as one entry per order or a daily summary, how gift cards and refunds are recorded, and whether a closed period is ever reopened. Those are judgment calls about your books, not settings.
Questions to ask anyone you hire, us included
- Which tool will post Shopify sales when you're done, and how will you make sure no other tool posts them too?
- How will we know within a day if the sync stops?
- Will you test changes on a copy or a past month before they touch the live books?
- How do I undo a change if the numbers look wrong?
- Will you work with our bookkeeper on how sales should be recorded, or decide it yourself?
- What access do you need, and when will you remove it?
Whoever you hire, show them last month's gap on screen rather than describing it. That is how a walk-through works, and it gets to the real break faster.
Frequently asked questions
How far back can Intuit's Shopify connector import?
Intuit says you can import transactions from up to one year ago. The first import can take between 10 minutes and 3 hours, depending on volume.
Should each Shopify order be its own entry in QuickBooks?
It depends on volume and how your accountant wants the books kept. Intuit's connector imports individual sales; A2X posts a summary per payout; Synder offers both. Ask your accountant before you switch.
Why don't my QuickBooks sales match Shopify's orders total?
Common reasons are unconfirmed transactions in For Review, gift cards (a liability, not a sale), refunds dated in a different month, and orders dated in a closed period. Compare against Shopify's Total sales breakdown rather than the orders list.
Who do I call when the sync fails?
Intuit's own advice is to contact the integration provider for any data sync issue. For Intuit's connector, that is QuickBooks support; for a third-party app, its support team.