I'm new here, but this thread interested me because I use a...

  1. 11 Posts.
    I'm new here, but this thread interested me because I use a spreadsheet too. I think it's pretty easy for anyone to create their own spreadsheet for profit/loss and taxation purposes, no need for a professionally purchased one. Every year I send my accountant a spreadsheet that has:

    • a shares cost section which includes the details and the cost of purchased shares plus brokerage fees
    • a shares income section which includes the details and income of sold shares minus brokerage fees
    • loss/gain as well as % growth against each of the shares
    • other costs section, which I use for subscription costs related to a charts website I use
    • other income section, which I use for dividends

    At the bottom, I put everything together to show total costs, total income, and total profit/loss. I only do short term trades so that my activity is treated like a business, and my profit/loss is added to my other income (eg. day job) for tax purposes. I don't do long term investments so I avoid CGT.
    Last edited by alanhoward: 20/06/21
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.