How do I restore/replace two damaged banking accounts
Quicken Deluxe Version R52.20 Build 27.1.52.20 running on Win 11. Two banking accounts have many double entries since my 1 Aug 23 backup. Easiest for me might be to delete both accounts and restore them from the undamaged backup. Is this possible?
Best Answers
-
Is it possible to delete the two messed up accounts, reestablish them, restore those two accounts from the most recent clean backup, and then bring them up to current status? Bearing in mind that both accounts are credit cards and tied to checking accounts for monthly transfer payments? Can accounts be imported/restored without dragging the whole file along?
0 -
you might look at the process of -
Backup your current Quicken QDF file
Restore the old file - with the 2 good accounts
File —> Export to QIF each of those 2 good accounts - individually
Go back and Restore your current QDF data file -
Delete those 2 bad accounts - establish 2 new accounts
Import QIF into those 2 new accounts - individually
then Update those accounts with current transactions from One Step Update
handle any dups -1
Answers
-
might be easier to just delete the dup entries, if everything else is good
0 -
That's what I started doing — and gave up after half an hour, when I saw that the doubled entries numbered in the hundreds.
0 -
If you don't feel like deleting the duplicate entries (sort your register by the "Clr" column and they might be easy to locate by looking at their "Clr" column status, uncleared or cleared vs reconciled)
you're probably better off restoring a backup of your data file taken before the problem first occurred and then downloading any missing transactions and making other changes again, as needed, to bring your data file up to date.There is no process to pick and choose only certain transactions from one data file and correctly inserting them into another one without causing more problems while doing so … at least, none that I'm aware of.
0 -
The duplication appears to be of all transactions in both accounts, sometimes singly, sometimes in pairs, sometimes clusters of 3. I'm leery of the validate and repair option, though I can do it to a copy of the file and see what happens, without further screwing up the original file?
0 -
Validate doesn't fix duplicate transactions. It's not programmed to recognize that situation.
But if you can sort your register by the "Clr" column, freshly downloaded duplicates which are not reconciled will sort together into a group. This group of transactions can easily be selected (just like group-selecting files in Windows File Manager) and then deleted in one bunch. Be sure not to include valid, new, non-duplicate transactions in this process.0 -
Understood, and apologies for not clarifying that the duplication is of all transactions, uncleared, cleared and reconciled. I have no reason to think the problem is related to new downloads. Thanks for ruling out validation as a possibility.
0 -
Try sorting by Order Entered. With any luck, the new duplicates will sort to the bottom, where they can be deleted as a group.
Quicken user since version 2 for DOS, now using QWin Premier (US) on Win10 Pro.
1 -
Good idea — but duplication includes the entry date. Suddenly, there are two of everything, one on one, two on two, or three on three. Go figure. Please!
0 -
wow - since there is no easy way of "sorting" out the dups by the usual transaction attributes…..
this is a bigger mess than usual - and a Restore and bringing things up to current status might be the best solution.1 -
If I understand correctly, you "…have many double entries since my 1 Aug 23 backup…" The solution, then, would be to restore the 1 Aug 23 backup and reconstruct your data from that point using bank statements and downloaded transactions. Worst case scenario is that you have to accept balance adjustments to agree with the bank statements, but you will have a clean data file going forward.
Next, figure out how the double entries got introduced, and don't do that! 😉
0 -
Is it possible to delete the two messed up accounts, reestablish them, restore those two accounts from the most recent clean backup, and then bring them up to current status? Bearing in mind that both accounts are credit cards and tied to checking accounts for monthly transfer payments? Can accounts be imported/restored without dragging the whole file along?
0 -
you might look at the process of -
Backup your current Quicken QDF file
Restore the old file - with the 2 good accounts
File —> Export to QIF each of those 2 good accounts - individually
Go back and Restore your current QDF data file -
Delete those 2 bad accounts - establish 2 new accounts
Import QIF into those 2 new accounts - individually
then Update those accounts with current transactions from One Step Update
handle any dups -1 -
That's what I've done before (years ago) and couldn't remember. Thank you!
In the meantime, I've discovered that the double entry phenomenon includes all six currently active Banking accounts. (I've been afraid to look at those that are closed) The only transactions NOT affected, appear to be the two dozen I downloaded yesterday into one of the credit card accounts.
I'm thinking it would be well to delete Quicken, download the app, and start fresh. Unless each of the updates is a complete download of the app — I can't tell. Then, using copies of backed up files, I can practice in a sandbox (sort of), until I'm confident of the outcome.
If you have a different idea, I'll be glad to hear.
0
