How to Delete Duplicate Transactions in QuickBooks Online Easily 2026
By Impran M N
Duplicate expenses or twin deposits throw off your reconciliation fast, and QuickBooks Online handles cleanup a little differently depending on whether the duplicate is already recorded or still sitting in your review queue. This guide covers both scenarios.
01Open your bank transactions
Go to Transactions, then Bank Transactions, and select the account with the duplicate entries.
02Undo already-categorized duplicates
In the Categorized tab, check the boxes next to duplicate rows and click Undo to roll them back into the For Review queue.
03Exclude duplicates from the review queue
In the For Review tab, check the duplicate rows and click the Exclude command from the top action bar.
04Go to the Excluded tab
Navigate to the Excluded tab to see all the transactions you've flagged for removal.
05Delete permanently
Check the master checkbox at the top of the column, then click Delete to wipe the duplicates so they never affect reconciliation again.
Frequently asked questions
What's the difference between excluding and deleting a transaction?
Excluding removes it from your active balance calculations while keeping a record, but deleting from the Excluded tab wipes it permanently.
How do I fix a duplicate that's already been categorized?
Use Undo in the Categorized tab first to send it back to For Review, then exclude and delete it from there.
Will excluding a transaction affect my account balance?
Excluded transactions don't count toward your live balance, which is exactly why they need to move there before deletion.
How do I stop duplicates from happening again?
Review your active automation rule parameters, since overly broad matching rules are a common cause of systematic duplicate entries.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.



