How to Find Duplicate Transactions in QuickBooks Online
Published October 1, 2026 · LedgerMedic
QuickBooks Online does not give you a single report that lists every duplicate. You find them by sorting standard transaction reports so the copies sit next to each other. The method below takes about an hour on a small file and covers payments, sales receipts and deposits. It is slow but it works.
Find them by hand
- Pick a window. Start with the last 12 months, or the period you are about to reconcile or file taxes for.
- Payments. Run Reports > Transaction List by Customer (or Transaction List by Date), filter Transaction Type to Payment, then export to Excel or Google Sheets. Sort by customer, then amount, then date. Highlight rows where customer and amount match and dates are within three days.
- Sales receipts. Repeat with Transaction Type set to Sales Receipt. Same sort. Same highlight rule.
- Deposits. Open the bank register for each bank account and sort by amount. Two deposits into the same account for the same amount on the same day deserve a look. Open both: one built from itemised customer payments and one lump sum with no source is the classic bank-feed duplicate (see duplicate deposit in QuickBooks Online).
- Money posted straight to the bank. Look in the bank register for income that was entered directly instead of going through Undeposited Funds, with a matching payment or receipt elsewhere. That pair can hide a duplicate on the bank side.
- Verify every candidate. For each highlighted pair, match to the bank statement and to the invoice or sale it settles. Only void or delete after one copy has no real-world counterpart.
- Record what you changed. Keep a list of transaction numbers, dates and amounts you voided, for your accountant.
Where this method falls short
It misses duplicates where the amounts differ by a few cents, it takes real time on a file with thousands of lines, and it needs repeating every month. It also produces false positives: legitimate repeat sales and recurring payments look identical to duplicates until you check them.
Once you have a list, the removal steps depend on the type: a customer payment recorded twice, a duplicate sales receipt, or a duplicate deposit.
The faster way
LedgerMedic's free scan gives you the number. It checks payments, sales receipts and deposits in a connected QuickBooks Online company for likely duplicates and tells you how many pairs it found, with both sides shown together. Fixing is guided: you confirm each void, and you can mark any pair as not a duplicate. Scanning is free with no limit and no credit card; every account gets a lifetime allowance of free guided fixes, then fixes need Pro. Run the free scan.