Net worth report uses cost-basis of investment security instead of current value of security

Joshua Sweetkind-Singer's Avatar

Joshua Sweetkind-Singer

17 Jan, 2020 05:11 PM

OS: Mac High Sierra
MoneyDance Version: 2019.3 (1880)

Description
The net worth report, found under "GRAPHS & REPORTS" in the left-column navigation pane, incorrectly sums up the contributions of securities in investment accounts. It uses their cost basis instead of their current value.

To Reproduce
Open the attached MoneyDance file on a Mac. Click on the "Net Worth" report in the left-column navigation pane. Notice that it shows a net worth of $200, reflecting the cost basis of the stock ABC in the my_investments account, for which 100 shares were purchased at a price of $2/share. However, the *current* value of ABC is $3/share, so the net worth of this account should be $300, not $200.

Now click on the "Summary" option at the top of same left-column navigation pane and look at the "net worth" line item in this summary. Note that it *correctly* shows the net worth as $300.

  1. 1 Posted by sth on 19 Jan, 2020 01:10 AM

    sth's Avatar

    This is a "quirk" of the distinction between "Current price" and the as of price for reports. The Summary page uses the "current price" to calculate networth and then shows what you think is the correct value.

    The Networth report is as of 1/18/2020 for example. This has a specific date and thus uses the security price history that is on or before that date. The Networth report is as of a date and thus needs to always use the same data and not the transitory "current price".

    Any update to the current price for a security should also have a dated history entry. That will resolve your issue. It is not the basis price but the most current price in the the history.

    So for example if your stock was $2 on 1/17 when you bought it and has a hisorty entry of $3 on 1/18 and then went to $4 as the current price sometime later, the summary page would show $400, the networth report for 1/18 and later would show $300, and the summary page would show $400.

  2. 2 Posted by joshua sweetkin... on 21 Jan, 2020 06:33 PM

    joshua sweetkind-singer's Avatar

    Thank you very much for your detailed reply. I understand the distinction.

    -joshua

  3. System closed this discussion on 21 Apr, 2020 06:40 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac