$ Dashboard and "Investing" do not agree

jimarcher6837

The Dashboard "total value $" do not match the total of "investing $" in the left hand bar, by 14%. The "Value over Time" quadrant agrees with "Investing $". The "Portfolio by Security" quadrant does not agree with either. "Todays Change" does not agree with the net gain for the portfolio. The Value over Time totals in not in agreement with the bar charts. The pull downs are set for all securities and all accounts. I tried looking for a settings for this page, but cannot find one.

The Total Value, in the upper left quadrant, which lists individual securities and market values, does not agree with the totals in the Portfolio by Security in the upper right quadrant. The difference in values is 14%.

The Portfolio by Security value agrees with current portfolio value.

I am confused by all this.

Quicken Jasmine

Hello @jimarcher6837,

Thanks for reaching out!

I’d like to gather a bit more information to better understand the discrepancy you’re seeing. Are there any specific accounts or securities that seem to be missing from the Dashboard but appear correctly in the Investing tab? In the Portfolio by Security quadrant, do any securities show outdated or incorrect values compared to what’s in your brokerage accounts? When you check the Portfolio View under the Investing tab, does the total match either of the values from the Dashboard, or is it showing yet another different total?

Additionally, do you have any placeholder transactions in your investment accounts? You can check this by going to Edit > Preferences > Investing and enabling Show hidden transactions to see if any estimated values might be affecting the calculations. Have you recently made any manual adjustments to your investment transactions that might not have fully synced across different views?

Let me know what you find, and I’d be happy to help troubleshoot further!

jimarcher6837

I use Quicken Windows. In the Portfolio by Security quadrant, the total agrees with the Portfolio View totals and the MTD Value Over Time quadrant. I can only see percentages in Portfolio By Security for each security. Mouse over each security shows the market value. Those values are correct.

The Total Value in the upper left quadrant is in error. It seems that a brokerage account under the Accounts / Investing left hand bar is doubled. Each market value for each stock in this brokerage account is doubled. No other funds or bonds in the portfolio are treated this way. The Total Value expression reflects the the doubling of this brokerage account.

And, the value in the Accounts / Investing LH bar does not agree with any total values in Dashboard.

Quicken Jasmine

Hello @jimarcher6837,

Thank you for the detailed follow-up! That’s very helpful information.

It definitely sounds like the issue may be tied to that specific brokerage account being duplicated in the Dashboard’s Total Value calculation. This type of discrepancy can sometimes occur due to data file inconsistencies or account setup issues.

Here are a few steps I recommend trying to help narrow this down:

1. Check for Duplicate Account Listings:
   Go to Tools > Account List and confirm that the affected brokerage account is only listed once. Sometimes, duplicate accounts can appear if an account was accidentally added twice.
2. Review Account Settings:
   Open the affected brokerage account, go to Account Details, and verify that it is set up correctly and only linked once to your financial institution.
3. Check for Placeholder Transactions:
   As mentioned earlier, go to Edit > Preferences > Investing and ensure Show hidden transactions is enabled. Look for any placeholder entries in the account that may be inflating values.

Looking forward to your update so we can get this resolved!

jimarcher6837

Went through your steps.

1, The account is not duplicated.

2. The account is linked only once to the financial institution.

3. Show hidden transactions is enabled.

This in not a case where the account is duplicated. I am not sure where the duplication is.

Also, the value in the Accounts / Investing LH bar does not agree with any total values in Dashboard. This is because one account shows the proper value in the Portfolio view (agrees with broker statement. The Register for this account shows an amount 30% less and the LH bar shows the same value.

Maybe I should validate the Quicken file?

Quicken Jasmine

Hello @jimarcher6837,

Thanks for attempting those steps and providing more information.

Yes, in this case, I suspect that this could potentially be a data file issue. Therefore, I suggest that you please try validating and/or super validating your data file. However, I do recommend that you first save a backup file prior to performing these steps.

Validate: 

1. File
2. Validate and Repair File...
3. Validate File
4. Click OK
5. Close the Data Log
6. Close Quicken (leave it closed for at least 5 secs)
7. Reopen Quicken and see if the issue persists.

If the issue persists, proceed to Super Validate. If the issue is resolved after performing validation, then please disregard the instructions to Super Validate.

Super Validate:

1. File
2. Hold CTRL + Shift and click Validate and Repair File...
3. Super Validate File
4. Click OK
5. Close the Data Log
6. Close Quicken (leave it closed for at least 5 secs)
7. Reopen Quicken and see if the issue persists.

Let me know how it goes!

jimarcher6837

Makes sense. It is an 85.5 MByte file. It has many years of data.

jimarcher6837

Database Validate resolved the problem with the Dashboard.

The issue of one account in which the Portfolio view / value is accurate, but the Register Sum and the LH panel are 30% below the accurate value in the account persists.

jimarcher6837

There is a security, a money market fund, which shows up in the Account Overview, for the amount of the difference between the Portfolio value and the Register Value. This goes back to 2015. I am trying to track this one error.

jimarcher6837

Jasmine, Thanks for your help. Since there was a negative number for the MMF in this account, I added the positive value to earliest date for this account, as an Opening Account Balance (in 2013), then bought the MMF in an equal amount. The account now accurately reflects the account Market Value.

Between the Validate and the above, all accounts reflect proper MVs.

Quicken Jasmine

https://community.quicken.com/discussion/comment/20479773#Comment_20479773

That is wonderful news. Sounds like it was a bit tricky, but I am happy to hear that we were able to get this issue resolved and get you up and running again!

Thanks for coming back to let us know!