Just set your own spreadsheet up, it's not difficult.These are...

  1. 22,856 Posts.
    lightbulb Created with Sketch. 1259
    Just set your own spreadsheet up, it's not difficult.

    These are the rows I use in my spreadsheet
    Purchase date
    Sale date
    Days held (calculation Sale date less purchase date)
    Purchase Cost (calculation unit × purchase price)
    Brokerage Cost
    Total Cost (calculation PC + BC)
    Purchase price
    Units
    Sale price
    Gross proceeds (calculation SP X units)
    Commission
    Net proceeds (calculation GP - Commission)
    Net profit / loss (calculation NP - Total Cost)

    I find that records all the information I need.
    You just then need to add up each column with regard to gains, losses & those sold after holding after a year or before.

    If you sell only part of your holding just split the column pro rata in multiple columns.

    If you trade REITs or other shares with deferred taxation distributions then you need to keep a record of those separately to adjust the cost base.

    I also record the brokerage reference number as a note in the spreadsheet so I can find the contract note easily if necessary.

 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.