Books Watchdog

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.

Updated 11 November 2026

Why orders get posted twice

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

  1. Export the report: Export/Print → Export to Excel.
  2. Sort by the Num column (or Memo, if your connector puts the order number there).
  3. 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.
  4. 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

  1. 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.
  2. 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.
  3. 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.
  4. Fix doubled lines by editing the sales receipt so it totals the Shopify order amount.
  5. 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.