Quick Answer: Portfolio-level financial rollups without the monthly Excel reconciliation means every property's rent roll, expenses, and NOI feed into a live portfolio view that recalculates in real time as leases change, rent gets collected, and expenses post. Traditional workflow relies on a portfolio accountant reconciling five to twenty property-level Yardi or MRI extracts into a master Excel monthly. MiOpsAI's Mac chair does this continuously, so the portfolio owner or asset manager sees a live rollup at any hour without waiting for month-end close.
Every CRE portfolio owner or asset manager has the same monthly ritual. Around the 10th of the month, the property accountant sends over the individual property P&Ls for the previous month. Around the 15th, someone (usually the same accountant or a portfolio analyst) starts consolidating them into a master Excel. Around the 20th, the rollup is ready, with all the tabs, formulas, and pivot tables that the CFO or ownership group expects. Around the 25th, questions come back about the numbers, someone re-checks the source data, and the answers go back. By the 30th, the report is final. The next day, the cycle starts again.
This workflow eats 40 to 80 analyst-hours per month per portfolio, per portfolio accountant. For an owner with 3 portfolios, that is 120 to 240 hours monthly, or roughly one full-time person doing nothing but portfolio reconciliation. And the report is always at least 15 to 20 days stale by the time it lands.
Why the Excel reconciliation exists in the first place
Property-level accounting typically lives in Yardi, MRI, RealPage, or a similar property management platform. Each property has its own general ledger, its own rent roll, and its own expense structure. Yardi and MRI can generate portfolio-level rollups in principle, but only if every property is on the same platform, using the same chart of accounts, with consistent property setup. In practice, portfolios grow through acquisitions, and every acquired property brings its own accounting quirks.
Excel becomes the reconciliation layer because it is the only tool flexible enough to handle inconsistent source data. The analyst maps property-level accounts to a portfolio-level chart, normalizes reporting periods, adjusts for straight-line rent, handles free rent amortization, and produces the rollup. This work is skilled and important. It is also mind-numbingly repetitive and prone to error.
What Mac does with portfolio rollups
Mac, the finance chair in MiOpsAI's specialist AI system, handles portfolio-level financial rollups as a core function. During onboarding, Mac ingests the source data from each property's accounting system (Yardi, MRI, RealPage, QuickBooks, or a shared drive of monthly extracts) and builds a canonical chart of accounts at the portfolio level. She maps each property's accounts to the portfolio chart with a set of transformation rules that get reviewed by the analyst once and then run automatically going forward.
After setup, every time new data arrives from a property, Mac processes it against the transformation rules and updates the live portfolio view. Straight-line rent adjustments happen automatically. Free rent amortization is calculated per-lease using Julia's abstracted lease terms. NOI is calculated by property and rolled to portfolio total. Occupancy is tracked by property and portfolio. Cap rates are calculated using current rent roll and a configurable market cap rate assumption.
The result: at any hour of any day, the asset manager or portfolio owner can see a live rollup. Month-end still happens for GAAP compliance and outside reporting, but the operational visibility is continuous, not lagging.
What this means for the portfolio analyst role
Some portfolio analysts worry that AI-powered rollups eliminate their job. It does not. It eliminates the mechanical reconciliation work and moves the analyst up the value chain. Instead of spending 30 hours a month producing the rollup, the analyst spends 5 hours reviewing Mac's flags (variance from budget, unusual expense patterns, unit turnover trends) and 25 hours on analysis that used to be crowded out. Portfolio-level lease exposure analysis, cap rate sensitivity, submarket concentration risk, acquisition underwriting: all the work that portfolio owners actually want their analysts doing.
For firms without a dedicated portfolio analyst, Mac replaces the outsourced portfolio accounting service (typically $2,000 to $8,000 per month per portfolio) entirely. For firms with an analyst, Mac augments the role and lets the analyst do more valuable work.
Integration with property management systems
Mac integrates with Yardi, MRI, RealPage, and QuickBooks via standard export files (CSV, PDF, Excel). Native API integration with Yardi and MRI is on the 2026 roadmap. Today, the workflow is: each property manager runs their monthly P&L export from Yardi or MRI, drops it in a shared folder (or emails it to the portfolio inbox), and Mac processes it automatically. Setup takes 2 to 4 hours per property during onboarding.
For firms with mixed property management (some in Yardi, some in MRI, some in a shared spreadsheet for smaller properties), Mac handles the mixed sources without requiring standardization. The transformation rules normalize the data at the portfolio level.
The three types of reports Mac produces
Mac produces three tiers of reporting automatically. Property-level: individual property P&L with variance to budget, rent roll, occupancy, and cap rate. Portfolio-level: consolidated P&L, NOI, occupancy, and cap rate across all properties. Investor-level: quarterly and annual reports formatted for LP reporting, including waterfall calculations, preferred returns, and distributions.
Custom reports are also easy. Ask Mac "show me all leases expiring in the next 12 months with above-market current rent" or "which properties are more than 5 percent below budget on NOI" and she returns the answer in seconds. This is the kind of ad-hoc analysis that used to require the analyst to build a one-off Excel model.
Frequently Asked Questions
Does Mac replace Yardi or MRI?
No. Yardi and MRI remain the property-level system of record for tenant accounting, lease administration at the property level, and vendor payments. Mac sits on top and handles the portfolio-level rollup layer. Firms with Yardi Voyager or MRI keep them; Mac makes them more useful.
How does Mac handle acquisitions mid-year?
New property is added to the portfolio in Mac during acquisition close. Historical financials are ingested from the seller's records or the pre-acquisition due diligence file, and going-forward data feeds into Mac from the property management platform. Straight-line rent and other GAAP adjustments are calculated from acquisition date forward.
Can Mac produce audit-ready reports for the accountants?
Mac produces the reports and the underlying data. Your outside accountant still runs the audit and prepares the tax return, but Mac gives them cleaner, more consistent source data than the traditional Excel handoff. Most firms report the annual audit takes 30 to 40 percent less time when Mac is producing the source rollups.
What about non-financial portfolio metrics like tenant satisfaction or leasing velocity?
Mac partners with Lizzi (operations) and Marcus (growth) to track these. Leasing velocity, deal cycle time, tenant retention, and inbound inquiry volume all feed into the operational dashboard alongside the financial rollups. It is one platform, not three.
What is the cost for a portfolio of 20 properties?
MiOpsAI is priced per chair, not per property. A portfolio management team of 5 people is 5 chairs at $250 each = $1,250 per month, all-in for the platform. Compare to typical portfolio accounting service fees of $2,000 to $8,000 per month per portfolio plus internal analyst salary. See pricing and read our companion guide on the 2026 CRE tech stack.
Ready to end monthly reconciliation?
Portfolio owners in 2026 do not accept 15-day-stale financial reports. The firms that consolidate to a live rollup platform have a structural information advantage over firms still running monthly Excel reconciliation. Request access to see Mac's portfolio rollup on your actual property data.