Net Worth Reports ERRORS

Ron n Round Rock · June 14

Well, I guess it has been a long time since viewing the Community Support features - a lot seems to have changed - and as usual, it took me an inordinate amount of time figuring out how to post a question.

BUT THE RIDICULOUS ERRORS IN THE NET WORTH REPORTS HAS GONE WAY TOO LONG.

BOTTOM LINE: The values reported in the New Worth Reports Do Not Match the register values.

I cannot think of any reason that these values do not match. I will start off by saying that on a weekly basis, I compare the values in my accounts with the values in my Brokerage account - and "literally for years and years", they have matched "to the penny". Then all of the sudden, several months ago, they no longer match.

The values in the account registers DO Match the Brokerage account balances, but the same balances in the New Worth Reports DO NOT Match (i.e. do not match the register balances).

I run 2 New Worth Reports - one "Earliest to Date" and another from an "Early to Date" (Custom Dates) Report - and those Reports used to match each other, to the penny. And now, they don't even match each other - and neither give me an actual value of my Brokerage account.

I will point out that some figures do match the register values. It used to be that my IRA accounts were reported accurately, but other did not match. Now it is just random matching of the balances. For instance, in the Reports today, 3 of 9 accounts in the Report did not match the register values, but the difference in the Total Balance was off by over 23K. Last week, only 1 of the account's values between Reports and the register did not match.

I will mention that the errors (UNTIL this week) have only been off by a few hundred dollars, so I have let it slide, figuring others were complaining, but this week - a 23K error is too much to ignore.

SO, WHAT IS GOING ON? WHY do the values in the Net Worth Reports NOT match the values in the account registers. Seems to me a simple question - why would they not match.

Com'on Quicken - what happened. This is driving me crazy - probably a 20+ year Quicken user.

ron, now in shawnee

Ron n Round Rock · June 21

OK, it is me again - same guy, SAME COMPLAINT!

Nothing has changed, nothing fixed - and in fact, it has gotten worse.

3 of the 7 figures (Account Balances) on my Net Worth Report do NOT MATCH the balance in the Account Registers (the register account balance being correct by the way). Again, my total balance is off by about $23K, with 1 Account being off by about $20K, which accounts for most of the error).

BUT when I say worse, I find one of the balances in my BANK accounts off by $1K exactly. So, what is going on there.

I will point out again that all of these balances in the past (and I mean years) used to match "to the penny" the actual brokerage account balances - and for the 1st TIME ever, I now have a $1K error on one of my Bank Accounts on the Report.

Quicken, I wish, or rather, why can't you fix this - these are pretty simple (to transfer an account balance in the register to a "to-date" report - why should they not match), but egregious errors.

ron, now in shawnee

[Deleted User] · June 21

@Ron n Round Rock here are some suggestions to troubleshoot your Net Worth Report issues -

In Report Customization -
- Under the Date Range, make sure it ends on today’s date.
- On the Accounts tab, ensure Select All accounts are selected. Ensure that Select All is clicked on all the other tabs as well.
- Check the boxes for Hidden accounts and Separate accounts if they might have balances that affect your Net Worth Report.
Include Closed or Hidden Accounts
Sometimes closed or hidden accounts still carry balances that affect the report. In the Customize window, make sure those are visible and included.
Validate Your File
Click on File → Validate and Repair File, then select Validate file.
- To do a Super Validate, hold Ctrl+Shift while clicking “Validate and Repair File”.
- Review the validation log for any issues that might be affecting your data.
Check for Investment Account Discrepancies
If the mismatch is in an investment account, select "Account Detail" on the Display tab, and rerun the report. Compare each security MV on the Net Worth Report with the security MV on Quicken. Do the same for the Cash balance. See if you can find which security is causing the out of balance condition.

You might have tried some of all of these already, but hopefully they can at least help with narrowing down the cause of the issues.

Ron n Round Rock · June 28

CaliQkn,

Thanks for the response and attempted explanation.

HOWEVER. THERE IS ABSOLUTELY NO REASON THAT THE VALUE IN A "TO DATE" REPORT SHOULD NOT MATCH THE VALUE IN THE ACCOUNT REGISTER - PERIOD.

And it is even worse that what I have been reporting. Under somewhat closer examination today, I looked at 2 Reports, both "Earliest to Date" after modifying the report and adding a 6th brokerage account, 2 of the same Schwab accounts have different values on the Report. Again, that makes even less sense.

Sorry, but all of your suggestions will not change the simple facts that I have been ranting about for some time now (Report balances should match account balances) - WITH THE EXCEPTION ON ONE. I will admit that I have not run a "Validate and Repair" on the account files - BECAUSE I did not think the files were bad, questionable - AGAIN mentioning that the Balance on the individual accounts match exactly the balance at/on the brokerage accounts. I have no problem with the account tracking - it is just the Reports.

But I suppose running the Validate and Repair is a reasonable thing to do given how bad Quicken has messed things up - REPEATING again that "some" balances in the reports are correct, some not - and not sure how bad files just mess up Reports and yet the accounts balances are correct to the penny.

But thanks for the reminder, Cali - I will do that and of course report back here the results.

ron, now in shawnee

Ron n Round Rock · June 29

OK - DID THE VALIDATE - DIDN'T HELP AT ALL - BUT AT LEAST DIDN'T DO ANY DAMAGE

(i.e. When I re-ran my report after the Validate, it came out exactly the same as the one before the Validate)

And the results of the Validate were:
QDF - "No Errors"
QEL - "No Read Errors" & "All Internal consistency checks passed".

The only complaint was about "Stock Splits", I guess because they get recorded differently in the registers.

Anyway, where do I go from here. I have good records, so I looked back and see all account Reports were accurate "to the penny" as of 2/15/25 - the errors beginning on 2/22/25 and forever after (I run these reports once a week on Saturdays).

So is there a way to get a Quicken itself validated - or a new Quicken without losing all of my historical data.

I can't believe all of the hours I have put into this - and will start putting in even more - tracking which accounts are off and by how much to see if there is any consistency in the errors (i.e. 3 accounts off this week with about a $22K total mismatch in Reports vs. Register values).

Wish a Quicken super-heavy would take a look at this problem.

ron, now in shawnee

NotACPA · June 29

There's no way to get the program "validated" … but you can re-install.

Ron n Round Rock · July 4

OK Quicken - Here is my weekly Update - PROBLEM NOT CHANGED MUCH (OR FIXED)

Again, my Process: I have 9 Schwab accounts (all not mine, 4 are family members) and 1 MLE account
1st run - Earliest to Date - 9 Schwab accounts (all accounts)
(3 values on the Net Worth Report do not Match the End values on the account registers)
(2 of these accounts are Individual and the 3rd an IRA - so no consistency there)
(The 3 accounts are the same accounts I reported on as last week
- and the differences between the values are different - so no consistency there either)
2nd run - Earliest to Date - 5 Schwab accounts (just my accounts) - removed 4 from the Account list
(Still bad, but the values on the Report match those on the 1st run)
3rd run - Earliest to Date - 5 Schwab accounts + a MLE Account was added to the list
(This is awful - 3 of the Schwab values on this Report do not even match the values
on the above Reports - and 2 are different accounts than the 3 noted above)
4th run - a Custom early Date to Today - Same as 3rd run except for the Time period - different beginning date
(Report of Schwab values match those on the 1st 2 runs)

So, I am still stuck with the values on the Reports (ALL are "To Date") not matching the end values in the various account Registers - and I will repeat again that the End values in the account registers match exactly to the penny the values reported by Schwab in my accounts.

I have no idea WHY the 3rd report above has 3 account values that do not match the values from an earlier run when ALL I DID was add a 6th account to the Report run - that one just makes no sense (either).

And repeating one more time - I cannot think of ANY REASON that the values in a "To Date" New Worth Report do not match the End values in the various account registers.

Am I the only one having this problem - and can't seem to find any rational reason (or fix) for it.

Sorry for the long-detailed posts but was hoping someone could pass it on to a Quicken rep/programmer(s).

ron, now in shawnee

Jim_Harman · July 4

@Ron n Round Rock The reports will only match your account balances if they have the same ending dates and all accounts and securities are included in the report. Checking that was the intent of @CaliQkn's steps 1 and 2.

Do the investing account balances in the Account Bar agree with the Total Market Value at the bottom right of the account's Transaction list (Register)? If not, the discrepancy may be due to an overdue Reminder in the investing account.

If they agree, here are some additional steps I would take to troubleshoot this problem.

Back up your data file, in case something goes wrong.
Select a transaction in the account with the biggest error and hit Ctrl-Z. This will force the account to recalculate.
Go to File > Validate and Repair and validate the file as @CaliQkn recommends in Step 3.
If these steps have not corrected 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. This will show the balances for each security in the account. Is there one security that is off, or are they all off? If just one or a couple, that would be a clue to the cause of the problem.

Set the end date for the report and the As of date for the Holdings view back in time until the amounts agree, then go forward until they first disagree.

Look for an unusual transaction on that date. For example it might be a split, spinoff, placeholder, or a Short sale that is not closed with a Cover Short. Correct or delete and replace the problem transaction, then continue going forward until the balances agree for today.

Repeat with the remaining bad accounts.

Please let us know what you find.

rch1973 · July 19

I have a similar but different problem. When i run net worth report—for 5 years—my Roth account shows a balance for 12-31-24 & current date 7-19-25 but zero for all other years. I have invested in this account for years. Quicken support hasn't been able to solve since last November when I first reported.

vvverna · July 29

@Jim_Harman, I'm having the same problem and ONLY with my Schwab accounts. Thanks for the detailed troubleshooting procedure. I may take the time to go through it today. But you know what? This is not how net worth should work. All of us users are not looking for Quicken to use this opportunity to do a quick internal data integrity check. All we want is for the values in the account registers to be the values in the net worth report - that's it. Sure, there may be errors in reporting stock splits or other transactions some years ago - who cares? All we want is to have a report of what we see in the registers today. THOSE NUMBERS ARE CORRECT, TO THE PENNY, including Schwab. Just pull that - and then let us go back however many years we want to see our data. I have also been a user of Quicken for 30+ years and have been silently suffering with this issue for a few years and would really like it fixed since it has made my net worth reports useless.

Jeff76 · July 29

Just curious @Ron n Round Rock, do you get the same results when you run the Net Worth Lifetime Overview Report?

Jim_Harman · July 29

@vvverna Of course we would all like the all numbers in Quicken to tie out to the penny. The fact is that sometimes they don't.

One thing the developers could do would be to improve the Validate and Repair process so it does a better job of finding and fixing or helping us fix inconsistencies in the data. There is an active Idea post for this, which has been in the Planned state since October of 2023.

https://community.quicken.com/discussion/7850837/need-a-tool-to-really-truly-repair-data-corruption-13-merged-votes

In the meantime, we are left with manual processes like the one outlined above.

Ron n Round Rock · August 9

SORRY - SORRY - SORRY - ME FALLING ON MY SWORD - PROBLEM HAS BEEN RESOLVED

Well, it was one of those infamous "I haven't changed anything" errors - and I hadn't - and apparently that was the problem.

One of the Report filters (Categories, Payees, Tags, Securities) had changed on me. I "thought" I had the all checked, selected - but apparently not. Not sure which one - or maybe Quicken had snuck a new something in on me (I had been very carefully about the securities) - but anyway, going through and checking "include all, no matter what" and "Selecting All" - fixed the problem.

And particular apologies to CaliQkn, one of the 1st responders in this thread - for suggesting I make sure all of the filters were set correctly (i.e. select all) - as it pretty much went over my head because I was in that "I have not changed anything" mode.

Again apologies - as usual, my answer was there - if I had been listening.

So please close this one out - with the final advice of "CHECK THE FILTERS ON YOUR REPORTS"

ron, now in shawnee (and it took me long enough, didn't it - problem 1st appeared Feb and reported June)

[Deleted User] · August 9

@Ron n Round Rock no worries! But thank you for circling back and confirming what the issue was and that it's now resolved. Not enough people do that.

vvverna · August 19

@Jim_Harman , yeah, I wish it was off by only a penny. That would be fine. That's what's called a straw man argument. The reality of the problem is that it's off by 10's of thousands of dollars…

Net Worth Reports ERRORS

Comments

Categories