Australia's largest stock trading and investment forum Australia's #1 stock forum

Hi Alan and welcome to HC.Spreadsheets may be pretty easy to...

First 30 Last

Share
Profile

Follow
Veritas2000

12,542 Posts.

1033

20/06/21

11:09

Post #: 53949054
Share
Originally posted by alanhoward: ↑

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.

Expand

Hi Alan and welcome to HC.

Spreadsheets may be pretty easy to some but others have trouble with it - after all we can be masters of everything.

Cheers

V
Upvote

0 Great analysis

Reply

There are more pages in this discussion • 20 more messages in this thread...

First 30 Last