Erroneous Values shown in Net Worth Report and Graphs

Bione

I have read some history on this issue. I do not understand what the value of a particular investment account is different in the report tool than is actually shown in the actual account which is correct. Both the transaction list and the Investing Account values are correct. But the report values and graphs are off. Why is this somehow calculated separately. I really do not have the time or energy to figure this out. Seems someone at Quicken has gone out of their way to make it more difficult.

Jim_Harman

Where are you accessing the Net Worth report?

I would start by using the default report at Reports > Net Worth & Balances > Net Worth, and set the date range so it ends today. Does that report agree with the account's Transaction List?

If there is a difference, how much is the report off by?

With that info, we can make further recommendations.

Bione

I am using the default Net Worth Report. If I set it to "Include All Dates", it is off +23K or about 3%. It does not match the accounts Transaction List. The Transaction List does match the online amount reported by Fidelity.

Jim_Harman

Try changing the date range to Earliest to date or Year to date. Does that make a difference? If you have future dated transactions, they will be included if you use Include all dates.

You can also force Quicken to recalculate the transactions by selecting a transaction in the account and hitting Ctrl-Z. Does that make a difference?

Please let us know what you find and post back for more troubleshooting steps if neither of those fixes it.

Bione

That is what it has been set to. "Year to Date" has the same issue. Doing the recalculate did not change the investment account and the Report value still stayed +23K higher.

Jim_Harman

Are you looking at the Account Balances report or the Net Worth report? They should show the same totals, but they are calculated differently I think. Are they both wrong, or or does one agree with your account total and one not?

Is the account set to Show Cash in a checking account? If so there will be an account in the banking section called <your investment account name> - Cash. and the total account balance will be split between those accounts.

If that does not explain it, here are the steps I would take to troubleshoot this problem.

Back up your data file, in case something goes wrong.

Go to File > Validate and Repair and validate the file.

If that does not correct the problem, go to the problem account and click on Holdings to view the current holdings in the account.

Start with the built-in report at Reports > Net Worth & Balances > Net Worth, not a saved report or one accessed from elsewhere in Quicken.

Customize the report to include just the account with the largest error. On the Display customization tab, select Account detail.

Presumably these will disagree. See if it is just one security that is causing the problem or more than one, or maybe the cash balance. Set bot the As of date for the Holdings view and the end date for the report back in time until the balances agree, then go forward to zero in on the date when they first disagree. Look for a suspicious transaction - it might be a corporate action or a split or something - and correct it or delete and re-renter it.

Continue forward in time until the balances agree as of today.

Repeat with any other accounts that need to be fixed.

Please let us know what you find.

Bione

Account Balances Report=Net Worth Reports. These are the stock (not saved) reports. Securities+ Cash match online Fidelity numbers and are -23K less that reports and graphs. Two other Fidelity accounts and all others have no issue. Yes. did Super Validate and also Repair Investing History.

Now one interesting point. I did go to Net Worth and selected only that account. The value was still off. But when I clicked on it and exploded it out. It had one Mutual Fund shown14 years before that account was opened. The account number was changed during Covid because of potential security issues in 2020. That transaction was for about 2K shown as 2006. I have not tried deleting it yet.

I will backup and try deleting that transaction to see results. Will not get to try this until tomorrow or next. I am betting there might be some other erroneous items in this account but the only way to really clean it up would be to delete and add again. This will mess up my ROI and Return columns for sure since they are based on accumulated Quicken history. Might just have to live with it.

Jim_Harman

I am betting there might be some other erroneous items in this account but the only way to really clean it up would be to delete and add again. 

I hope you aren't proposing to delete the account. That is likely to cause more problems than you have now.

If the problem security was Added but should never have been in this account and that is the only transaction for the security, it should be OK to simply delete the Added transaction. If the transaction is a Bought or BoughtX, deleting it will change the account's cash balance or the balance of the account the cash came from. There may be a later cash balance adjustment or something that corrects the cash balance, and you would also need to delete that.

Bione

I have decided just to leave it alone. The amount differential is small but just annoying. Wish there was a switch to just use the values from investing and not try to do a parallel calculation.