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)
- Forums
- ASX - General
- cgt and tax time
cgt and tax time, page-8
-
- There are more pages in this discussion • 4 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
Featured News
The Watchlist
SBW
SHEKEL BRAINWEIGH LTD
Dani Nadri, Country Manager Australia
Dani Nadri
Country Manager Australia
SPONSORED BY The Market Online