tax return and share trading, page-7

For CGT accounting, you only calculate the shares sold during the year.

But when you are a trader, you calculate the profit and loss on all shares because you must calculate 'closing stock'.

So for CGT:

1. download you annual trading from your share trading account in an Excel Sheet

2. Make sure the download is in date order, from earliest to latest

3. Then insert a column to left and cut and paste the share codes into that far left hand column

4. then sort the whole sheet A - Z

5. then carefully calculate the gain or loss for each share sold, using the Excel formula function. You can choose any buy to match the sale.

6. mark those shares held for over 12 months

7. take your spreadsheet and accounts to your accountant to work out the CGT gain or loss

the sheet should look like this: