UKCGT – UK Capital Gains calculator
Now with ERI LookUp which can reduce your tax bill!
A free and automated alternative to the well-respected cgtcalculator.com calculator but also includes ERI calculations. Simply select all your downloaded broker .csv transaction files (use Ctrl+Left-Click in ‘Choose files(s)), you must include all trades for all the years since you first opened the account(s) up to at least the 6th May or later (30 days past end of last tax year) – set a Tax year (optional) – then click ‘CALCULATE’. If you wish to also add ERI dividends for offshore ETFs (e.g. if you have accumulating and distributing ETFs), they can be calculated and added into the Trades form by using the ERI Lookup tool. Stock splits are handled for some brokers, e.g. T212 (contact me if any issues). Unlike cgtcalculator.com, ukcgt.xyz can also lookup and include ERI – if you are a basic rate tax payer, this can reduce your tax bill!
Supports .csv files for: Trading 212, Freetrade, Barclays (.xls must be converted to .csv first), Interactive Brokers, Interactive Investor, Hargreaves Lansdown, LightYear/Sharesight, AJ Bell and cgtcalculator.com text files.
If your broker is not supported (UK only), please send me a sample of your csv and I will add in support within a few days.
Notes: no tax rate, annual exemption, loss carry-forward, spouse transfer, option, reorganisation, or pre-6-Apr-2008 special handling is included.
This page does not submit trade data anywhere. It has no external scripts, analytics, or browser storage. Interactive Investor and Trading 212 rows with non-GBP values request historical Bank of England FX/GBP rates via Frankfurter; Convert to tickers requests matching symbols using the optional server helper. Calculation sends sold ticker symbols and available company names to the AIM helper, which checks current Stock Analysis AIM listings and Yahoo Finance cross-exchange matches and caches market status on the server. No trade dates, quantities or amounts are sent to the AIM helper.
Accepted Formats
Accepted lines include cgtcalculator.com style B/S date company shares price costs tax,
POOL_ADJ date ticker pool-quantity signed-cost-adjustment (or use POOL; positive adds cost; negative reduces cost, without changing shares; applied after that day’s trades; quantity must be within 5% of the current Section 104 pool),
converter formats date company shares price total and date buy/sell company shares price total,
Lightyear/Sharesight CSV format Date, Type, Ticker, ISIN, Quantity, Price, Currency, Total, Fee, FX Rate,
Trading 212 CSV exports with Action, Time, Ticker, No. of shares, Price / share, Exchange rate, Total (GBP),
Freetrade CSV format Title, Type, Timestamp, Account Currency, Total Amount in Account Currency, Buy / Sell, Ticker, Quantity, FX Rate,
Interactive Brokers CSV format with Transaction History,Header,Date,Account,Description,Transaction Type,Symbol,Quantity,Price,Gross Amount,Commission,Net Amount and GBP base currency,
Interactive Investor CSV format Date, Symbol, Quantity, Debit, Credit including USD Debit/Credit values marked with $,
Hargreaves Lansdown CSV format Trade date, Settle date, Reference, Description, Unit cost (p), Quantity, Value (GBP),
Barclays CSV format (please save .xls as .csv in Excel first) Investment, Date, Order Status, Account, Buy/Sell, Quantity, Cost/Proceeds, Country,
AJ Bell GBP CSV format Deal date, Time, Settlement date, Type, Instrument, Sedol/ISIN, Venue, Quantity, Price, Consideration, Charges, Total Consideration,
AJ Bell CSV format Date, Type, Description, Quantity, Price, Net Consideration, Charges, Total Value, Reference,
and AJ Bell CSV format Date, Transaction, Description, Quantity, Price, Amount (GBP), Reference.
Add .L to any ticker to prefer its London listing (AIM or LSE). Use .AIM to force Unlisted shares (AIM) reporting, e.g. AT.AIM. Use the same ticker on all trades and adjustments for that holding.
Ticker warning
WARNING: Descriptions found instead of tickers! All identical shares must use identical ticker symbols. Use the ‘Convert to tickers’ button to change the descriptions to ticker names. Manually check for any errors.