Every year, the same thing happens. Budget season arrives and the operations team suddenly needs data they have never asked for before. The accounting team scrambles to build reports from scratch. Somebody pulls numbers into Excel and manually adjusts them. The budget gets submitted two weeks late with asterisks next to the numbers nobody is confident about.
The problem is not the budget process. The problem is that the reports needed for budgeting do not exist until someone is already under the gun.
Here are five reports you should have built and running before the first budget meeting gets scheduled. Not complicated reports. Not dashboards with 47 widgets. Five straightforward reports that answer the questions your budget is supposed to answer.
1. Rent Roll Variance: Budget vs. Actual vs. Market
This is the one that matters most, and the one most companies get wrong.
A standard rent roll tells you what each unit is renting for right now. That is a snapshot. For budgeting, you need the trend and the gap.
What this report shows:
- Current in-place rent per unit
- What the budget projected for that unit
- Current market rent for comparable units (from your comp surveys or third-party data)
- The variance between all three: budget-to-actual, actual-to-market, budget-to-market
Why you need it before budget season: If your in-place rents are 6% below market and your budget projected them at 3% below, your next budget needs to account for both the opportunity and the execution gap. Building this report during budget season means you are calculating variances while simultaneously trying to set targets. Those two things need to happen sequentially, not in parallel.
What to look for: Properties where in-place rent is significantly below market but turnover is low. Those are properties where your residents are getting a deal and they know it. Your renewal increase strategy for next year starts with this data.
2. Maintenance Cost Trending by Category
Your maintenance budget for next year should not be "last year plus 3%." It should be based on actual cost trends by category, because not all maintenance costs move at the same rate.
What this report shows:
- Monthly maintenance spend by category (HVAC, plumbing, electrical, appliance, etc.) for the trailing 24 months
- Cost per unit by category
- Trend line: increasing, stable, or decreasing
- Seasonal patterns (HVAC spikes in summer, plumbing in winter)
Why you need it before budget season: If your HVAC costs have increased 18% year-over-year but your plumbing costs are flat, a blanket 3% increase across all maintenance categories is going to be wrong in both directions. You will underbudget HVAC and overbudget plumbing. Both errors create variance that your team has to explain every month.
What to look for: Categories where costs are accelerating. If emergency HVAC repairs doubled at a specific property, that is a capital replacement signal, not a maintenance budget line item. Catching that before budget season means you can put a capital project in the budget instead of padding the maintenance line and hoping for the best.
3. Lease Expiration Clustering
This is the report most companies do not have, and it is the one that causes the most preventable revenue loss.
What this report shows:
- Number of leases expiring each month for the next 18 months, by property
- Percentage of total units expiring each month
- Average rent of expiring leases vs. current market
- Historical renewal rate by month (so you can project likely turnover)
Why you need it before budget season: If 40% of your leases at Property A expire in March and April, your vacancy budget for Q1 needs to reflect that. Your marketing budget for Q1 needs to reflect that. Your turn cost budget for Q1 needs to reflect that. If you are building the budget with an even distribution of lease expirations, you are going to miss Q1 by a mile and overcorrect for the rest of the year.
What to look for: Clusters. If too many leases expire in the same month, you have a structural problem that originated when the property was leased up. The budget is the wrong place to fix this -- the renewal strategy is. But you need to see the clusters before you can design around them.
4. Utility Cost Per Unit Trending
Utility costs are the line item most companies budget as a flat number or a flat percentage increase. That works until it does not, and when it does not, the variance can be significant.
What this report shows:
- Monthly utility cost per unit by type (water/sewer, electric, gas, trash) for the trailing 24 months
- Trend by property (some properties may be trending up while others are flat)
- Comparison to utility rate increases from the local provider
- RUBS recovery rate if applicable (how much you are billing back vs. paying)
Why you need it before budget season: Utility rates are set by external providers, and rate increases are usually published months in advance. If your water provider announced an 8% rate increase effective January, and you budgeted 3% growth, you are starting the year behind. This report lets you incorporate known rate changes into your budget before the first draft.
What to look for: Properties where cost-per-unit is significantly above portfolio average. That is either a leak, a billing error, or an operational issue (common area lights running 24 hours, irrigation systems on during rain). All of those are fixable, but only if you see them before they become next year's budget baseline.
5. Vacancy Loss by Property with Cause Codes
Most companies track vacancy as a single number: units occupied / units available. That is insufficient for budgeting because it treats all vacancy as the same.
What this report shows:
- Vacancy loss in dollars, by property, by month
- Breakdown by cause: market vacancy (no demand), model/office units, down units (renovation/repair), skips/evictions, notice-to-vacate pipeline
- Average days vacant by cause code
- Revenue impact: what each day of vacancy costs at that unit's rent level
Why you need it before budget season: If your 5% vacancy rate is actually 2% market vacancy, 1% renovation downs, 1% eviction-related, and 1% slow turns, your budget strategy for each of those is completely different. Market vacancy needs marketing spend. Renovation downs need capital project timelines. Eviction vacancy needs legal process improvements. Slow turns need operations fixes.
Budgeting "5% vacancy" as a single line item means you are funding none of those solutions specifically.
What to look for: Properties where "down units" have been down for more than 45 days. That is either a capital project that stalled or a unit that fell through the cracks. Either way, it is revenue loss that is fixable, and it should not be in next year's vacancy budget as if it is normal.
Build Them Now
All five of these reports can be built from data that already exists in your system. None of them require new software, new integrations, or a BI platform. They require someone to build the report specifications, test them against your data, and validate that the numbers tie to your financials.
The time to build them is now. Not when the CFO sends out the budget calendar. Not when the regional managers are asking for "just a quick report." Now, when there is no deadline pressure and the data team can build something they are confident in.
Every year I see companies spend 80% of their budget season energy on building reports and 20% on actually analyzing the data and making decisions. That ratio should be inverted. Build the reports before the season. Spend the season on decisions.
If you are looking at budget season and your reports are not ready, that is a solvable problem. Reach me at nick@cokas.io.