The CEO's Unrealistic Demand
"I want to see real-time NOI. Like, right now. For every property."
CFO: "...do you mean this month's numbers? Or yesterday? Or this instant?"
CEO: "Yes."
Let's talk about what real-time actually means.
Defining "Real-Time"
It Doesn't Mean What You Think
Not Real-Time:
- Month-end close in 2 days
- Weekly dashboards
- Daily reports
Actually Real-Time:
- Data refreshing continuously
- No delay between transaction and visibility
- Up-to-the-second accuracy
Practical Real-Time:
- Data refreshing every few hours or daily
- Near-current visibility
- Good enough for decision-making
Most companies need Practical Real-Time, not Actually Real-Time.
What Real-Time Reporting Actually Requires
1. Automated Data Integration
If anyone is manually exporting from MRI, you don't have real-time. You have "whenever someone remembers to export."
2. Continuous Reconciliation
Real-time data that's wrong is worse than delayed data that's right.
3. Exception-Based Workflows
You can't review every transaction in real-time. You need automated flags for anomalies.
4. Clean Source Data
Garbage in, real-time garbage out.
When Real-Time Actually Matters
✅ Use Cases Where It's Critical
1. Cash Management Need to know current cash position? Real-time matters.
2. Operational Metrics Occupancy, collections, delinquency—daily updates drive action.
3. Crisis Management Market crashes, tenant defaults, natural disasters—need instant visibility.
4. Pricing Decisions Dynamic pricing for leasing requires current data.
❌ Use Cases Where It Doesn't Matter
1. Month-End Financial Statements These are retrospective by definition. Real-time doesn't help.
2. Board Reporting Board meets quarterly. They don't need microsecond data.
3. Budgeting Forward-looking. Real-time historical data is interesting but not critical.
4. Tax Reporting Once a year. Very much not real-time.
The Real-Time Paradox
The Irony:
Companies that demand real-time reporting often:
- Close books in 8 days
- Pull MRI reports manually
- Email Excel files around
- Make decisions based on month-old data
They don't need real-time reporting.
They need basic reporting done well.
The Right Approach: Tiered Reporting
Tier 1: Real-Time Operational Dashboards
Refresh: Hourly or daily Content:
- Cash position
- Collections
- Occupancy
- Leasing activity
- Work order status
Users: Property managers, COO, CEO
Tier 2: Near-Real-Time Performance Metrics
Refresh: Daily or weekly Content:
- Portfolio NOI (flash)
- Key variance indicators
- Trend analysis
- Exception reports
Users: CFO, Controllers, executive team
Tier 3: Closed-Book Financial Reporting
Refresh: Monthly Content:
- Official financial statements
- Complete variance analysis
- Board reporting packages
- Investor reports
Users: Board, investors, lenders, auditors
How to Build Practical Real-Time Reporting
Step 1: Automate Data Flows
- API connections from MRI
- Automated bank feeds
- Nightly data synchronization
- No manual exports
Step 2: Implement Continuous Validation
- Automated reconciliations
- Anomaly detection
- Balance checks
- Exception alerts
Step 3: Build Self-Service Dashboards
- Key metrics visible to stakeholders
- Drill-down capability
- No waiting for reports
- Mobile-accessible
Step 4: Maintain Closed-Book Integrity
- Flash reports are preliminary
- Official close still monthly
- Clear distinction between estimates and actuals
What It Looks Like in Practice
Morning (7 AM):
- CEO checks dashboard on phone
- Sees yesterday's collections across portfolio
- Notices one property is 20% below target
- Alerts property manager
Mid-Day (Noon):
- CFO reviews flash NOI for month-to-date
- Identifies favorable variance at 3 properties
- Schedules call with those PMs to understand drivers
Afternoon (3 PM):
- Controller notices unusual AP transaction
- System flagged it automatically
- Investigates and resolves before close
Month-End (Day 2):
- Official close completes
- Flash reports validated against closed books
- Board package generated
- Variance analysis complete
Result: Best of both worlds
- Real-time operational visibility
- Rigorous financial close
- No confusion between the two
The Technology Requirements
Minimum Viable Real-Time Stack:
- Automated Data Integration: APIs pulling from source systems
- Cloud Data Warehouse: Central repository, refreshed regularly
- Dashboard Platform: Self-service visualization
- Automated Alerts: Exception notifications
- Mobile Access: Executives expect phone access
What You Don't Need:
- Microsecond latency
- Enterprise data lake
- Full-time data engineering team
- Million-dollar BI platform
The Realistic Timeline
From "monthly Excel reports" to "practical real-time":
Month 1-2: Automate MRI data extraction Month 3-4: Build validation and reconciliation Month 5-6: Create operational dashboards Month 7-8: Add drill-down and analytics Month 9-10: Mobile deployment and refinement Month 11-12: Adoption and optimization
Investment: $50K-150K depending on portfolio complexity
ROI: Typically breaks even in 12-18 months through:
- Time savings
- Better decisions
- Error reduction
- Competitive advantage
The Hard Truths
1. Real-Time Data Won't Fix Bad Processes
If your close takes 10 days, real-time dashboards won't help.
2. You'll Still Need a Month-End Close
Real-time doesn't eliminate the need for rigorous accounting.
3. Bad Data in Real-Time Is Worse
Accuracy > Speed. Always.
4. Nobody Watches Dashboards 24/7
Real-time data is valuable when decisions need to be made, not constantly.
The Bottom Line
What CFOs Think Real-Time Means: "Instant access to perfectly accurate financial data, refreshed continuously, with no effort."
What Real-Time Actually Means: "Near-current operational data for day-to-day decisions, with rigorous monthly close for official reporting."
The second version is achievable. The first is fantasy.
Know the difference.
For finance teams looking to implement practical real-time reporting, the key is starting with automated data flows and self-service dashboards—not trying to eliminate the month-end close.