How to Find and Fix Duplicate Transactions in QuickBooks (Before You Close the Year)
Duplicates inflate income or expenses, throw off the bank balance and make reconciliation impossible. Before you close the year, it’s worth an hour to find and remove them. The key is understanding where each copy came from, because the fix depends on it.
Where duplicates come from
- Entered by hand and downloaded by the bank feed. You record a check or a customer payment, then the same transaction arrives from the bank and gets added instead of matched.
- An overlapping file import. A CSV uploaded for dates the bank feed (or an earlier file) already covered. CSV files carry no transaction IDs, so QuickBooks can’t tell they’re the same.
- The same account connected twice. For example after a bank changes its connection, a card issuer is taken over, or a reconnect creates a second account. Both feeds download the same transactions, often a day apart.
- Payments recorded twice through two paths. An app sync (Jobber, Shopify, Stripe…) records the invoice payment, and the bank deposit is then matched to the invoice again instead of to that payment.
- A reconnect that re-downloads. Reconnecting with a start date earlier than the last downloaded transaction.
How to find them
QuickBooks Online
- Open the account register (Chart of accounts → View register) and sort by amount. Duplicates sit next to each other with the same amount and close dates.
- In Banking → For review, read the suggestion on each line: “1 match found” means QuickBooks thinks you already have it. Don’t add those lines.
- For a period, run Transaction Detail by Account for the bank account and sort by amount, or export it to Excel and highlight repeated amounts.
QuickBooks Desktop
- Open the register from the Chart of Accounts and sort by amount, or use Edit → Find with the amount.
- In the Bank Feeds Center, check which items were added versus matched.
Compare with the bank’s own file. Export the month from your bank as .qbo/.qfx and open it as a spreadsheet with QBO to Excel. Any transaction that appears once in the bank file but twice in QuickBooks is a duplicate.
How to fix them safely
First check whether either copy is reconciled. Deleting a transaction from an already-reconciled month changes that month’s beginning balance and breaks the next reconciliation. If the duplicate is in a reconciled period, fix it with your accountant or plan to re-reconcile that month.
QuickBooks Online
- Still in For review: select the duplicate lines and choose Exclude (batch actions work too). Excluded items stay in the Excluded tab and can be restored.
- Added from the bank feed: go to Banking → Categorized (called Reviewed in newer layouts), find the item and click Undo. It goes back to For review, where you Match it to the hand-entered transaction or exclude it.
- Entered by hand twice: open the extra transaction from the register and Delete it.
- Duplicate payments on an invoice: open the invoice, check its payment history and delete the payment that was not part of a real deposit.
QuickBooks Desktop
- Delete or void the extra transaction from the register (right-click → Delete).
- If a downloaded item was added instead of matched, delete the added copy and keep the one you entered (or the other way around, but keep exactly one).
- Accountant editions have Batch Delete/Void Transactions for larger clean-ups. Back up the company file first.
Same account connected twice: keep one connection. Before disconnecting the old one, check whether disconnecting would remove its downloaded history (some products remove downloaded transactions when you disconnect). If so, exclude the duplicates from the new feed instead.
How to stop them coming back
- One connection per account. If you see two bank accounts with the same last four digits, merge or disconnect one.
- Match, don’t add, whenever the bank feed finds an existing transaction.
- Never import overlapping dates. Start every file the day after the last transaction QuickBooks has. When you reconnect a feed, choose a start date after your last import.
- Prefer .qbo over CSV for imports. Web Connect files carry a unique ID per transaction, which QuickBooks uses to recognise ones it already downloaded. Convert a bank CSV with CSV to QBO or a Quicken file with QFX to QBO.
- Reconcile monthly. A duplicate shows up as a difference the same month, not a year later.
Related
- Missing bank transactions in QuickBooks: import last year’s gaps
- How to reconcile bank accounts in QuickBooks (year-end checklist)
- How to import bank and credit card transactions into QuickBooks
- Stripe and Shopify to QuickBooks: avoiding double-counted payouts