Our work / Client story
Bringing fragmented fund data together for inception-to-date reporting.
The finance team at a credit asset manager needed to report fund metrics on an inception-to-date basis, but the underlying data was spread across legacy systems, Excel files and newer systems. Dacumen interpreted and consolidated that data, modeled the reports and delivered reconciled outputs.
- Client
- Credit asset manager, AUM 10bn+
- Sponsor
- Chief Financial Officer
- Engagement
- Consulting: data consolidation and reporting
- Source data
- Legacy systems, Excel files and newer systems
- Delivered
- Modeled reports and reconciled inception-to-date outputs
Summary
The engagement in three points.
- The client’s finance team needed to produce fund metrics from inception to date.
- The historical data was unstructured and spread across legacy systems, Excel files and newer systems.
- With minimal direction from the client, Dacumen interpreted the data, modeled the reports and delivered reconciled outputs.
Placeholder
Client name, if the client authorizes a named reference.
The reporting requirement
Reporting fund metrics from inception to date.
The finance team’s requirement was to report fund metrics on an inception-to-date basis.
Inception-to-date figures depend on a complete history. Every period since a fund began has to be present and consistent, because a gap or inconsistency in older records carries through to the figure reported today.
Fragmented source data
Fund history held in three kinds of source.
The historical data needed for those metrics was not held in one place. In the CFO’s words, the data was “scattered across legacy systems, Excel files and new systems.”
- Legacy systems
- Earlier systems that still held fund data.
- Excel files
- Workbooks that held fund data outside any system.
- Newer systems
- Systems the client had adopted more recently.
The data was also unstructured, so the three sources could not simply be combined. The data had to be interpreted before it could be used for reporting.
Dacumen’s role
From unstructured data to reconciled reports.
Working with minimal direction from the client, Dacumen carried out each stage of the engagement:
- Interpreted the unstructured data held in the three kinds of source
- Modeled the reports the finance team required
- Delivered reconciled outputs
How the outputs were reconciled
Reconciling consolidated history to source records.
The client’s statement confirms that the outputs Dacumen delivered were reconciled.
On engagements of this kind, our practice is to reconcile the consolidated history to the underlying source records, investigate and explain any differences before figures are released, and document the report logic so that each figure can be traced to its inputs.
Placeholder
Engagement-specific detail on the reconciliation, to be confirmed with the client: what the outputs were reconciled to, and how differences were resolved.
What the finance team received
Modeled reports and reconciled outputs.
- Modeled reports for the required fund metrics
- Reconciled inception-to-date outputs
- The ability to meet its reporting requirement. In the CFO’s words, Dacumen’s expertise “enabled us to deliver on this challenge.”
Placeholder
Verified measure of scope or impact, to be confirmed with the client: number of funds, reporting periods covered, or time to delivery.
The client’s statement
“Dacumen delivered beyond our expectations. We needed to produce inception to date fund metrics, however, our data was scattered across legacy systems, Excel files and new systems. With minimal direction, Dacumen managed to make sense of our unstructured data, modeled the reports, and delivered reconciled outputs. Their unique expertise enabled us to deliver on this challenge.”
Related
The capabilities behind this engagement.
Operations advisory and transformation
Data strategy
Consolidating data from legacy applications and spreadsheets into a data model that supports reporting and that lenders and auditors can rely on.
ConsultingData and automation platform
Orion
Collects and standardizes credit data from any source, and performs calculations such as life-to-date P&L.
OrionEngagement governance
How we govern engagements
Every engagement has a named lead, agreed service levels, parallel runs, a defined escalation route and recorded approvals.
Why DacumenDiscuss your priorities.
If your finance or operations team faces a similar reporting requirement, tell us about it. A senior practitioner will reply personally.