Interactive Investor CGT: upload your transaction listing, get an HMRC report
Interactive Investor does not work out your Capital Gains Tax — a trading-account disposal is yours to report on SA108. Our CGT Calculator now reads the ii transaction listing CSV: a debit/credit cash ledger with no action column, where every row’s meaning has to be read out of its description. The parser does that reading for you.
What each row becomes
| Row in the export | What it becomes |
|---|---|
Rows with a Symbol and SEDOL | Acquisitions (Debit) and disposals (Credit), matched under the same-day, 30-day and Section 104 rules |
Div … UNITED KINGDOM(GOVERNMENT OF) | A gilt coupon — savings interest, not a dividend |
GROSS INTEREST | Interest on uninvested cash |
578 U.S. DOLLARS … | A currency purchase — an FX acquisition at the pounds you paid |
Scheme of Arrangement | A cash-takeover disposal, sized from the shares your trades show held |
PBB PAYMENT | Cash funding — skipped, not a taxable event |
The ledger settles in sterling, so no FX conversion is involved in the trades themselves. A row the parser does not recognise is flagged with a warning, never silently dropped.
Gilts are exempt — and the export never says so
Gilt disposals are exempt from CGT under s115 TCGA 1992, but an ii export identifies a gilt only by its SEDOL — no ISIN, no “this is a gilt” marker. For a UK security the ISIN is derivable: GB00 plus the SEDOL plus a check digit. We derive it, match it against the UK Debt Management Office register, and the disposal comes out exempt — the trade still shows in the report, with a note saying why it is not in the gain.
The “Div” that is not a dividend
A gilt coupon arrives in the ledger labelled Div, as if the Treasury had paid you a dividend. It has not: gilt interest is savings income, taxed against the personal savings allowance, not the dividend allowance — a different box on the return. The same registry match that makes the disposal exempt also reroutes the coupon to interest, so the income lands where HMRC expects it.
How to export your transaction listing
- Sign in to ii.co.uk, open the account and go to Transactions.
- Set the date range to cover your full UK tax year (6 April to 5 April).
- Download the CSV and upload it as it downloaded.
Export the trading (general investment) account. ISA and SIPP gains are outside CGT, so those accounts have nothing to report.
What is not handled yet
- Corporate actions. A scheme-of-arrangement cash-out is recorded as a disposal. The ledger omits the share count, so the calculator sizes it from the shares your uploaded trades show held on that date — include the export that covers the purchase, and check the figure against the contract note.
- Missing purchase history. A sale with no matching buy is excluded with a warning, never booked at £0 cost; add the earlier purchase to complete it.
The parser is in beta — check the result against your own records.
Sources
- TCGA 1992 s.115 – exemption for gilt-edged securities
- CG54900 – HMRC Capital Gains Manual on gilt-edged securities
- SAIM2440 – interest on gilts is savings income
- Individual Savings Accounts – GOV.UK, on the tax treatment of an ISA