Why It Matters: Anaplan models for the multifamily portfolio require clean, consistent, and reliable data to produce accurate financial forecasts. This workflow is the dedicated process that prepares and loads that data, ensuring the integrity of the planning process.
How It Works: The process starts with raw financial data from the accounting systems: Yardi for Highmark-managed properties and RealFoundations for properties managed by third parties. This data is first brought into a central data hub, Cherre, for cleaning and validation. Within Cherre, two critical mapping steps occur: first, we map the property IDs from the accounting systems to the master property ID from DealCloud. Second, we apply a standardized Chart of Accounts (CoA) mapping to ensure all financial data is categorized consistently.
Key Data & Transformations:
Data Sources: Yardi, RealFoundations.
Key Data: Property-level Cash Flow data.
Detailed Transformations:
Identifier Mapping: A mapping process explicitly links the DealCloud Property ID to the Yardi Property ID.
Chart of Accounts (CoA) Standardization: A dedicated mapping table is used to translate source account codes into a standardized CoA, ensuring financial data is consistently categorized before being sent to Anaplan.
End Result: The final, validated cash flow data is delivered to Anaplan on the 22nd of each month. This reliable and timely data delivery ensures financial modeling and forecasting for the multifamily portfolio are always accurate.