Home → Investments →

Capital Gains Report not recognising share split

• Edit

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
Chris

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

   

   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)

   • Edit

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

   

   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
   Chris

   • Edit

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

   

   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)

   • Private.jpg 101 KB
   • Edit

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