Budget vs. actual analysis is the process of comparing what was planned to what happened. In commercial real estate, it is the primary tool for identifying operational problems before they become financial crises.
Not all variances matter. A $500 variance in a $50,000 expense category is noise. A $500 variance in a $2,000 expense category is a signal. The skill is knowing which variances require action and which can be ignored.
This article explains how to perform budget variance analysis, which variances matter, and how to automate the exception reporting.
The Variance Framework
Absolute Variance vs. Percentage Variance
Absolute variance: The dollar difference between actual and budget. $5,000 over budget.
Percentage variance: The percentage difference between actual and budget. 10% over budget.
A $5,000 variance on a $500,000 revenue line is 1%. Noise. A $5,000 variance on a $20,000 expense line is 25%. Signal.
The rule: Use percentage variance for large categories. Use absolute variance for small categories. Set thresholds for both.
Favorable vs. Unfavorable
Favorable variance: Actual is better than budget. Revenue higher than expected. Expenses lower than expected.
Unfavorable variance: Actual is worse than budget. Revenue lower than expected. Expenses higher than expected.
Both require explanation. A favorable variance is not automatically good. It may mean the budget was wrong. It may mean revenue was recognized in the wrong period. It may mean an expense was deferred to the next period.
Controllable vs. Uncontrollable
Controllable variance: The variance is caused by something the property manager can influence. Repairs, maintenance, administrative costs, marketing.
Uncontrollable variance: The variance is caused by something outside the property manager's control. Taxes, insurance premiums, utility rates, interest rates.
Controllable variances require action. Uncontrollable variances require documentation.
The Variances That Matter
1. Revenue Variance
What to look for: Rental income below budget. Recovery income below budget. Other income below budget.
Why it matters: Revenue variance directly reduces NOI. A 5% revenue shortfall on a $2 million budget is $100,000 in lost NOI.
Action: Identify the cause. Occupancy decline? Collections problem? Missed escalation? Recovery error?
2. CAM Expense Variance
What to look for: CAM expenses above budget by more than 5% or $2,000.
Why it matters: CAM expenses are recoverable. An overrun reduces recovery if the cap is applied. An overrun without a cap reduces NOI directly.
Action: Identify the specific expense. Determine if it is controllable or uncontrollable. Apply the cap if applicable. Document for the true-up.
3. Tax and Insurance Variance
What to look for: Tax or insurance premiums above the base year or cap.
Why it matters: Tax and insurance increases are often recoverable. If the recovery is not processed, the property absorbs the increase.
Action: Calculate the recoverable amount. Bill the tenant. Document the base year and cap application.
4. Repair and Maintenance Variance
What to look for: R&M expenses above budget by more than 10% or $5,000.
Why it matters: R&M is the most variable operating expense. A large variance may indicate a deferred maintenance problem, a capital expense misclassified as operating, or an emergency repair.
Action: Determine if the expense is operating or capital. If capital, remove from the operating pool. If operating, document for recovery.
5. Utility Variance
What to look for: Utility expenses above budget by more than 8% or $1,500.
Why it matters: Utility variances may indicate a leak, a meter error, a rate increase, or a tenant usage issue. Some utility increases are recoverable through CAM or NNN.
Action: Investigate the cause. Determine if recoverable. Bill the tenant if the lease allows.
The Exception Report
An automated exception report identifies the variances that require attention:
Threshold-based. Variances exceeding 5% or a dollar threshold are flagged. Variances below the threshold are not reported.
Category-specific. Different thresholds for different categories. Revenue: 3%. CAM: 5%. R&M: 10%. Utilities: 8%.
Trend-aware. A variance that is within threshold but has been increasing for three consecutive months is flagged.
Documented. Each exception includes the amount, the category, the cause, and the recommended action.
Conclusion
Budget variance analysis is the tool that identifies operational problems before they become financial crises. The skill is knowing which variances matter and which are noise. The automation is the system that finds the variances that matter and flags them before they become material.
Komod.ai is an AI-native operating layer for the commercial real estate back office. The platform reads leases, invoices, and bank activity; performs deterministic calculations; and stages completed work for human approval. Nothing posts without you.