Forum

Please or Register to create posts and topics.

ERI lookup user file load feature

I have now added a user lookup file feature.

If UKCGT.xyz cannot find the ERI data for any offshore reporting fund, you can create your own Excel file with the missing ERI data and load it into UKCGT.xyz.

The data is not stored by UKCGT.xyz and cannot be accessed by other users.

This allows you to use the file each year.

The user file is used first by UKCGT.xyz so it will also increase lookup speed.

It is really annoying that many ETF providers do not seem to publish their fund ERI data or make it easy to find and parse.

I can add providers xlsx/pdfs  into ukcgt.xyz, so if you find any missing reporting ERI files, please let me know.

 

On 20th October 2026 I have now added a new 'Add KPMG Data' button. This makes it easy to add ERI data to your own local ERI data xlsx file.

After running an Analyse on your Trades, some ERI data may be missing.

  1. Click on one of the KPMG buttons (there will be one  for each missing ticker and tax year if any lookup has failed)
  2. A new browser KPMG search tab will open - use Ctrl-V to paste in the ISIN number and click on the tax year you need
  3. When the KMPG page loads the ERI data, type Ctrl+A and then Ctrl+C to copy the page contents into the clipboard
  4. Now in the ERI_Lookup page, click the UKCGT_ERI_Lookup.xlsx button to download a local copy of the UKCGT overrides data file.
  5. Click 'Load user ERI Lookup' to load the file and click 'Add KPMG Data'
  6. Paste the data on the clipboard from the KMPG data page in step 3 into the new form and click 'Parse and add row' - it should parse the data for that tax year and add a new row. No need to manually add all that data!
  7. Check all fields in the new row and edit, if required. The new data will be remembered but before quitting UKCGT.xyz, you should use the 'Save user XLSX' button to save a local copy of your own version of UKCGT_ERI_Lookup.xlsx for future use.
  8. You will usually need to add a new row for each year (reporting date/distribution date). Sometimes (rarely), a fund may have more than one reporting date within 12 months.

You can close the KPMG window without saving to a file and re-open it and your data rows will be remembered, but you must save it to a file between browser sessions or reloads.

To use your new ERI lookup file, don't forget to tick the 'Use User ERI Lookup' checkbox.

If UKCGT cannot determine the income class (interest or dividend) then you can use your local ERI lookup file and add just the ISIN number and the Tax Type (INT\DIV) cell data to one new row for each ticker.  You don't need to add any dates.

 

 

Scroll to Top