How to Build a Simple 12-Month Revenue Forecast for Your Hotel

Content created by Gourmet Marketing, a full-service hotel marketing agency helping independent hotels grow direct revenue with data-driven marketing strategies built for today's competitive landscape.

Every hotelier has a forecast. Most of them just have a bad one.

The budget built last October, untouched since. The spreadsheet with one occupancy number per month, copied from last year plus 3%. The gut feel of a GM who has been in the market for 20 years and is right until the year they are not.

A real 12-month hotel revenue forecast is different. It is a living document that tells you, every month, exactly where revenue is building, where it is stalling, and how much time you have left to do something about it. It is the difference between discovering a soft October in July and discovering it in October.

This is the framework we use with independent and boutique properties, and it is designed to be kept. Bookmark it, build the spreadsheet alongside it, and hand it to the next revenue manager you hire. Everything here works whether you run 30 rooms or 300.

The Core Model: Three Numbers Per Month, Twelve Months Out

Strip away the complexity and every room revenue forecast reduces to:

Rooms Available x Occupancy % x ADR = Room Revenue

Your spreadsheet skeleton is 12 rows, one per month, with columns for:

1. Rooms available (rooms x days in month, minus planned out-of-order rooms)
2. Forecasted occupancy
3. Forecasted ADR
4. Room revenue (calculated)
5. RevPAR (calculated, for benchmarking against your compset)

Add lines for F&B, spa, parking, resort fees, and events if they are material. For most boutique properties, ancillary revenue tracks as a fairly stable percentage of room revenue. Pull that ratio from last year's actuals, apply it, and refine quarterly. Do not let ancillary modeling stall the room revenue work. Rooms are where the forecast lives or dies.

One structural decision matters before you type a single number: your forecast must be organized by stay date, not by booking date. Revenue belongs to the month the guest sleeps in the room, not the month they clicked "confirm." This sounds obvious. It is also the single most common structural error in hotel forecasts, and it quietly breaks every pace comparison you will ever run. Platforms like Hotel Metrics treat purchase date and stay date as two distinct lenses on the same data for exactly this reason: purchase date tells you how your sales period performed, stay date tells you what future demand actually looks like.

Step One: Establish the Seasonal Baseline From Three Years of History

One year of history is an anecdote. Three years is a pattern.

For each of the last 36 months, pull occupancy, ADR, and RevPAR by stay month. Then calculate each month's index against your annual average. If your average annual occupancy is 70% and June historically runs 84%, June indexes at 120. If January runs 49%, it indexes at 70.

That index table is your seasonal fingerprint, and it is the most reusable asset in this entire exercise. It tells you:

• Which months are structurally strong or weak, independent of what happened in any single year.
• Where the variance lives. A month that swings between 58% and 81% across three years demands a conservative forecast and a contingency plan. A month locked at 86% every year can be forecasted tightly and priced aggressively.
• Whether your shoulder seasons are shifting. Many markets have seen September strengthen and July soften over the past few years. Three-year trendlines catch that. Memory does not.

If a year in your history is contaminated by a renovation, a citywide anomaly, or a one-off group, note it and weight it down. Do not delete it. Outliers carry information about your downside case.

Step Two: Layer In Forward Intelligence

History gives you the shape. Now adjust each month for what you actually know about the year ahead. Work through four categories:

Market demand. Convention calendar, festival dates, sports schedules, new flight routes, and anything your CVB publishes. A strong citywide can be worth 4 to 6 occupancy points and 10 to 15% ADR premium on surrounding nights. Put those nights in the forecast explicitly rather than smearing them across the month.

Supply. A new 120-room competitor opening in Q2 does not care about your budget. Model the absorption honestly: expect 2 to 4 points of occupancy pressure and rate compression in affected months for at least two quarters, then plan the counterpunch in product, packaging, and marketing.

Your own initiatives. A website rebuild, a direct booking campaign, a loyalty push. Give these credit, but conservatively and with a lag. Marketing compounds over quarters. It rarely spikes in weeks.

Rate strategy. If you are planning a 6% ADR lift in peak season, model the revenue and then stress-test the assumption: does your product, review score, and compset position support it, or are you about to donate share to the hotel across the street?

Then build three scenarios: conservative, base, and stretch. Budget expenses against conservative. Set team goals against base. The spread between them is your margin of safety, and it is what keeps a soft Q1 from becoming a panicked Q3.

Step Three: Forecast by Channel, Because Revenue Is Not Profit

A forecast that only totals revenue hides the most expensive problem in independent hospitality: channel mix.

Break each month's room revenue into direct website, voice, OTA, GDS, group, and wholesale. Every channel carries a different acquisition cost. An OTA booking at 18% commission on a $220 ADR costs you roughly $40 per night before the guest walks in. The same booking on your own site might cost $8 to $15 in marketing spend, and it hands you the guest relationship instead of renting it.

Now the forecast becomes a strategic weapon. Set a channel mix target: say, moving direct share from 26% to 33% over the year. For a property doing $2.5M in room revenue, that 7-point shift is worth roughly $31,000 a year in avoided commissions, before you count the lifetime value of owning the guest data.

The catch is that most hotels cannot see this clearly. GA4 shows website sessions. The PMS shows confirmed reservations. Neither shows what happens in between: how many guests searched dates, what rates they saw, where they abandoned, and which campaign actually produced the booking. That gap is precisely what booking engine analytics exists to close. Hotel Metrics' channel distribution and full guest journey reporting ties first-touch attribution through to confirmed revenue, so your channel forecast is built on production data instead of assumptions.

Step Four: Run the Monthly Reforecast Ritual

A forecast built in December and reopened in June is a decoration. The value is in the cadence. Block 90 minutes in the first week of every month and run this sequence:

1. Close the month. Actual occupancy, ADR, and revenue next to forecast. Calculate the variance in dollars and percent.

2. Explain every variance over 5%. One honest sentence each. "Citywide underperformed." "We held rate too long in the last 10 days." "The spring campaign converted above plan." This log becomes your institutional memory, and it makes next year's forecast sharper.

3. Check pace on every future month. This is the step that separates forecasting from reporting. For each of the next 12 stay months, compare revenue currently on the books against the same point last year. A month pacing 15% behind in July, with 90 days of booking window left, is a solvable problem. The same gap discovered 20 days out is a fire sale. A live pace report that shows how every future stay month is building versus last year turns this from a half-day data pull into a five-minute read, which is exactly what tools like Hotel Metrics' pace and demand outlook reporting are built for.

4. Reforecast the remaining months. Adjust the numbers, then adjust the plan. A soft month 90 days out gets a targeted campaign, a package, or a booking window promotion. Do not just change the number and hope.

5. Watch booking windows and length of stay. If your average booking window is compressing from 45 days to 30, your pace comparisons need recalibrating and your marketing needs to fire later and harder. This is a leading indicator most hotels never track and it changes everything about how you read pace.

The Benchmarks That Keep You Honest

A few reference points worth taping to the wall:

• Forecast accuracy target: within 5% of actual revenue at 30 days out, within 3% at 14 days out. If you are consistently outside that, the problem is usually pickup assumptions, not the baseline.
• Pickup awareness: know your typical pickup curve. If a month historically books 40% of its final revenue inside the last 30 days, a pace deficit at 60 days out reads very differently than at a property that books 80% in advance.
• Channel cost ceiling: if blended acquisition cost across all channels creeps above 15 to 18% of room revenue, channel mix is eating your hotel annual financial plan from the inside.

And one last hotel budgeting tip that outranks all the others: never let the budget overwrite the forecast. The budget is a commitment made once a year. The forecast is the truth, updated monthly. When they diverge, the forecast wins, and the variance log explains why.

Make the Forecast the Operating System, Not the Homework

Built this way, a 12-month hotel revenue forecast stops being a finance exercise and becomes the operating rhythm of the property. It tells marketing where to spend, tells revenue management where to hold rate, tells operations where to staff, and tells ownership the truth before the P&L does.

The framework is free. The discipline is monthly. The only real dependency is visibility: you cannot forecast demand you cannot see, and you cannot fix a channel mix you cannot measure. If your current stack ends at GA4 and a PMS report, that is the gap to close first. Book a walkthrough of Hotel Metrics and see your demand calendar, pace, and channel production in one view, then build your forecast on top of data that actually reflects how guests book.

Twelve rows. Three scenarios. Ninety minutes a month. That is the whole system, and it will outperform gut feel every single year.

Frequently Asked Questions

What is the difference between a hotel budget and a hotel revenue forecast?

A budget is a commitment made once a year, usually in Q4, and it stays fixed so ownership can measure performance against it. A forecast is a living projection updated every month based on actual pace, pickup, and market conditions. When the two diverge, the forecast is the truth and the budget is the benchmark. Hotels get into trouble when they treat the budget as a prediction instead of a target.

How accurate should a hotel revenue forecast be?

A well-maintained forecast should land within 5% of actual revenue at 30 days out and within 3% at 14 days out. If you are consistently missing by more than that, the problem is usually your pickup assumptions rather than your baseline. Track your accuracy month over month; it is the fastest way to find and fix the weak spots in your model.

How far in advance should a hotel forecast revenue?

Maintain a rolling 12-month forecast by stay date, updated monthly. Twelve months gives you enough runway to act on soft periods with marketing, packaging, and rate strategy while the booking window is still open. Some resort and group-heavy properties extend to 18 or 24 months for the group segment, but 12 months is the working standard for transient business.

What data do I need to build a hotel revenue forecast?

At minimum: three years of monthly occupancy, ADR, and RevPAR by stay date, current on-the-books revenue for every future month, your channel mix by production, and a local demand calendar covering events, citywides, and supply changes. The common gap is forward-looking demand data. A PMS shows confirmed reservations, and GA4 shows website sessions, but neither shows searches, abandoned bookings, or pace by stay month, which is where booking engine analytics platforms like Hotel Metrics fill the picture.

Should I forecast occupancy or ADR first?

Forecast occupancy first, because demand sets the ceiling for rate. Establish each month's likely occupancy range from your seasonal index and current pace, then set ADR strategy against it: hold or push rate in compressed months, and compete on value rather than deep discounting in soft ones. Forecasting ADR first leads to rate plans built on wishful thinking instead of demand.