Compare the source
Use the bank statement, receipt, invoice, or processor payout report to confirm whether one or two real events occurred.
Duplicate transaction guide
Duplicate transactions in QuickBooks? Don’t delete blindly.
Quick answer
Duplicates often appear when a bank-feed item is added after the same transaction was entered manually, when an import is repeated, or when processor deposits are recorded twice. Confirm the date, amount, account, payee, and reconciliation status before deleting or excluding anything.
Find duplicates in your own file, free
Drop in a CSV export from your bank or QuickBooks. It runs in your browser, so the file never leaves your computer and nothing is uploaded to us. No account, no card.
Drop a CSV here, or click to choose oneNothing is uploaded. The scan happens on this page.
This flags likely duplicates for you to review. It doesn't change anything in QuickBooks, and TrainedBooks is software, not a CPA firm.
Signs to look for
- Two entries share the same amount and nearly the same date
- A manual check or expense sits beside a bank-feed addition
- Revenue appears once as a sale and again as a processor deposit
- A previously reconciled month changes after an import
What to do next
Check links
Look for matches to bills, invoices, transfers, deposits, and reconciliations before removing an entry.
Document the decision
Keep a short record of what was changed and why, especially when the affected month was previously closed.
Where TrainedBooks fits
TrainedBooks can flag possible duplicate activity in imported QuickBooks Purchases and Deposits. You review the findings; the read-only connection does not delete or change QuickBooks records.
The current QuickBooks Online integration imports Purchases and Deposits for analysis. It does not write transactions back, move money, file taxes, or replace a licensed professional.
Frequently asked questions
Can two transactions with the same amount both be legitimate?
Yes. Recurring subscriptions, split payments, payroll, and repeated customer payments can share an amount. Date and amount are clues, not proof.
Should I delete or void a duplicate?
That depends on how it was created and whether it is linked or reconciled. If the period affects a filing or you are unsure, ask an accountant before changing it.
Will TrainedBooks automatically delete duplicates?
No. It flags possible duplicate activity for review and does not write changes back to QuickBooks Online.