Capital Gains Report not recognising share split

Chris Hill's Avatar

Chris Hill

31 Jul, 2018 02:45 PM

It seems that the Capital Gains report does not take a share split into account. Is that a known issue?

I bought a share, 2,000 at £1 each. There was a 1 for 10 split, which I captured in moneydance. This means I held 200 shares after the split. I then sold the 200 for £2,400. When I run the CG report it's showing as a -£17,600 loss. I'd have expected to see a £400 gain?

Thanks in advance

  1. 1 Posted by -Kevin N. on 01 Aug, 2018 04:31 PM

    -Kevin N.'s Avatar

    Hi Chris,

    Can you confirm that you used Lot Matching for the Cost Basis?

    It has been my experience that I need to use Lot Matching in order for the Capital Gains report to be accurate.

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

  2. 2 Posted by Chris Hill on 01 Aug, 2018 05:15 PM

    Chris Hill's Avatar

    HI Kevin

    Thanks so much. Yes, you are correct it was because the security was set up as Avg Cost. I switched to Lot Matching, allocated the sale number and the Capital Gains report is now showing the "correct" gain.

    Thanks for your help, I'd not realised this had also published publically .. not doing so well!

    Thanks once again

  3. 3 Posted by -Kevin N. on 01 Aug, 2018 05:52 PM

    -Kevin N.'s Avatar

    Hi Chris,

    You're welcome. I'm glad to hear that it worked.

    Thank you for reporting back with your results.

    I'd not realised this had also published publically...

    There is a small checkbox on the submission form to make the post 'private'.

    TBH though, provided that you're not posting any sensitive data, you stand a better chance of getting a quick reply from the user base when you leave the post as 'public'.

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

  4. System closed this discussion on 31 Oct, 2018 06:00 PM.

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

Keyboard shortcuts


? 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