Hi,
Capital gains tax is a separate tax to income tax and do not mix in any way.
Any unused annual exempt allowance (AEA) can be set against other gains arising in the same tax year.
The unused AEA cannot be carried forward or back or set against income tax.
Unused personal allowanced cannot be set against capital gains tax.
There is no spreadsheets or other type of file to support your evidence.
It is up to you how to record the evidence, with the spreadsheet merely being nothing more than an example. Create your own version.
You can contact our self assesment helpline on +441619319070 from outside the UK (this overseas number will not work if you are in the UK) or contact our webchat facility at:
Contact HMRC
Monday to Friday 8am to 6pm Closed on weekends and bank holidays.
Thank you.