The short answer. A portfolio variance is caused by individual buildings, so you explain it by walking the number down: portfolio, fund, region, asset, then the line item that moved. At each asset, pair the number with the reason from the people who run that building and with management’s next action. That chain lets an executive answer “why?” in the meeting, instead of “we’ll have to come back to you on that.”
Why it gets harder as the portfolio grows
With 10 or 20 buildings, senior executives often know every property personally. They know the building with the difficult tenant, the one under renovation and the market where concessions are rising, so the context is already in their heads when the numbers arrive.
With hundreds of buildings, that knowledge is spread across more funds, markets, property managers, asset managers and operating partners. Leasing knows why occupancy slipped. Operations knows why repairs went up. Finance sees the resulting variance. The reasons sit in Yardi or MRI, spreadsheets, variance reports, emails, meeting notes and people’s heads, and someone has to connect them.
A line such as “Fund NOI is 4% below plan” is a result, not an explanation. A portfolio is made of buildings, and the explanation lives there.
The questions investors will ask
An investor does not see the complexity behind the number. They see that NOI missed plan, and they keep asking:
- Which properties drove it?
- How much did each one contribute?
- What is happening at those properties?
- What does management think caused it?
- What are we doing about it?
- What should we expect next quarter?
A good variance explanation answers all six before anyone asks.
Step by step: from portfolio to building
- Start with the headline variance. Take the line that matters, usually NOI, and compare actual with plan (and with the prior period) for the portfolio.
- Break it down by fund, then by region or asset class. Rank each level by its dollar contribution to the variance, not by its percentage.
- Find the assets. In most periods a handful of buildings explain most of the gap. List them in order until they account for the bulk of the variance.
- Split each asset’s variance into drivers. For example rental revenue (occupancy, rent, concessions), recoveries, other income, controllable expenses, non-controllable expenses and one-time items.
- Attach the reason from the people closest to the building. Ask the property manager, leasing team or asset manager for one or two plain sentences on what happened and when.
- Record the action and the outlook. Note what management is doing, who owns it and what it means for next period.
- Roll it back up. Present one page: the total variance, the assets that drove it, the reasons and the actions.
Example (illustrative numbers)
Fund NOI came in at $9.6M against a plan of $10.0M, a variance of -$400k (-4%). Walking it down to the buildings gives:
| Asset | Variance | Driver | Reason from the site team | Action and outlook |
|---|---|---|---|---|
| Office A | -$250k | Rental revenue | A tenant left two floors in July; reletting needed concessions | Two letters of intent in negotiation; lease expected next quarter |
| Industrial B | -$120k | Repairs and maintenance | Roof repair after a storm | One-time cost, partly covered by insurance |
| Retail C | -$60k | Recoveries | Timing of the common area maintenance reconciliation | Billed next period |
| All other assets | +$30k | Various | Small differences across the rest of the fund | None needed |
| Fund total | -$400k |
The explanation an executive can give: “Fund NOI was $400k, or 4%, below plan. Three buildings drove $430k of the shortfall. Most of it is a vacancy at Office A that we expect to relet next quarter; the roof repair at Industrial B is one-time, and the Retail C shortfall is timing.”
Common mistakes
- Reporting percentages without the dollar contribution, so small assets look like big problems.
- Stopping at fund level, where the number has no story yet.
- Commentary written by finance alone, without the people who know the building.
- No action or outlook, which invites the next question.
How Refined Data helps
Your ERP has the numbers. Your people have the insight. Refined Data brings them together, connecting the figures in Yardi or MRI with commentary from the people closest to each building, so every variance can be traced and explained.
Frequently asked questions
What is a variance in real estate financial reporting? It is the difference between actual results and plan (or the prior period) for a line such as NOI, revenue or expenses, at an asset, fund or portfolio level.
Which variances should we explain? Agree a threshold with both a dollar amount and a percentage, so you explain the variances that matter to investors and skip the noise.
Who should write the variance commentary? The people closest to the asset, such as the property manager, leasing team or asset manager. Finance collects it, checks it against the numbers and rolls it up.
How often should variances be explained? Every reporting period, monthly or quarterly, so the explanation is ready before the board or investor meeting.
Can AI explain a portfolio variance on its own? AI can summarise the numbers, but the reasons often live with the people who run each building. The explanation needs both the data and their commentary.
About the author
Carl Paulse is CEO of Refined Data.
