The FP&A Problem Nobody Talks About
You have MRI. It manages properties beautifully.
But when your CEO asks "Should we expand into Phoenix?" MRI can't answer that.
You need FP&A. And MRI wasn't built for that.
What MRI Does Well
- Property-level accounting
- Lease management
- Work orders and maintenance
- AP/AR workflows
- Transaction processing
What FP&A Needs (That MRI Can't Deliver)
- Portfolio-level strategic analysis
- Market comparisons
- Scenario planning ("what if we sell these 5 properties?")
- Capital allocation modeling
- Rolling forecasts
- Cohort analysis
- Return attribution
The Framework: Three-Layer Architecture
Layer 1: Operational Data (MRI)
What It Does: Day-to-day property management Who Uses It: Property managers, leasing agents, maintenance staff Output: Transactions, leases, invoices
Layer 2: Financial Intelligence
What It Does: Consolidates, validates, enriches operational data Who Uses It: Controllers, accountants Output: Clean, standardized financial data
Layer 3: FP&A Analytics
What It Does: Strategic analysis and decision support Who Uses It: CFO, FP&A team, CEO Output: Insights, forecasts, scenarios, recommendations
Building Layer 2: Financial Intelligence
This is where most teams fail. They try to jump from MRI directly to FP&A.
You need an intelligence layer in between.
What This Layer Does:
1. Data Consolidation
- Pulls from MRI automatically (no manual exports)
- Combines property-level data into portfolio view
- Handles multiple legal entities
- Manages different MRI instances
2. Data Standardization
- Normalizes chart of accounts across properties
- Standardizes vendor names
- Applies consistent categorization
- Handles reclassifications
3. Data Validation
- Reconciles to bank statements
- Checks for anomalies
- Validates completeness
- Flags errors before they propagate
4. Data Enrichment
- Adds market data
- Applies property attributes
- Calculates derived metrics
- Tags with strategic categories
Building Layer 3: FP&A Capabilities
Once Layer 2 is solid, you can build real FP&A:
Capability 1: Portfolio-Level Planning
Old Way: Budget in Excel, upload to MRI, hope it works
New Way:
- Build budget at portfolio level
- Allocate down to properties
- Iterate quickly
- Push approved budget to MRI
Capability 2: Rolling Forecasts
Old Way: Annual budget, maybe 1-2 reforecasts
New Way:
- Quarterly rolling 12-month forecast
- Updated automatically with actuals
- Scenario-based (base, upside, downside)
- Property-level detail with portfolio roll-up
Capability 3: Scenario Analysis
Questions FP&A Should Answer:
- "What if we sold our 5 oldest properties?"
- "How does Phoenix market entry affect cash flow?"
- "What's the impact of 5% rent growth vs 3%?"
- "Can we survive if occupancy drops 10%?"
Old Way: Days of Excel modeling New Way: Minutes of scenario configuration
Capability 4: Driver-Based Forecasting
Not: "Next year NOI will be $X because I said so"
But: "Next year NOI will be $X because:
- Occupancy: 94% (up from 92%)
- Rent per unit: $1,850 (3% increase)
- Operating expense ratio: 42% (down from 44%)
- Expected move-outs: 15% annual turnover"
Capability 5: Variance Intelligence
Old Way: "Actuals vs budget was -$47K unfavorable"
New Way: "Actuals vs budget was -$47K unfavorable, primarily driven by $60K higher R&M (deferred maintenance from Q1 completed) partially offset by $13K favorable utilities (mild weather). Outlook for year unchanged."
Human-written narrative. AI-assisted first draft. CFO approved.
Capability 6: Capital Allocation Framework
Questions:
- Which properties should get capital investment?
- What's the expected return?
- How does this fit portfolio strategy?
- What's the opportunity cost?
Output: Data-driven capital deployment decisions
The Technology Stack
Option A: Build It Yourself
Components:
- Data warehouse (Snowflake, BigQuery)
- ETL tool (Fivetran, Stitch)
- Analytics layer (dbt)
- Visualization (Tableau, PowerBI)
- FP&A tool (Anaplan, Adaptive)
Pros: Fully customized Cons: Expensive, slow, requires data engineering team Timeline: 12-18 months Cost: $300K-$500K first year
Option B: Platform Approach
Components:
- Integrated financial intelligence platform
- Pre-built MRI connectors
- Built-in FP&A capabilities
- Embedded analytics
Pros: Fast, proven, turnkey Cons: Less customization Timeline: 60-90 days Cost: $50K-$150K first year
Most Teams Choose: Hybrid
- Platform for 80% of needs
- Custom development for unique requirements
- Best of both worlds
Implementation Roadmap
Phase 1: Foundation (Month 1-2)
- Connect MRI
- Build data validation
- Create portfolio dashboard
- Train team
Phase 2: Intelligence (Month 3-4)
- Implement automated reconciliations
- Build variance analysis
- Create property scorecards
- Establish KPIs
Phase 3: Planning (Month 5-6)
- Deploy budgeting capability
- Build driver-based models
- Create scenario framework
- Test with next budget cycle
Phase 4: Advanced FP&A (Month 7-12)
- Rolling forecasts
- Capital allocation models
- Market analytics
- Predictive capabilities
Measuring Success
Months 1-3:
- Close time reduced 50%
- Manual exports eliminated
- Data accuracy improved
- Team morale up
Months 4-6:
- Ad-hoc analysis 10x faster
- Board deck prep time cut 70%
- Better variance insights
- Forecast accuracy improved
Months 7-12:
- Strategic decisions data-driven
- Capital deployed more efficiently
- Acquisition analysis accelerated
- CFO time freed for strategy
Common Mistakes to Avoid
1. Trying to Make MRI Do FP&A
MRI is operational. Accept it. Build on top of it.
2. Skipping the Intelligence Layer
Can't do good FP&A on bad data.
3. Over-Engineering
Start simple. Add sophistication as needed.
4. Ignoring Change Management
Technology is 30% of success. People and process are 70%.
5. Not Defining Use Cases
"We want FP&A" is too vague. Define specific decisions you need to support.
The Bottom Line
MRI is great at what it does. FP&A requires different capabilities.
The winning approach:
- Keep MRI for operations
- Build intelligence layer for financial data
- Add FP&A analytics on top
- Integrate all three
Result: Best-in-class property operations AND strategic financial planning.
For real estate companies looking to build sophisticated FP&A capabilities on top of MRI, the key is treating MRI as a data source rather than trying to force it to be an FP&A platform.