Hotel Revenue Forecasting: A Simple 30/60/90-Day Method That Works

Most independent hotels in India follow the same ritual: a budget gets built in February or March, everyone signs off, and then the property spends the rest of the year being surprised by it. A soft monsoon quarter, a corporate account that quietly moved its volume, a wedding season that started two weeks late — each one lands as a shock, and the response is always the same panicked rate cut.

The fix is not a better budget. Forecasting is a weekly habit, not a spreadsheet project. A general manager who spends forty-five minutes every Monday looking 30, 60 and 90 days ahead will outperform a hotel with sophisticated software and no rhythm. Here is the method I install in 25–300 room properties, and it works on a single sheet of paper if it has to.

Start With Pickup: What Is Actually on the Books

Every Monday, write down three numbers for each of the next three months: rooms on the books, revenue on the books, and ADR on the books. Then put them next to the same numbers from this time last year.

That comparison — same lead time, same month — is the heart of the method. If last year you had 1,400 room nights on the books 60 days out and finished at 3,100, and this year you have 1,100 at the same point, you are not "fine because there's still time." You are pacing roughly 20% behind, and you now have 60 days to do something about it instead of discovering it in the month-end P&L.

Read Pace by Segment, Not Just in Total

A total pickup number hides more than it reveals. Corporate, leisure/OTA, travel trade, and groups/weddings behave on completely different booking curves. Corporate books 3–15 days out; weddings book months ahead; OTA leisure fills in the last 30 days.

So split your pace:

• Corporate ahead, leisure behind? Hold rates; the OTA window hasn't opened yet.
• Group/wedding pace behind at 90 days? That gap will not self-correct — your sales team needs to move now.
• Everything behind across segments? That is a market problem, and it calls for a rate and promotion response, not just hope.

Layer In What You Already Know Is Coming

Your forecast is pickup plus knowledge. Keep a running demand calendar for the next 90 days:

• City events, exhibitions, and conferences in your micro-market
• Wedding dates and muhurat clusters — in most Indian markets these are knowable months in advance
• Corporate RFP outcomes and contracted account travel patterns
• Holidays, long weekends, school vacations, and election or exam dates that suppress travel

A hotel that knows a three-day exhibition is landing 70 days out prices for it in week one. A hotel that doesn't, sells those rooms at base rates on MakeMyTrip and finds out later what it left on the table.

Turn Occupancy Bands Into Pre-Agreed Actions

Forecasting fails when it produces a number and no decision. Attach actions to bands in advance, so Monday's meeting ends with moves, not commentary. For example, at 30 days out:

• Forecast above 85%: restrict OTA availability, raise rates, stop discounting, tighten cancellation terms on remaining inventory.
• Forecast 65–85%: hold rates, push targeted promotions to your direct database, chase corporate and travel-trade top-ups.
• Forecast below 65%: open promotional rates on shoulder days, activate OTA visibility selectively, and adjust costs — rostering, casual labour, purchasing — before the month begins.

The rate moves themselves should follow a clear dynamic pricing framework, so the team changes prices by rule rather than by mood.

Forecasting Feeds Staffing and Purchasing, Not Just Pricing

This is where the real money hides. A forecast that only drives rates captures half its value. If the 30-day view says 58% occupancy, your F&B purchasing, banquet casuals, housekeeping roster and laundry contracts should all shrink with it. If it says 90%, hire and provision early instead of paying premium rates in a scramble.

Two hotels can earn identical revenue and report very different profits. The difference is rarely one big decision — it's a hundred small ones, made well or made carelessly. Forecasting is what lets you make them early.

Review Your Accuracy Once a Month

At each month-end, compare what you forecast at 30 days out with what actually happened. Were you within 5%? Which segment did you misjudge, and why? A forecast that is never audited never improves. Within three to four months of honest reviews, most teams get their 30-day forecast reliably tight — and that is when management starts trusting it enough to act on it.

Make It a Standing Weekly Ritual

None of this works as a one-time exercise. The 30/60/90 review belongs on the calendar — same day, same hour, every week, with the GM, front office and sales in the room. This is the same argument I make about revenue management discipline overall: results come from the cadence, not the cleverness.

Start This Month

1. Build the one-page 30/60/90 sheet: on-the-books rooms, revenue and ADR versus same time last year.
2. Split pace into four segments — corporate, leisure/OTA, travel trade, groups/weddings.
3. Create a 90-day demand calendar of events, weddings and holidays for your micro-market.
4. Agree your occupancy bands and actions in writing with the team.
5. Fix a weekly 45-minute forecast meeting and a monthly accuracy review — and protect both.

If you want help setting up this forecasting rhythm for your property — templates, bands and the meeting structure included — book a free 30-minute strategy call and we will build it around your numbers.