Net worth reports not capturing current investment account balances.

Options
Mike Judd
Mike Judd Quicken Windows Subscription Member

I'm on Windows, Classic Premier, version R62.16, Build 27.1.62.16. Recently, my Net worth reports are not accurately capturing balances of two of my investment accounts. The other 5 are working fine.

Comments

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited May 29

    More information please:

    1. Is this the built-in report at Reports > Net Worth and Balances > Net Worth, or are you accessing it in another way, or is it a report you have customized and saved? If not the built-in report, try that and see if it gives correct results.
    2. Are the problem accounts missing from the report, present but zero balances, or incorrect balances?
    3. What is the end date for your report? If not today, set it today and see if that fixes it.
    4. Are the balances for these accounts correct elsewhere in Quicken, for example in the Accounts Bar on the left side of your screen and in the report at Reports > Net Worth and Balances > Account Balances?
    QWin Premier subscription
  • Mike Judd
    Mike Judd Quicken Windows Subscription Member

    Jim answers are as follows

    1. I'm using the built in report. Not a custom report
    2. Problem accounts are not missing, but they have the incorrect balances.
    3. End date is today.
    4. No. They are not correct under Account Balances either.
  • CaliQkn
    CaliQkn Quicken Windows Subscription Member ✭✭✭✭

    @Mike Judd ensure that all of your securities are selected by clicking on "Select All" on the Securities tab. That is the first thing I check if I have a discrepancy.

  • Mike Judd
    Mike Judd Quicken Windows Subscription Member

    All are checked and the error keeps occurring.

  • CaliQkn
    CaliQkn Quicken Windows Subscription Member ✭✭✭✭

    @Mike Judd you don't mention what troubleshooting steps you have taken so far, but a data file validate can resolve report issues.

    Click on File→Validate and Repair File and select "Validate file". When the validate completes, review the validate log for any error messages.

    You can also do a Super Validate. Hold Ctrl-Shift when clicking "Validate and Repair file". You will be asked to add a password, but just escape out of it.

  • Mike Judd
    Mike Judd Quicken Windows Subscription Member
    edited June 4

    I validated and repaired and it didn't do anything. I spent about an hour with tech support, and long story short, nothing helped. I will leave you with this last bit of information. I was able to track down that the change happened on 5/5/25. Everything from 5/4/25 and backward is badly corrupted. On 5/5/25, everything except the two investing accounts resolved itself. I am resigned to the fact that I won't have historical data for net worth and account balance summary. The amounts aren't off by that much, but I question where the reports pull their data from?

  • Ed V
    Ed V Quicken Windows Subscription Member ✭✭✭

    Are you selecting the report from the Reports and Graphs Center or a saved report?

    I'm not sure this is the issue, but I have had this happen to me on several occasions. I have had issues where a saved report was incorrect (usually after some update). If I recreated the report

    from the Reports and Graphs Center it was accurate.

  • Mike Judd
    Mike Judd Quicken Windows Subscription Member

    I am not selecting a saved report. However, I believe I found the problem. I just don't know how to fix it. After a TON of digging, it looks like Quicken on 5/5/2025 entered several phantom unrealized gains entries into my three Morgan Stanley accounts. After checking with my brokerage account portal, these aren't there. The interesting thing is they don't appear in my account register, but they do appear in my net worth and account balance reports. Have there been any reports of phantom unrealized gain entries that anybody has heard of? Is there a fix?

  • CaliQkn
    CaliQkn Quicken Windows Subscription Member ✭✭✭✭

    @Mike Judd If your three Morgan Stanley accounts are in balance when you do a "Reconcile shares" and these phantom transactions do not include shares, I think you can safely delete these transactions.

    Make a backup before you delete these transactions, just in case.