QuickBooks Online
Duplicate Shopify sales receipts in QuickBooks
Sales are suddenly double, or the same order number appears two or three times. It usually starts on a specific day: a resync, an app update or a new connector. Here's how to find every duplicate and remove the extras safely.
Why orders get posted twice
- A resync or import. Re-running a date range, or asking support to import sales after a sync stopped, can re-post orders that were already there. Some merchants have found every order doubled or tripled this way.
- Two connectors running at once. When you switch connectors, or the old app is replaced by a new version, both can post the same orders for a while. A new connector's start date set before the switch does the same.
- An app update that changes how orders are posted: for example from invoices to sales receipts, so the new type doesn't see the old one and posts again.
- The order entered twice on one document: one sales receipt at exactly twice the order total.
- Inventory or customers duplicated during setup, which makes reports look doubled even when transactions aren't.
Check by hand
1. Spot the day it started
In QuickBooks Online, go to Reports → Standard reports and search for Transaction List by Date. Set last month, then use Customize to filter Transaction Type to the type your connector posts (Sales Receipt or Invoice). Compare the count per day with Shopify's paid orders per day. Duplicates usually start on one date.
2. List every duplicate
- Export the report: Export/Print → Export to Excel.
- Sort by the Num column (or Memo, if your connector puts the order number there).
- In an empty column, enter
=COUNTIF(C:C,C2), where column C holds the order number, and fill down. Anything above 1 is posted more than once. - Look for doubled totals too: a sales receipt for exactly twice the Shopify order total is one order entered twice on one document.
3. See which connector created each copy
Open Settings (gear icon) → Audit log (you need admin access) and filter by date. The audit log shows which user or app created each transaction and when. This tells you whether two connectors are both posting.
Fix it
- Stop the source first. Disconnect or switch off the connector you're no longer using, or correct the new connector's start date. Otherwise duplicates keep arriving.
- Decide which copy to keep. Keep the one that's matched to the bank deposit (in a bank deposit, or matched in the bank feed). Deleting the matched copy unmatches the deposit.
- Remove the others. Go to All apps → Sales & Get Paid → Sales transactions, find the extra copy and choose Void or Delete from its actions dropdown (or open it and use More at the bottom). Void keeps a zero-value record with its number; Delete removes it. Ask your accountant which one they prefer, especially for a closed period.
- Fix doubled lines by editing the sales receipt so it totals the Shopify order amount.
- Re-check the sales tax for the period, because duplicated sales usually double the tax liability too.
QuickBooks Online has no bulk delete for sales receipts. If there are hundreds, ask your connector's support whether they can remove the copies their app created before you delete them one by one.