FYI/IYI How to kill an Investment Account's Ending Balance

Check the prices for each security in that account. An incorrect price is a MUCH more likely explanation that your Reminder theory.

Also check your number of units/shares for each security in the account. Again, a MUCH more likely explanation.

Check the prices for each security in that account. An incorrect price is a MUCH more likely explanation than your Reminder theory.

Also check your number of units/shares for each security in the account. Again, a MUCH more likely explanation.

Check the prices for each security in that account. An incorrect price is a MUCH more likely explanation than your Reminder theory.

Also check your number of units/shares for each security in the account. Again, a MUCH more likely explanation.

Check the prices for each security in that account. An incorrect price is a MUCH more likely explanation than your Reminder theory.

Also check your number of units/shares for each security in the account. Again, a MUCH more likely explanation.

--------------------------------------------------------------------------------------- I did all of that. The unchanged Qkn holdings/costs matched the brokers and prior files. The unchanged Qkn prices matched the brokers and prior files. There were no differences in the Qkn Acct vs. the broker other than the Qkn Reminder. Restoring a sequence of backups and examining the Account in question showed the correct Ending Balance until [that] first backup after entry of the Reminder. Everything else remaining as before, removing the Reminder from [that] restored backup and/or from the current file allowed the Ending Balance to [re-]calculate to the correct amount. It's pretty clear the 2099 Transaction was way too far off to handle. Of course, as a text item, it should simply be ignored in math but that's another matter. Geo.

Have you tried entering a reminder in a Cash account instead of an Investment account?

"GSalisbury" wrote

I did all of that. The unchanged Qkn holdings/costs matched the brokers and prior files. The unchanged Qkn prices matched the brokers and prior files. There were no differences in the Qkn Acct vs. the broker other than the Qkn Reminder. Restoring a sequence of backups and examining the Account in question showed the correct Ending Balance until [that] first backup after entry of the Reminder. Everything else remaining as before, removing the Reminder from [that] restored backup and/or from the current file allowed the Ending Balance to [re-]calculate to the correct amount. It's pretty clear the 2099 Transaction was way too far off to handle. Of course, as a text item, it should simply be ignored in math but that's another matter.

----------------------------------------------------------

I am able to reproduce your problem, but I'm not sure I would classify it as a bug.

Although you said, in response to danbrown, "I did all of that", I do not believe you did. Danbrown suggested that you "Check the prices for each security in that account", and doing so should have led you to the cause of the problem: a future-dated security price.

I believe what happens is that your 12-31-2099 Reminder sets the Quicken "through date" for the date range "All dates", which is used in reports and also for the "Ending Balance" in the Quicken Account Bar. If you also have a security price dated in the future, Quicken will use that price to compute the value of that security for dates on, and after, the future dated price.

So if you have a security price dated 02-01-2038 (for example) and a Reminder in the account where that security is held dated later than

To correct the problem, delete all future dated security prices. If you do a File > File Operations > Validate, Quicken should tell you which security prices are future dated.

Have you tried entering a reminder in a Cash account instead of an Investment account?

------------------------------------------------------------------------ Yes. I had the same "reminder" in a Checking Account (not the Cash Account) that's associated with the Investment Account. It wasn't disturbed. I hadn't thought to put a reminder in the Investment Account's Cash Account. I'll do that for S&G and watch it for awhile to see what happens. Geo.

"GSalisbury" wrote

I did all of that. The unchanged Qkn holdings/costs matched the brokers and prior files. The unchanged Qkn prices matched the brokers and prior files. There were no differences in the Qkn Acct vs. the broker other than the Qkn Reminder. Restoring a sequence of backups and examining the Account in question showed the correct Ending Balance until [that] first backup after entry of the Reminder. Everything else remaining as before, removing the Reminder from [that] restored backup and/or from the current file allowed the Ending Balance to [re-]calculate to the correct amount. It's pretty clear the 2099 Transaction was way too far off to handle. Of course, as a text item, it should simply be ignored in math but that's another matter.

----------------------------------------------------------

I am able to reproduce your problem, but I'm not sure I would classify it as a bug.

Although you said, in response to danbrown, "I did all of that", I do not believe you did. Danbrown suggested that you "Check the prices for each security in that account", and doing so should have led you to the cause of the problem: a future-dated security price.

I believe what happens is that your 12-31-2099 Reminder sets the Quicken "through date" for the date range "All dates", which is used in reports and also for the "Ending Balance" in the Quicken Account Bar. If you also have a security price dated in the future, Quicken will use that price to compute the value of that security for dates on, and after, the future dated price.

So if you have a security price dated 02-01-2038 (for example) and a Reminder in the account where that security is held dated later than

To correct the problem, delete all future dated security prices. If you do a File > File Operations > Validate, Quicken should tell you which security prices are future dated.

----------------------------------------------------------

I guess I misspoke ? stated an alternative fact - no, it turns out, I didn?t ?do all of that?.

The Prices I checked were those shown on the Register -> Holdings view. They agreed with the brokers prices and that?s as far as I went. Beyond that is way more granular than I attend to on the account in question. I?ve never given its price history any attention ? not overly interested in it ? it is what it is.

It turns out that, yes, there was a string of 01/18/2038 zero price entries across a number of securities. Did you pull 2038 out of the air? Good call. How would they get there/where did they come from/curious/never would have had a reason to notice.

I removed all of the 01/18/2038 zero price entries from all of the price histories and re-entered my 12/31/2099 Reminder in the Register for the Investment Account and in its related Cash and Checking Accounts. I restarted Quicken and, so far, the Investment Account Ending Balance has remained undisturbed.

As always your guidance is spot on! (I still think that as a text entry it shouldn?t have affected anything but ?). Thanks. Geo. Salisbury Long Valley, NJ

"GSalisbury" wrote

....

It turns out that, yes, there was a string of 01/18/2038 zero price entries across a number of securities. Did you pull 2038 out of the air? Good call. How would they get there/where did they come from/curious/never would have had a reason to notice.

I removed all of the 01/18/2038 zero price entries from all of the price histories and re-entered my 12/31/2099 Reminder in the Register for the Investment Account and in its related Cash and Checking Accounts. I restarted Quicken and, so far, the Investment Account Ending Balance has remained undisturbed.

As always your guidance is spot on! (I still think that as a text entry it shouldn?t have affected anything but ?).

-----------------------------------------------------------

There have been multiple reports in the past of price histories with an unwanted price dated in 2038. I don't know the cause, though I'm inclined to look in the direction of the entity that supplies the prices.

I think it makes sense that the date range "Show all dates" (which is the date range used for the Account Bar "ending balance") would apply to all transactions, and that Reminder transactions can set the "through date" for that date range, just as any other transaction can.