Who This Guide Is For
This guide is for Indian hotel owners and managers who understand the value of revenue management but are not yet using dedicated revenue management software. It covers how to build a practical, functional revenue management process using Excel or Google Sheets — the tools most hotel teams already have.
A well-designed spreadsheet process handles the core of what revenue management requires: tracking booking pace, monitoring competitor rates, maintaining a demand calendar, and making rate decisions based on data rather than instinct. It is not as fast or as comprehensive as a Revenue Management System, but it is significantly better than no process at all.
This guide also covers clearly when a spreadsheet is no longer sufficient — so you know the right moment to invest in purpose-built software rather than continuing to patch a process that has outgrown its tools.
The Core Revenue Management Spreadsheet
What it needs to do
A revenue management spreadsheet for a small Indian hotel needs to track four things: occupancy on the books for future dates, booking pace compared to the same period last year, competitor rates for the next 30 days, and the current rate plan for each room type across each channel.
Everything else — segment analysis, channel mix reporting, TRevPAR tracking — can be added over time. Start with these four and build from there.
Structure: one row per future date
The most practical structure is a row for each future date — typically the next 90 days — with columns for: date, day of week, any events or demand triggers, rooms on the books today, rooms on the books at the same point last year, variance (this year versus last year, as a number and a percentage), current rate, and competitor rate checks for your top two or three comparable properties.
Updating it
The spreadsheet is only useful if it is updated consistently. For most small Indian hotels, a daily 15-minute update is the right cadence: pull the current rooms-on-books count from your PMS for each of the next 30 dates, check competitor rates on Booking.com for the next 14 high-demand dates, and update any rate changes made that day.
Building Your Demand Calendar in Excel
A demand calendar maps every significant demand trigger for the next 12 months against its expected impact on your property. For an Indian hotel, this means capturing:
- National holidays and long weekends: Republic Day, Holi, Eid, Independence Day, Gandhi Jayanti, Diwali, Christmas, New Year
- Regional festivals: Ganesh Chaturthi in Maharashtra, Navratri across Gujarat and western India, Pongal in Tamil Nadu, Onam in Kerala, Durga Puja in West Bengal
- Wedding season: typically peaks in November-December and February-March, varying by region and community
- School holidays: summer, Diwali break, winter break — these drive domestic leisure demand
- Local events: conferences, exhibitions, concerts, sporting events near your property
- Corporate cycles: MICE event seasons, financial year-end travel patterns for business hotels
For each event, assign a demand tier: Low, Medium, High, or Peak. This tier determines which rate tier applies to that period. The demand calendar, built once and updated annually, is the foundation of forward-looking pricing decisions.Here are some e-books and webinars that can better guide your hotel.
Rate Tier Structure in Excel
Define four rate tiers for each room type and set them up in a reference table in your spreadsheet:
- Floor Rate: the minimum rate below which you will not sell under any circumstances, regardless of occupancy. This covers variable cost and a margin contribution.
- BAR (Best Available Rate): your standard rate for moderate demand periods — neither high nor low. This is the rate that applies to most of the year.
- High Demand Rate: applied when booking pace is running ahead of last year or when local events are creating stronger demand. Typically 15 to 25% above BAR.
- Peak Rate: applied during your highest demand periods — major festivals, long weekends, events that drive near-full occupancy. Typically 30 to 50% above BAR, or higher if demand supports it.
The decision of which tier to apply to any given date comes from your booking pace data and demand calendar, not from intuition. A date where rooms-on-books are 20% ahead of last year at the same point in advance gets a rate increase. A date where rooms-on-books are 20% behind gets a promotion or stays at BAR.
Competitor Rate Tracking in Excel
A weekly competitor rate check for your top two or three comparable properties takes 15 to 20 minutes and changes pricing decisions materially. Build a simple tracking table in your spreadsheet with columns for: date, your current rate, competitor A rate, competitor B rate, competitor C rate, and a flag for any dates where a competitor is significantly above or below your rate.
Check Booking.com for each competitor on the same dates you are tracking your own booking pace. Look specifically for:
- Dates where competitors have raised rates significantly above yours — a signal that they see demand you may have priced too conservatively
- Dates where a competitor has gone to stop-sell — a signal that the market is tightening and you may be able to raise rates on remaining inventory
- Dates where competitors are running promotions or reduced rates — a signal of weak demand that may require a response
Weekly Revenue Review Routine
A weekly 45-minute revenue review using your spreadsheet is the operating rhythm that makes the data useful. Structure it consistently:
- Review booking pace for the next 60 days: which dates are ahead of last year, which are behind
- Check current rates against your demand calendar tier — is the rate on each date appropriate for the tier assigned to it
- Review competitor rates for the next 30 high-demand dates — any significant movement to act on
- Make rate decisions: increase rates on dates running ahead of pace, apply promotions or packages on dates running behind
- Update the spreadsheet with any rate changes made this week
Done consistently, this routine takes less than an hour and produces meaningfully better pricing decisions than gut feel alone.
When Excel Is No Longer Enough
A spreadsheet works well for properties under approximately 20 rooms managing three or fewer OTAs with a relatively straightforward demand pattern. It becomes insufficient when:
- The number of dates and channels to track exceeds what one person can update reliably in 15 to 20 minutes per day
- Demand patterns are complex enough that manual competitor tracking misses rate signals faster than the team can respond
- The property needs rate automation — the ability to push rate changes across all OTAs without manual entry for each channel
- Multiple properties need to be managed and a single spreadsheet cannot handle the data volume
- The team wants demand forecasting accuracy beyond what historical pace comparison can provide
At this point, a Revenue Management System typically pays for itself within two to four months of implementation through the RevPAR improvement it enables compared to the manual spreadsheet process. The transition from spreadsheet to RMS is also easier if the spreadsheet process has been running well — the data habits, the demand calendar, and the competitive set are all already in place.
→ Shelter Beach Resorts — RMS — Moving from manual to automated revenue management
→ All Success Stories — Properties that made the transition from spreadsheet to RMS
Excel Templates for Hotel Revenue Management
The most useful templates to build or adapt for your property:
- 90-day booking pace tracker: rows for each of the next 90 dates, columns for rooms on books today, rooms on books same day last year, variance, current rate, and competitor rates
- 12-month demand calendar: rows for each week of the year, columns for demand tier, known events, rate tier applied, notes
- Rate plan reference table: room types as rows, demand tiers as columns, with the specific rate for each combination
- Channel mix summary: monthly booking counts and OTA revenue and direct, with net ADR after commission for each channel
- Weekly revenue review log: a simple record of decisions made each week, the data that drove them, and the actual outcome — essential for learning what works in your specific market
AxisRooms and Revenue Management
The transition from spreadsheet to AxisRooms is designed to preserve the work you have already done: your demand calendar, rate tiers, competitive set, and rate decision logic all transfer directly into the platform configuration.
Frequently Asked Questions
Q1-Is Google Sheets or Excel better for hotel revenue management?
A-Google Sheets has the advantage of being accessible from any device, including your phone, and allows multiple team members to update and view the spreadsheet simultaneously. Excel is more powerful for complex formulas and large data sets. For most small Indian hotels, Google Sheets is the more practical starting point.
Q2-How often should I update my revenue management spreadsheet?
A-Daily updates of rooms-on-books for the next 30 dates take 10 to 15 minutes and are the minimum required for booking pace tracking to be useful. Competitor rate checks are best done weekly for the next 14 high-demand dates. Rate decisions should be made weekly based on both data inputs combined.
Q3-How do I get historical booking data into my spreadsheet?
A-Most PMS platforms have a booking pickup or pace report that shows how many reservations were on the books for each future date at each point in time. Export this report for the same period from last year and enter it as the baseline in your pace tracking spreadsheet. If your PMS does not have this report, work backward from your cancellation and check-out records to reconstruct the data.