At the risk of sounding like Pee Flynn (only for the more mature readers!), here is my "problem":
I get shares in a publicly listed company and have been for 25 years. For simplicity purposes, I get 1000 shares each year so therefore my holding is 25,000. Each year the purchase price is different. On occasion I sell shares in small tranches, for example, 200 or 1500. My questions are as follows:
I have been using Excel to try and record transactions from a tax perspective but it is getting very cumbersome. For example, each sale may have different purchase price amounts within the batch. CGT calculation is (slightly) tricky but how the overall share portfolio is deceasing is difficult to track.
My questions are as follows:
1. Does anyone know of an Excel template that will elegantly record the scenarios above?
2. Is there a software package that will do this task?
3. When it comes to calculating CGT, when I go to sell, is it assumed that I am selling the earliest batch first and then working forward from there as I sell more?
Appreciate any thoughts.
I get shares in a publicly listed company and have been for 25 years. For simplicity purposes, I get 1000 shares each year so therefore my holding is 25,000. Each year the purchase price is different. On occasion I sell shares in small tranches, for example, 200 or 1500. My questions are as follows:
I have been using Excel to try and record transactions from a tax perspective but it is getting very cumbersome. For example, each sale may have different purchase price amounts within the batch. CGT calculation is (slightly) tricky but how the overall share portfolio is deceasing is difficult to track.
My questions are as follows:
1. Does anyone know of an Excel template that will elegantly record the scenarios above?
2. Is there a software package that will do this task?
3. When it comes to calculating CGT, when I go to sell, is it assumed that I am selling the earliest batch first and then working forward from there as I sell more?
Appreciate any thoughts.