Help for owners
My integration created the same invoices twice in QuickBooks
Short answer
Duplicates appear when a sync sends a record, gets no answer, and sends it again, or when the same event is delivered twice. The fix is to make each send safe to repeat, using a unique reference. Do not delete the extras yet: first list which copy is linked to a payment.
Does this sound like your situation?
- Some invoices or sales receipts appear twice with the same amount and customer.
- The doubles appeared after an outage, a slow day or a reconnect.
- Income in QuickBooks is higher than what the shop or app reports.
- My bookkeeper cannot tell which copy is the real one.
- Fixing it by hand brings the duplicates back at the next sync.
Why does this happen?
A send timed out and was repeated
If QuickBooks created the invoice but the answer never came back, a sync that only knows it got no reply sends it again. Payment services solve this with a unique key on each request: Stripe documents that retrying with the same idempotency key returns the saved result instead of repeating the operation. A sync with nothing like that can double every record that times out.
Confirmed by docs.stripe.com
The same event is delivered twice
Shopify's guidance tells apps to ignore duplicate deliveries using the webhook ID. An integration that does not check it creates a second invoice when the same order event arrives again.
Confirmed by shopify.dev
Two syncs run at once
A test copy, a second server, or an old connector left switched on can each send every order. The result is neat pairs of identical invoices.
A manual entry and the sync both record the sale
Entering missing sales by hand while the repaired sync later sends them as well is a common source after an outage.
Old records are re-sent after a repair
A re-sync that cannot tell what was already sent will send the whole period again, including records that were fine.
What can I do about it today?
- Stop adding to the problemAsk your developer to pause the sync, or at least confirm that only one copy of it is running.
- Do not delete anything yetOne copy of each pair may already have a payment, a credit or a tax filing attached. Deleting the wrong one can break reports.
- Make a list of the doublesInvoice or order number, amount, customer and date for each pair. Mark the first date a double appears.
- Note what happened that dayAn outage, a reconnect, a software update or someone entering sales by hand.
- Ask your bookkeeper which copies carry paymentsThat decides which one stays. A careful clean-up works from that list, not from the amounts alone.
When should I bring someone in?
- The duplicates affect a month that is already filed or about to be.
- They keep coming back after you clean them.
- Payments or credit notes are attached to both copies.
How do I handle it?
- Find how they were createdI read the vendor's current documentation first, and every change is tried on test data before it touches your real books. I trace pairs back to the sync log to see whether they came from a retry, a repeated event, two running copies or a manual entry.
- Add a unique reference to every recordEach send carries the order number or a generated key and checks for it first, so a repeat finds the existing record instead of making a new one.
- Clean up from your bookkeeper's listExtras are voided or removed only where nothing is attached, after a backup of the affected records.
- Reconcile both waysA count and total comparison of the source system and QuickBooks confirms the books agree before the sync is switched on again.
The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.
What do owners ask about this?
Can I merge the duplicate invoices?
Invoices are usually voided or deleted rather than merged, and the right copy depends on what is attached to it. Decide that with your bookkeeper first.
Why did it only happen once?
Duplicates often come from a single bad hour, such as a slow response or a reconnect. A one-off event can still be repeated by the next retry, so the cause needs fixing even if it has stopped.
Does this mean my accounting is wrong?
Until the extras are removed, income and balances can be overstated. That is why the list and the clean-up matter before reports are used.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.