Net worth Doesn't match Investments

SteveTucker79 · April 6

I think the title pretty much says what I am scratching my head over and I think it's been going on a while. I use Quicken Premier and Win 11.

So here's my story….When I pull a net worth report, the net worth shows about $200 more than the investment screen for my broker (Charles Schwab). I am somehow confident this has been caused by me messing something up about a year ago, but I am at a loss on how to track it down. Don't want to silly nilly correct an entry and make a new one, would rather be surgical and determine where I made the mistake.

Does anyone have any guidance for me? Both finding my error and what to do to correct it. I trade covered call options fairly frequently, and something tells me I screwed something up in the process of entering a sell short and a corresponding CvrSht when the option was assigned.

Appreciate any assistance in getting to the bottom of this one.

[Edited Readability]

Quicken Laura · April 7

Hi @SteveTucker79,

Thank you for sharing the details of what you’re experiencing.

To help identify any discrepancies, I recommend comparing the Net Worth report (Account Details) with the Holdings view for the affected account. Before proceeding, please make sure to save a backup of your data file.

Steps to compare Net Worth vs. Holdings:

Open the account in question
Select Holdings in the upper-right corner of the account
Open the Net Worth report
Double-click the balance for the affected account to view the underlying transactions
Use subtotaling or sorting by security to make the comparison easier

This process should help pinpoint any inconsistencies. Once identified, you can manually correct the discrepancies within the account as needed.

Please let me know how it goes!

SteveTucker79 · April 7

Thank you so much for trying to assist and I am not sure if I grabbed the correct report :-(. The abbount that is off is a brokerage account and there seems like five or six entries for each and i had no idea what I was looking at, so I chose not to screw anything up.

Thanks again for trying.

Quicken Laura · April 7

@SteveTucker79

Understood, no problem.

Please feel free to reach out if you have any additional questions!

SteveTucker79 · April 20

Thought I would come back and give you some additional information that I may not have provided before.

The balance in my Quicken register matches the brokerage account exactly.
When I pull a Net Worth report shows the balance for the broker to be $200.32 more than the broker reports or my brokerage account displays in Quicken
I did pull the report in Net Worth for all dates and sorted by security, but there are soooo many entires, some of which are long gone from my register view.
My assumption is this is a needle in the haystack and may actually many small entries which add up to $200.32 total and I made an entry or entries in the register, then my register will no longer match the broker when I update
However, I have determined the issue to be somewhere in 2025 when I compare holdings and net worth on an annual basis. Interesting, other years were $.01 different. Here's a table:

Year	Holdings	NetWorth
2026	$650,940.75	$651,141.08
2025	$557,999.22	$558,199.57
2024	$470,508.92	$470,508.93
2023	$407,836.89	$407,836.88
2022	$336,359.42	$336,359.41

Now the question becomes how to find and correct without disturbing the correctness of my registration matching the broker exactly.

Appreciate any thoughts.

Jim_Harman · April 21

The difference first appears in 2025. Narrow down the date by changing the As of date in the Holdings view and the end date for the report to see exactly when it appears.

Then look for an unusual transaction on that date. It might be a duplicate, a spin-off, a stick split, or something like that.

Sometimes deleting and re entering the transaction fixes problems like this.

SteveTucker79 · April 21

Thanks for your pointer I have been able to nail it down to the month of July and that month has the ~$200 ($200 and change)…meaning more int he net work transactions than in the investment transactions.

Funny thing is, there are a couple transactions in both reports for 7/13 that don't show up in the other report. Crazy.

Thing is the investment account in Quicken reconciles perfectly with the Charles Schwab account at the brokerage, so I am super reluctant to change anything there. Not even sure how I would go about correcting the net worth records without screwing up the investment transactions which, again, are matching up 100% with the brokerage.

One thing that was driving me crazy in the net worth transactions file when I downloaded, there were a ton of unrelaizdgains entries, which I assume came about from the daily sync with Charles Schwab. When I filtered these out in excel it was much more manageable to match up the entries from the two reports, except for the weirdness I already mentioned.

As much as I hate to admit defeat, I guess I am going to have to live with it.

Thanks again.

Quicken Laura · April 22

Hi @SteveTucker79,

Thank you for trying the suggested troubleshooting steps. It looks like you’ve done everything right. Because your account register reconciles perfectly with Schwab, the ~$200 difference in the Net Worth report is almost certainly due to reporting nuances, such as unrealized gains, option adjustments, or rounding in the Net Worth calculations; these differences don’t affect your actual account balances.

You can always contact Quicken Support directly for further help if you would like, since they can walk you through troubleshooting steps or escalate the case as needed in real time.

You can find the Quicken Support phone number here: Support Home | Quicken. Phone support is available Monday through Friday, from 5:00 AM PT to 5:00 PM PT.

Please feel free to reach out if you have additional questions!

SteveTucker79 · May 1

After much head scratching I believed I have resolved my issue 😊

And after some tedious comparing Net Worth and Portfolio Value I narrowed the problem down to a single day in July 25 and then went to looking. The problem turned out to be an entry for the sale of a stock option which expired worthless and the reversing entry was never made and of course I could not make the entry because it was no longer seeing a short sale. I deleted the ShtSale (selling of the option) and added it back and CvrSht the option when it expired worthless.

I appreciate everyone's assistance and pointers. It driving the OCD/Anal me crazy!!!!

Quicken Laura · May 3

That's great news @SteveTucker79!
I'm glad to hear the issue has been resolved.

Please feel free to reach out if you have additional questions.

Net worth Doesn't match Investments

Comments

Categories