Blog · Board and management reporting · Hospitality
Hotel revenue management reports connect reservations, room rates, channel revenue and budget by property. Build a review that distinguishes business already booked from expected revenue and proves that the reports agree.
Hotel revenue management reports connect what is booked, what changed and what revenue the property expects to earn. Review pace, pickup, occupancy, rate and channel economics together, with the same stay dates and reporting cutoff. A higher booking count means little until the team knows which rates and distribution costs came with it.
Give each report a decision rather than producing several versions of the same total.
| Report | Main question | Evidence to retain |
|---|---|---|
| Booking pace | Are reservations ahead or behind at comparable lead time? | Dated reservation snapshots and comparison dates |
| Net pickup | What changed since the previous review? | New bookings, cancellations and amendments |
| Occupancy and rate | Are room volume and achieved price moving together? | Sold room nights, available room nights and room revenue |
| Channel contribution | Which channels brought the revenue and related charges? | Channel tags, commissions and payment fees |
| Budget and forecast | What remains to reach the plan? | Approved budget, booked revenue and forecast assumptions |
The pace per property guide owns the detailed lead-time comparison. Keep that analysis in its own report, then bring its exceptions into the revenue review. The wider management reporting package explains where this review belongs alongside financial performance.
The revenue manager owns reservation snapshots, pace commentary and proposed commercial actions. Property management confirms available inventory and operational restrictions. Finance owns the budget, accounting definitions and completed-period reconciliation. Channel or distribution managers validate charges that sit outside the reservation export.
Use one row per reservation and stay date, or a daily reservation summary that retains those dimensions. Include property, snapshot date, stay date, booking status, room nights, room revenue, channel and currency. A reservation spanning several dates needs revenue allocated to the dates it covers; its booking date alone cannot identify the correct stay month.
Bring the inventory calendar separately. It should identify available room nights and the approved treatment of rooms unavailable for sale. Add a budget by property and stay period, plus channel charges on a consistent basis. Keep taxes, ancillary revenue and guest deposits outside room revenue unless the approved report definition expressly includes them.
For completed periods, finance should reconcile room revenue to its approved accounting schedule. Future reservations are commercial commitments with cancellation risk. The distinction between bookings, billings and revenue matters before a reservation total enters a monthly financial report.
Consider a fictional US hotel group reviewing November 2026 stays. November has 30 days. Harbor has 100 available rooms each day and Garden has 80, giving 3,000 and 2,400 available room nights. For this example, neither property has rooms removed from availability.
The team saves snapshots on October 1 and October 8. Revenue below is booked room revenue in USD, excluding taxes and ancillary sales. Budget is the approved full-November room revenue budget.
| Property | October 1 room nights | October 1 revenue (USD) | October 8 room nights | October 8 revenue (USD) | November budget (USD) |
|---|---|---|---|---|---|
| Harbor | 1,800 | 324,000 | 2,100 | 388,500 | 432,000 |
| Garden | 1,200 | 180,000 | 1,440 | 223,200 | 252,000 |
| Total | 3,000 | 504,000 | 3,540 | 611,700 | 684,000 |
Harbor's net pickup is 2,100 - 1,800 = 300 room nights and $388,500 - $324,000 = $64,500. Garden adds 240 room nights and $43,200. Group pickup is therefore 540 room nights and $107,700, and the second snapshot proves it: 3,000 + 540 = 3,540 and $504,000 + $107,700 = $611,700.
Those differences are net pickup. They do not reveal how many new reservations arrived before cancellations and amendments. Keep the movement detail when the team needs to explain the change.
Use the latest snapshot to calculate booked performance for the future stay month:
Booked occupancy = Booked room nights / Available room nights
Booked ADR = Booked room revenue / Booked room nights
Booked RevPAR = Booked room revenue / Available room nights
These use the denominator structure described in Hilton's annual report definitions of hotel operating statistics. Here the figures describe reservations on the books, rather than final achieved results.
| Property | Available room nights | Booked occupancy | Booked ADR (USD) | Booked RevPAR (USD) | Budget less booked revenue (USD) |
|---|---|---|---|---|---|
| Harbor | 3,000 | 70.0% | 185.00 | 129.50 | 43,500 |
| Garden | 2,400 | 60.0% | 155.00 | 93.00 | 28,800 |
| Total | 5,400 | 65.6% | 172.80 | 113.28 | 72,300 |
Calculate totals from summed numerators and denominators, then round percentages to one decimal and dollar rates to two decimals. Before rounding, occupancy multiplied by ADR must equal RevPAR. The group calculation is 611,700 / 5,400 = $113.28 per available room night, rounded.
Booked revenue covers 611,700 / 684,000 = 89.4% of budget. The remaining $72,300 is a coverage gap, not a forecast shortfall. Decide whether expected additional bookings, cancellations and rate changes can close it, recording the assumptions separately for each property.
The latest reservation snapshot also splits into these channels. Assume the supplied charge schedule applies a 2% fee to direct revenue and a 12% fee to third-party revenue; those rates are illustrative contract inputs.
| Channel | Room nights | Room revenue (USD) | Specified channel charges (USD) | Revenue less charges (USD) |
|---|---|---|---|---|
| Direct | 1,980 | 354,600 | 7,092 | 347,508 |
| Third-party | 1,560 | 257,100 | 30,852 | 226,248 |
| Total | 3,540 | 611,700 | 37,944 | 573,756 |
The channel room nights and room revenue must equal the property totals. Charges are 354,600 × 2% + 257,100 × 12% = $37,944; $611,700 - $37,944 = $573,756. This final amount excludes all other operating costs, so it is not hotel profit.
Use the report to ask whether incremental demand justifies the channel charge and whether direct demand would otherwise fill those dates. The table describes the booked mix; it does not prove what would happen if a channel were closed.
Bring a sample of your own reservation snapshots, property budget and channel-charge export to Covirage. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.
See Covirage for hospitality for the supporting industry context.
Choose a cadence that matches the decisions. Review near-term pickup and exceptions frequently when prices or inventory restrictions may change. Use a consistent weekly snapshot for property comparisons, and reconcile completed stay periods to finance during the monthly close.
Pace compares business on the books at an equivalent lead time, often against the same point before a previous stay period. Pickup measures the net change between two snapshots for the same future stay dates, including cancellations and booking amendments.
Show both using clearly labeled columns. Gross room revenue supports rate and revenue comparisons; revenue after specified channel charges helps compare distribution economics. Keep that management calculation separate from the revenue presentation finance approves for the ledger.
It can show how much of the budget is covered, but it is not a forecast variance before the month ends. A forecast must also include expected future bookings, cancellations and changes to existing reservations. Label the comparison so those differences remain visible.