Example of spreadsheet rows for a typical retail investor with two share broker GIA accounts, a crypto account, a CFD account and two bank savings accounts. Some figures can be obtained from tax year annual reports, some from UKCGT.
CAPITAL GAINS
Listed shares Capital Gains (from UKCGT – broker 1 + broker 2)
Unlisted shares Capital Gains (from UKCGT – broker 1 + broker 2)
Crypto Capital gains (should use a calculator which includes HMRC same-day and 30-day rules)
Other property, assets and gains – CFD Capital Gains (gains/loss from broker report)
UK INTEREST
Broker 1 interest on share lending (from broker 1 report)
Broker 1 interest on cash (from broker 1 report)
Broker 2 interest on cash (from broker 2 report)
Bank savings interest #1 (from bank report)
Bank savings interest #2 (from bank report)
UK DIVIDENDS
Broker 1 GIA (from broker 1 report)
Broker 2 GIA (from broker 2 report)
FOREIGN INTEREST – interest and other income from overseas savings
ERI interest (from UKCGT) – e.g. CSH2 money market fund
FOREIGN DIVIDENDS (itemised by country) – notional ERI and distributed (paid out) dividends
IRL notional ERI (from UKCGT – broker 1 + broker 2)
LUX notional ERI (from UKCGT – broker 1 + broker 2)
IRL Broker 1 ETF (from broker 1 report)
IRL Broker 2 ETF (from broker 2 report)
IRL Broker 2 Companies (from broker 2 report)
GER Broker 2 Companies (from broker 2 report)
CAN Broker 2 Companies (from broker 2 report)
USA Broker 2 Companies (from broker 2 report)
NLD Broker 2 Companies (from broker 2 report)
Other categories of taxable income:
- Employment: salary, bonuses, commission, tips and taxable benefits such as a company car or private medical cover.
- Pensions
- Property: rent from a UK or overseas property, holiday lets, or income from letting a room (some reliefs may apply).
- Side Hustles, online or occasional work: freelancing, tutoring, delivery work, selling services, or paid content and subscriptions, YouTube income, eBook sales. “Buy Me a Coffee” payments may be taxable if they’re connected to your work or content; genuine personal gifts are different.
- Royalties and licensing: books, music, photography, software, patents or other intellectual property.
- Trusts, estates and settlements: income paid or allocated to you.
- Benefits and compensation: some state benefits, redundancy or termination payments, and certain insurance or legal settlements can be taxable, depending on the type and circumstances.
Note: I am not a tax advisor – please do your own research or employ an accountant if you are unsure!