Community Discussion: Net Worth report off by a bit when I set Interval = Year (or anything other than None)

Net Worth report off by a bit when I set Interval = Year (or anything other than None)

Found at:

I believe this discussion is reporting a Quicken bug that is well over a decade old (I can see it in Q2004). But there are a few pieces of information missing from the linked discussion, so I can't be certain the bug I see is the same as that reported in the Community.

In my case, the accounts with the discrepancies are always investment accounts. And the discrepancies are always with securities whose Quicken holdings went to zero at some point in the past - and for each report interval since the holding went to zero, there is some tiny $ amount in each report interval.

I have always assumed the problem was related to Quicken's inability to reliably remove all shares of a security when all shares have been sold or transferred; coupled with the way Quicken computes un-realized gains/losses.

You can exclude un-realized gains/losses from the report and the incorrect tiny amounts should disappear.

And if you want further confirmation of the source of the problem; you can Customize the report to display the individual securities held in each account (select "Account detail" on the Display tab of the Customize dialog). If you also select an interval of "Week", you should be able to pretty well pinpoint the security/securities involved and the date when the last share of each was (intended to be) sold.

The same problem affects the Account Balances report.

[I reported this problem in the Quicken Community more than once.]