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
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Wasron,jfgw,Rhyd6,eyeball08,Wondergirly, for Donating to support the site
Capital Gains Tax spreadsheet
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Capital Gains Tax spreadsheet
Cookie wrote:
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
-
- The full Lemon
- Posts: 18938
- Joined: November 4th, 2016, 3:58 pm
- Has thanked: 636 times
- Been thanked: 6677 times
Re: Capital Gains Tax spreadsheet
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.
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.
Who is online
Users browsing this forum: No registered users and 29 guests