Capital Gains Tax spreadsheet

[Cookie]

Before reinventing the wheel, does anyone have a spreadsheet for calculating CGT they use or is one available elsewhere,

Both for property and for equities

Thanks

[Itsallaguess]

Before reinventing the wheel, does anyone have a spreadsheet for calculating CGT they use or is one available elsewhere,

Both for property and for equities

I've had this link in my bookmarks for quite a while now -

http://www.cgtcalculator.com/

It's got a calculator and lots of worked examples, but I think it's only applicable to equities unfortunately, and I've never had the need to seek out anything for property.

Cheers,

Itsallaguess

[Lootman]

For equities, I use a very simple spreadsheet that is refreshed each tax year. It basically has a new row created each time I make a sale (or a purchase for a short position). And it has a column for each of the following data items:

Date of sale
Security identifier and name
Net cost basis for the lot sold
Net proceeds for the lot sold
Profit or loss (derived)

You can optionally include number of shares sold and the original purchase price, which are on the tax form but which are not required by HMRC. I don't bother.

It's a sufficiently simple spreadsheet that I don't think you need to copy a boilerplate one. Just draft your own.

For properties it's the opposite. Very few transactions (presumably) but a lot of data to record for each property e.g. past capital expenditure and the details of the original purchase. So in that case I'd probably have a file for each property rather than a spreadsheet. If the property was only partly rented and partly owner-occupied, then you need to keep records of that with dates.