6.2 Budget Variance Analysis & Corrective Actions

Variance analysis compares actual results with a plan and turns differences into decisions. A useful report states the sign convention, validates accounting completeness, identifies cause, distinguishes timing from structural change, updates the forecast, and assigns action. A percentage alone is not an explanation.

Define the calculation

One common convention is:

$\text{Dollar Variance} = \text{Actual} - \text{Budget}$

$\text{Percentage Variance} = \frac{\text{Actual} - \text{Budget}}{|\text{Budget}|} \times 100$

Under that convention, positive revenue variance is usually favorable and positive expense variance usually unfavorable. Some systems reverse expense signs or calculate budget minus actual. Label favorable or unfavorable explicitly and follow the report definition.

If budget is zero or very small, percentage variance can be undefined or misleading. Report the dollar amount and operational cause. Compare period, year-to-date, and full-year forecast; a favorable current month can reverse later.

Validate before explaining

Reconcile actuals to the general ledger and operational source. Check late invoices, missing accruals, reversals, prepaid allocation, miscodes, duplicate bills, unit status, concessions, payroll allocation, and capital classification. A variance caused by a coding error needs correction, not an operating story.

Verify the budget version and monthly calendarization. Comparing a February expense with an annual average can manufacture a variance when the approved budget expected a March invoice.

Classify the cause

A timing variance moves between periods without necessarily changing the annual total. A structural or permanent variance changes the expected full-year result. Examples:

• an invoice arriving one month late may be timing;
• a utility rate increase may be structural;
• a vacant position creates temporary payroll savings but can create overtime or service cost;
• a tax refund may be one-time;
• a lower repair expense can reflect preventive success or deferred work.

Use price, volume, mix, scope, timing, and efficiency to organize causes. For revenue, consider occupied units, achieved rent, concessions, collection, lease timing, and other-income volume. For expense, consider unit price, usage, staffing hours, asset failure, vendor scope, and accounting.

Flexible comparison

A static budget assumes the planned activity level. A flexible budget adjusts variable expectations to actual activity using an approved relationship. For example, turn-cleaning expense should be interpreted with the number and scope of actual turns. Utility or waste cost may move with occupancy but not always proportionally.

Do not “flex away” poor performance after the fact. Define which costs vary, the driver, rate, and authorization. Preserve the original budget and show the flexible analytical view separately.

Investigation thresholds

Owners often set dollar, percentage, account, or risk thresholds for written explanation. The management agreement, reporting package, lender, or program may set them. There is no universal ARM ±5%, ±10%, or fixed-dollar threshold.

Thresholds do not override risk. A small life-safety, fraud, legal, resident-fund, or recurring control variance can require immediate investigation, while a large expected timing variance may need a concise explanation. Review both amount and consequence.

Root-cause analysis

Move beyond “higher than expected.” If water expense is $18,000 against a $14,000 budget, first confirm meter dates, rates, accrual, occupancy, and reimbursement. Then inspect consumption, leaks, irrigation, equipment, vacancy, and weather. Quantify how much each verified cause explains.

A simple bridge can show:

$\text{Total Variance} = \text{Price Effect} + \text{Volume Effect} + \text{Mix/Scope Effect} + \text{Timing/Other}$

The terms must be defined and reconciled. Avoid double counting interactions.

Corrective action

A complete action states the owner, specific step, authorization, due date, expected financial effect, service or risk effect, and verification. Examples include correcting a ledger mapping, repairing a leak, rebidding an expiring contract, changing a schedule, improving collection controls, or revising the forecast.

Do not cut maintenance, training, security, accessibility, habitability, or staffing below lawful and safe levels simply to offset another line. Consider resident impact, asset life, contractual obligation, and total cost.

Update the forecast

The budget remains the approved baseline. A forecast incorporates actuals to date and current assumptions for remaining months. If a variance is structural, update expected annual result and cash need. If timing, shift the amount without changing annual total unless evidence supports another outcome.

Explain whether the variance affects NOI, cash, capital, balance sheet, or only timing. Communicate material risk early rather than waiting for month-end narratives.

Worked examples

Revenue budget is $200,000 and actual is $190,000. Under actual-minus-budget, dollar variance is negative $10,000, or negative 5%, generally unfavorable. Investigation may separate vacancy, concessions, collection, and rent.

Repair expense budget is $20,000 and actual is $24,000. Variance is positive $4,000, or 20%, generally unfavorable under this sign convention. If $6,000 was a planned job pulled forward from next month, year-to-date and annual interpretation may differ.

The manager's final explanation should allow the owner to answer: Is the number correct? Why did it occur? Will it persist? What are the risks? Who will act, by when, and how will completion be verified?