Breadcrumbs

Rate Report .ng

Rate Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🏷️ Rate Management

Target Roles: Directors of Revenue Management, Revenue Analysts, General Managers, Hotel Controllers, Front Office Managers, Operations Managers

Key Value: Monitor active reservation rate assignments on a daily and stay-date basis, audit room rates, taxes, and fees across individual guest stays, track reservation statuses and market segment alignments, and verify corporate or travel agent account rate attachments.

Executive Summary

The Rate Report is a primary operational rate audit and reservation pricing document within the 🏷️ Rate Management category of the 📈 Revenue & Analytics hub. Designed to deliver complete reservation-level transparency over pricing and folio charges, it itemizes active, checked-in, checked-out, and cancelled guest reservations along with their assigned rate plans, room charges, taxes, and market classifications.

  • By mapping reservation parameters (Room Number, Room Type, Guest Name, Reservation Status, Nights, Check In / Check Out Dates) to rate plan structures (Rate Plan Code, Rate Plan Name, Travel Agent Name, Company Name) and financial posting metrics (Room Rate, Room Taxes, Room Fees, Total Guest Balance, Auto Charges, Market Segment, Local Market Segment), this report enables revenue directors, controllers, and front office management teams to verify rate plan compliance, audit tax and fee assessments, track guest balances, and ensure accurate account-level revenue attribution.

Key Capabilities

  • Reservation-Level Pricing Audit: Itemizes base room rates (Room Rate), room taxes (Room Taxes), room fees (Room Fees), auto charges (Auto Charges), and outstanding guest balances (Total Guest Balance) for every reservation on the selected date.

  • Reservation Status Transparency: Displays real-time and historical reservation operational statuses (e.g., IN HOUSE, CHECKED OUT, ARRIVAL, CANCELLED) to evaluate rate applications across active and past stays.

  • Hierarchical Market & Rate Plan Alignment: Correlates rate plans (Rate Plan Code, Rate Plan Name) with Corporate Market Segments (Market Segment, Market Segment Name) and Local Market Segments (Local Market Segment Code, Local Market Segment) for complete pricing visibility.

  • Account & Channel Source Verification: Identifies corporate company profiles (Company Name) and travel agency mappings (Travel Agent Name) attached to guest stays to confirm negotiated rate contract compliance.

  • Guest Occupancy Context: Captures assigned room numbers (Room Number), room categories (Room Type), stay durations (Nights), and guest headcount (Adult(s), Children) to contextualize rate yield across room types.

Report Views & Functional Breakdown

The Rate Report presents reservation pricing and rate assignment data in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                        RATE REPORT                                     │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Guest Pricing &       │ 2. Stay & Reservation    │ 3. Market &      │
│    Financial Ledger      │    Context               │    Account Trace │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Guest Pricing & Financial Ledger

Monitors base room rates, tax/fee assessments, automatic charges, and guest folio balances across individual reservations.

  • Primary Use: Verifying room charge accuracy, auditing tax and fee calculations, checking automated charge postings, and monitoring guest ledger balances.

  • Key Metrics: Room Number, Guest Name, Room Rate, Room Taxes, Room Fees, Auto Charges, Total Guest Balance.

2. Stay & Reservation Context

Provides operational reservation details, stay timeframes, room categories, and current reservation statuses.

  • Primary Use: Evaluating rate plan assignments against stay durations, checking room category pricing, and tracking rate postings across in-house guests, arrivals, departures, and cancellations.

  • Key Metrics: Room Number, Room Type, Reservation Status, Nights, Check In Date, Check Out Date, Adult(s), Children.

3. Market & Account Trace

Correlates reservations with assigned rate plans, market segment classifications, and corporate or travel agency affiliations.

  • Primary Use: Auditing corporate contract rate attachments, verifying travel agency booker codes, and checking market segment revenue attribution.

  • Key Metrics: Rate Plan Code, Rate Plan Name, Market Segment, Local Market Segment, Company Name, Travel Agent Name.

Image 10-9-26 at 8.41 AM.png
Rate Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available in this report:

💡 Rate Calculation Note: Room Rate represents the daily base room rate charged for the reservation (Excludes Taxes & Fees). Total Guest Balance reflects the current live folio ledger balance for the guest.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Room Number

Physical guest room assigned to the reservation (Blank for unassigned or cancelled stays).

PMS > Assigned Room Number

N/A

Room Type

Code representing the room category assigned to the reservation (e.g., DQ, KR, KS, QQRS).

PMS > Room Type Code

N/A

Guest Name

Combined full name of the primary registered guest (e.g., FULLER JAMES).

Guest Profile > Full Name

N/A

First Name

First name of the primary registered guest.

Guest Profile > First Name

N/A

Last Name

Last name of the primary registered guest.

Guest Profile > Last Name

N/A

Adult(s)

Count of registered adult occupants on the reservation.

Reservation System > Adult Count

N/A

Children

Count of registered child occupants on the reservation.

Reservation System > Child Count

N/A

Reservation Status

Operational status of the reservation (e.g., IN HOUSE, CHECKED OUT, ARRIVAL, CANCELLED).

Reservation System > Stay Status

N/A

Nights

Total number of physical room nights spanned by the reservation.

Reservation System > Total Nights

N/A

Check In Date

Scheduled or actual arrival date of the reservation.

Reservation System > Arrival Date

N/A

Check Out Date

Scheduled or actual departure date of the reservation.

Reservation System > Departure Date

N/A

Room Rate

Daily base room rate quoted or charged for the reservation.

Folio Posting > Base Room Rate

❌ No

Room Taxes

Estimated or posted room tax amount associated with the room rate.

Folio Posting > Room Taxes

🟢 Yes

Room Fees

Additional surcharges or mandatory room fees assessed on the stay.

Folio Posting > Room Fees

🟢 Yes

Total Guest Balance

Current live folio ledger balance for the guest reservation.

Guest Folio > Total Net Balance

🟢 Yes

Auto Charges

Automated ancillary charges scheduled to post automatically to the folio.

PMS > Scheduled Auto Charges

N/A

Rate Plan Code

Alphanumeric code of the rate plan assigned to the reservation (e.g., BAR, COMP, CORP30, Commission).

Reservation System > Rate Code

N/A

Rate Plan Name

Full descriptive title of the assigned rate plan (e.g., BEST AVAILABLE RATE, COMPLIMENTARY).

Rate Plan Setup > Rate Title

N/A

Travel Agent Name

Name of the travel agency profile linked to the reservation (if applicable).

Reservation System > Travel Agency

N/A

Market Segment

Code representing the corporate market segment mapped to the reservation (e.g., RACK, DISCOUNTS).

PMS > Market Segment Code

N/A

Market Segment Name

Full name of the corporate market segment mapped to the reservation (e.g., RACK, DISCOUNTS).

PMS > Market Segment Title

N/A

Local Market Segment Code

Property-specific local market segment category code (e.g., A, B, I).

PMS > Local Market Code

N/A

Local Market Segment

Property-specific local market segment title (e.g., A - Fully Flex BAR Direct, I - Local Corporate).

PMS > Local Market Title

N/A

Company Name

Name of the corporate company account linked to the reservation (e.g., Corporate Lodging, ACME Design).

Reservation System > Company Account

N/A

Customization & Platform Features

User & Property Preferences

  • Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.

  • Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks.

    • Reservation & Guest Audit (Cols 1–6): Room Number | Reservation Status | Guest Name | First Name | Last Name | Company Name

    • Stay & Occupancy Details (Cols 7–12): Check In Date | Check Out Date | Nights | Room Type | Adult(s) | Children

    • Rate Plan & Market Mapping (Cols 13–19): Rate Plan Code | Rate Plan Name | Market Segment | Market Segment Name | Local Market Segment Code | Local Market Segment | Travel Agent Name

    • Financial Billing & Balances (Cols 20–24): Room Rate | Room Taxes | Room Fees | Auto Charges | Total Guest Balance


Report Toolbar & Quick Actions

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon

Action / Feature

Description
Image 9-29-26 at 1.04 PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.
Image 9-29-26 at 12.37 PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
Image 9-29-26 at 12.39 PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.
Image 9-29-26 at 12.40 PM.png

Highlight

Highlights column values in a designated color based on selected conditions.
Image 9-29-26 at 12.42 PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
Image 9-29-26 at 12.43 PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
Image 9-29-26 at 12.44 PM.png

Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.
Advanced Controls

  • Exporting & Rate Audit Analysis: Download in Excel or PDF format to support daily front office rate checks, corporate contract audits, and night audit balancing.

  • Filtering: Filter data by specific Reservation Status = IN HOUSE, isolate high-rate reservations (Room Rate > $300), or filter by Company Name.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight zero-rate stays (Room Rate = $0), high guest balances, or complimentary reservations.

Within 📈 Revenue & Analytics & 🏷️ Rate Management:

  • Rate Plan Summary – Comprehensive overview evaluating daily and period-to-date revenue performance across individual rate plans.

  • Rate Code Configuration – Master system setup report detailing rate code parameters, lifecycle dates, and market mappings.

  • Discrepant Rates – Audit log comparing system-quoted benchmark rates against actual charged rates on guest folios.

  • Rate Override – Operational log tracking manual price overrides, rate adjustments, and staff authorization credentials.

Cross-Pillar Deep Dives: