Hotel PMS: daily checklist of key data for revenue 🏨

Hotel PMS: what data you should check every day (checklist for revenue)

A daily routine in the PMS does not seek to “guess” the perfect rate. Its goal is more realistic and more valuable for a small hotel: control and prevention. In 10-20 minutes you can detect inventory mismatches, channel inconsistencies, cancellation spikes or abnormal booking rates before they turn into lost revenue. In addition, that same review gives you the basis for tactical rate decisions and restrictions without managing “blindly”.

hotel pms chek list revenue managment

The PMS is especially useful here for two reasons: it centralises operational data (bookings, occupancy, typologies, status) and it is usually the place where changes are executed or, at least, where it is validated that what is distributed is aligned (with channel manager, engine and OTAs if applicable). The key is not to look at “everything”, but to look at what changes decisions or avoids errors.

Your daily routine in 3 blocks: today, the next 7 days and the next 30 days.

P

Organising the review by horizons helps you not to mix urgencies with strategy. Each block answers a different question:

  • Today (and tomorrow)Is there anything that could cost money today (errors, gaps, overbooking, mismanaged upsell)?
  • Next 7 daysWhich dates require tactical rate adjustments, channel or rate restrictions for bookings and cancellations?
  • Next 30 daysHow is the “health” of the forecast and what problems are brewing (sluggish weeks, lead time changes, increasing cancellations)?

This order avoids a typical mistake: spending 20 minutes looking at monthly averages while you have an upcoming weekend with inconsistent inventory or broken parity.

What revenue decisions are usually taken at each horizon?

Adopting measures such as LED lighting, zoned climate control systems, motion sensors and aerothermics can reduce energy consumption by up to 40%. In addition to reducing the carbon footprint, these changes have a direct economic impact.

Adjust rates for sensitive dates according to pick-up, activate or remove restrictions (min stay/CTA/CTD/closures), review consistency per channel and decide if specific action is needed for off-peak dates.

Open/close tariff plans according to trend, plan restrictions for long weekends/events, decide promotion windows wisely and check if distribution (direct vs OTA) is aligned with margin.

Block 1 (Today and tomorrow): operational data that immediately impact revenues

In this block, the PMS protects you from losses due to errors and allows you to capture incremental revenue without improvisation. The most important thing is to see the reality by typology and status, not just the total hotel.

Actual occupancy and availability by typology

Check first today and tomorrow:

  • Total occupancy and, above all, occupancy by type (room type).
  • Availability by typology and active tariff plans (what can actually be sold).

Typical alerts that merit investigation:

  • A typology is zeroed for no obvious reason (blocking, quota, stop sell, incorrect mapping).
  • Recent manual changes that do not match reservations (“low only” inventory).
  • Discrepancy between total availability and availability by typology (risk of overselling or closed sales).

In hotels with channel managers, it is advisable to check whether the problem is only in PMS or also in distribution (because the impact on sales can be immediate).

Arrivals, departures and stays (in-house) with focus on upgrades/upsells

The internal arrival and stay list is a revenue tool when used responsibly:

  • Identifies arrivals where higher category rooms are available without compromising future inventory.
  • Detect late check-out or breakfast opportunities based on operational availability (not “force sales”, but offer when it fits).
  • Review long stays or repeaters to propose improvements in experience if there is scope.

What is relevant is the criteria: the PMS allows you to cross-reference arrivals with real availability, avoiding promising something that the hotel cannot deliver.

No-shows, last-minute cancellations and overbooking risk

For today/tomorrow, look at data from the last 24-48 hours:

  • Last minute cancellations per channel and per fare plan (flexible vs. non-refundable).
  • Bookings without guarantee or with weak payment terms (if shown in the PMS).
  • Basic history: if your hotel has a pattern of no-shows on certain channels or rates, keep this in mind.
  • Level of risk of overbooking by typology (when availability is “tight” and there are constant changes).

Operational recommendation: coordinate with reception on a single criterion for handling doubtful bookings and inventory release. The goal is not to assume that there will be no-shows, but to avoid surprises.

Block 2 (Next 7 days): indicators to adjust tariffs and restrictions

Here the PMS usually gives you clear signals: booking rhythm, channel mix, cancellation and changes on sensitive dates. In small hotels, it is more effective to check the dates that matter (weekends, events, bridges, high elasticity days) than to navigate by averages.

Pick-up by date vs. reference (previous week / same period)

Pick-up, simply explained: it's how each date fills up over time. You don't need advanced modelling to use it; you need to detect acceleration and braking.

Practical way to review it:

  • Choose key dates in the next 7 days (including weekends and an off-peak date).
  • Compare the pick-up with a reasonable benchmark: the previous week or a comparable period.
  • Signals dates where the rate goes above (possible gradual increase or restriction) or below (review price/conditions/channels).

Indicative mini-list (to prioritise actions):

  • Date → current occupancy → recent pick-up → action
    • If occupancy rises rapidly: review price steps and restrictions.
    • If occupancy stagnates: review competitiveness and conditions before discounting.
    • If there is pick-up but with high cancellation: review channel mix and policies.

The idea is not to automate decisions, but to know where to act first.

ADR and RevPAR by date (not only averages)

In 7 days, averages are deceptive: you can be “doing well” on average and be bad on two critical dates. Check by day:

  • ADR by datetells you the average price level achieved on that day.
  • RevPAR by datehelps you to understand the balance between occupancy and price.

Simple operational readings:

  • High occupancy + low ADRlikely selling too cheap or too early; review tariff plans and reliance on high-cost channels.
  • Low occupancy + high ADRmay indicate out-of-market price or blocking restrictions; check parity, conditions and restrictions.

Channel mix and cost of distribution (direct vs. OTAs)

The PMS usually shows production by channel, but not always the full cost. Even so, reviewing the mix allows you to make informed decisions:

  • % of upcoming bookings coming from direct vs OTAs.
  • If the dominant channel at strong dates is high cost, there may be scope for direct protection (without promising to “change” immediately).
  • If the PMS does not calculate commissions, it uses simple internal rules: identify which bookings are OTAs and assume that they have a higher distribution cost than direct, without the need for exact numbers to be aware of.

It is not about demonising OTAs, but about monitoring dependency and protecting margin where possible.

Active restrictions and consistency per channel

In the next 7 days, a misapplied restriction can block sales or allow stays that break the calendar. Check out:

  • Min stay, CTA/CTD, closures and release (if applicable).
  • That they are active where they should be (date and type) and not by accident.

Practical method for small teams:

  • Choose 2-3 sensitive dates.
  • Validate restrictions in PMS and, if available, in channel/motor with a quick check (including a search as a customer).

Block 3 (Next 30 days): forecast health and early detection of problems

This block does not aim for perfect accuracy. In small hotels, the forecast suffers from dirty data or lack of segmentation; therefore, a light daily review and a more complete weekly analysis (without loading the day-to-day) is appropriate.

Occupancy and revenue forecast per week (trends)

Look at the next month by weeks, not just by single days:

  • Weeks clearly below the expected (risk of being late).
  • Peak“ weeks where ADR and availability should be protected.
  • Sudden changes from previous days (signal of cancellations, channel changes or incidents).

Typical associated actions (no foolproof formulas):

  • If a week weakens: review parity, conditions, distribution and whether there is an event that changed the pattern.
  • If a week strengthens: review restrictions and price steps with caution.

Lead time and booking windows (is purchasing getting shorter?)

If you notice that customers are booking later and later, your strategy needs to adapt:

  • See if the average or median lead time goes down (trend, not accuracy).
  • If shortened, a very early aggressive rally may slow down conversion, and a strategy based on “early bookings” may have less impact.

For a small hotel, the useful thing is to detect change and adjust expectations and routines (more focus on 7 days, more parity and front-end control), not to build complex models.

Cumulative cancellations and cancellation ratio by channel

Check if the cancellation increases:

  • In a specific channel (possible policy, visibility or customer type problem).
  • On a specific tariff (very dominant flexible, unclear conditions or incentives to book “just in case”).
  • On specific dates (signal of market uncertainty, cancelled event or out-of-market price/condition).

This improves the reliability of the forecast and avoids pricing decisions based on “inflated” occupancy.

Daily alerts: “red flags” to look out for in the PMS

These signals often warrant same-day action because they may affect sales or inventory:

  • Uncaused drop in availability (does not correspond to reservations/modifications).
  • Disappearing tariff or ceases to be saleable on key dates.
  • Duplicate bookings or “phantom” reservations without clear confirmation.
  • Unanticipated price jumps (misapplied rules, inheritance, rounding, currency).
  • Occupation not matching inventory by typology.
  • Cancellation peaks in 24-48h.
  • Massive changes of tariffs/restrictions without registration or without a clear responsible person.

Mini-protocol for action when an alert is detected

  1. Confirm in the PMS: date, type, fare plan and status of bookings involved.
  2. Check if it affects all channels or just one (if you have channel/engine, validate quickly).
  3. Review latest changes (if audited): what was touched and when.
  4. If applicable, make a test booking (direct or channel) to see the actual front-end behaviour.
  5. Document for support: booking ID, channel, time, screenshots, playback steps and “expected vs. actual”.

This protocol reduces incidence time and prevents the problem from recurring.

How to adapt the checklist if your hotel is small and you don't have RMS

An RMS can help, but it is not essential to operate with control. For many hotels, the essentials are: a well configured PMS, a consistent channel manager/engine and review discipline.

In practice, it simplifies:

  • Maintain 6-8 key metrics.
  • Check for critical dates, not the entire calendar.
  • Prioritise routine and consistency: what is reviewed is always improved first.

Checklist “minimum viable” in 10 minutes

Realistic version for days when time is short:

  • Occupancy and availability by typology today and tomorrow.
  • Occupancy for the next 7 days and sensitive dates marked.
  • 7-day pick-up (even if comparing “today vs. yesterday” by date).
  • ADR/RevPAR for 2-3 key dates (not averages).
  • Cancellations in the last 48 hours.
  • Channel mix (direct vs OTA) in the near future.
  • Restrictions on 2-3 sensitive dates.
  • 1 quick parity check: web vs. an OTA on a test date.
  • 1 inventory alert revision (zero typology or inconsistent availability).

What should help you to see a revenue-oriented PMS (without selling)

For this routine to be sustainable, a revenue-oriented PMS should provide visibility and control, rather than “more data”:

  • Clear dashboards by dateoccupancy, ADR and RevPAR per day and per typology.
  • Reports by channel (production and cancellation) without complex exports.
  • Audit of changeswho changed tariffs/restrictions and when.
  • Basic segmentation (even if it is simple) so as not to mix different demands.
  • Easy export for timely analysis without relying on daily manual sheets.
  • Operational alerts or warnings (or simple ways to detect anomalies).

The practical value is that it reduces errors and speeds up decisions with less friction on a day-to-day basis.

What should help you to see a revenue-oriented PMS (without selling)

How much time should I spend on PMS each day if my hotel is small?

A typical range is 10-20 minutes, adjusted to demand and occupancy. On quiet days, the minimum checklist (inventory today/tomorrow, 7-day pick-up, cancellations and parity) may be sufficient. In peaks, it is advisable to extend the checklist by typology, restrictions and alerts to avoid losses due to incidents.

It depends on the objective and the moment. Occupancy warns you of operational risk and demand; ADR protects positioning and margin; RevPAR helps you balance price and occupancy. In practice it is best to look at them together by date: you can have a good monthly average and be bad on two key days if you only look at one metric.

You can do this simply by comparing confirmed bookings by date “today vs yesterday” or “this week vs last week” with a report by date. If the PMS allows you to export a daily report of future bookings, save a copy and compare changes. The important thing is to detect acceleration or slowdown, not a perfect calculation.

A quick check several times a week is usually reasonable, and always after seasonal changes, new promotions or rule adjustments. To avoid wasting time, use 2-3 test dates (one peak and one off-peak) and compare web vs. OTA by checking final price, price and cancellation/payment conditions.

Inconsistent availability by type, rates disappearing on key dates, duplicate bookings or incorrect statuses, restrictions applied where they should not (or do not) apply, and anomalous cancellation spikes within 24-48 hours. These signals often affect sales or inventory immediately and should be investigated on the spot.

Performance by channel (production and cancellation), lead time evolution, production by rate/plan, distribution by basic segment if you use it, and forecast by weeks of the next month. The weekly review complements the daily control: it serves to detect trends and adjust rules, not just to put out operational fires.

You may also be interested in

REQUEST YOUR DEMO TODAY

Discover how Lean Hotel System can transform your hotel business

REQUEST YOUR FREE DEMO!

Related articles

Scroll to Top