Ideas on how to recover 'missing' transactions?

Oct 19, 2024 Last reply: 1 year ago 7 Replies

Quicken Deluxe Version: R59.18 Build: 27.1.59.18



Grasping at straws ...



Is there any hope in recovering 'missing' transactions in Quicken? I've tried Validates & Super Validates incl Rebuild Lots & Prices etc. and there's always "No Joy in Mudville".



Is there any method/trick/technique for copying an account from one Qkn File into another?



I have a Quicken Account (IRA CD @ BOA) that has gone to zero and all transaction history has disappeared! (The CD is still active on the BOA Site and the 3rd Quar 2024 Statement has been rec'd.)



The Account shows in Home->Our Accounts and the Accounts List Bar and Edit Account Details displays like all others. No Register opens, however, because there no longer are any transactions.



An Account Overview a/o Today (10/19/2024) shows the zero balance and a Last Transaction Date of 08/17/2024. An Account Overview a/o 08/16/2024 show a proper non-zero balance.



I certainly didn't go into the Account's Register on the 17th and do something overt to delete all its transaction history. That history includes transfers into and out of other Accounts to make matters worse.



I was doing some Deactivate/Add Account sequences around then (maybe then?) but why would that cause Quicken to lose its 1st Trx pointer?



Anyway, does anyone have some other ideas of things to try?



Does anyone know if Support might have some sort of a utility they could provide that might be able locate and re-attach [that] 1st transaction? I have to believe they're still in the QDF File just detached.



Thanks for any ideas. Geo. Salisbury Long Valley, NJ


Make a copy of your data file and work in that.

One way would be to compare statements from BoA to Quicken status. Start from a "middle date" available from BoA and make sure your Q file is sorted by date. If OK work towards current date, if not work backwards.

Note that there is a "shares Transfer between accounts" transaction but that just duplicates the problem in the new account and would only be helpful if you have more than one asset in the Q account.

Thanks for taking the time to consider and respond. I've done pretty much all of the "comparisons" that are available and applicable.

The problem is there are no transactions to compare to and there definitely was no transaction on BoA to empty the Account in Quicken.

The Account (an IRA CD) doesn't really have any transactions per se at BoA to compare to. The Statements are just Quarterly Summaries showing a Prior Balance and a negligible Interest Credit and the Current Quarter Balance. The 4th Quarter Statement also shows when I took the RMD. (I've long been in the 70 1/2+ world.)

I have the Account intact in lots and lots of Quicken Backups from prior to 08/17/2024.

What I'm trying to determine is if there's any way to get [the] 1st transaction pointer repaired in Quicken or get an entire Quicken Account copied from one QDF file into another.

I know I can manually prime the Account with a few summary lines then get over it but the AR side of me can't let it go just yet.

Thanks. Geo.

There is (export/import a QIF file), but it can be a little tricky, and I'm not sure it's necessary for your situation.

A Quicken account with no transactions still has a register and normally an account with no transactions will still open to its (empty) register. If you really can't open the account register, there is something else wrong.

The only source of a non-zero account balance is one or more transactions in the account If your account is showing a non-zero balance (as of any date), there must be transactions in the account.

Have you tried running a Banking > Transaction report (for the account in question, for All Dates) to see whether Quicken finds any transactions in the account?

If the Banking > Transaction report displays any transactions in the account, try double-clicking on the date of one of those transactions: that should take you directly to that specific transaction in the account register.

If Quicken does find transactions in the account, perhaps you have unintentionally set one, or more, filters on the account that are preventing Quicken from displaying them.

If any filters are set, there should be a green button to the right of the filters (in the row above the Heading row: clicking that reset button will remove all the filters from that register.

If you allowed Quicken to create a New account when you reactivated (using Add Account), instead of "Matching" the download to the original account; you would now have two Quicken accounts for the same single real-world account. The original account would be missing any transactions since the deactivate/reactivate: those newer transactions would be in the New Quicken account.

I know of no such possibility.

If nothing else helps, you can try Validating your data. To do that I would:

- Backup (to a separate location from your regular Quicken backups)

- File > Backup or Copy file

- Choose "Create a copy or template"

- Copy everything (which I believe is the default)

- Choose a location for the Copy and click OK

- When the Copy finishes:

-- Open the Copy

-- File > Validate and Repair file

-- Put a check mark in the Validate file box, then click OK

Note whether the "missing" transactions appear. If they do, plan to make the Copy your regular file. Delete the original file, then rename the Copy to the original file name. The you will need to reactivate EVERY account that had been enabled for downloading (the Copy process deactivated every one of those accounts).

If the Validate process did not help, try Super Validate Click File, hold down CTRL+SHIFT while clicking Validate and Repair file. Put a check mark in the Super Validate file box, then click OK.

Note again whether the "missing" transactions appear: if yes, do as above.

If neither Validate or Super Validate help, post back for instructions on using QIF file export/import to move transactions between Quicken files.

Has the account been accidentally hidden?

Select "Tools - Security List" and click on the NAME you gave the security which should open the "Security Detail View" and show the transaction history.

When I enter the register for an investment with NO entries in it Q (R59.18, 27.1.59.18) always starts up the Enter Transaction GUI. If there is at least one entry, even a zero balance one, the transaction GUI does not show.

John,

Thank you for the Transaction Report thought. I hadn't thought of that - that turned out to be key. As I noted I had done all of the Validate/Super Validate steps but to no avail.

I ran the Transaction Report for all dates in the Account in question and it displayed all of the transaction history so we know it is, indeed, still out there in the QDF file.

The Report DOES show an 08/17/2024 Balance Adjustment transaction to zero.

NO way did I enter that (can't image why I would have) as there would be no rational reason to do so - the CD is still with BoA and at a non-zero value.

I now know that somewhere along the way I can delete that zeroing transaction and get my balance back but ...

the question now is how do I get the register display back!

Short story ... I did get my register display back and all seems well!!! Phew.

At first I could not find the "filtering" in the usual places but then I found it in Edit Account Details and evidentially it had to do with my Deactivate/Add Account sequence for my BoA Accounts (I no longer remember what lead me down that path but something did).

The General tab in Account Details had "Tracking Method" 'grayed-out' and a Link to a "why can't I track..." which popped-up a disclaimer that Bank of America - Quicken only did "summary" (my words).

When I was doing the Deactivate/Add Account sequence for BoA the Bank of America - Quicken appeared as an FI so I chose it as it fit the profile. Previously it was most likely Bank of America-All Other States.

I Deactivated Online Services and selected Complete Tracking and that gave me back my Register with all transaction history. Yeah!

I'll worry about Online later.

Again, John, thank you for the Report tip - that lead to a solution. Geo.

When I read your initial post, I assumed that you had your BofA CD in a Quicken savings account. Only investment accounts have the "Tracking Method" option, so I didn't even think of about Tracking Method. I didn't think BofA offered any investment accounts - BofA owns Merrill Lynch so I thought Merrill Lynch would be the appropriate financial institution.

[Quicken investment accounts using the Simple tracking method don't have "registers" (actually known as "Transaction Lists" for investment accounts). "Simple" investment accounts just track the account balance.] [Investment accounts don't have the register filters that are available in non-investment accounts, so that's why you had trouble there.]

If I recall correctly, when reactivating a Quicken account, Quicken will sometimes adjust the account balance (though I thought that only occurred for non-investment accounts). If the downloaded account balance differs from the Quicken account balance, that might trigger such an adjustment.

[I did a test; switching an online-enabled investment account to the Simple method, then back to the Complete method. I ended up with exactly what I started with - and there was never any adjustment transaction in the account.]

I'm not sure what to make of " ... 'Quicken' appeared as an FI so I chose it ....". But if you told Quicken to use a different financial institution for the account when you reactivated, that too might have contributed to the unusual results.

In any event, glad seem to be back to near-normal.

I intended to mention in my previous reply:

Sorry, I did miss that you had already tried Validate/Super Validate.

But you didn't mention that you tried them on a Quicken Copy of your data. The Quicken Copy not only makes a copy of the .QDF file, but it removes any "logically deleted" data from the file.

When you tell Quicken to delete data, Quicken typically does not actually remove that data from the file: Quicken usually just marks that data as deleted, in such a way that when Quicken later encounters that data, Quicken treats it as not being in the file.

Sometimes that logically deleted data can cause problems in Quicken, and occasionally when that happens, removing the logically deleted data from the .QDF file, then Validating can repair a problem that it could not repair when the logically deleted data was still in the .QDF file.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required