cgt and tax time, page-8

CGT accounting is hard work with split trades.

It is easy to do but time consuming.

Step 1: Paste your trading history into a spreadsheet or download it via spreadsheet.

Step 2. Insert a new column on the left and then cut and paste your transaction dates column into that new column.

Step 3. Then using the "sort" function, sort the whole spreadsheet into chronological order, from earliest to latest.

Step 4. Insert a new column on the left and then cut and paste your shares code column into that new column and sort by alphabetical order.


As a result, you will have your shares in alphabetical order and from the earliest date to the latest.

Then comes the hard work of split.

Here one uses the formula function. Eg below:



For 1,000 TTY sold, i had to split from the lot of 3,000, using the formula =PRODUCT(E557,1/3)