PMS Reporting for Revenue and Operational Decision-Making

Why PMS Reports Matter

A Property Management System (PMS) collects data on every reservation, check-in, check-out, room charge, and housekeeping update that flows through a hotel. Reports turn that raw data into numbers a supervisor or manager can act on. Without the ability to read and use these reports, a front office leader is managing by guesswork. The AHLEI Hospitality Supervisor credential tests your ability to use operational data — so developing this skill now serves both your career and your exam.

The Six Standard Reports You Must Know

1. Occupancy Report

Shows the percentage of available rooms that were occupied on a given date or date range. The occupancy percentage is calculated as rooms sold divided by rooms available, multiplied by 100. This report tells you how busy the property was.

2. Average Daily Rate (ADR) Report

ADR is the average revenue earned per occupied room. It is calculated as total room revenue divided by rooms sold. ADR tells you the quality of the revenue, not just the volume.

3. RevPAR Summary Report

RevPAR — Revenue Per Available Room — combines occupancy and rate into one figure. It is calculated as total room revenue divided by total rooms available, or equivalently as ADR multiplied by occupancy rate (expressed as a decimal). RevPAR is the single most widely used metric in hotel performance analysis.

4. Arrival/Departure List

This operational report lists every guest arriving or departing on a specific date. Front desk agents use it to pre-assign rooms, prepare welcome packets, and coordinate with housekeeping on prioritized checkouts. Errors in this list can lead to double-assigned rooms or guests waiting — so always verify it against live reservations before the shift begins.

5. Folio Activity Report

A folio is the running record of all charges and payments for a guest's stay. The folio activity report flags unusual posting patterns: voided charges, late charges posted after checkout, disputed items, or high volumes of adjustments. Supervisors review this report to detect posting errors and potential revenue leakage.

6. Housekeeping Status Report

This report shows the current status of every room — occupied, vacant clean, vacant dirty, out of order, or on change. The front desk and housekeeping department must reconcile this report at least once per shift. A discrepancy between the PMS room status and the physical room status (called a "housekeeper discrepancy") can delay sellable rooms and reduce revenue.

Reading a Report: Key Fields to Locate

When you open any PMS report, identify these fields first:

• Date range — confirm the report covers the period you intended.
• Property or outlet — multi-property systems must be filtered to your location.
• Rooms available — total rooms in inventory minus out-of-order rooms.
• Rooms sold (occupied) — actual rooms that had a registered guest.
• Room revenue — total revenue posted to room-rate charges only (exclude taxes and incidental charges unless the report specifically includes them).
• Computed metrics — occupancy %, ADR, RevPAR as calculated by the PMS.

Always check the report header for the run date and run time. A report generated at 7 a.m. will not reflect charges posted at 8 a.m. This matters most for folio activity and housekeeping status.

Hand-Calculating ADR and RevPAR

PMS systems round displayed figures, and exam questions often ask you to calculate from raw numbers. Practice the formulas until they are automatic:

• ADR = Room Revenue ÷ Rooms Sold
• RevPAR = Room Revenue ÷ Rooms Available
• RevPAR (alternative) = ADR × Occupancy Rate (decimal)

If your hand-calculated result differs from the PMS figure by a few cents, the cause is almost always rounding. Document which figure came from the system and explain the rounding difference — this is exactly what the annotation worksheet asks you to do.

Using Report Data to Make Decisions

Data only has value when it drives action. When you spot a pattern — say, occupancy falls sharply mid-week, or folio adjustments spike on weekend nights — your job is to ask why and recommend a response. A well-structured operational memo to a general manager should:

1. State the finding with specific numbers from the report (cite the report name, date range, and the exact figures).

2. Identify the likely cause based on what you know about hotel operations.

3. Recommend one concrete action — a targeted promotion, a staff scheduling adjustment, an audit procedure — that is within the scope of the front office or rooms division.

4. Avoid vague language. "Improve service" is not a recommendation. "Add a second front desk agent on Friday nights to reduce check-in wait time, supported by the arrival list showing 47 arrivals between 5 p.m. and 7 p.m." is a recommendation.

Data Accuracy and Security

PMS reports contain guest names, room numbers, credit card authorization codes, and revenue figures. Treat printed reports as confidential. Shred all draft printouts after the exercise. Do not leave reports visible on shared screens or unattended at workstations. In a real property, access to financial and folio reports is role-restricted — supervisors must log in with their own credentials and never share passwords. These practices align with both property data-security policy and general industry standards for guest privacy.