Hi Redsky
In Comsec Application
1) Click My Portfolio
2) Click Confirmations
3) Click Download (Next to Sort by Contract Number)
4) Open file in Microsoft Excel
5) Delete all transactions that were not in current Financial Year
6) Sort all Transactions into Buy/Sell Column (B/S)by using sort function in excel
7) Isolate all of the Buy orders and the Sell orders
8) Match the Buy orders with the sell orders by cutting and pasting the Sell line next to the corresponding buy line. I dont change any format or delete any columns (ie Contract # Field)
9) Use a simple formula to calculate net loss or gain (Involving Net Proceeds ... You may want to manually check a Capital Gains Transaction to see if your formula is right)
10) Total all Gains and Losses using Autosum.
- Forums
- ASX - General
- another tax question
another tax question, page-3
Featured News
Featured News
The Watchlist
AGC
AUSTRALIAN GOLD AND COPPER LTD
Glen Diemar, MD
Glen Diemar
MD
SPONSORED BY The Market Online