Budget vs Actual: What Is Variance Analysis and How to Run One for a Multifamily Property

A budget vs actual report tells you the property missed. It doesn't tell you why, and why is the first thing the owner is going to ask.

The short version: compare every line to plan, ignore the noise, and sort what's left into timing, one-time, recurring or error. Then say what changes for the rest of the year.

Quick Answer Budget vs actual compares what a property planned to earn and spend with what it actually earned and spent over the same period. The gap is the variance: Variance = Actual − Budget, and Variance % = (Actual − Budget) ÷ Budget. A property that budgeted $22,000 for make-ready and spent $30,240 has an unfavorable variance of $8,240, or 37.5%. Variance analysis is the next step: working out why the gap happened, whether it will continue and what to do about it.

What Does Budget vs Actual Mean?

Budget vs actual is a side-by-side comparison of your plan and your results. You'll also see it called "actual vs budget" or "budget to actual." All three describe the same report.

Three terms do all the work:

• Budget: The approved plan for the period. In multifamily, that's the annual operating budget, broken out by month. Our guide covers how a property budget gets built.
• Actuals: What was really recorded in the books for the same period, usually from the property's P&L.
• Variance: The difference between the two, in dollars and as a percentage.

The comparison runs line by line, from income down to net operating income (NOI). NOI is the number owners read first, so it's usually where the questions start.

What Is Variance Analysis?

Variance analysis is the process of finding out why actual results differ from the plan. The Association for Financial Professionals (AFP) defines it in its variance analysis glossary as "a quantitative method used to assess the difference between planned and actual financial outcomes."

The report shows what happened. The analysis explains it. AFP gives the review three jobs: find the root cause, decide how controllable it is, and make someone responsible for the fix.

Budget variance analysis is the same process with the approved budget as the yardstick. It's the version most owners ask for, but it isn't the only useful comparison:

One note on the name: "analysis of variance" (ANOVA) is an unrelated statistics method. This article covers the finance version.

Types of Variance Analysis

Most guides list variance types that were built for factories. CFI's variance analysis guide breaks costs into materials, labor, variable overhead and fixed overhead. Add a sales variance on the revenue side and you have the usual list.

A property doesn't buy raw materials, but the ideas translate:

The Budget Variance Formula

Two formulas cover every line on the report:

Variance = Actual − Budget
Variance % = (Actual − Budget) ÷ Budget

Here's make-ready, with a $22,000 budget and $30,240 of actual spend:

Variance = $30,240 − $22,000 = +$8,240
Variance % = $8,240 ÷ $22,000 = +37.5%

If a line has no budget at all, the percentage doesn't exist. Show the dollars and write "n/a."

Favorable vs Unfavorable Variances

A positive variance isn't automatically good news. More income helps NOI. More expense hurts it.

That's why AFP describes variances as "favorable" and "unfavorable" rather than "positive" and "negative":

Some reports flip the sign on expense lines, so a positive number always means "good for NOI." Either approach works. Pick one, label it and use it on every report.

In this article, variance is always actual minus budget, and an F or U column does the interpreting.

Budget vs Actual Report: A Multifamily Variance Analysis Example

Here's a budget vs actual report for an illustrative 120-unit property with a $1,500 average market rent. It's the same property from our NOI calculation walkthrough, six months into the year.

Illustrative example. Not a benchmark for any market.

Three things stand out:

• The total hides the story. Operating expenses are only 1.7% over budget, which sounds fine. Underneath, $25,890 of overruns are being offset by $17,211 of savings, and some of those savings won't last.
• The percentage can mislead you. Rental income is only 2.6% off, yet it's the largest variance on the page. Marketing is 25.6% over, and that's $3,200.
• A favorable variance can be bad news. The management fee is $711 under budget because it's 3% of total income, and total income fell.

Finance teams often lay the same numbers out as a walk: a path from budgeted NOI to actual NOI. An AACSB article on variance analysis notes that "Most businesses apply variance analysis at the operating income level," often using walk or waterfall charts. For a property, that level is NOI.

In a walk, each number shows its effect on NOI, so an expense overrun is negative:

Budgeted NOI                   $511,966
Net rental income              −$25,500
Make-ready and turnover         −$8,240
Utilities                       −$6,800
Insurance                       −$6,750
Payroll                         +$9,000
Contract services               +$6,000
All other lines, net               −$89
Actual NOI                     $479,587

That's the view an owner can follow in about 30 seconds.

What to Include in a Budget vs Actual Report

The columns above are the minimum. A report your team can act on also has:

• Month and year-to-date views. One month can swing on a single invoice. Year to date shows whether the swing held.
• A budget phased by month. Spread each line the way it will actually happen. This property expects 22 of its 50 annual turns by June, because its lease expirations lean toward late summer, and it budgets a $6,000 annual fire inspection in May.
• A flag for lines that need an explanation. Step 2 below covers how to set it.
• An explanation column. One or two sentences for each flagged line.
• A full-year estimate. Where each flagged line should land by December.

To build it in Excel, put the line name in column A, Income or Expense in column B, the budget in column C and the actual in column D. Then add these formulas in row 2 and copy them down:

E (Variance):    =D2-C2
F (Variance %):  =IF(C2=0,"n/a",E2/C2)
G (F/U):         =IF(E2=0,"-",IF(OR(AND(B2="Income",E2>0),AND(B2="Expense",E2<0)),"F","U"))
H (Explain?):    =IF(OR(ABS(E2)>=10000,AND(ABS(E2)>=5000,IF(C2=0,TRUE,ABS(E2/C2)>=0.05))),"Explain","")

The last formula uses the example thresholds from step 2. Change them to fit your property.

How to Run a Budget Variance Analysis in 5 Steps

Here's the sequence, using the report above. It turns a $32,379 NOI miss into a list of causes and a revised full-year number.

1) Clean the Actuals First

Before you explain a variance, make sure it's real. Some variances are just bookkeeping.

• Coding. Is each invoice on the right line? Consistent expense coding has to come before any line-level analysis.
• Capital vs operating. An $8,000 HVAC replacement coded to repairs creates a variance nobody should have to explain. Our post on capex vs opex in real estate shows where the line falls.
• Period. Did the invoice land in the month the service happened?
• Accruals. If you accrue property taxes at budget until the bill arrives, a $0 variance doesn't mean you're on budget. It means you don't know yet. That's the property tax line in this report.

2) Filter to the Variances That Matter

Don't explain every line. AFP calls this management by exception: leaders focus on variances that "exceed a predetermined materiality threshold." Wall Street Prep's budget to actual guide asks whether it matters if a million-dollar line item is $100 off, then answers: "Probably not."

There's no industry-standard threshold, so set your own and use two tests. A percentage alone chases small lines like marketing, and it can wave through a big miss like rental income. A low dollar amount alone flags large lines that barely moved.

Here's an illustrative rule for this six-month report: explain any line that's over 5% and over $5,000, plus any line over $10,000 at any percentage. Scale the dollar amounts to the property and the period. A one-month report needs lower ones.

That rule flags six of the 12 lines: net rental income, payroll, make-ready, contract services, utilities and insurance. Those six account for all but $89 of the NOI miss.

Check whether your owner or management agreement already sets a threshold. Lender reporting has its own too. Freddie Mac's March 2020 desk reference for loan servicers calls for commentary when effective gross income (total income), total operating expenses, total capital items or debt service coverage ratio (DSCR) move more than 20% in either direction between full years.

The same guide applies that 20% test against underwriting for the first three years of reporting, or while underwriting is still relevant, and it lists the property manager among the possible sources of information. Requirements vary by lender and loan program, so check your own loan documents.

3) Sort Each Variance: Timing, One-Time, Recurring or Error

Every flagged variance is one of four types, and the type decides what happens next:

Utilities are recurring in this report too, because a water rate increase took effect in January. Rental income is recurring until two vacant units lease.

Sort the favorable lines as well. AFP's guidance is direct: "Material favorable variances are not immune from analysis." That $9,000 payroll saving is the proof.

While the position sat open, turns went to outside vendors, and that cost is sitting in the make-ready line.

If you can't say which type a variance is, you aren't done with it.

4) Split Real Variances Into Volume and Rate

Most real variances have two possible causes: you did more of something, or you paid more for it. Splitting them tells you which conversation to have. These are AFP's price and volume formulas, with "rate" in place of "price":

Volume variance = (Actual Volume − Budgeted Volume) × Budgeted Rate
Rate variance   = (Actual Rate − Budgeted Rate) × Actual Volume

The property budgeted 22 turns at $1,000 each through June. It ran 27 turns at $1,120:

Volume variance = (27 − 22) × $1,000 = $5,000
Rate variance   = ($1,120 − $1,000) × 27 = $3,240
Total variance  = $5,000 + $3,240 = $8,240

About 61% of the overrun came from more turns, which is a retention question. About 39% came from cost per turn, which is a vendor, scope and staffing question.

Finance calls the first half of this a flexible budget: the budget re-run at actual volume. Here, 27 turns at $1,000 is a $27,000 flexible budget. Measured against that, the team is $3,240 over, not $8,240.

The same split works on most multifamily lines:

On this property, two extra vacant units for six months at $1,500 is $18,000 of volume. Another $7,500 of concessions used to fill units is rate. Together they make up the $25,500 rental income miss.

Concession and disclosure rules vary by state and city, so check local rules before changing your offers.

5) Write the Explanation, Then Update the Forecast

A good variance explanation has five parts: what moved, what drove it, which type it is, what's being done and what it means for the full year.

Here's the same variance explained two ways:

Weak: Make-ready is over budget due to higher than expected turn costs.

Strong: Make-ready is $8,240 over budget year to date (+37.5%). We ran 27 turns against 22 budgeted, which accounts for $5,000. Cost per turn was $1,120 against $1,000, which accounts for $3,240, because turns went to outside vendors while the maintenance tech position was open. That position filled in June, so we expect cost per turn back near budget. Full-year estimate: $8,240 over.

The weak version only repeats the number in the next column.

Then carry each flagged line forward to December. The type tells you how:

Illustrative example. Signs show the effect on NOI.

Doubling the year-to-date number would give you about $64,600. Working line by line gives you about $57,800, and it shows which part you can still change: those two vacant units.

Variance reports look backward by design. By the time one lands, you may be reading 45-day-old actuals, which is why reforecasting through the year belongs next to this report instead of after it.

Across a portfolio, this work gets slow by hand, because every property means another export and another copy of the file. Vizibly connects to Yardi, RealPage and Entrata and rolls up budgets, forecasts and actuals, so the comparison starts from current numbers.

The same sorting pays off at budget time. Recurring variances get built into next year's numbers, one-time items get left out, and timing items move to the right month. Asset Living moved its budget workshops from August to October "to incorporate more current-year actuals."

Why Owners Ask "Is It Recurring?"

Owners don't weigh every variance the same way. A one-time variance changes this year's NOI. A recurring one changes what the property earns every year, and that's what value is based on.

In this example, insurance and utilities add $27,100 a year of recurring expense. A cap rate converts NOI into property value, and we cover how in our post on debt, DSCR and valuations. At an illustrative 5% cap rate:

$27,100 ÷ 0.05 = $542,000 of implied value

The $9,000 payroll saving doesn't get that treatment. It helps this year's NOI, and then it's gone. The 5% is for illustration only, not a market rate or a valuation.

Not every recurring line is yours to control. NAA's 2025 Dollar of Rent analysis, which covers 13,471 communities, found that revenue grew 2.7% in 2025 while operating expenses grew 4.6%. As NAA puts it, "Tax assessments, insurance premiums and utility rates are set elsewhere."

You can't negotiate the premium on-site. You can control how early the owner hears about it and how clearly it's separated from the lines your team runs.

Consistency matters as much as the math. When a variance labeled "timing" in April is still sitting there in August, owners start discounting everything else on the page. That's how the operator–owner trust gap opens.

Keep a running note on each open variance and close it out when it reverses.

Common Budget vs Actual Mistakes

• Dividing the annual budget by 12. Turns, utilities and annual contracts don't run evenly. On this property, a flat make-ready budget would be $25,000 through June instead of $22,000, which hides $3,000 of the overrun.
• Mixing cash and accrual. If the budget spreads an insurance premium across the year and the books expense it when it's paid, the month of payment shows a huge variance that means nothing.
• Skipping favorable lines. A repairs line under budget in June can be deferred work that comes back in October.
• Rewriting the budget mid-year. Once the baseline moves, the comparison stops meaning anything. Keep the approved budget fixed and put changes in the forecast.
• Comparing dollar variances across properties. A $10,000 overrun is about $167 per unit on 60 units and about $17 per unit on 600. Use per-unit numbers in a portfolio review.

FAQ

What is the difference between budget and actual?

The budget is the approved plan for a period, and actuals are what was really recorded in the books for that same period. The difference between them is the variance.

Is it budget vs actual or actual vs budget?

Both names describe the same report, and "budget to actual" is a third. What matters is stating your sign convention, because some reports flip the sign on expense lines.

What is an acceptable budget variance percentage?

There's no universal standard, and the right threshold depends on the size of the line and what your owner or lender requires. A practical rule pairs a percentage with a dollar amount, because a high percentage on a small line and a low percentage on a large line can both mislead.

What are the four main types of variance analysis?

Cost accounting usually lists materials, labor, variable overhead and fixed overhead variances, which come from manufacturing. In multifamily, those map to make-ready, payroll, utilities, and fixed costs such as insurance and property taxes.

What is a variance report?

A variance report summarizes the differences between planned and actual results so management can see what to act on first. In property management, it's usually a budget vs actual report plus a written explanation for each significant line.

How often should you run a budget vs actual report?

Run it monthly after the books close, with month and year-to-date views side by side. Reforecast on a regular schedule alongside it, so you aren't waiting on the report to see what's coming.

The Punchline

A budget vs actual report shows where the property landed. Variance analysis shows what to do next.

Timing reverses. One-time stays. Recurring compounds. Errors get fixed.

Know which one you're looking at before the owner asks.

Want your team writing variance explanations like this? Financials 101 for Property Managers walks through the whole P&L, with Volume × Rate and Variance Statement Builder calculators built in.

Sources

• Association for Financial Professionals, "Variance Analysis" (glossary), updated June 29, 2026. https://www.financialprofessionals.org/glossary/variance-analysis
• National Apartment Association, "Where a Dollar of Rent Went in 2025," Leah Cuffy and Michael Liu, October 14, 2026. https://naahq.org/news/where-dollar-rent-went-2025
• Freddie Mac Multifamily, "PRS CREFC Desk Reference Guide," March 2020. https://mf.freddiemac.com/docs/prs_cref_individual_desk_reference.pdf
• Wall Street Prep, "Budget to Actual Variance Analysis," updated February 20, 2024. https://www.wallstreetprep.com/knowledge/budget-actual-variance-analysis-fpa/
• Thomas E. Conine Jr. and Michael B. McDonald IV, "The Importance of Variance Analysis," AACSB Insights, January 21, 2020. https://www.aacsb.edu/insights/articles/2020/01/the-importance-of-variance-analysis
• Corporate Finance Institute, "Variance Analysis," October 3, 2019. https://corporatefinanceinstitute.com/resources/accounting/variance-analysis/