Re: Ideas on how to recover 'missing' transactions?

On 10/20/24 2:59 PM, Geo. Salisbury wrote:
> On 10/20/2024 12:14 PM, John Pollard wrote:
>> On 10/19/24 2:57 PM, Geo. Salisbury wrote:
>>> 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?
>>
>> 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.
>>
>>> 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.
>>
>> 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.
>>
>>> 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.
>>
>> 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.
>>
>>> 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
>>
>> 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.
>>
>>> 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 know of no such possibility.
>>
>>> I have to believe they're still in the QDF File just detached.
>>
>> 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.
>>
>>
>>
> 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.

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.