GNOME Bugzilla – Bug 311549
Advanced Portfolio report miscalculates money in/out (and hence gain and total return)
Last modified: 2018-06-29 20:53:03 UTC
Please describe the problem: VERSION: GnuCash 1.8.9 The problem is that the "money in" and "money out" columns include reinvested dividends under "money in" and include broker's fees under "money out". This doesn't accurately reflect the role of those transactions for a typical investment account. Steps to reproduce: 1. Purchase $100 worth of a mutual fund. 2. Receive a $50 dividend. 3. Pay $30 in broker's fees. 4. Assume the value of the fund's shares doubled after all this. Actual results: Money In == $150 Money Out == $30 Current Value == $240 Gain == $120 Total Return == $120/$150 = 80% Expected results: Money In == $100 Money Out == $0 Current Value == $240 Gain == $140 Total Return == $140/$100 = 140% Does this happen every time? Other information: I have a suggested patch based on the existing calculation of dividendcoll and brokeragecoll in advanced-portfolio.scm (they are currently unused, but I think they should be used to adjust the moneyincoll and moneyoutcoll lists).
Created attachment 49754 [details] [review] Proposed change
Applied to SVN r13242. Thanks for the patch.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=311549. Please update any external references or bookmarks.