Caruso provides a comprehensive set of downloadable CSV reports, giving fund managers deeper insights into their funds and investors. Reports are grouped by category for ease of use and cover a wide range of operational, compliance, and investment activities.
Most reports are available from the Reports page in the Manager Console. Reports tied to a specific batch (for example a distribution or capital call) are downloaded from that batch's page instead, as noted below.
Note: Each report's file format is shown at the end of its name – (CSV), (XLSX) or (PDF). CSV and PDF reports download immediately. Excel (XLSX) reports are generated in the background: click Generate report and collect the file from the Operations panel at the top right of the Manager Console once it is ready.
Investors
Report Name | Description |
All Investing Entities (CSV) | Detailed information about all investing entities and their key accounts. |
All Accounts (CSV) | Detailed information about all accounts and prospects. |
Investor Lifetime Value (CSV) | All accounts and beneficial owners related to investing entities. This report enables investor relations teams to quickly understand capital contributed by investing entities associated with an account and investing entities associated with an account's connections. It provides genuine insight into which individuals bring the most value to the firm. |
Identity Duplicate (CSV) | Any related parties (beneficial owners) that have presented an ID document already used by another related party. |
All PEP Matches (CSV) | All accounts and beneficial owners with PEP (Politically Exposed Person) matches over a selected period.
This report enables compliance teams to review PEP (politically exposed persons) matches in bulk across all investing entities. |
Operations (CSV) | A one-row summary of onboarding activity over a selected period: new prospects, accounts and investing entities, broken down by type and country. |
All Tasks (CSV) | All tasks including the task status, priority, due date, completed date, notes and no. of related tasks. |
All Transactions (CSV) | All transactions created over a selected period, mirroring the Holding Movements table in the Manager Console. It surfaces both the date the transaction was created and the date of the transaction (e.g. a distribution confirmed on 10 April with a payment date of 15 April). |
Schemes /Capital Raising
Report Name | Description |
All Allocations (CSV) | All investment applications across your capital raises. |
Capital Raise Book Build (XLSX) | All investors interested or committed in a specific capital raise. This report can be downloaded from the Reports page, or directly from the capital raise's Book Build or Applications tab.
Note: The metric ‘% of Book Build’ divides an application or expression of interest by the total units on offer. |
Capital Call Audit Report (CSV) | All approved applications included in a capital call, with a full breakdown of the calculations behind it. Downloaded from the capital call batch. |
All Deposits (CSV) | All payments received for allocation requests over a selected period. |
Holdings
Report Name | Description |
All Holding Movement (CSV) | A detailed registry of all unit movement (transfers, issuances and redemptions) over a selected period. |
Fund Holding Movement (CSV) | A detailed registry of all unit movement (transfers, issuances and redemptions) in a specific fund since its inception. |
All Holdings (CSV) | All holdings across funds on a selected date, with key information about each fund, investing entity and their key account. |
All Holdings Sensitive (CSV) | The All Holdings report plus sensitive investor tax identification data required for regulatory reporting. Available to Super Admins only. |
Fund Holdings (CSV) | All investors in a specific fund on a selected date. |
Fund Holdings (PDF) | A PDF summarising all investors across classes on a selected date. |
Redemptions Payment File (CSV) | All redemption requests approved within a specified date range, fund by fund, for use as a review file before bulk payment. |
Apportionment (CSV) | All funds with a breakdown of each investing entity's holding, including the apportionment % over a selected period, which takes unit movement during that period into account. |
Distributions
Report Name | Description |
All Distribution Details (CSV) | All distributions broken down to granular distribution components – a global view of the individual distribution audit reports. Used as the input for the IPS, NRT and PIE reporting converters. |
All Distribution Details Sensitive (CSV) | The All Distribution Details report plus sensitive investor tax identification data required for regulatory reporting. Available to Super Admins only. |
Distribution – Calculation Summary (CSV / PDF) | A summary of the distribution inputs, showing the total gross, tax withheld and net for each component of a distribution. |
Distribution – Audit Report (CSV / XLSX) | A detailed breakdown of the calculations within one distribution. The Excel version adds rounding transparency columns and a Variance tab comparing the distribution to the previous one for the same fund. |
Distribution – Payment File (CSV / XLSX) and Payment Pack (ZIP) | Detailed payment file for a specific fund's distribution. The Payment Pack contains a payment file per outgoing bank account, plus an ABA file for Australian accounts and an International Payments file. |
Distribution – Reinvestments Report (CSV) | A summary of all holdings reinvesting back into the fund, including:
|
Distribution – Adviser Fee Audit Report (CSV) | Adviser service fees withheld within a distribution, per holding. Downloaded from the distribution's page (Funds → Distribution Batches → open the distribution → download menu at the top right). |
Tax & Regulatory
Report Name | Description |
Annual Investment Income Report (AIIR) (XLSX) | AIIR data for ATO lodgement (Australian funds). The AIIR is normally generated from an AU tax statement batch as part of the tax pack; it is also available from the Reports page. Contains investor TFNs, so it is available to Super Admins only. See Regulatory Reporting. |
FATCA/CRS Tax Pack (ZIP) | The FATCA and CRS lodgement files for one fund and reporting year, generated together as a single pack. Select the fund and reporting year, and Caruso shows the reporting period that applies (Australian or New Zealand). The fund's FATCA/CRS details must be completed under Fund Settings → Tax Reporting before the pack can be generated. |
Management Fee Report (XLSX) | Management fee calculations per fund and class over a selected period. |
Other
Report Name | Description |
Audit Log (CSV) | A detailed log of high-risk data changes across the Manager Console and Investor Portal. Includes event date and time, type of action, application source (Admin or Portal), associated record (e.g. account, fund, or entity), description of change, and the admin user or investor who made the change. Useful for compliance and monitoring activities. See Audit Log. |
Note:
If a data point relates to a calculation over a period or “as at” a specific date, this will be reflected in the column name
Examples: Holding – Apportionment % (during report period), Holding – % Held (at report end date)
Otherwise, the value reflects the state at the time the report was generated
Excel reports state the report date, the date basis and the timezone used in their header rows
If you have any questions or need help at any stage, please contact our Caruso Support team either by email or live chat.