Who this is for: GMs, controllers, and owners at independent hotels, hotel groups, motels, resorts, B&Bs, parks, and hostels who build or track an annual operating budget. (All seven property types apply.)
This free hotel budget template gives you three ready-to-use budget formats. It covers annual department budgets, quarterly breakdowns, and prior-year comparisons. A filled-in example shows exactly how the numbers should look. Every property type gets its own field table, from independent hotels to campgrounds.
What's Included in This Template
- Annual Department Budget grid, covering Rooms, Food & Beverage, and Other Operated Departments
- Quarterly Budget Breakdown by line item across all four quarters
- Budget vs Prior Year Comparison table with dollar and percent variance
- A worked example with realistic, fully calculated numbers
- Budgeted Revenue, Budgeted Expense, and Departmental Profit fields for every department
- Occupancy, ADR, and RevPAR target fields for revenue planning
- Property-type variations for all seven roommaster property types
Which Budget Template Do You Need?
| Template | Use For | Key Fields |
|---|---|---|
| Annual Department Budget | Setting yearly revenue and expense targets by department | Department, Budgeted Revenue, Budgeted Expense, Budgeted Departmental Profit |
| Quarterly Budget Breakdown | Tracking budget performance across shorter, practical intervals | Line Item, Q1, Q2, Q3, Q4, Annual Total |
| Budget vs Prior Year Comparison | Measuring this year's plan against last year's actual results | Line Item, Current Year Budget, Prior Year Actual, $ Change, % Change |
Template 1: Annual Department Budget
This template sets yearly revenue and expense targets for each department.
| Department | Budgeted Revenue | Budgeted Expense | Budgeted Departmental Profit |
|---|---|---|---|
| Rooms | $[Amount] | $[Amount] | $[Amount] |
| Food & Beverage | $[Amount] | $[Amount] | $[Amount] |
| Other Operated Departments | $[Amount] | $[Amount] | $[Amount] |
| Total | $[Amount] | $[Amount] | $[Amount] |
Template 2: Quarterly Budget Breakdown
Quarterly columns keep this sheet practical, while monthly detail lives in a separate report.
| Line Item | Q1 | Q2 | Q3 | Q4 | Annual Total |
|---|---|---|---|---|---|
| Rooms Revenue | $[Amount] | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
| F&B Revenue | $[Amount] | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
| Total Revenue | $[Amount] | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
| Total Expenses | $[Amount] | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
| Gross Operating Profit (GOP) | $[Amount] | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
Template 3: Budget vs Prior Year Comparison
This template compares this year's budget against last year's actual performance.
| Line Item | Current Year Budget | Prior Year Actual | $ Change | % Change |
|---|---|---|---|---|
| Rooms Revenue | $[Amount] | $[Amount] | $[Amount] | [Percent]% |
| F&B Revenue | $[Amount] | $[Amount] | $[Amount] | [Percent]% |
| Total Revenue | $[Amount] | $[Amount] | $[Amount] | [Percent]% |
| Total Expenses | $[Amount] | $[Amount] | $[Amount] | [Percent]% |
| Gross Operating Profit (GOP) | $[Amount] | $[Amount] | $[Amount] | [Percent]% |
| Occupancy % | [Percent]% | [Percent]% | [Percent] pts | [Percent]% |
| ADR | $[Amount] | $[Amount] | $[Amount] | [Percent]% |
| RevPAR | $[Amount] | $[Amount] | $[Amount] | [Percent]% |
Example: Completed Annual Department Budget
Here is a completed budget for a mid-size independent hotel.
| Department | Budgeted Revenue | Budgeted Expense | Budgeted Departmental Profit |
|---|---|---|---|
| Rooms | $3,800,000 | $950,000 | $2,850,000 |
| Food & Beverage | $850,000 | $680,000 | $170,000 |
| Other Operated Departments | $150,000 | $90,000 | $60,000 |
| Total | $4,800,000 | $1,720,000 | $3,080,000 |
Rooms typically carries the highest margin, while food and beverage runs thinner. Other Operated Departments, like parking or laundry, adds a smaller but steady profit line.
Best Practices for a Hotel Budget
A budget only works if someone checks it against real numbers every month.
- Compare actual spend to budget for every department, every month.
- Build revenue targets from occupancy, ADR, and RevPAR assumptions.
- Set a realistic F&B margin based on last year's actual costs.
- Review payroll budgets against scheduled labor hours each pay period.
- Update the forecast when a major booking pattern shifts mid-year.
- Keep one owner accountable for each department's budget line.
Pro Tip: Convert every budget variance into a percentage before flagging it to ownership.
What Happens When a Hotel Budget Goes Wrong
- A department overspends by 20% because nobody compared actual spend to budget monthly.
- Cash gets tight in the low season because the budget ignored seasonal revenue swings.
- Owners approve a bad hire because the payroll budget was never checked against real shifts.
- A renovation stalls mid-year because capital spending wasn't budgeted as its own line.
- Revenue targets miss by a wide margin because occupancy assumptions never matched market data.
- F&B keeps losing money because nobody set a department-specific expense ratio target.
Hotel Budget Templates by Property Type
All seven property types build some form of annual budget. Independent hotels use the templates above exactly as written.
Hotel Groups Budget
Hotel groups need to roll up budgets across every property in the portfolio.
| Department | Property Name & Location | Budgeted Revenue | Budgeted Expense | Budgeted Departmental Profit |
|---|---|---|---|---|
| Rooms | [Property Name, City] | $[Amount] | $[Amount] | $[Amount] |
| Food & Beverage | [Property Name, City] | $[Amount] | $[Amount] | $[Amount] |
| Other Operated Departments | [Property Name, City] | $[Amount] | $[Amount] | $[Amount] |
| Total | [Property Name, City] | $[Amount] | $[Amount] | $[Amount] |
Motel Budget
Motels rarely run food and beverage or other departments.
| Field | Budgeted Amount |
|---|---|
| Rooms Revenue | $[Amount] |
| Rooms Expense | $[Amount] |
| Departmental Profit | $[Amount] |
Resort Budget
Resorts earn revenue well beyond rooms and food and beverage.
| Department | Budgeted Revenue | Budgeted Expense | Budgeted Departmental Profit |
|---|---|---|---|
| Rooms | $[Amount] | $[Amount] | $[Amount] |
| Food & Beverage | $[Amount] | $[Amount] | $[Amount] |
| Spa | $[Amount] | $[Amount] | $[Amount] |
| Activities & Recreation | $[Amount] | $[Amount] | $[Amount] |
| Total | $[Amount] | $[Amount] | $[Amount] |
Bed & Breakfast Budget
B&Bs run a simpler budget with breakfast folded into room revenue.
| Field | Budgeted Amount |
|---|---|
| Room Revenue (Breakfast Included) | $[Amount] |
| Utilities Expense | $[Amount] |
| Housekeeping & Supplies Expense | $[Amount] |
| Maintenance Expense | $[Amount] |
| Departmental Profit | $[Amount] |
Parks (RV & Campground) Budget
Campgrounds budget by site instead of by room.
| Department | Budgeted Revenue | Budgeted Expense | Budgeted Departmental Profit |
|---|---|---|---|
| Site Revenue | $[Amount] | $[Amount] | $[Amount] |
| Camp Store & Retail | $[Amount] | $[Amount] | $[Amount] |
| Total | $[Amount] | $[Amount] | $[Amount] |
Hostel Budget
Hostels budget by bed rather than by room.
| Department | Budgeted Revenue | Budgeted Expense | Budgeted Departmental Profit |
|---|---|---|---|
| Bed Revenue | $[Amount] | $[Amount] | $[Amount] |
| Food & Beverage | $[Amount] | $[Amount] | $[Amount] |
| Other Operated Departments | $[Amount] | $[Amount] | $[Amount] |
| Total | $[Amount] | $[Amount] | $[Amount] |
A budget nobody checks against actuals stops being useful within a few months. Numbers drift, and decisions get made on assumptions that are already stale.
How roommaster Fits In
roommaster PMS includes hundreds of built-in reports for pulling real financial data. Finance teams can compare actual department revenue and expenses against the budget in minutes. roommaster Revenue Management adds demand forecasting for next year's rate and occupancy assumptions. That keeps the revenue side of the budget grounded in real market signals.
Frequently Asked Questions
1. What is a hotel budget template?
A hotel budget template projects revenue, expenses, and profit by department for the year.
2. How often should a hotel budget be revised during the year?
Most hotels review the budget monthly and adjust forecasts when actual performance drifts from plan.
3. What's the difference between a budget and a forecast?
A budget sets fixed annual targets for the year. A forecast updates predictions based on current trends.
4. Should a hotel budget include occupancy and ADR targets?
Yes, occupancy and ADR targets anchor revenue projections and make variance analysis meaningful.
5. How far in advance should next year's budget be built?
Most properties start budgeting 60 to 90 days before the fiscal year begins.
