PMSNiveau 2

Revenue Management Reporting

18 min readRead by 640 hoteliers

Why Revenue Management Reporting Is Non-Negotiable

Most hotel managers have been there. You check yesterday's numbers, nod at the occupancy report, and move on to the next fire. But here's the uncomfortable truth: that approach is costing you money—likely more than you realize.

Without structured revenue management reporting, you're running your business in reverse. You're reacting to what already happened instead of shaping what comes next. Yesterday's occupancy tells you about last night's battle, not tomorrow's war.

The Feeling vs. The Data

A general manager with 20 years of experience develops intuition. That's valuable. But intuition has limits. It struggles to track 14 booking pacing trends across six channels while simultaneously comparing this weekend against the same weekend in 2019 and 2023. It's simply too much data moving too fast.

Revenue management reporting transforms gut feel into measurable, actionable intelligence. It shows you demand patterns across multiple time horizons—not just tonight, but next week, next month, and next quarter. It reveals which channels are pulling ahead, which segments are booking early, and which rate codes are cannibalizing your best rooms.

Distribution Complexity Demands Structure

When you had two channels—phone and front desk—you could eyeball it. Those days are gone.

Your property now likely operates across OTAs, your own website, corporate negotiated rates, group bookings, and meta-search platforms. Each moves at a different speed. OTAs can spike and crater within days. Corporate accounts book months out but shift at the last minute. Group blocks create artificial scarcity that distorts your transient pricing.

Without reporting that synthesizes this complexity, you're essentially flying blind through a storm. The right report gives you the radar you need to navigate.

Consider two scenarios.

During your high-demand period—let's say a major local event or holiday weekend—you're sold out but didn't push rates until 48 hours out. You left $30 per room on 80 rooms for three nights. That's $7,200 you didn't capture.

Conversely, during a soft Tuesday in February, you dropped rates to fill rooms, only to discover later that shoulder demand existed at your original price point. You traded margin for occupancy you probably would have achieved anyway.

Both mistakes stem from the same failure: insufficient reporting.

Revenue management reporting isn't about creating more work. It's about making decisions with confidence instead of hope.

Definition: What Revenue Management Reporting Actually Is

Before diving into specific reports, let's establish clarity on what we're talking about.

A revenue management reporting system is a structured set of daily, weekly, and forward-looking reports that transform raw property management system data into actionable signals. It's not a single spreadsheet or a dashboard your vendor built once and forgot. It's a living discipline that gives you visibility across time horizons so you can act, not just observe.

The Three Core Report Types

1. The Pick-Up Report

This is your short-term booking velocity tracker. It shows you how many rooms were added to each future date over a defined period—typically the last 7, 14, or 30 days.

Example: If your pick-up report shows 12 rooms booked in the last 7 days for a date 30 days out, and your same-time-last-year (STLY) figure was 18 rooms at the same point, you have a negative pace deviation of 33%. That's not a number to ignore. It's a pricing or distribution problem worth investigating immediately.

2. The Pace Report

This operates in the medium term—typically 30 to 90 days out. It measures your current booking position against a benchmark, usually STLY, to determine whether you're tracking ahead, behind, or on pace. The pace report tells you whether your demand trajectory supports your current pricing strategy or requires adjustment.

3. The Daily Dashboard

This is your consolidated KPI snapshot across all horizons. It should surface occupancy, ADR, RevPAR, OTB status, pick-up pace, and any anomalies flagged for attention. The dashboard's job is to help you prioritize—not drown you in data.

OTB vs. Actual: Understanding Commitment vs. Realization

"On the books" (OTB) represents rooms currently committed through reservations. "Actual" represents what has already occurred—checked-in rooms, completed transactions. The gap between them matters enormously. Groups may be on the books but create constrained inventory for transient guests. Understanding this difference prevents false confidence or unnecessary panic.

Why STLY Beats "Last Year's Final"

A common mistake: comparing current OTB against last year's final occupancy number. This is misleading because last year's final includes walk-ins, last-minute bookings, and all the chaos that happened after your reporting date. That's not a fair fight.

STLY—same-time-last-year—captures your position at this exact point in the booking window. It's the only benchmark that gives you a true apples-to-apples comparison.

The Reporting Hierarchy

Operational reports answer: "What happened?" Pick-up reports, yesterday's occupancy, current OTB—these are backward-looking but essential for tracking.

Strategic reports answer: "What will happen, and what should we do about it?" Pace analysis, demand forecasting, channel mix trends—these inform pricing decisions, channel budget allocation, and group negotiation strategy.

Both matter. But many small hotels focus exclusively on operational reports and miss the strategic picture entirely.

How It Works: The Daily Revenue Management Reporting Routine

This is where theory becomes practice. A revenue management reporting system only delivers value if you use it consistently. Here's the mechanics of a functional daily routine.

The Daily Dashboard Structure

Every morning, before checking email or taking calls, your first 10 minutes should follow a standard checklist.

Occupancy on the books for the next 30, 60, and 90 days compared to same-time-last-year (STLY) OTB. You're not just looking for the number—you're looking for the delta. If you're at 68% occupancy 30 days out versus 72% STLY, that's a 4-point deficit worth investigating.

ADR on the books for the same windows. Are you capturing the same rate, or has your mix shifted toward lower-rated channels? OTB ADR tells you whether your pricing strategy is translating into actual bookings.

RevPAR on the books synthesizes both metrics. It's your forward-looking health score. A declining RevPAR OTB pace, even with stable occupancy, signals ADR erosion.

Pick-up in the last 24 hours and last 7 days by segment. This tells you what's moving today versus the trend. A strong 24-hour pickup on a soft week can change your pricing posture for that date.

The Pick-Up Report Mechanics

Pick-up measures net new reservations added to a future date over a defined period. It answers: "How fast is demand arriving?"

Reading it is straightforward:

Pick-up accelerating → demand is strengthening → hold or increase rate
Pick-up decelerating → demand softening → investigate channel mix or adjust pricing

The 7-day pick-up is your most actionable signal for the next 30 days. It smooths daily volatility while remaining fresh enough to respond to market shifts.

Example: If you added 8 rooms in the last 7 days for a date 14 days out, but you're pacing 15 rooms behind STLY in total OTB, you have a distribution or pricing problem—not a demand problem. The bookings aren't coming. Your current rates or channel visibility may be the culprit.

The Pace Report Mechanics

Pace is calculated as: OTB today divided by STLY OTB at the same days-out, expressed as a percentage. A pace of 95% means you're tracking 5% behind where you were last year.

Here's how to display it:

| Date | Days Out | OTB Rooms | STLY OTB | Pace | OTB ADR | STLY OTB ADR | ADR Delta | |------|----------|-----------|----------|------|---------|--------------|-----------| | Sat, Mar 15 | 14 | 112 | 118 | 95% | $189 | $182 | +$7 | | Sun, Mar 16 | 15 | 98 | 105 | 93% | $175 | $178 | -$3 | | Fri, Mar 21 | 20 | 134 | 128 | 105% | $212 | $198 | +$14 |

Reading this table: Saturday shows a slight pace deficit but ADR strength. Sunday has both pace and ADR weakness—investigate pricing and channel performance. The following Friday is ahead of pace at stronger rates—demand is real, protect inventory.

When you see a pace deficit, diagnose the root cause:

Demand problem: Market-wide softness. Check comp set reports.
Pricing problem: You're above market. Test rate reductions.
Distribution problem: Channels aren't delivering. Audit visibility and commission structures.

Time Horizon Logic

Your response changes depending on how far out the issue is.

J (today's arrivals): Operational focus. Monitor occupancy, housekeeping capacity, and walk risk. Pricing levers are largely unavailable—your window closed.

J+7: Tactical window. Last-minute pricing adjustments, channel restrictions, or promotions can still move the needle. This is your firefighting horizon.

J+30: Strategic pricing window. Adjust your BAR (best available rate), open or close rate fences, and shift channel mix. Most transient demand books within this window—your decisions here have maximum impact.

J+90: Demand forecasting horizon. Inform group strategy, corporate rate negotiations, and budget planning. Accuracy matters less than trend direction.

The discipline isn't complexity—it's consistency. Ten minutes each morning on these metrics will outperform hours of reactive firefighting.

Best Practices: Building a Reporting Discipline That Actually Works

Revenue management reporting delivers value only when it's systematic. Here are seven practices that separate hotels running on data from hotels running on hope.

1. Establish a Daily Reporting Ritual

Do the same reports at the same time every morning. No exceptions. Revenue management decisions made without a routine become inconsistent—one day you're conservative, the next you're aggressive for no structural reason. A ritual creates discipline. Ten minutes, same sequence, before your inbox takes over.

2. Segment Your Pick-Up

Total pick-up hides critical information. Break it down by transient, group, and corporate. A hotel showing flat total pick-up for a Friday night might actually be losing transient business while groups fill the gap. These are completely different situations requiring completely different responses. One requires rate testing. The other requires group inventory management. You can't fix what you can't see.

3. Use Pace Reports to Trigger Decisions, Not Confirm Them

By the time pace shows a severe negative deviation, you've already lost most of your pricing window. Act early. When you see a pace deficit exceeding 10% at 60 days out, investigate immediately. Is it a pricing issue? A distribution problem? Early intervention costs nothing. Late intervention means scrambling for scraps.

4. Distinguish Structural Softness from Timing Softness

A date showing negative pace in January for what is typically a February booking pattern is not the same as a spring date with consistent early booking windows. Know your property's historical booking curve. Benchmark against the right reference. Applying a demand problem diagnosis to a date that simply books late wastes energy on a non-problem.

5. Make Reports Visual

Raw numbers in a spreadsheet require cognitive processing. Color-coded cells—green for ahead of pace, amber for within 5%, red for behind—register instantly. A dashboard that communicates in seconds what a spreadsheet communicates in minutes is a dashboard that gets used. Invest five minutes formatting reports. It pays back daily.

Keep it to one page. Structure it simply: three dates of concern, one recommended action per date, and one metric to track per date. Your general manager doesn't need to understand every nuance of channel mix analysis. They need clarity on what matters and what you're doing about it. A concise weekly summary builds trust and keeps leadership aligned with your pricing strategy.

7. Archive Your Daily Snapshots

This is the most underutilized practice in small hotels. A daily snapshot you take today becomes next year's STLY benchmark. Without archived data, you're comparing against incomplete or reconstructed numbers from last year—introducing errors into your most important reference point. Save your daily dashboard export to a dated folder. Monthly. Relentlessly. The value compounds. After two years, you'll have reliable multi-year benchmarks that most of your competitors don't have.

The bottom line: Best practices aren't complicated. They're about consistency, segmentation, and thinking ahead—not just reporting back.

Market Matters: How RM Reporting Adjusts to Property Type

Revenue management reporting isn't one-size-fits-all. The metrics stay the same, but how you interpret them—and how much weight you give each signal—shifts based on your hotel type and market dynamics.

Independent Hotels

Without brand benchmarking or STR reports, independent properties operate in a data vacuum. Your STLY database is your competitive intelligence. Build it methodically. Archive daily snapshots consistently. After 24 months, you'll have robust multi-year benchmarks that give you context your branded competitors access through corporate reports.

Pick-up and pace become your primary external-free signals. You won't know if OTAs are underperforming the market. You'll only know they're underperforming your own historical trajectory. That's still valuable—it just requires more discipline to maintain.

Boutique and Resort Hotels

These properties typically see longer booking windows—60 to 180 days out for leisure segments. Your pace report at the 90-day horizon carries more weight than for city hotels. Transient leisure demand is pricing-sensitive in a way corporate travel isn't. A $20 rate increase can crater pick-up faster than you'd expect. Your response curves are steeper, meaning small pricing errors compound into significant revenue gaps.

Monitor the shape of your pick-up, not just the volume. Accelerating pick-up in resort markets often precedes oversell risk. Act before you're sold out.

City Center Business Hotels

Corporate booking behavior creates blind spots. Negotiated corporate rates may sit in your system without visibility into when they'll materialize. A city hotel with 40% corporate mix could show modest pick-up on the books while significant demand sits unrevealed until 14 days out.

Segment your pick-up report carefully. Distinguishing transient OTA bookings from corporate direct reservations prevents mispricing. If OTA pick-up is strong but corporate is invisible, don't panic-drop rates to fill the gap. The corporate business may be coming. Your dashboard should show both channels independently.

Seasonal Markets

STLY comparisons break down when the calendar shifts. Easter moves. School holidays vary by region. Major events occur on different dates annually. A pace deficit in April may simply reflect that the same date last year fell during school holidays while this year it doesn't—or vice versa.

Add a comments column to your pace report. Flag calendar anomalies explicitly. "This date is 3 days earlier than STLY—Easter effect" takes seconds to add and prevents wasted diagnostic effort chasing a non-problem.

Small-Chain Hotels with Shared RM

One revenue manager overseeing three to five properties needs a consolidated view. Individual property reports can't be reviewed in full for each hotel daily. Build a consolidated pace report showing all properties' deviations simultaneously, sorted by magnitude of pace deficit. Review full detail only for properties exceeding a threshold—say, 10% behind pace.

Prioritize attention by deviation size. A hotel at 88% pace deserves focus. Two hotels at 98% and 96% pace can wait for the weekly deep-dive. Structure your workflow around this triage logic and you'll manage more properties without sacrificing quality.

The common thread: Context shapes interpretation. Your reporting framework should flex to reflect how your specific market and property type actually behave.

Mistakes: The Six Errors That Cost You Revenue

Revenue management reporting only works if you're using it correctly. These mistakes appear constantly in independent and small-chain properties. None of them are exotic. All of them are expensive.

1. Comparing OTB to Last Year's Final Result

This is the most common and most damaging error. If a date closed at 80% occupancy last year and you're sitting at 55% OTB today, the instinct is panic. But that instinct is wrong.

What matters is where you were at this same point in the booking window last year. If you were also at 50% OTB on the same date with 30 days to go, your trajectory is identical. The final number last year included walk-ins, last-minute bookings, and a dozen variables that don't exist yet this year. Compare OTB to OTB. Always.

2. Looking at Only One Metric

Occupancy tells half the story. A hotel with steady occupancy but declining ADR is losing revenue yield. A hotel with rising occupancy but collapsing ADR may be working harder for the same total revenue. Neither metric alone is sufficient.

RevPAR is your combined signal. If RevPAR on the books is tracking at 95% of STLY while occupancy is at 100%, you have an ADR problem. If RevPAR is at 90% while occupancy is at 95%, your mix is shifting toward lower-rated channels. Always report occupancy and ADR together. Never one without the other.

3. Ignoring Segment Mix Shifts

Your total OTB might look healthy at 72% for next Saturday. But if closer inspection reveals that 40% of those rooms came through high-commission OTAs at discounted rates while direct bookings are tracking 20% behind pace, you're not healthy—you're bleeding margin through distribution cost.

The pick-up report must show channel attribution. Not just how many rooms booked, but through which channel. A rate that requires 20% commission to capture isn't the same as a rate that arrives through your direct channel at zero incremental cost.

4. Acting Too Late

Many properties review the pace report monthly. This is insufficient for any property with meaningful transient business. By the time a date 30 days out shows a severe deficit, the window for meaningful pricing intervention has narrowed significantly.

Minimum requirement: weekly pace reviews for all dates within 90 days. For high-demand periods—holidays, local events, peak season—daily monitoring is necessary. The earlier the deviation is identified, the cheaper the correction.

5. Using Reports to Justify Rather Than Guide

"Look, our ADR improved last month" is a backwards-looking observation masquerading as revenue management. It's operational reporting dressed up as strategic insight.

RM reporting serves one purpose: guiding future decisions. The relevant question isn't "what happened?" but "what will happen if current pace holds, and what should we change?" Your reports should consistently lead to action items, not historical scorecards.

6. Presenting Raw Data Without Translation

A general manager presented with a pick-up table showing 12 columns, color variations, and no interpretation will disengage within 90 seconds. This isn't their fault—it's yours.

When presenting RM data to leadership, always include a clear translation. For each significant data point: state what it means, explain why it matters, and propose a specific action. "So what: ADR on the books for June 15 is tracking 8% behind STLY. Therefore: we will test a $10 rate increase for that date and monitor pick-up response over the next 7 days."

Data without translation is noise. Translation creates decisions.

Elyra: Removing the Friction from RM Reporting

Manual reporting has a shelf life. Spreadsheets break. Formulas get corrupted. Someone forgets to export on a Friday. Once your reporting depends on human consistency, it becomes inconsistent.

Elyra Suite was built to eliminate that friction. The reporting layer is native to the platform—no manual exports, no spreadsheet maintenance, no version control issues.

Automated Pick-Up and Pace Reports

Elyra pulls booking data directly from your PMS on a set schedule, calculating pick-up and pace automatically. Your 7-day and 30-day pick-up by segment is ready each morning without intervention. OTB versus STLY comparisons at 14, 30, 60, and 90 days are calculated and displayed without a formula in sight.

The Daily Dashboard

The dashboard surfaces color-coded OTB versus STLY across a rolling 90-day horizon. Green, amber, and red thresholds are configurable based on your tolerance levels. The display is designed for speed—deviations that need attention surface immediately without scanning columns.

Reporting Into Action

Where Elyra differentiates is the connection between reporting and pricing. When a date shows a pace deficit beyond your defined threshold, the system generates a pricing recommendation alongside the data. You're not just seeing the problem. You're seeing the suggested response, ready for evaluation and implementation if approved.

Weekly GM Summary

Elyra generates a one-page weekly RM summary designed for leadership consumption. It includes three dates of concern, the underlying metric deviation, and plain-language commentary explaining the situation and the recommended action. No interpretation required from the recipient.

Historical Snapshot Archiving

Every day's OTB snapshot is stored in the platform. When next year arrives, your STLY benchmarks are already built—no backfilling required. The data from January 2025 becomes your January 2026 reference point automatically.

The goal is straightforward: reporting that runs itself so you can focus on decisions, not data compilation.