How to Build a Realistic Rooms Revenue Budget for an Independent Hotel

A useful annual rooms budget is not last year plus a percentage. It is a month-by-month view of the room nights you expect to sell, the rates guests will pay and the revenue you will retain, with documented assumptions and a separate forecast.

1. Start from actuals and the latest forecast

Reconcile stayed room nights and rooms revenue from your property management system with finance. Inventory follows the hotel's reporting standard: out-of-order rooms, unusable for repairs, are typically removed from available inventory, while out-of-service rooms, briefly held back for minor issues, usually remain in it. Report complimentary and house-use rooms separately from paid room nights. Allocate package, breakfast, VAT and service charge components the same way every month so rooms revenue stays consistent.

Use completed months as actuals and a current forecast for the remaining months. Remove one-off distortions such as a large group or temporary closure, and explain why any exceptional month should repeat.

2. Read on-the-books business as evidence, not a finished forecast

Extract next year's bookings by stay month, segment, channel, rate and cancellation terms. Compare booking pace with the same lead time for previous stay periods, not with their final occupancy. Separate confirmed reservations from tentative enquiries. Apply cancellation and no-show assumptions based on your own experience and the terms of each booking.

Early bookings can reveal demand and price acceptance, but a low on-the-books position far ahead does not automatically mean a weak year. Your normal booking window matters. Record the additional pickup needed to reach each monthly budget and explain which markets, accounts or channels are expected to deliver it.

Illustrative pickup example only, for one month:

3. Build a segment and channel matrix

Segments describe why guests stay: leisure, corporate, groups or wholesale, for example. Channels describe how they book: direct website, hotel reservations, OTA or an intermediary. They overlap, so use a matrix or consistent mapping to avoid counting the same booking twice. Build room nights and achieved ADR for each combination.

Use stayed rates after discounts, not the published best available rate. Show where growth comes from, such as a renewed corporate account or more direct conversion. A segment with no clear route to more bookings should not carry an uplift.

4. Build seasonality month by month

Thailand is not one demand calendar. Use your property's actual weekday, weekend and seasonal pattern; a Bangkok business hotel and a beach resort have different curves. Split busy and quiet dates where a monthly average would conceal the problem.

Create an annual events calendar covering public holidays, source market school breaks, exhibitions and local events. Confirm dates officially, check whether each event generated demand for your hotel, not merely the destination, and drop uplifts for unconfirmed events.

5. Set occupancy and rate assumptions separately

Calculate occupied room nights from demand assumptions and available inventory. Calculate rooms revenue as occupied room nights multiplied by achieved ADR. Derive occupancy and RevPAR from those numbers. Blended ADR must be weighted by sold room nights in each segment, not a simple average of segment ADRs. Separating volume and price exposes targets that need many more rooms at much higher rates.

Illustrative example only: a 100-room hotel with all rooms available for a 30-day month has 3,000 available room nights. Selling 2,100 nights means 70% occupancy. At THB 2,800 ADR, rooms revenue is THB 5,880,000 and RevPAR is THB 1,960. These are model inputs, not a forecast for the Thai market.

Test a downside alongside the base case. What happens if pickup is slower or a planned rate increase fails? Use the revenue calculator to explore room revenue sensitivity, then return to the segment detail before adopting a target.

6. Budget distribution cost and retained revenue

Show gross rooms revenue and a bridge to revenue after acquisition costs: OTA commission, reservation charges, payment fees and direct marketing costs. Agree allocation rules with finance so nothing is omitted or deducted twice. Distribution net revenue is not operating profit.

Illustrative example only: THB 1,000,000 of OTA rooms revenue with an assumed 18% commission leaves THB 820,000 before other costs. The 18% is an example, not a standard rate. Use your contracts and invoices. Direct bookings also have costs, as explained in The True Cost of a Direct Hotel Booking.

7. Test group and wholesale commitments

List contracted group room blocks, rates, release dates, deposits and cancellation conditions. Distinguish guaranteed business from an allocation that may return unsold. For wholesale agreements, check whether rates are net or commissionable and account for inclusions. Do not deduct commission again from a rate already recorded on a net basis.

Review commitments against high-demand dates. A low-rate block can support a quiet month but displace better-paying guests during compression. Estimate realistic materialisation, and have sales and revenue management agree the assumptions first.

8. Turn the budget into a forecast process

Keep the approved budget fixed as the reference plan. Update a separate rolling forecast as evidence changes. Review near-term pickup weekly and refresh the monthly outlook with sales, revenue management and finance. Explain variances through room nights, ADR, segment mix and acquisition cost, not simply a single revenue percentage.

Assign an owner and an action to each material gap, and agree when deviations require owner escalation. The hotel revenue warning signs article can help frame those conversations before a shortfall becomes routine.

For the owner review, our sister company Signa Hotel Advisors offers an annual budget checklist covering owner-side scrutiny.

Frequently asked questions