Home → General Questions →

Stock Split Cost Basis Error

• Edit

davestirling1

17 May, 2022 10:14 PM

Hi There

So on May 16, CM.TO split 2 for 1. I went into my CM security, selected the split button, put in the May 16 date with a 2 for 1, and in the two accounts I have that security it shows the increased amount of shares.

While it shows the correct amount of shares now, it appears that it has not compensated for the cost. According to MoneyDance, I am now down 17.81% because it is saying that my cost per share is $85.82 and it should actually be around $52.7506.

Prior to entering the split, I had 134 shares, and after the split it increased to 268 which is correct.

The first image is the security, and the second image is from the Cost Basis tab where it hasn't increased the amount of shares, but compensated for the cost. So the $14,137.17 is a correct figure, however, that section is still only showing 134 shares, when it should be now 268.

Any suggestions?

Thank you

• Screen_Shot_2022-05-17_at_6.09.35_PM.png 18.3 KB
• Screen_Shot_2022-05-17_at_6.11.44_PM.png 28.9 KB

1. 1 Posted by Stuart Beesley ... on 18 May, 2022 06:21 AM

   

   Average cost or lot controlled cost basis?
   We’ve seen with splits that using lot control and matching buys/sells can sometimes correct cost basis.

   • Edit

2. 2 Posted by davestirling1 on 18 May, 2022 12:46 PM

   

   I'm using Average Cost.

   Not sure how you use lot control.

   • Edit

3. 3 Posted by Stuart Beesley ... on 18 May, 2022 01:03 PM

   

   Would be interesting on a test copy of your dataset to use/try lot control just to see if it actually resolved the issue.

   • Edit

4. 4 Posted by davestirling1 on 18 May, 2022 01:06 PM

   

   I will have to look through the documentation and see if I can give it a try.

   • Edit

5. 5 Posted by davestirling1 on 23 May, 2022 05:44 PM

   

   I tried a test copy and the Lot Control idea didn't resolve the issue.

   I'm hoping that someone from MoneyDance might have a suggestion to the issue.

   • Edit