1. A weekly hotel PMS reporting dashboard should connect occupancy, ADR, RevPAR, booking pace, cancellations, channel revenue, staffing demand, and payment status.
2. Each metric needs a decision: change a rate, adjust a restriction, schedule staff, shift channel effort, or follow up on cash due.
3. Compare future stay dates with prior periods and current pickup; historical totals alone arrive too late for action.
A hotel PMS reporting dashboard is useful when it changes next week’s decisions. Small hotel owners do not need dozens of charts. They need a short review that shows where demand is building, which dates are weak, how much each channel contributes, when labor is needed, and whether booked revenue is turning into cash.
Run the review on the same day each week. Use one consistent date window, compare with the previous week and relevant prior period, and write down the action attached to every exception.
The dashboard should answer four operational questions: should rates change, should staffing change, should the channel mix change, and is cash arriving when expected?
Start With Data the PMS Can Explain
The Property Management System (PMS) should combine reservations from online travel agencies (OTAs), the direct booking engine, walk-ins, and manually entered bookings. That common reservation record supports occupancy, revenue, channel, and payment reporting.
Before trusting a dashboard, check definitions. Room revenue should not unexpectedly include taxes or ancillary sales. Cancelled rooms should not count as occupied. Complimentary and out-of-order rooms need consistent treatment. Average daily rate (ADR) and revenue per available room (RevPAR) should use the same room inventory basis each week.
Also check the “as of” time. A live dashboard and a report exported yesterday evening can show different pickup. The difference is normal only when the timestamps are visible.
Owners should be able to move from a total to the underlying reservations. If a revenue spike cannot be traced to bookings, rate plans, and stay dates, the dashboard is decoration rather than a management tool.
Use Occupancy, ADR, and RevPAR to Adjust Pricing
Occupancy shows the share of sellable rooms booked. ADR is room revenue divided by rooms sold. RevPAR is room revenue divided by available rooms, or occupancy multiplied by ADR.
Read the three together. High occupancy with weak ADR can mean the hotel filled too cheaply. Strong ADR with low occupancy can mean the price is too ambitious for remaining demand. RevPAR helps show whether rate and volume are producing revenue across the available inventory.
Review these metrics by future stay date, not only for the week just completed. Flag dates with occupancy materially above or below the hotel’s normal booking curve.
For a high-demand date with few rooms left, consider raising the rate, closing an unnecessary discount, or increasing the minimum stay where demand supports it. For a soft date, review competitor context, open an appropriate rate plan, remove an avoidable restriction, or target a segment that books within the remaining lead time.
Do not react to one percentage without context. A six-room hotel moves 16.7 percentage points when one room books. Small inventory requires looking at room counts alongside ratios.
Add Booking Pace and Pickup to the Rate Decision
Occupancy is a snapshot. Booking pace explains how quickly the snapshot is changing.
Pickup measures new room nights or revenue added since the previous review. Compare current pickup with the same lead time for a relevant prior period. A Saturday at 70% occupancy and accelerating may need a rate increase. Another Saturday at 70% but with no pickup for two weeks may need a different action.
Break pickup down by stay date, room type, rate plan, and channel. One room category may be selling out while another remains untouched. A broad hotel-wide discount could sacrifice revenue on the strong category without fixing the weak one.
When weekly reporting is built from disconnected exports, owners spend the review assembling numbers instead of acting. Smart Order’s reporting and analysis tools connect reservation source, occupancy, ADR, RevPAR, and revenue so the owner can move from the dashboard exception to a pricing decision.
Turn Weekly Metrics Into Hotel Actions
Use Smart Order to review occupancy, rates, channel revenue, and booking performance from the same PMS records, then act on the dates that need attention.
Map Arrivals, Departures, and Room Status to Staffing
Weekly staffing should follow workload, not occupancy alone. A hotel can be nearly full with few room turns, or moderately occupied with many same-day departures and arrivals.
Review arrivals, departures, stayovers, rooms out of order, and special requests by day. These counts translate into front-desk coverage, housekeeping assignments, linen demand, breakfast preparation, and maintenance windows.
Pay attention to compressed turnover days. If eight rooms depart and eight arrive on Friday, the housekeeping workload is different from eight occupied stayover rooms. Late checkouts and early arrivals further reduce the cleaning window.
Use guest and reservation notes carefully. Extra beds, accessibility preparation, airport pickups, group arrivals, or outstanding payment checks can add work that room counts miss.
After the week, compare planned staffing with actual task volume and overtime. The next schedule should improve from that evidence rather than repeat a fixed roster.
Review Channel Mix by Net Contribution
Channel mix shows where reservations come from: Booking.com, Expedia, Airbnb, Agoda, direct website, corporate accounts, walk-ins, or other sources.
Do not rank channels by gross revenue alone. Compare room revenue, commission, discounts, cancellation rate, length of stay, payment cost, and operational burden. A high-volume OTA can be valuable even with commission, while a smaller direct channel may deliver stronger margin and guest data.
Review the mix for both booked future stays and recently completed stays. Future bookings show demand direction; completed stays provide more reliable net revenue and cancellation outcomes.
If one channel is filling discounted rooms far in advance, revisit rate-plan mapping and allocation. If direct bookings are growing but cancellation or payment failure is also rising, improve deposit and confirmation rules before spending more on traffic.
The decision is rarely to remove an OTA. It may be to adjust availability, change a promotion, protect last-room inventory, improve the direct offer, or investigate why one source converts but produces poor net value.
Use Cancellation and Modification Patterns to Protect Revenue
Track cancellation rate, cancellation lead time, no-shows, shortened stays, and repeated modifications. A headline cancellation percentage is less useful than knowing which channel, rate plan, and booking window produced it.
High cancellations on a flexible promotional rate may be expected, but the hotel should account for the inventory returning close to arrival. A non-refundable rate with unexpected cancellations may point to payment or policy configuration problems.
Review how quickly cancelled inventory becomes sellable again. The PMS and channel manager should return the room once under the intended replenishment rule. Duplicate inventory increases can create overselling.
Use the patterns to decide whether to change deposit terms, cancellation windows, overbooking controls, or the balance between flexible and restrictive rates.
Connect Booked Revenue to Cash Flow
Booked revenue is not cash in the bank. The weekly dashboard should distinguish deposits requested, payments received, balances due before arrival, pay-at-property amounts, OTA payouts expected, refunds, disputes, and overdue receivables.
Look forward by payment date and stay date. A strong revenue month can still create a cash shortage if most guests pay after arrival while payroll and supplier bills fall earlier.
Review outstanding deposits for near-term arrivals. Confirm whether failed or expired payment requests need follow-up. For Expedia Collect, Booking.com payouts, direct card payments, and bank transfers, record the expected settlement path so staff do not treat every booking balance the same.
Ancillary consumption also matters. Airport transfers, breakfast, upgrades, late checkout, and other order charges should appear with the reservation and payment status. Otherwise, the revenue dashboard can overstate what has been collected.
Build a 30-Minute Weekly Dashboard Routine
Start with the next 30 to 90 stay dates, depending on the hotel’s booking window. Scan for occupancy, ADR, RevPAR, and pickup exceptions. Then review operational load for the next seven days.
Next, compare channel contribution, cancellations, and payment status. Finish with an action list that names the date, metric, owner, change, and review point.
Keep the list short. Typical weekly actions include:
- change rates or restrictions for specified stay dates;
- adjust housekeeping or front-desk coverage;
- investigate a channel, mapping, or cancellation anomaly;
- follow up on deposits, payouts, or overdue balances;
- test whether last week’s action improved pickup or net revenue.
Do not redesign the dashboard every week. Consistency makes trends visible and prevents the review from becoming another reporting project.
FAQ About Hotel PMS Reporting Dashboards
Which hotel metrics should a small owner check every week?
Check future occupancy, ADR, RevPAR, pickup, arrivals, departures, room status, channel mix, cancellations, deposits, outstanding balances, and expected payouts. Add property-specific measures only when they trigger a decision.
Should a hotel dashboard use live or weekly data?
Use live PMS data where possible, but preserve consistent comparison timestamps. A weekly management routine can still use live data as long as the owner knows when each value was refreshed.
What is the difference between ADR and RevPAR?
ADR measures room revenue per room sold. RevPAR measures room revenue across all available rooms, including unsold inventory. Reading both prevents high prices or high occupancy from looking successful in isolation.
Can a PMS dashboard replace accounting reports?
No. It supports operational and revenue decisions, while accounting records handle the formal treatment of payments, taxes, liabilities, expenses, and financial statements. The two should reconcile but serve different purposes.
Make the Dashboard a Decision Meeting
A weekly hotel PMS reporting dashboard should not end with “occupancy was 68%.” It should explain which dates need a price change, where staffing will be tight, which channels produce usable net revenue, and when booked revenue becomes cash.
Use a small, stable set of metrics. Trace exceptions to reservations. Assign actions and review their results the following week.
For a small hotel, that discipline is more valuable than a dashboard with dozens of charts and no operating decision attached.
