Why It Matters: This workflow is fundamental to the relationship with investors. It ensures that every dollar they contribute and every dollar distributed is meticulously tracked. This accuracy builds investor confidence and provides the precise data needed for financial reporting, statements, and calculating returns on investment.
How It Works: The process begins by pulling all raw transaction data from the core accounting system, Starwood Yardi. This data is then processed in two parallel streams to serve different needs. The first stream, for Asset Management (AM), involves detailed mapping of accounts and properties to create a comprehensive financial schedule. The second, for Portfolio Management (PM), provides a daily snapshot by summing up all of an investor's transactions for that day into a single line item. Simultaneously, we pull data from official Investor Commitment Documents. This commitment data is carefully filtered to match transactions to the correct funds (like SOF XI and SOF XII) and the specific legal entity structures involved, ensuring every transaction is correctly allocated.
Key Data & Transformations:
Data Sources: Starwood Yardi, Investor Commitment Documents.
Key Data: Transactions (contributions, distributions), Investor Names, Fund Names, Entity Legal Codes.
Detailed Transformations:
Mapping: Fund-level accounts and properties are mapped to standard definitions. Yardi entity data is mapped to standardized entity and investor names.
Filtering: Transaction data is filtered to include only contributions and distributions. Commitment data is filtered by specific funds (e.g., SOF XI, SOF XII), entity levels (>= 680), and specific legal entity codes.
Calculation: For distributions, the sign of the transaction value is reversed to correctly represent a cash outflow. For the daily PM schedule, all transactions for the same investor and investment on the same day are summed.
Enrichment: A control number (ctrl_#) is added as a primary key, and a 12-month incremental logic is applied. The investor's name is joined from an attribute list.
End Result: The final output is a consolidated and validated view of each investor's equity position. This is used by finance and investor relations teams to generate accurate reports and answer investor inquiries with confidence.