Home → Investments →

Incorrect "Gains" displayed in the "Investment Performance" Report

• Edit

mario.gorreo

28 Jun, 2024 02:11 PM

I am a Moneydance user since 2011.
I purchased 10 shares of Amazon at USD 3150.00 each on Jan 6, 2021 with fee of USD 48.10.
I made the share split 1:20 on June 6, 2022 (10 shares>200 shares).
I sold 200 shares of Amazon at USD 195.00 each on June 27, 2024 with fee of USD 194.58.
This is the Investment Performance Report I get for this stock.
Can you explain why the Report shows negative “Gains” of USD 592,156.58?
I have other stocks and never experienced similar problems.
I look forward to receiving your comments. Thank you.

1. 1 Posted by Chris on 14 Jul, 2024 08:18 AM

   

   I'm here because I've noticed a similar problem. Performance report is calculating gains wrongly for a stock that is split.

   For a stock that split 10 for 1 between purchase and sale, it shows plausible totals for both "Buys" and "Sales", but for "Gains" it shows "Sales" - 10 x "Buys". What should be a gain is turned into a loss roughly 10x the correct amount.

   I haven't noticed a problem with the split anywhere else in Moneydance, I think it's just the performance report that is wrong.

   • Edit

2. 2 Posted by Chris on 14 Jul, 2024 08:24 AM

   

   Even within the investment report, it is only the gains column that is affected. All the return columns appear to be correct, despite gains being wrong.

   • Edit

3. 3 Posted by Stuart Beesley ... on 14 Jul, 2024 10:33 AM

   

   Upgrade to md2024.2(5139)
   https://infinitekind.com/preview

   The costbasis and capital gains engine was significantly upgraded for this release.

   • Edit

4. 4 Posted by mario.gorreo on 15 Jul, 2024 10:43 AM

   

   Hi Stuart, Hi Chris,

   Thank you for your comments.
    
   I installed the latest version of Moneydance (Build 5139) and now the report is correct.
   >

   Best regards
   Mario Gorreo

   • Edit

5. 5 Posted by Stuart Beesley ... on 15 Jul, 2024 11:21 AM

   

   👍

   • Edit