By Md Arif AhamedQuick summary: Learn how to build a hotel budget step by step: forecast revenue, plan costs, test scenarios and track variance monthly. Includes a simple template.
Knowing how to build a hotel budget starts with one idea: forecast revenue first, then fit costs around it. A hotel budget is a month-by-month financial plan for the coming year that sets targets for occupancy, ADR, revenue, departmental costs and profit. You build it by projecting demand and rate, converting that into revenue by department, then layering fixed and variable costs on top.
- Forecast revenue first
- Split fixed and variable costs
- Review and reforecast monthly
Most owners do it the other way round. They take last year’s costs, add 10 percent, and hope revenue follows. That produces a number, not a plan. This guide walks through a practical process that a 40-room hotel in Goa or a 12-room property in Darjeeling can follow with nothing more than a spreadsheet and last year’s accounts.
Why a hotel budget matters
A budget is the benchmark against which every month is judged. Without it, you cannot tell whether a 62 percent occupancy month was good or bad. With it, you can see that the plan said 58 percent, so you are ahead on volume but perhaps behind on rate.
A good budget also drives decisions during the year: when to hire seasonal staff, when to run promotions, how much to spend on marketing, and when to pause discretionary spending. It is also the document banks, investors and partners ask for first.
Budget to build rooms and facilities.
Step-by-step: how to build a hotel budget
Step 1: Gather your inputs
Before touching any numbers, collect the following for the last two or three years if available:
- Monthly occupancy, ADR and RevPAR by room type and by channel.
- Profit and loss statement by month and by department (rooms, food and beverage, other).
- Payroll register, including service charge and statutory contributions.
- Utility bills, repair and maintenance spend, and contract costs such as pest control and software.
- OTA commission statements and direct booking data.
- Your future bookings (on-the-books) for the next six to nine months.
Step 2: Set the market assumptions
Write down what you believe will happen to demand next year. Note new supply near you, new flights or roads, major events, festivals, wedding dates, school holidays and any renovation that takes rooms out of inventory. Keep each assumption written, so you can revisit it when reality differs.
Step 3: Forecast room revenue
Room revenue is the foundation. For each month, calculate:
Room revenue = available rooms x occupancy % x ADR
Available rooms are rooms times days in the month, minus any rooms out of order. Start with last year’s occupancy and ADR for the same month, then adjust for your assumptions. See our guides on hotel demand forecasting and average daily rate for the logic behind each input.
Step 4: Forecast other revenue
Food and beverage, spa, laundry, transport, banquets and activities should be budgeted separately. A common approach is to link them to occupied rooms through a per-occupied-room spend, then add banquet or event revenue where you have actual enquiries. Our article on hotel upselling and ancillary revenue shows where this income usually comes from.
Step 5: Budget departmental costs
Split costs into three groups:
- Variable costs that move with occupancy: housekeeping supplies, laundry, breakfast cost, commissions, payment gateway charges.
- Semi-variable costs that step up at certain volumes: extra staff, utilities, maintenance.
- Fixed costs that do not change with occupancy: core salaries, insurance, licences, property tax, software, loan interest.
Step 6: Calculate profit and test it
Subtract total costs from total revenue to get gross operating profit, then deduct management fees, depreciation and finance costs as your accounting practice requires. Then test it: what happens to profit if occupancy is 5 points lower or ADR is 5 percent lower?
Step 7: Review, approve and lock
Share the draft with the owner, general manager, head chef and housekeeping head. Their comments often catch missing costs. Once approved, lock the original budget and keep a separate reforecast version that you update during the year.
A simple hotel budget template
Use a layout like this for each month. All figures below are hypothetical, for a 40-room hotel in Goa.
| Line | How to calculate | Example (December) |
|---|---|---|
| Available room nights | 40 rooms x 31 days | 1,240 |
| Occupancy | Forecast % | 78% |
| Rooms sold | Available x occupancy | 967 |
| ADR | Forecast rate | ₹6,200 |
| Room revenue | Rooms sold x ADR | ₹59,95,400 |
| F&B and other revenue | Per occupied room + events | ₹14,00,000 |
| Total revenue | Sum | ₹73,95,400 |
| OTA commission | Channel mix x rate | ₹7,20,000 |
| Payroll | Headcount x cost | ₹16,50,000 |
| Other operating costs | Utilities, supplies, repairs | ₹12,00,000 |
| Operating profit | Revenue minus costs | ₹38,25,400 |
Repeat for all twelve months. Seasonality shows immediately: the same hotel may run a much leaner profit in the monsoon, which is why annual averages hide the real picture.
Revenue-led versus cost-led budgeting
| Approach | Starting point | Risk |
|---|---|---|
| Revenue-led | Demand, rate and channel forecast | Over-optimistic forecast inflates profit |
| Cost-led | Last year’s costs plus inflation | Ignores demand changes, hides lost opportunity |
| Zero-based | Every cost justified from scratch | Time-consuming for a small team |
For most independent hotels, a revenue-led budget with a zero-based review of the largest cost lines gives the best balance of accuracy and effort.
Tools you need
A well-structured spreadsheet is enough for most properties. Add a tab per department and a summary tab. Your PMS gives historical occupancy and ADR, your accounting software gives costs, and your channel manager gives channel mix. If your reports are scattered, fix that first; our guide to hotel KPIs lists the numbers worth tracking monthly.
Common mistakes when building a hotel budget
- Using a flat annual occupancy. Always budget month by month, and ideally by day type (weekday, weekend, peak).
- Forgetting commission and payment charges. Distribution cost is a real cost of sale; see OTA commission rates for hotels.
- Ignoring rate and occupancy together. Budgeting higher occupancy and higher ADR at the same time without a reason is wishful thinking.
- Leaving out capital spending. Renovation, furniture replacement and equipment need a reserve.
- Never reforecasting. A budget that is not updated quarterly becomes useless by month four.
- Setting targets nobody owns. Every line needs a named owner.
How to use the budget during the year
Each month, compare actual against budget for occupancy, ADR, RevPAR, revenue, payroll percentage and profit. Explain every variance above a threshold you define, for example 5 percent. Then reforecast the remaining months, keeping the original budget unchanged for reference. This monthly rhythm is where a budget earns its value.
Scenario planning: best, base and worst case
One number is never enough. Build three versions of your revenue forecast and see how profit behaves in each.
| Scenario | Occupancy assumption | ADR assumption | What it tells you |
|---|---|---|---|
| Base | Most likely, from history and pace | Current rate plus planned increase | The budget you commit to |
| Best | Base plus 4 to 5 points | Base plus 3 to 5 percent | Whether you have enough staff and stock |
| Worst | Base minus 5 to 8 points | Base minus 5 percent | Cash needed to survive a weak season |
The worst case matters most. If it shows a loss in the monsoon, you can plan a cash reserve, a leaner roster or a targeted offer for that period well in advance. Our article on hotel occupancy rate explains how to read the occupancy side in more depth.
Budgeting payroll and staffing
Payroll is usually the largest controllable cost, so give it special care. List every position, its monthly cost including statutory contributions, service charge distribution and meals if provided. Then separate permanent roles from seasonal or part-time roles that can flex with occupancy.
A useful check is payroll as a percentage of total revenue for each month. If December shows 22 percent and July shows 41 percent, your roster is not flexing with demand. Decide in advance which roles can move to shorter shifts or temporary contracts in slow months, within the law and your employment agreements.
Budgeting marketing and distribution
Do not set marketing as a random percentage. Start from the revenue you want from each channel, then work out the cost of acquiring it. Direct bookings through your website carry the cost of your booking engine, ads and content. OTA bookings carry commission. Compare the two honestly before moving money between them. Our guide to increasing hotel direct bookings shows which direct tactics usually pay back.
Include these lines: OTA commission, OTA paid visibility programmes if used, Google and social ads, website and booking engine fees, photography, review management and loyalty or repeat guest offers.
Common budget ratios to sanity-check
Ratios vary widely by hotel type and city, so treat them as prompts for questions, not targets. Compare against your own history first.
- Payroll as a percentage of total revenue.
- Room cost per occupied room, covering housekeeping, laundry and amenities.
- Utilities as a percentage of revenue, especially power and diesel in hill locations.
- Distribution cost as a percentage of room revenue.
- Repairs and maintenance as a percentage of revenue, which tends to rise as the property ages.
If a ratio moves sharply without a reason, the budget probably has an error or the business has changed in a way you have not noticed.
Budget checklist
- Collect two to three years of monthly data.
- Write down market assumptions and events.
- Forecast occupancy and ADR by month.
- Calculate room revenue, then other revenue.
- List fixed, semi-variable and variable costs.
- Add commissions, taxes and capital reserve.
- Run a best, base and worst case.
- Get sign-off and assign owners.
- Review monthly and reforecast quarterly.
Key takeaways
- Forecast revenue first; fit costs around it.
- Build monthly, not annually, and separate fixed from variable costs.
- Include distribution costs and a capital reserve.
- Test best and worst cases before approving the budget.
- Compare actual against budget every month and reforecast regularly.
If you would like help turning your numbers into a realistic budget and pricing plan, the team at Revgrow360 hotel revenue management can review your figures through a free consultation via our contact page.
For more background, see this revenue management overview on Wikipedia.
Frequently asked questions
What is the first step in building a hotel budget?
Collect two to three years of monthly data on occupancy, ADR, departmental revenue, payroll and operating costs. Then write down your market assumptions for the coming year. With these inputs you can forecast room revenue first and build costs around it.
How often should a hotel budget be reviewed?
Compare actual results against the budget every month and explain larger variances. Reforecast the remaining months at least quarterly. Keep the original approved budget unchanged so you always have a fixed benchmark to measure performance against.
Should a hotel budget be monthly or annual?
Both. The annual figure is the total target, but you should build it month by month because hotels are seasonal. A flat annual average hides weak and strong periods and leads to poor staffing, marketing and pricing decisions.
What costs do hotels often forget in a budget?
Common omissions are OTA commissions, payment gateway charges, seasonal staff, repairs and replacement of furniture or equipment, licence renewals and software subscriptions. Add a capital reserve and a small contingency so surprises do not wipe out the planned profit.
More Revenue Management guides
Hotel Revenue Forecasting in Excel: A Practical Guide
Build a simple Excel workbook that combines history and on-the-books bookings to forecast rooms, ADR and revenue, then measure accuracy.
OTA Commission Rates for Hotels Explained
What hotels really pay OTAs once programmes, promotions and taxes are added, with typical commission ranges and practical ways to reduce OTA…
Revenue Management for Boutique Hotels: A Practical Guide
A practical guide to pricing and distribution for small, distinctive hotels, including room-type pricing, restrictions, channels and a weekly checklist.
Short Term Rental KPIs: 10 Metrics with Formulas
The 10 short term rental KPIs every host should track, each with a formula and a worked example, plus how to set…
Airbnb Income and Expense Tracking: A Simple System
Learn what to record for every booking and expense, how payouts differ from gross revenue, which categories to use and a monthly…
Revenue Management for Resorts: A Practical Guide
How resorts can manage rates, groups, packages and non-room revenue to maximise total income per guest, with a worked example and checklist.
