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.
Found another way around this?
Share your steps and trade-offs so fellow engineers don't have to reinvent the wheel. No account required.
How to delete an entire uploaded file of duplicate transactions?
- 1Spot checking a few days and bulk reclassing the restDid this help you?
- 2Changing the recording workflow to use Undeposited Funds instead of depositing directly to the bankDid this help you?
- 3Exporting transactions with a filter, sorting by amount, and reviewing for missing duplicates using ExcelDid this help you?
- 4Restoring from a backup made prior to the importDid this help you?
- 5Deleting all pending transactions and re-importingDid this help you?
- 6Going through and deleting duplicated transactions one by one manuallyDid this help you?
- 7Bulk excluding the transactions and then deleting them in bulkDid this help you?
- 8Bulk accepting the transactions and creating a journal entry (JE) to reverse themDid this help you?
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
- 8Inherited spreadsheets with white fill instead of hidden gridlines
- 4How to merge duplicate prospect records faster without doing it manually
- 21How to clean up messy CRM data after importing
- 2Why are there two search boxes right on top of each other?
- 5How to quote data cleanup in system migrations
- 34How to clean up months of messy client expense records