AJ Bell CGT: upload your transaction history, get an HMRC report

product-updates

AJ Bell does not work out your Capital Gains Tax — a Dealing-account disposal is yours to report on SA108. Our CGT Calculator now reads the AJ Bell Transaction history CSV: seven columns, everything in sterling, and no fee column anywhere in it. That last part is the interesting one.

What each row becomes

Row in the exportWhat it becomes
PurchaseAn acquisition at the cash that settled — the price paid plus the dealing charge
SaleA disposal at the cash you received, matched under the same-day, 30-day and Section 104 rules
InterestInterest on uninvested cash — savings income, not a dividend
Custody ChargeCash out. A platform fee is not an allowable CGT cost, so it is excluded from the gain
Debit Card PaymentCash funding — not a taxable event
Accumulation DistributionNot booked. The fund is named in a warning instead — see below

A row the parser does not recognise is named in a warning, never silently dropped — a dropped row is money missing from your report with nothing to tell you it went.

The dealing charge is in the file — just not in a column

AJ Bell states the quantity, the unit price and the cash that settled, and the charge lives in the gap between them. A real example from the export we built this against: 193 units at £37.167118 is £7,173.25 of consideration, and AJ Bell took £7,178.25 — the £5.00 online dealing charge, to the penny. That is an allowable incidental cost of acquiring the shares under s38 TCGA 1992, so it belongs in your cost, and it is already there because the settled cash is what we book.

The same arithmetic on a fund recovers the £1.50 fund charge. But it does not always work, and where it cannot we say nothing rather than invent a figure: a fund priced at £570.7331 a unit has its quantity printed as 0.66, so the true unit count — and the consideration with it — is only knowable to about £2.85 either way. The £1.50 charge inside that cannot be separated from the rounding, so no charge is shown on that row. Your gain does not move either way: the cash AJ Bell settled is the cost, charge and all.

A worked disposal

One ETF, bought twice and sold once. 193 units for £7,178.25 and 2 more for £79.66 make a Section 104 pool of 195 units at £7,257.91. Selling 28 of them releases 28/195 of that cost — £1,042.16 — against proceeds of £1,583.66, which is the £1,588.66 the units fetched less the £5.00 charge on the way out. The gain is £541.50, and the pool carries on with 167 units and £6,215.75 of cost. Every figure there is asserted in our test suite against both of our calculation engines. See how Section 104 pooling works if the averaging is new to you.

No ISIN, so holdings are pooled by name

The export carries no ticker, no ISIN and no SEDOL — the fund name AJ Bell prints is the only thing identifying a holding, so that is what we pool on. Two consequences worth knowing. If the same fund appears under two spellings across your exports, give both the same name on the edit page and they pool as one. And if you hold the same fund at another broker, the two will not pool, because a fund name cannot be matched to the symbol or SEDOL the other broker uses — HMRC treats them as one holding, so upload both and we warn you rather than let a split cost basis pass in silence.

How to export your transaction history

  1. Sign in to ajbell.co.uk in a desktop browser (the mobile app and Dodl have no CSV download) and choose your Dealing account under View account.
  2. Click My account → Documents and statements → Transaction history.
  3. Set the date range to cover your tax year (6 April to 5 April) and any earlier years in which you bought shares you still hold.
  4. Click the download icon above the table — the print icon next to it gives a PDF — and upload the CSV.

Export the Dealing account only. ISA, Lifetime ISA and SIPP gains are tax-free, so those accounts have nothing to report.

What is not handled yet

  • Accumulated fund income. An accumulation fund rolls its income into the unit price and reports it as Accumulation Distribution, paired with Equalisation Acc Units. How those two net off turns on a reading of HMRC’s CG57707 we have not settled, and guessing would misstate both your dividend income and every later disposal of that fund — so we book neither and name every affected fund in a warning, with both amounts. Those pools are understated, which shows a later gain too high.
  • Excess reportable income. ERI attaches through a fund’s ISIN, which this export does not carry. Add the ISIN on the edit page for any ETF or offshore fund and it applies.
  • Options and corporate actions. Not parsed — any row we do not recognise is flagged, so you can see what to add by hand.

The parser is in beta — check the result against your own records.

Sources