Capital Gains Report Issue

dwg's Avatar

dwg

Apr 08, 2019 @ 06:49 AM

There appears to be a bug in the Capital Gains report.

If I select to show unrealised Capital Gains and run the report what I get with any shares owned it shows the current market value of the shares, and a cost basis of 0 rather than the purchase value of the shares and an unrealised capital gain value equal to the current market value. This is clearly wrong.

  1. 1 Posted by -Kevin N. on Apr 08, 2019 @ 02:32 PM

    -Kevin N.'s Avatar

    Hi Des,

    I can reproduce this behavior if a security's basis is set to 'Avg. Cost'.

    When the basis is set to 'Lot Matching' the report seems to generate as expected.

    -Kevin N. (not a member of MD support)

  2. 2 Posted by dwg on Apr 08, 2019 @ 09:30 PM

    dwg's Avatar

    Hi Kevin,

    That is one for the books, normally Average cost is the one that works and lot matching the one that fails.

    While I would love to have everything set to lot matching (excluding funds) as that is they way we need to handle shares alas I have a large number of return of capital transactions which I can only include in Moneydance if I use Average Cost for those securities,

    Looks like this is a bug.

    Des

  3. 3 Posted by -Kevin N. on Apr 08, 2019 @ 09:47 PM

    -Kevin N.'s Avatar

    HI Des,

    As we discussed on Slack, the bug appears to have reared it's head sometime after MD 2012 (where the cap gains report behaved as expected).

    -Kevin N.

  4. 4 Posted by dwg on Apr 08, 2019 @ 10:07 PM

    dwg's Avatar

    Hi Kevin,

    I cannot say when this one came in, I do not often run an unrealised capital gain report so I probably have not tested it in any later release than 2012. I had a couple of issues with MD2014 so got no where near looking at this report before I decided not to upgrade to that release.

    Des

  5. 5 Posted by Mezzanine on Apr 18, 2019 @ 10:25 PM

    Mezzanine's Avatar

    +1

    I think this bug appeared in an update to 2015 or 2017. I remember it worked fine and then I went to use it to review some unrealised gains and found it producing the market value rather than the gain. Would be great to get this fixed.

  6. 6 Posted by faye.connors on Jun 01, 2019 @ 01:26 AM

    faye.connors's Avatar

    I have the same problem I run on Mac & have MD 2019.1

  7. System closed this discussion on Aug 31, 2019 @ 01:30 AM.

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