HMRC requires you to calculate and report Excess Reportable Income (ERI) for all reporting funds (e.g. distributing and accumulating ETFs) – more info on ERI here and here. UK Basic rate tax payers could pay less tax overall when they include ERI in their calculations. This app. finds the ISIN number of each stock ticker (typically offshore ETFs), then ensures that it is a valid reportable fund by checking the current HMRC Approved Funds list and then looks up the ERI if you held the stock on it’s reporting date. Then it finds the published ERI for that reporting date and the Fx rate on the distribution date and calculates the total ERI for the quantity of shares held on the reporting date. ERI data is often hard to find, especially for past years because it is published only on the providers site but KPMG also have a manual ERI search facility. Note that most broker annual tax year reports (Trading 212, AJ Bell, etc.) do not include ERI and are thus are not suitable for HMRC Self Assessment forms.
INSTRUCTIONS:
1. Paste Trades from the UKCGT.xyz main calculator page into the Trades box below (uses cgtcalculator.com format) – you can use the home page to load and convert your broker .csv files into cgtcalculator.com format and then use the ‘Copy trades’ button.
2. Choose a Tax year initially and click ANALYSE (may take several minutes – watch the analysis window, ‘ALL’ years will take considerably longer but this is a quick pre-run test to cache ticker lookups!).
Note: For CG calculations you should use ‘ALL’ to find all excess income (unpaid interest and dividend income). To save an ERI tax year report PDF – change ALL to the tax year.
If there is missing ERI data you can use your own ERI lookup Excel file:
…. 2a. Download the current UKCGT template ERI Lookup file using the ‘Download UKCGT_ERI_Lookup.xlsx‘ button.
…. 2b. Use the KPMG ERI Lookup buttons on this page to manually find any missing ERI for the tax years that you held ETFs on – after clicking an ERI lookup button, type Ctrl-V to paste the ISIN number from the clipboard into the KPMG search box to find the ERI rate for each share. You can instead use AI or other methods to find the ERI rates and other data if necessary.
…. 2c. Edit and add new rows with the missing ERI data into the downloaded user .xlsx lookup file. Tax type can be DIVidend or INTerest (bonds/moneymarket type funds will be INT). HMRC ref can be omitted but if included then it must match (check Analysis log)
…. 2d. Use the ‘Load User ERI Lookup‘ button to use your new file and tick the ‘Use User ERI Lookup‘ box to use your file. You can keep and use the same file next year – your file is NOT stored by UKCGT.
3. Set ALL trade years and click ANALYSE and wait. Check for missing ERI lookups – edit your ERI_Lookup xlsx file if required.
4. Click ‘Add to UKCGT trades’ in the ERI Data section – this sends all the DIVIDEND entries to the Trades box in your already-open UKCGT calculator page.
5. Click ‘Calculate‘ on the calculator page again to add them into your cost base. The ERI dividends will then be added to the cost of your trades and thus it will reduce your capital gain on any stock sale.
ERI for the tax year should also be reported to HMRC – use the table in the Summary box. Use SA106 for Foreign dividends and Foreign Interest on your HMRC Self-Assessment return if above £500. Select the tax year and then use ‘Save as PDF’ to attach the file to your HMRC self-assessment submission.
Missing ERI? If you find any ERI Reportable Income information for a particular ISIN and year which ukcgt.xyz has failed to find, please inform me with as many details as possible and I will try to add in support. Note: Provider’s ERI reports may not be available until 6-12 months after the Reporting date. Provider ERI Reporting documents are often very difficult/impossible to find on some providers sites . The user ERI lookup file allows you to save and reuse your ERI data each year!
Version v5.45 PHP – 13 November 2026 – Reports which funds in your portfolio you held on their reporting date and thus notional ERI may need to be declared.
Approved offshore reporting funds: HMRC download page
Yahoo lookups use the Check_ERI_api.php proxy when direct browser access is blocked.
External ISIN lookup URL:
Trades
Trades should be in cgtcalculator.com format
ERI Lookup
Click on each KPMG ISIN Lookup button to look up the ERI for each share and tax year. A free sign-in is required on first access to KPMG. Paste (Ctrl-V) the ISIN in and select the correct tax year to find the ERI.