UK CGT Calculator for Vanguard

Upload your Vanguard Client Transaction Listing. Get the tax year’s gains, SA108 boxes and a PDF.

Client Transaction Listing.xlsx
  1. 07/08/2025Account Fee for the period 08-May-2025 to 07-Aug-2025-16.309,838.39
  2. 01/09/2025Cash Account Interest5.959,844.34SA100 interest
  3. 16/09/2025Bought 50 FTSE 100 UCITS ETF - Distributing (VUKE)-1,890.00-1,897.507,954.34Same-day match
  4. 16/09/2025ETF dealing fee (buy) FTSE 100 UCITS ETF - Distributing (VUKE)-7.507,946.84
  5. 16/09/2025Sold 100 FTSE 100 UCITS ETF - Distributing (VUKE)3,820.003,812.5011,766.84Same day + pool
  6. 16/09/2025ETF dealing fee (sell) FTSE 100 UCITS ETF - Distributing (VUKE)-7.5011,759.34
  7. 24/09/2025DIV: VUKE.XLON.GB @ GBP 0.245036.7511,796.09SA106 dividend
Capital Gains Tax ComputationTax year 2025/26Self Assessment schedule
SA108 box 24 · Disposal proceeds
£39,936
SA108 box 25 · Allowable costs
£33,847
Dealing fees in the figures
£67.50
ERI added to pool cost
£609.63
SA100 · UK interest
£46.63
Net chargeable gain
£6,089.51
PDF ready

Vanguard Export, in 4 Steps.

Upload the Client Transaction Listing .xlsx as it downloads. Every account tab is read; ISA, Junior ISA and SIPP tabs are skipped.

  1. Log in to Vanguard Investor UK
  2. Go to Documents → Report generator
  3. Choose Client Transaction Listing Excel and a date range covering your full UK tax year (6 Apr – 5 Apr)
  4. Upload the downloaded .xlsx workbook

Vanguard and Your Other Brokers.

Upload every broker’s file together and get one report,
each sale tagged with where it came from.

PDF
PDFSA108-ready
PDF

Summary + SA108 boxes

FAQ

Which Vanguard file do I upload for UK tax?

+

The Client Transaction Listing from Documents → Report generator, as the .xlsx downloads. Every tab is read: the General Account produces the report, and ISA, Junior ISA, SIPP and Summary tabs are skipped and named. Set the date range from your first buy, not from 6 April: the cost of what you sell comes from your whole buying history (HS284).

Do I pay Capital Gains Tax on Vanguard?

+

In a General Account, yes, once the tax year’s gains go above the £3,000 annual exempt amount. Gains inside a Stocks and Shares ISA, Junior ISA or SIPP are tax-free, which is why those tabs of the workbook are left out.

Is the £7.50 ETF dealing fee included in the cost?

+

Yes. Vanguard charges it on a live quote-and-deal ETF trade, on a cash row of its own, so the fee is paired with its trade by date, fund and side. It is an incidental cost of the deal (TCGA92 s38): added to the cost of a buy and taken off the proceeds of a sale. Bulk-dealt ETFs and Vanguard’s own funds carry no fee, and a fee row with no trade to claim it is reported.

Is the quarterly Account Fee allowable?

+

No. The platform fee is a cost of holding the account, not of buying or selling a fund, so it never enters a pool. Deposits, withdrawals and bank transfers are passed over the same way.

The workbook has two tables. Which one is used?

+

Both are read, and the Cash Transactions table decides. Its date is the day you dealt, which is the date HMRC uses (TCGA 1992 s28), and its Amount is the money that moved. The Investment Transactions table settles two days later and rounds the price to four decimals, so its copy of each trade is dropped and the price is always amount divided by quantity.

Is excess reportable income handled for accumulating ETFs?

+

Yes. The file carries no ISIN, so each Vanguard fund is resolved to its ISIN from Vanguard’s own fund list, and the excess reportable income for each reporting date is taxed as income and added to the pool cost, so a later gain is not overstated. A name that could be one of several share classes is left unresolved and warned about; add the ISIN on the edit page. Vanguard’s UK-domiciled funds, such as LifeStrategy, report no ERI.

Are dividends and cash interest reported?

+

Yes. A DIV row is a dividend at the sterling amount Vanguard paid, and Cash Account Interest is UK savings interest for the SA100, set against your personal savings allowance. Neither is a capital gain.

What if I sell a fund and buy it back within 30 days?

+

The sale is matched to the buy-back rather than to your Section 104 pool (HS284), and a sale on the day of a buy is matched to that buy first. The High Dividend Yield ETF in the example, sold on 18 November and bought back on 2 December, is matched that way.

How are fractional fund units handled?

+

As they are. Vanguard prices its own funds in units to four decimal places, and a part-sale takes its share of the pool cost at average cost, so 14.1439 units sold out of 28.3447 carry exactly that fraction of what they cost.

I moved holdings from my General Account into my ISA. Is that a disposal?

+

Yes, at market value: a Bed & ISA is a sale for CGT even though no cash reaches you. The workbook does not record it as a trade, so a row that names a holding and a transfer is flagged with the date and quantity, and any row that cannot be read is named rather than dropped. Add the sale on the edit page at that day’s price.

Why was my workbook refused?

+

Because it did not add up. Vanguard’s running Balance column is checked row by row, and the Cost footer against the trades: a sheet that is out by a penny is refused by name rather than turned into a report we cannot stand behind. Open the workbook, save the account tab as a CSV with both tables in it, and upload that; a hand-saved CSV is only warned about.

Can I combine Vanguard with another broker?

+

Yes. Upload the files together. An ETF is one pool however many brokers hold it, so the S&P 500 ETF at Vanguard and at Trading 212 are costed as one holding, and the 30-day rule runs across both. A Vanguard fund with no ticker is pooled under its name.