Identify the change
Define who flags a new source account, a revised description or a reclassification. Retain the source period and supporting detail.
Portfolio reporting / Account mapping
Different accounts.
One reporting chart.
Map property-manager accounts to portfolio reporting. Start with the source detail, agree the owner's categories and record the decisions that need review.
CREx Intelligence builds on the portfolio context held in CREx OS. Discuss account mapping, source coverage and responsibility for changes as part of your reporting scope.
The owner question
How do you map different property-manager charts of accounts?
Create a source-to-reporting crosswalk for each manager. Keep the original account identifier, agree the owner's reporting category, check period and accounting basis, and send ambiguous balances to the appropriate reviewer. Record who approves changes before using the mapped figures in a portfolio comparison.
A worked example
Same category.
Different source accounts.
| Manager source account | Proposed portfolio category | Review decision |
|---|---|---|
| Manager A: RENT_RES | Residential rental income | Confirm the period and treatment of concessions. |
| Manager B: RENT_APT | Residential rental income | Confirm that the balance represents the same reporting basis. |
| Manager B: UTIL_AND_REPAIR | Requires detail before splitting | Request supporting detail and reviewer approval before allocating the balance between utilities and repairs. |
| Manager A: OTHER_INC | Requires review | Request supporting detail before assigning the whole balance. |
| Manager B: CAPEX_REPAIR | Requires review | Ask the owner's accounting reviewer to determine the classification. |
Some accounts can share a proposed reporting category. Others need more detail or a split before the reviewer can approve the treatment. Matching account names alone does not establish equivalent accounting treatment.
Operating responsibility
Agree who owns mapping changes.
Review the treatment
Name who proposes the reporting category and who approves it. Keep unresolved items visible to the people preparing and reviewing the report.
Accept the reporting basis
Agree the mapping version and reporting period used in the output. Define how later corrections should be reviewed.
Where included in your agreement, a named CREx operator can support data upkeep and manager follow-up around this process. Your team retains responsibility for accounting judgments and portfolio decisions.
Prepare the source pack
Bring the account detail.
Define the comparison.
Agree the reporting period, accounting basis and level of detail before comparing balances. A useful source pack includes:
- The current chart of accounts, with account codes and descriptions.
- Financial reports for the agreed period and accounting basis.
- Property and entity identifiers that connect the reports to the portfolio.
- The budget structure where a budget comparison is required.
- Notes on new accounts, reclassifications and adjustments.
- A source contact who can explain ambiguous accounts and arrange authorized corrections.
Keep original source identifiers available during review so the team can explain how a portfolio reporting category relates to a manager's records.
OS foundation / Intelligence
Put reporting definitions in context.
CREx OS provides the agreed portfolio data and reporting foundation. CREx Intelligence builds on that context for asset-management questions and reviews. The mapped view supports management reporting; retain the source financial statements, period definitions and your team's accounting approvals.
Account mapping, supported sources, review responsibilities and any automation are confirmed for your scope. Bespoke reporting or warehouse projects are separately scoped through CREx Core consulting.
Data from property managers
Agree the source route, cadence and responsibility for missing inputs.
Explore PM data integration ↗Data from JV partners
Keep entity, ownership basis and partner follow-up with the reporting package.
Explore JV data collection ↗Reporting for the owner
Agree what enters the pack and who reviews it before distribution.
Explore portfolio reporting ↗Account mapping / Questions
Questions before implementation.
Do all property managers have to change their chart of accounts?
Start by evaluating the existing source accounts and the owner's reporting requirements. Whether mapping is sufficient, or a source change is needed, depends on the detail available and the agreed scope.
Can matching account names be mapped automatically?
Matching names are a starting point for review, not proof of equivalent accounting treatment. Confirm definitions, basis and supporting detail before relying on the mapping. Any automation must be separately confirmed for the agreed workflow.
What happens when a manager adds a new account?
Define an exception process during implementation: who identifies the account, what evidence the reviewer needs and who approves the reporting category. Confirm which parts CREx supports in your agreement.
Does account mapping determine our accounting treatment?
Your accounting team agrees the reporting structure and review process. That team remains responsible for accounting judgments and approvals.
Start with a source pack
Bring the accounts.
Show us the reporting gap.
Use a sample chart of accounts and financial report to explain the problem. Agree the appropriate secure sharing route before providing confidential files.
Discuss account mapping