FP&A real estate: property budgets and variances

FP&A real estate work explains property revenue and operating costs against a budget, with occupancy and rent measured separately. Start with the rent roll and expense ledger for the same month, then build a bridge that adds exactly to the change in property operating income. The result should tell the property manager what changed and which action needs an owner.

Set the property and period boundaries

Use a stable property ID across the rent roll, budget and general ledger. Bring the month, unit ID, occupancy dates, earned rent, concessions, other income and expense account. Keep available units and units temporarily taken out of service visible; changing that denominator changes the occupancy story.

This is property operations analysis. It does not estimate a property's market value or recommend an investment. The broader finance cycle belongs in what FP&A does; the job here is to reconcile the operating drivers beneath each property result.

Define net operating income, or NOI, for this management report as rental revenue plus other property income minus property operating expenses. Exclude financing, income taxes, depreciation and capital projects from this particular measure, and show them in separate schedules when needed. This definition is a reporting policy for the example, not a substitute for the company's accounting policy.

Keep repairs and capital work separate at intake. IRS Publication 527 distinguishes rental-property repairs from improvements and explains that improvements generally must be capitalized. Tax treatment and management reporting have different purposes; ask accounting to settle uncertain classifications before comparing periods.

Build the monthly property worksheet

The example is an invented US apartment operator reporting September 2026. Occupied units below are full-month equivalents: occupied unit-days divided by days in the month. Rent is earned rent after concessions per occupied equivalent, with no separate bad-debt adjustment in these example rows.

Enter these inputs in columns A through J, with the headings in row 1 and the properties in rows 2 and 3.

The displayed table occupies A:J, so use K onward for calculations. In K2 enter budget rental revenue, L2 actual rental revenue, M2 budget NOI and N2 actual NOI:

=C2*E2
=D2*F2
=K2+G2-I2
=L2+H2-J2

Fill down through row 3. The calculated amounts are whole dollars; occupancy percentages below are rounded to one decimal place.

Property A's budget occupancy is 95 / 100 = 95.0%, against actual occupancy of 92.0%. Property B moves from 76 / 80 = 95.0% to 74 / 80 = 92.5%. Across the portfolio, divide occupied totals by available totals: 171 / 180 = 95.0% budget and 166 / 180 = 92.2% actual.

Separate the occupancy and rent effects

Use budget rent to price the occupancy change, then actual occupied equivalents to price the rent change. This ordering captures the interaction once.

Occupancy effect = (Actual occupied equivalents - Budget occupied equivalents) × Budget rent

Rent effect = Actual occupied equivalents × (Actual rent - Budget rent)

In O2:R2, calculate occupancy, rent, other income and the operating cost effect:

=(D2-C2)*E2
=D2*(F2-E2)
=H2-G2
=I2-J2

The cost formula makes an expense increase a negative contribution to NOI. Keep that sign convention throughout the review.

The check in S2 must return zero:

=SUM(O2:R2)-(N2-M2)

Both property checks and the portfolio check equal zero. The total bridge is -7,600 + 6,080 + 100 - 2,000 = -3,420, which equals 149,980 - 153,400.

For an expense export with property in column A, month in B and positive expense amount in C, aggregate the selected property and month with:

=SUMIFS(Expenses!$C$2:$C$5000,Expenses!$A$2:$A$5000,$A2,Expenses!$B$2:$B$5000,$U$1)

U1 holds the selected month using the same date convention as the export. Microsoft documents SUMIFS as summing amounts that meet multiple criteria. Use equally sized ranges and reconcile the summed expenses to the ledger control total. Covirage is not affiliated with Microsoft.

Turn the bridge into property actions

Property A's total revenue is unchanged: 152,000 + 3,000 = 155,000 budget and 151,800 + 3,200 = 155,000 actual. Higher rent almost offsets lower occupancy, but operating costs explain the full $3,000 NOI shortfall. Ask the property manager for the expense accounts and work orders behind that increase.

Property B has a smaller NOI miss because lower operating costs offset part of its rent shortfall. Leasing owns the occupancy explanation; the property manager owns whether reduced expenses reflect savings or deferred work. Finance owns the reconciliation and consistent definitions.

A real estate dashboard can carry these checked figures into the review. Use collaborative FP&A for the owner submissions, and FP&A consolidation when property results roll into a wider group.

Where it goes wrong

• Closing occupancy against monthly rent. A snapshot and a full-month revenue measure cover different exposure.
• Changing rent definitions. Gross lease rent and earned rent after concessions cannot be mixed in the same bridge.
• Cash receipts counted as earned rent. Deposits, advance payments and late collections can move cash without moving the month's operating performance.
• Capital replacements inside routine costs. One classification change can overwhelm an otherwise useful comparison.
• Acquisitions entering only actuals. Separate newly added properties before describing a comparable-property variance.

Analyze your property files in Covirage

Bring a sample of your own rent roll, expense ledger and property budget as files or a Google Sheet. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.

See FP&A reporting for the supporting finance workflow.