Who this is for: owners, general managers, and revenue managers at independent hotels, hotel groups, motels, resorts, and hostels who set room rates and track demand on a regular basis. Bed & Breakfasts and Parks can use a simplified version further down.
A revenue management template isn't a financial report. It's the working sheet you update regularly to decide whether to raise, hold, or drop rates. It's based on how bookings are actually pacing, not a monthly look-back. This page gives you one template, plus the property-type adjustments that actually matter.
What's Included in This Template
- Reporting period, total rooms available, and base rate by room type
- Daily rooms sold, occupancy percentage, ADR, and RevPAR
- Competitor rate for the same dates, tracked alongside your own
- Pickup tracker: room nights on hand versus the same period last year and versus forecast
- Segment mix: direct, OTA, corporate, and group, as a percentage of room nights
- An action/notes column for every rate decision you make and why
The Revenue Management Template
The template has three parts. Setup details, a daily rate and performance tracker, and a weekly pickup and segment summary.
Setup Details
| Field | Details |
|---|---|
| Property Name | [Property Name] |
| Reporting Period | [Week of MM/DD/YYYY - MM/DD/YYYY] |
| Total Rooms Available | [Number] |
| Base Rate by Room Type | [Room Type: Rate, Room Type: Rate] |
Daily Rate & Performance Tracker
| Date | Rooms Sold | Occupancy % | ADR | RevPAR | Competitor Rate | Notes / Action |
|---|---|---|---|---|---|---|
| [MM/DD] | [Number] | [%] | $[Amount] | $[Amount] | $[Amount] | [Rate held / raised / dropped, and why] |
| [MM/DD] | [Number] | [%] | $[Amount] | $[Amount] | $[Amount] | [Rate held / raised / dropped, and why] |
Weekly Pickup & Segment Summary
| Metric | This Period | Same Period Last Year | Forecast | Variance |
|---|---|---|---|---|
| Total Room Nights Sold | [Number] | [Number] | [Number] | [+/- Number] |
| Pickup (booked this week) | [Number] | [Number] | [Number] | [+/- Number] |
| Direct % | [%] | [%] | [%] | [+/- %] |
| OTA % | [%] | [%] | [%] | [+/- %] |
| Corporate % | [%] | [%] | [%] | [+/- %] |
| Group % | [%] | [%] | [%] | [+/- %] |
Completed Example
Riverside Inn, a 40-room independent hotel, tracks a slow Tuesday in its shoulder season.
| Date | Rooms Sold | Occupancy % | ADR | RevPAR | Competitor Rate | Notes / Action |
|---|---|---|---|---|---|---|
| 09/15 | 22 | 55% | $118 | $65 | $129 | Pace is 8% behind last year. Dropped rate $10 for the weekend to close the gap. |
Weekly summary for the same period: 154 room nights sold, against 168 the same week last year. Pickup this week added 31 new bookings. Segment mix ran 40% direct, 35% OTA, 15% corporate, and 10% group.
How Do You Use a Revenue Management Template?
Set your base rates before the period starts. Then adjust based on real demand signals, not instinct.
- Set base rates by season and day of week before the reporting period begins.
- Update rooms sold and rate daily, not just once at the end of the week.
- Compare pickup pace to the same period last year, not to how business feels.
- Check competitor rates before raising or dropping your own.
- Log every rate change with a reason, so past decisions actually inform future ones.
Common Mistakes to Avoid
- Reviewing rates only once a month, missing pickup trends while they're still fixable.
- Skipping a same-period-last-year baseline, so pace numbers have nothing to compare against.
- Changing rates without logging why, so nobody can learn from past decisions.
- Ignoring competitor rates until occupancy has already dropped.
- Mixing this tracker with full accounting, making it too heavy to update quickly.
Revenue Management Templates by Property Type
Every property type benefits from tracking rate and demand. The right level of detail depends on how many segments and channels a property actually manages.
This applies at full detail to Independent Hotels, Hotel Groups, Motels, Resorts, and Hostels below. Bed & Breakfasts and Parks get a simplified version instead. They typically run fewer channels and simpler seasonal pricing. Independent Hotels use the template above as-is.
Hotel Groups Tracker
Adds the specific property name and a portfolio rollup row, so leadership can see performance across every property at a glance.
| Field | Details |
|---|---|
| Hotel Group / Brand Name | [Group Name] |
| Specific Property Name & Location | [Property Name, City, State] |
| Portfolio Rollup (all properties) | [Combined occupancy %, ADR, RevPAR] |
Motel Tracker
Keeps the same core metrics, but simplifies the segment mix, since most motel demand is direct or OTA with little corporate or group business.
| Date | Rooms Sold | Occupancy % | ADR | RevPAR | Notes / Action |
|---|---|---|---|---|---|
| [MM/DD] | [Number] | [%] | $[Amount] | $[Amount] | [Rate held / raised / dropped, and why] |
Resort Tracker
Adds package and ancillary revenue, since resort guests often add spa, dining, or activity packages on top of the room rate.
| Date | Rooms Sold | Occupancy % | ADR | RevPAR | Package / Ancillary Revenue | Notes / Action |
|---|---|---|---|---|---|---|
| [MM/DD] | [Number] | [%] | $[Amount] | $[Amount] | $[Amount] | [Rate held / raised / dropped, and why] |
Hostel Tracker
Replaces room-based metrics with bed-based ones, since hostel inventory and pricing usually run per bed, not per room.
| Date | Beds Sold | Occupancy % (Beds) | Rate per Bed | RevPAB* | Notes / Action |
|---|---|---|---|---|---|
| [MM/DD] | [Number] | [%] | $[Amount] | $[Amount] | [Rate held / raised / dropped, and why] |
*RevPAB: revenue per available bed, the hostel equivalent of RevPAR.
Bed & Breakfast Tracker (Simplified)
Drops segment mix and pickup-versus-last-year tracking, since most B&B bookings come direct with little OTA or group mix. Keeps rate, occupancy, and a notes field for local events that affect demand.
| Date | Rooms Sold | Occupancy % | Rate | Local Event / Notes |
|---|---|---|---|---|
| [MM/DD] | [Number] | [%] | $[Amount] | [Festival, holiday weekend, etc.] |
Parks Tracker (Simplified)
Tracks by site type instead of room type, and drops segment mix in favor of a simple seasonal rate view.
| Date | Site Type | Sites Sold | Occupancy % | Rate per Site | Notes / Action |
|---|---|---|---|---|---|
| [MM/DD] | [RV / Tent / Cabin] | [Number] | [%] | $[Amount] | [Rate held / raised / dropped, and why] |
Frequently Asked Questions
1. How often should I update a revenue management template?
Daily for rooms sold and rate, weekly for the pickup and segment summary. Monthly updates miss pickup trends while they're still fixable.
2. What's the difference between ADR and RevPAR?
ADR is average daily rate, revenue divided by rooms sold. RevPAR is revenue per available room, revenue divided by total rooms available, whether sold or not.
3. Do I need software for revenue management, or can a spreadsheet work?
A spreadsheet works for a single property tracking manually. Multi-property groups or properties wanting automated pricing typically move to dedicated revenue management software instead.
4. How do I know when to raise or lower rates?
Compare current pickup pace to the same period last year and to competitor rates. Pace running behind last year, with competitors priced similarly, usually signals room to hold or drop rate.
5. Is revenue management only for large hotels?
No. Even a small property benefits from tracking occupancy and rate by season, though the segment and channel detail matters less at smaller scale.
