Fix Growth of $10,000 graph so it handles Deposits and Withdrawals correctly

Jim_Harman

As discussed at length here
https://community.quicken.com/discussion/7814587/growth-of-10-000-deposits-and-withdrawals-handled-incorrectly

in QWin Subscription the Investing > Performance > Growth of $10,000 graph jumps up or down when an investing account has a cash deposit, withdrawal, or WriteCheck. It should work the same as it does when there is an XIn or XOut, and as it apparently did in QWin 2016 and 2017.

brandongblack

Any updates on this issue from the quicken team? Seems like a pretty glaring bug for this report

brandongblack

Actually @Jim_Harman , after looking at this closer it looks like the growth of $10k is technically correct. its just the "net additions" value thats wrong. But it looks like the "selected accounts" value is correct after i cross-checked it with other sources. I have all my contributions using the "deposit" action type

Jim_Harman

Sorry @brandongblack but I think you are mistaken. The Quicken Help says

• In calculating the growth of $10,000 invested in the selected Quicken accounts, Quicken subtracts the value of cash (e.g. XIn transactions) or securities (e.g Added transactions) added during the time period selected, and adds the value of cash (e.g. XOut transactions) or securities (e.g. Removed transactions) removed during the time period. This provides a more meaningful comparison to external indexes. 

Can we agree that the Growth of $10,000 for an account should reflect investment gains or losses within the account and should not be affected by cash that is moved into or out of the account?

To demonstrate this problem more clearly, I just set up a new test file using QWin 2020 R23.14 and it appears that nothing has changed since this issue was originally reported. The test file has 3 Brokerage accounts.

In the account Brokerage 1, the account starts 2019 with $10,000 in cash and on 1/15 I buy 10,000 shares of a money market fund at $1.00 per share. As expected, the Investing > Performance page looks like this:


There is no gain or loss in the account, just money moved from cash to the money market fund.

Account Brokerage 2 starts the year with $5,000 and on 1/15 I transfer in $5,000 from another account. The investing > Performance page for this account looks like this:


The Portfolio Value at the top grows from $5,000 to $10,000 but as expected the Growth of $10,000 is flat because there are no investing gains or losses.

Account Brokerage 3 also starts the year with $5,000 but instead of transferring in $5,000, I Deposit $5,000. I think this should show no growth just like Brokerage 2, but look what happens:


The Portfolio Value goes from from $5,000 to $10,000 as it should, but the Growth of $10,000 goes from $10,000 to $20,000 when it should stay flat at $10,000. Quicken has treated the deposit as if it is an investment gain. This is clearly wrong and is what I think Quicken should correct. The same problem occurs in the other direction with Withdraw and Write Check transactions. 

Jim_Harman

This issue has been resolved with a new Category setting in QWin Subscription R25.10. See this discussion
https://community.quicken.com/discussion/7869813/thank-you-to-the-qwin-developers

Thanks, Quicken!