The Hotel Budget Template Most Owners Get Wrong

Picture an owner who downloads a hotel budget template in November, fills in the blanks, and gets it approved before the new year starts. Six weeks in, a number comes in off, and nobody on the team can say why. Nothing about the process was careless. The template just never asked why any of its numbers were what they were in the first place.

I asked Manish Gupta, the hotel CFO I’ve been working with on this series, why that happens so often. His answer wasn’t about spreadsheets at all.

Too many budgets are created as files to get approved instead of agreements to manage the hotel.

Finance collects the numbers, departments submit something, everyone negotiates the totals, the file balances, it gets approved, and everyone is exhausted. Then the new year arrives, and daily operations carry on almost independently of the budget that was supposed to guide them.

A few terms come up throughout this piece, so in plain terms:

Why Most Hotel Budgets Become Paperwork

The problem, in Manish’s view, usually isn’t the spreadsheet. It’s that the assumptions behind the numbers disappear the moment the file gets approved.

You might have a Rooms Revenue target with nobody able to say what segment mix, channel mix, or rate assumption sits behind it. You might have a payroll number with no workload or productivity assumption attached to it at all. You might have a marketing budget with no stated view of which demand period it’s actually meant to influence.

For Manish, a useful budget answers five things for every material assumption: where it came from, what belief creates it, who owns it, what you’ll do if it doesn’t happen, and when you’ll review it. If those five answers disappear once the file is approved, the budget turns into paperwork fast, and everyone in the building already knows it. They just keep filling it in anyway.

The Budget Agreement Test

Manish built a check for exactly this into his book, Hotel Budgeting and Forecasting in Practice, and calls it the Budget Agreement Test. A material budget number is only ready for approval once your team can answer five questions about it.

Question	What it’s really asking	What breaks without it
Source	Where did this number come from, and when?	Old history gets treated as current fact, without checking whether it’s still complete or comparable
Assumption	What specific operating driver actually creates it?	A percentage gets typed in with no real operating reason behind it
Owner	Who can explain and defend it?	Finance ends up silently owning assumptions it doesn’t actually control
Action	What will you do if it doesn’t happen?	The variance gets reported every month, and nobody changes anything
Review trigger	What event would force you to revisit it?	You find out weeks after the assumption already broke

The five questions depend on each other. A source with no assumption behind it is just history. An assumption with no owner can’t really be defended. An owner with no action attached to it is only a name on a page. Skip any one of them, and the number might still add up correctly. It just isn’t ready to run a hotel on.

When Occupancy Hit Target and Revenue Still Missed

Early in his career, at a large branded city hotel, Manish saw exactly this gap play out. In the first quarter, occupancy came in close to budget. Rooms Revenue did not.

At first glance, that’s confusing. If occupancy is roughly where you expected, why isn’t the revenue there?

The answer was in the business underneath the total occupancy number. The mix of corporate accounts, OTA bookings, group contracts, rate quality, and channel cost had shifted. The team had budgeted the volume reasonably well, but the quality and composition of that volume hadn’t behaved the way the top-line assumption suggested.

Blended numbers are usually outputs, not assumptions.

A “70% occupancy” target isn’t specific enough on its own. Seventy percent built from higher-rated corporate and direct business behaves very differently from 70% built through discounts, wholesale, or costlier OTA channels. Same headline number. Different business underneath it.

Three Questions Before You Sign Off on Any Number

If you’re handed a budget to approve, Manish’s advice comes down to three questions, in this order, before you sign off on anything.

1. What evidence and operating assumption actually create this number? Not whether the growth percentage sounds reasonable, but what will actually create it.
2. Who owns the assumption, and what will you do if it doesn’t happen? Finance can own the model, not the room demand, restaurant covers, staffing productivity, or commercial pipeline behind it.
3. What will trigger you to reopen this assumption? A booking pace that falls behind, a group that cancels, a wage change, a supplier price move, anything specific enough to notice in time.

Finance may own the model, but Finance cannot own the room demand, restaurant covers, staffing productivity, maintenance condition, and commercial pipeline.

Without a review trigger, a team can discover months too late that an assumption stopped being true weeks earlier.

The Budget Agreement Test Template

To make this practical instead of theoretical, I built the Budget Agreement Test into an actual worksheet, free to download, structured around the same five questions.

Each row is one material budget line: the item itself, then Source, Assumption, Owner, Action, and Review Trigger, plus a Status column to mark it Approved, Conditional, or Return, the same three outcomes a finance team would use when reviewing a line before signing off on it.

Here’s what a completed row looks like. This is an illustration, not a real property’s numbers:

Column	Example entry
Budget line	Rooms Revenue
Source	PMS production report, extracted and reconciled against the general ledger on the 1st of the month
Assumption	70% occupancy driven by corporate and direct-channel mix, not discount or wholesale volume
Owner	Revenue Manager
Action	If corporate pace falls behind plan, shift rate strategy and reallocate OTA availability
Review trigger	Booking pace falls 5% behind the expected curve at any 30-day check

Download the Budget Agreement Test template to fill in with your own property’s numbers. It includes the worksheet above, two example rows to work from, and a plain-English reference tab explaining each of the five questions in more depth.

Budget, Forecast, Decision

Once a budget is approved, the discipline that keeps it alive is separating three different things instead of collapsing them into one file.

Budget is what we agreed. Forecast is what we now expect. Decision is what we are going to do about it.

The approved budget stays the baseline. You don’t rewrite it every time conditions change. New information goes into the forecast instead, while the original budget stays as the fixed point you’re actually measuring against.

That’s why Manish doesn’t judge a budget by whether the workbook got approved on time.

Did the budget change how the hotel was managed after approval?

A live budget has assumptions that trace back to the real operation, owners who understand those assumptions, and a regular forecast process that keeps asking whether they’re still valid. A dead one just sits in a folder until next year’s version replaces it.

This is the second of three articles built with Manish around how independent hotel owners can read and manage their own numbers with more confidence. The first looked at why a number can look right and still lead you to the wrong decision. The next looks at treating your hotel less like one business and more like several connected ones.

Bonus: The Full Interview With Manish Gupta

Manish Gupta is a Chartered Accountant and hospitality finance executive with more than 23 years of experience across hotels, resorts, mixed-use assets, and multi-property operating groups in Asia and Africa. With Shangri-La Hotels & Resorts, he was part of the leadership team that turned a loss-making hotel in Chiang Mai into a property generating around $5 million in GOP, before going on to multi-property CFO and owner-side leadership roles. He was named among Asia’s Top 10 CFOs in 2024. He’s also the author of Hotel Financial Reporting in Practice, Hotel Budgeting and Forecasting in Practice, Beyond Accounting: From Finance Manager to CFO, and Independent Hotel Finance (affiliate links). Here are his complete answers, unedited.

Why budgets turn into paperwork

Michael: Why do most hotel budgets turn into paperwork nobody actually uses once the year starts?

Manish Gupta: Because too many budgets are created as files to get approved instead of agreements to manage the hotel.

Finance collects the numbers. Departments submit something. Everyone negotiates the totals. The file eventually balances, it gets approved, and everybody is exhausted.

Then January arrives and daily operations continue almost independently of the budget.

The problem is normally not the spreadsheet. The problem is that the assumptions underneath the numbers have disappeared.

You may have a Rooms Revenue target, but nobody can tell you the segment mix, channel mix, group base or rate assumptions behind it. You may have a payroll number without the workload and productivity assumptions. You may have a marketing budget without knowing what demand period it is supposed to influence.

For me, a useful budget should answer five things for every material assumption: where did it come from, what assumption creates it, who owns it, what will we do if it does not happen, and when will we review it?

If those answers disappear after approval, the budget becomes historical paperwork very quickly.

A real budget number that turned out wrong

Michael: Tell us about a real budget number that turned out very wrong, either too optimistic or too pessimistic. What made it wrong?

Manish Gupta: Early in my hotel-finance career at a large branded city hotel, we had a first-quarter situation where occupancy was quite close to the target, but Rooms Revenue was not.

At first glance, that is confusing. If occupancy is broadly where you expected it to be, why is the revenue not there?

The answer was in the business underneath the total occupancy number.

The mix of corporate accounts, OTA bookings, group contracts, rate quality and channel cost had changed. We had budgeted the volume reasonably well, but the quality and composition of that volume had not behaved the way the top-line assumption suggested.

That was an important lesson for me because the occupancy number itself was not necessarily “wrong.” The budget was incomplete.

An assumption like “70% occupancy” is not enough. Seventy percent occupancy created by higher-rated corporate and direct business can produce a very different result from 70% created through discounts, wholesale or higher-cost OTA channels.

That is one reason I now say that blended numbers are usually outputs, not assumptions.

What to ask before signing off

Michael: If an owner is handed a budget to approve, what two or three questions should they ask before signing it?

Manish Gupta: The first question I would ask is: What evidence and operating assumption create this number?

Not “Does 8% growth sound reasonable?” I want to understand what will actually create the 8%.

The second is: Who owns the assumption, and what will management do if it does not happen?

Finance may own the model, but Finance cannot own the room demand, restaurant covers, staffing productivity, maintenance condition and commercial pipeline.

And the third is: What will trigger us to reopen this assumption?

Maybe booking pace falls 5% behind the expected curve. Maybe a major group cancels. Maybe wages change. Maybe a supplier price moves significantly.

If the budget has no review trigger, management may discover three months too late that an assumption stopped being valid.

What makes a budget survive the year

Michael: What’s the real difference between a budget nobody looks at again and one that actually gets used all year?

Manish Gupta: A useful budget remains connected to the operation.

The approved budget stays as the baseline. You do not keep rewriting history every time conditions change. Instead, new information goes into the forecast.

So the discipline becomes: Budget = what we agreed. Forecast = what we now expect. Decision = what we are going to do about it.

A live budget has assumptions that can be traced back to the operation, owners who understand those assumptions, and a regular forecast process that asks whether they are still valid.

That is why I do not think the success of budgeting should be judged by whether the workbook was approved on time.

The better question is: Did the budget change how the hotel was managed after approval?