How to delete an entire uploaded file of duplicate transactions?
Accounting software lacks a way to batch delete an entire upload once new items mix with original ones under pending. This leaves people unable to simply undo a file, forcing them to spend an unreasonable amount of time manually verifying a full year of duplicate sales receipts and deposits.
What people tried
Every workaround mentioned in the threads below. We haven’t tested any of them — and nobody here is claiming they worked.
- 1Spot checking a few days and bulk reclassing the rest
- 2Changing the recording workflow to use Undeposited Funds instead of depositing directly to the bank
- 3Exporting transactions with a filter, sorting by amount, and reviewing for missing duplicates using Excel
- 4Restoring from a backup made prior to the import
- 5Deleting all pending transactions and re-importing
- 6Going through and deleting duplicated transactions one by one manually
- 7Bulk excluding the transactions and then deleting them in bulk
- 8Bulk accepting the transactions and creating a journal entry (JE) to reverse them
In their words
Unedited, grouped by where they were said, most upvoted first within each place, each linked to the thread it came from.
“I know there is the bulk reclass tool to remove the duplicates but I’m not sure if i should check every single sales receipt and deposit to make sure they all got duplicated as this would take along time or just check a few and then remove the duplicates.”source ↗
“It’s a whole year of deposits. This would take absolutely too long that’s why I’m using the bulk reclass tool”source ↗
“Is there any way to delete my entire upload in bulk? The problem is that now my uploaded transactions are mixed in with his original transactions under Pending, so I can’t just select everything and delete it.”source ↗
“I really wish there were a way to simply undo or delete the file I uploaded. 😩”source ↗
“The long story short is no theres no way to batch delete transactions.”source ↗
Where this came up
People with this problem also raised
- 4Inherited spreadsheets with white fill instead of hidden gridlines
- 18How to clean up messy CRM data after importing
- 2Why are there two search boxes right on top of each other?
- 21How to clean up months of messy client expense records
- 2Kitten kicking litter out of the box and making a mess
- 5How do you do account reconciliation when departments are split up?