Hotel Budget Calculator & P&L Forecaster
Forecast 12 months of revenue, costs and profit for your hotel — with seasonality, OTA commission and rent built in.
How to build a hotel budget
A hotel budget forecasts revenue, costs and profit month by month for the next year. It starts with rooms — the number of rooms, expected occupancy and average daily rate (ADR) — then adds food & beverage and other income, and subtracts payroll, operating costs, OTA commission and fixed charges such as rent or loan EMIs. This free hotel budget calculator builds a 12-month profit and loss forecast with seasonality in seconds.
Key lines in a hotel P&L
| Line | What it includes |
|---|---|
| Room revenue | Room nights sold × ADR |
| F&B and other revenue | Restaurant, banquets, spa, laundry, transport |
| Distribution cost | OTA commission and GST on it |
| Operating costs | Payroll, utilities, supplies, repairs, marketing |
| GOP | Revenue minus operating and distribution costs |
| Profit after fixed charges | GOP minus rent, lease or EMI |
Tips for a realistic forecast
- Use last year's actual occupancy by month, not a flat guess — choose the closest seasonality pattern above.
- Budget ADR by season; peak months should carry a higher rate, not just higher occupancy.
- Include OTA commission explicitly — it is often the second-largest cost after payroll.
- Review the budget monthly against actuals and adjust pricing early. Our revenue management team does this every day for 500+ properties.
Frequently asked questions
What is a good GOP margin for a hotel?
GOP margins vary widely by hotel type and location. Limited-service hotels often run higher margins than full-service hotels with large F&B operations. Compare against your own history and similar properties rather than a single benchmark.
How do I forecast hotel occupancy?
Start from last year's monthly occupancy, adjust for known changes such as new competitors, events and marketing, and track booking pace weekly to update the forecast.
Should OTA commission be in the hotel budget?
Yes. Commission plus GST on it is a major cost for most independent hotels and should be budgeted as a separate line so you can track distribution cost.
Want a revenue expert to check your numbers?
Get a free OTA, pricing and reputation audit from Revgrow360 — no obligation.