Fund Details Register Consolidated Input Template

Overview

The Fund Details Register (FDR) is a centralised repository that captures essential information about investment funds managed by an organization. The Consolidated Input Template (CIT) is the standard spreadsheet used to feed data into the register, ensuring consistency, traceability and regulatory compliance across all funds.

Regulators, auditors and senior management rely on the FDR to obtain a single source of truth for fundlevel data. By consolidating input from multiple business units into one template, organisations reduce duplication, minimise errors and streamline reporting processes.

Purpose of the Consolidated Input Template

• Uniform Data Capture: Provides a single format for all funds, regardless of asset class, jurisdiction or strategy.
• Regulatory Alignment: Aligns data collection with the requirements of directives such as UCITS, AIFMD, and local securities legislation.
• Facilitates Consolidation: Allows the finance team to rollup information into grouplevel financial statements and performance dashboards.
• Audit Trail: Embeds version control and changelog fields, supporting internal and external audit checks.
• Operational Efficiency: Reduces manual reentry by linking directly to downstream systems (risk, compliance, portfolio management).

Template Structure

The CIT is divided into logical tabs that mirror the lifecycle of a fund:

1. Fund Summary

Basic identifiers, launch date, domicile, legal entity and investment mandate.

2. Asset Allocation

Target and actual allocation percentages across asset classes, regions and sectors.

3. Pricing & Valuation

Key pricing sources, valuation frequency, NAV calculation methodology.

4. Fees & Expenses

Management fees, performance fees, transaction costs and other operating expenses.

5. Regulatory Data

Registration numbers, reporting frequencies, specific regulatory limits.

6. Governance

Fund manager, investment committee members, custodians, auditors.

7. Change Log

Record of edits, user ID, timestamp and justification for each change.

Key Fields Explained

All numeric fields must be supplied without commas and with a dot as the decimal separator. Dates follow the ISO format YYYYMMDD.

How to Use the Consolidated Input Template

Step 1 Download the Latest Version

The template is stored in the shared drive under \\FundOps\Templates\FDR_CIT_Vx.x.xlsx. Always use the most recent version to avoid compatibility issues.

Step 2 Populate the Fund Summary Tab

Enter the fundamental data first. This information is referenced by all other tabs, so doublecheck the Fund_ID and Domicile values.

Step 3 Complete the Asset Allocation Tab

Enter both the target and current allocation percentages. The sum of each row must equal 100% (allow a tolerance of 0.1%). Use the builtin validation messages to spot rounding errors.

Step 4 Add Pricing & Valuation Details

Specify the pricing source (e.g., Bloomberg, Reuters) and the NAV calculation method. If the fund uses a hybrid pricing model, provide a brief note in the Comments column.

Step 5 Record Fees and Expenses

All fees are expressed in basis points (bps). Where a fee is tiered, list the maximum applicable rate in the main column and describe the tiering in the adjacent Notes field.

Step 6 Fill the Regulatory Data Tab

Enter every registration number and reporting frequency. If a fund is exempt from a specific regulation, indicate Exempt and provide the legal reference.

Step 7 Update Governance Information

List the current fund manager, investment committee members, custodian and external auditor. Update this tab whenever a change occurs; the change log will capture the modification automatically.

Step 8 Save and Upload

Save the file using the naming convention FDR__YYYYMMDD.xlsx. Upload it to the central repository at \\FundOps\Registrations\. An automated workflow will validate the file and import the data into the master register.

Common Issues and How to Resolve Them

• Missing Mandatory Fields: The validation macro highlights empty mandatory cells in red. Fill them before saving.
• Incorrect Date Format: Dates entered as DD/MM/YYYY cause import failures. Convert to YYYYMMDD.
• Allocation Totals 100%: Use the =SUM() formula to check each row; adjust rounding as needed.
• Duplicate Fund_ID: Run the Check Duplicates macro; if a duplicate exists, coordinate with the Register Owner to assign a new ID.
• Version Mismatch: Older templates lack new columns (e.g., ESG_Score). Always download the latest master copy.

If an issue persists after following the steps above, raise a ticket with the Fund Data Support team (email: funddata.support@company.com) and attach the problematic file.

Best Practices

1. Complete the template in a single session to avoid version conflicts.
2. Use dropdown lists provided in the sheet they enforce consistent coding (e.g., currency codes, fund types).
3. Document any assumptions or manual overrides in the Comments column.
4. Perform a final review with a peer before uploading; a fresh set of eyes often catches data entry slips.
5. Archive the submitted file in the Historical subfolder for audit purposes.