Hotel Spreadsheet Analysis With Jolene.pro: Occupancy, Rates and Booking Channels
More reservations do not automatically mean a better month. A hotel may sell more room nights at lower rates, accept a different channel mix or lose bookings closer to arrival. A monthly revenue total compresses all of that into one number. The underlying spreadsheets let a revenue analyst separate the movements.
Jolene.pro can help analyze Excel and CSV exports from your hotel systems, with charts, calculation steps and references to the records used. You supply the reporting definitions and the relevant data. The questions can then move from “How was the month?” to the specific dates, room types and channels worth reviewing.
Choose the right level of hotel data
Start with daily room-night records containing property, stay date, room type, reservation ID, rooms sold and room revenue. Include daily available-room inventory separately. Reservation exports should retain booking date, arrival and departure dates, cancellation date and status. Add recorded channel commissions and acquisition charges for contribution analysis.
A reservation spanning five nights is not five separate bookings. Allocate room revenue to its actual stay dates before comparing daily performance. Keep room revenue separate from food, tax and other charges. Document treatment of complimentary rooms, house use and out-of-order inventory so the denominators remain consistent.
1. Read occupancy, ADR and RevPAR together
Ask: “Calculate occupancy, ADR and RevPAR by week and room type. Use rooms sold divided by available room nights for occupancy, room revenue divided by rooms sold for ADR, and room revenue divided by available room nights for RevPAR. Show the numerator and denominator for each result.”
Request totals-based ratios for the period. Averaging daily occupancy percentages can mislead when available inventory changes. Keep zero-denominator groups flagged rather than producing an invented rate. A revenue chart alongside these measures helps distinguish stronger demand from heavier discounting.
2. Separate rate changes from booking mix
Ask Jolene.pro to compare room nights and ADR within the same room type, channel and weekday group across comparable periods. Request the groups contributing most to the room-revenue change and their source records. Mark holidays, closures or unusual group bookings where that context is available.
The hotel’s overall ADR can fall even when individual room-type rates stay steady, simply because more lower-priced rooms were sold. Within-group comparisons help the revenue team see whether the movement came from rates, volumes or mix. They do not by themselves establish which pricing decision caused it.
3. Examine booking pace and cancellations
With booking and stay dates, ask for booking lead time by channel and arrival month. For a true pickup comparison, provide two dated on-the-books snapshots or complete booking-change history. Ask how many room nights were added, canceled or changed between those cutoffs for the same future stay dates.
A current reservation export cannot always reconstruct what the hotel knew three weeks ago. Treat missing history as missing history. Define cancellation rates using a consistent booking population and observation window; recently booked future stays have not had the same chance to cancel as older completed stays.
4. Compare channel contribution after recorded charges
Ask: “For completed stays, summarize room revenue and recorded distribution charges by channel. Show revenue less those charges, per sold room night, and flag reservations with missing cost records.”
Call the result contribution after included distribution charges. It is not hotel operating profit unless all relevant costs are included. Compare cancellation behavior and booking timing alongside the contribution figure before deciding a channel is unattractive. A direct booking can have acquisition costs too.
Turn the workbook into a revenue meeting
Inspect the source trail, resolve ambiguous inventory and revenue definitions, then pin the useful charts into a dashboard. Save the analysis for the next comparable export. Start with one property and two complete periods. Bring the dates and segments behind the movement to the revenue meeting, where the team can decide what to test next.
Metric reference: HotelBee’s occupancy, ADR and RevPAR guide. The workflows above depend on the fields and history in your exports.