Reporting Funds
The reporting funds section lists all of the offshore fund assets in the system with a reporting status of Reporting. It allows you to input the excess reportable income (ERI) for each of these funds. All reporting funds must report ERI, regardless of if they are distributing or not (though often the excess reported income is zero for distributing funds). See Reference Data for how ShareCalc uses HMRC's list to identify funds and propose reporting status.
The system attempts to validate the data for each reporting fund and displays the status, with a valid status indicating that data in the system cover the full period of the ownership of the fund, with no gaps, except for the last 12 months. The system allows missing data in the last 12 months as most reporting funds report every 12 months (and that is the maximum length of period that can be reported) so at any given time there is up to a 12 month period where the data is not known. Note that ERI does impact disposals from the reporting period end date so it is possible that this delay means you are missing information required to submit your tax return on January 31.
Use the Add Period link on a fund's row to add a period for that fund, or the Add Period button at the top to pick the fund yourself. When the fund already has periods, the form is prefilled with the next annual period (starting the day after the latest one ends) and the same currency and distribution type, so usually only the ERI amount needs entering. The fields are:
- Fund: the reporting fund
- Period End: the end date of the reporting period
- ERI amount per unit: the amount of ERI per unit held of the reporting fund. This is the amount that the fund will report and will be used to calculate your ERI based on how many units you hold at the end of the reporting period (in combination with any anti-avoidance rules that apply).
- ERI currency: the currency asset of the ERI. These are the same as the currency assets you have in the system. If the currency does not exist yet, type its ISO code (e.g. USD) and pick the Create currency row to add it.
- Distribution type: the type of income from the fund for the reporting period, which should be reported by the fund.
- Period Start: derived automatically as the 12 months ending on the period end. Use Override to enter a different date (for example a short first period) and Reset to auto to go back.
- Distribution date: the date the distribution is treated as being made. Derived automatically as six months after the period end, which is the fund distribution date under the offshore fund regulations; override it only if the fund reports a different date.
- Equalisation amount (optional): your total equalisation for the reporting period, denominated in the ERI currency. This is the total equalisation for the period, not an amount per unit.
A period cannot be saved if the fund already has a period ending on the same date (edit that one instead) or if it overlaps another of the fund's periods.
Bulk Import
You can import multiple ERI records at once using the Bulk Import button. This accepts a CSV file with the following format:
asset,period_end_date,eri_currency,eri_amount,distribution_type,period_start_date,distribution_date,equalisation_amount
The first five columns are required. The last three columns are optional; the two dates will be filled in with sensible defaults if omitted:
| Column | Required | Description |
|---|---|---|
| asset | Yes | The symbol, ISIN, CUSIP or SEDOL of the reporting fund. The value is interpreted depending on the type of identifier it is: a valid ISIN, CUSIP or SEDOL is matched on that identifier, anything else on the symbol. Must match exactly one existing offshore fund asset with a reporting status of Reporting. |
| period_end_date | Yes | The end date of the reporting period (YYYY-MM-DD). |
| eri_currency | Yes | The currency symbol (e.g. GBP, USD, EUR). If the currency does not exist in your account, it will be created automatically. |
| eri_amount | Yes | The ERI amount per unit (positive number). |
| distribution_type | Yes | Either DIVIDEND or INTEREST. |
| period_start_date | No | The start date of the reporting period (YYYY-MM-DD). If omitted, defaults to 12 months before the end date (e.g. if the end date is 2024-12-31, the start date defaults to 2024-01-01). |
| distribution_date | No | The distribution date (YYYY-MM-DD). If omitted, defaults to six months after the end date (e.g. if the end date is 2024-12-31, the distribution date defaults to 2025-06-30). |
| equalisation_amount | No | Your total equalisation for the reporting period, denominated in eri_currency. This is a holder total, not an amount per unit, and must not be negative. |
A header row is optional and will be detected and skipped automatically.
Examples
asset,period_end_date,eri_currency,eri_amount,distribution_type,period_start_date,distribution_date,equalisation_amount
VWRL,2024-12-31,GBP,0.1234,DIVIDEND,2024-01-01,2025-06-30,25.50
VWRL,2023-12-31,GBP,0.0987,DIVIDEND,2023-01-01,2024-06-30,18.75
asset,period_end_date,eri_currency,eri_amount,distribution_type
VWRL,2024-12-31,GBP,0.1234,DIVIDEND
VWRL,2023-12-31,GBP,0.0987,DIVIDEND
To supply equalisation while using the default dates, leave both optional date columns empty:
VWRL,2024-12-31,GBP,0.1234,DIVIDEND,,,25.50
Behaviour
- Partial import: each row is processed independently. Valid rows are imported and invalid rows are skipped, with errors reported for each failed row.
- Overwrites: if a row in the CSV has the same reporting end date as an existing period for the same asset, the existing record is replaced with the new one. If the row is exactly the same as the existing period then it will show as skipped.
- Overlapping periods: If a row has a different period end date as an existing period, but overlaps the period of an existing period, then that row will fail to import.
- Duplicates: If there are multiple rows for an asset with the same period end date in a file, only the first row will be processed.
- Invalid rows: Any rows with invalid values (e.g. negative ERI amount, period end date before the start date, etc) will be skipped and an error will be reported.
- Currency auto-creation: if a currency symbol in the CSV does not exist in your account, a new currency asset is created automatically.