Account Disaster: 4000 duplicate transactions
I have managed to mess up one of my bank accounts in Quicken 2016. I had some notion of correcting an old bank account that had lost all of its data prior to 2011. So I exported the old data from an old backup and imported it from a QIF file. This left me with 4107 transactions to accept into the register.
I then decided that this was crazy and wanted to bail on the entire import. Unfortunately I could not get rid of the QIF file transactions waiting to be accepted. I searched here and found a work-around someone described which entailed accepting the transactions, sorting by date uploaded, and then deleting all the newly entered transactions. The problem, I discovered, was that there was no way to sort the transactions by date uploaded. As such, all the accepted transactions are duplicated next to the original transactions. The only way I can think to remove them is to manually delete 4107 duplicate transactions that start in 2001.
So this account is truly messed up and I'm trying to figure out the best way to fix it. Advice would be appreciated.