Reporting Funds
The reporting funds section lists all of the reporting fund assets you have in the system. 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).
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.
You can use the Add button at the bottom to input ERI with the following fields:
- Asset: the reporting fund
- Start Date: the start date of the reporting period
- End Date: the end date of the reporting period
- Distribution date: the date the distribution is treated as being made, which should be six months after the end date
- Income type: the type of income from the fund for the reporting period, which should be reported by the fund.
- ERI currency: the currency asset of the ERI. These are the same as the currency assets you have in the system.
- 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).
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
The first five columns are required. The last two columns are optional and will be filled in with sensible defaults if omitted:
| Column | Required | Description |
|---|---|---|
| asset | Yes | The name, symbol, or ISIN of the reporting fund. Must match an existing reporting fund asset in your account. |
| 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). |
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
Vanguard World Equity Fund,2024-12-31,GBP,0.1234,DIVIDEND,2024-01-01,2025-06-30
Vanguard World Equity Fund,2023-12-31,GBP,0.0987,DIVIDEND,2023-01-01,2024-06-30
asset,period_end_date,eri_currency,eri_amount,distribution_type
Vanguard World Equity Fund,2024-12-31,GBP,0.1234,DIVIDEND
Vanguard World Equity Fund,2023-12-31,GBP,0.0987,DIVIDEND
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.