Breadcrumbs

Zero Rate .ng

Zero Rate Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🏷️ Rate Management

Target Roles: Directors of Revenue Management, General Managers, Hotel Controllers, Night Auditors, Front Office Managers, Financial Auditors

Key Value: Audit zero room rate postings and complimentary reservations, track miscellaneous charges and guest folio balances on zero-rate stays, monitor rate plan compliance, and enforce internal revenue protection controls.

Executive Summary

The Zero Rate Report is a primary revenue protection and pricing audit document within the 🏷️ Rate Management category of the 📈 Revenue & Analytics hub. Designed to deliver complete operational oversight of non-revenue and complimentary room accommodations, it itemizes every reservation where the base room rate posts at zero dollars ($0.00).

  • By organizing non-yielding stay activity into 2 defined report sections: Zero Rate and Comp Reservations, this report enables revenue managers, controllers, and night auditors to audit zero-dollar room charge postings (Total Room Rent), monitor associated ancillary spend (Total Misc Charge, Total Charges), verify guest payment receipts (Total Payments), and validate stay justifications (Purpose Of Visit) across complimentary and non-revenue rate codes.

Key Capabilities

  • Two-Section Zero-Rate Audit: Organizes zero-rate stays into Zero Rate (all reservations posting at $0 room rate) and Comp Reservations (complimentary stay profiles) for targeted compliance auditing.

  • Zero Base Room Rate Verification: Audits base room charges (Total Room Rent) to confirm zero-dollar rate applications across complimentary, house-use, or promotional stays.

  • Ancillary Charge & Billing Visibility: Tracks non-room spend (Total Misc Charge), total gross charges including taxes (Total Charges), and collected guest payments (Total Payments) on zero-rate folios.

  • Reservation & Rate Code Traceability: Identifies confirmation numbers (Confirmation Number), primary guest names (Guest Name), stay windows (Check In Date, Check Out Date), and assigned rate plans (Rate Code).

  • Audit Compliance & Intent Tracking: Captures documented stay justifications (Purpose Of Visit) to ensure adherence to corporate complimentary stay policies and manager authorization rules.

Report Views & Functional Breakdown

The Zero Rate Report presents non-revenue room activity in a structured matrix across 2 defined sections:

┌────────────────────────────────────────────────────────────────────────┐
│                      ZERO RATE REPORT                                  │
├────────────────────────────────────────────────────────────────────────┤
│                       2 Defined Report Sections                        │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Zero Rate Section     │ 2. Comp Reservations     │                  │
│    (Zero Base Room Rent) │    Section (Complimentary│                  │
│                          │    Stays)                │                  │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Zero Rate Section

Monitors all reservations actively posting with zero base room rent ($0.00) during the selected report date range.

  • Primary Use: Identifying zero-dollar room charge postings across all rate codes, auditing rate override errors or zero-rate plan assignments, and tracking ancillary charges on non-yielding stays.

  • Key Metrics: Confirmation Number, Guest Name, Rate Code, Check In Date, Check Out Date, Total Room Rent ($0), Total Misc Charge, Total Charges, Total Payments.

Image 10-9-26 at 9.46 AM.png
Zero Rate Section
2. Comp Reservations Section

Isolates stays specifically classified under complimentary or house-use rate arrangements.

  • Primary Use: Verifying manager-approved complimentary room allocations, auditing staff house-use stays, checking comp tax/fee postings, and reviewing documented stay purposes.

  • Key Metrics: Confirmation Number, Guest Name, Rate Code, Check In Date, Check Out Date, Total Room Rent ($0), Total Charges, Total Payments, Purpose Of Visit.

Image 10-9-26 at 9.49 AM.png
Zero Rate Section

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:

💡 Financial Audit Calculation Note: Total Room Rent reflects base room charges ($0.00 for zero-rate stays). Total Charges represents the gross sum of room rent, miscellaneous charges, taxes, and fees (Total Charges = Total Room Rent + Total Misc Charge + Taxes/Fees).

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Confirmation Number

Unique alphanumeric reservation identifier.

Reservation System > Confirmation Number

N/A

Guest Name

Combined full name of the primary registered guest (e.g., DANKHADE JAY).

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

Check In Date

Arrival date of the reservation.

Reservation System > Check-In Date

N/A

Check Out Date

Scheduled departure date of the reservation.

Reservation System > Check-Out Date

N/A

Rate Code

Alphanumeric code assigned to the zero-rate plan (e.g., SPECIAL, COMP, Rate Commission).

Reservation System > Rate Code

N/A

Total Room Rent

Total base room revenue posted for the stay ($0.00).

Folio Posting > Base Room Rent

❌ No

Total Misc Charge

Cumulative non-room ancillary charges billed to the folio (e.g., F&B, parking, incidentals).

Folio Posting > Ancillary Charges

❌ No

Total Charges

Gross charges posted to the folio, including room rent, ancillary charges, taxes, and fees.

Folio Ledger > Gross Charges

🟢 Yes

Total Payments

Cumulative payments and credits posted to the guest folio.

Guest Folio > Total Payments

N/A

Purpose Of Visit

Documented notes or reason explaining the complimentary or zero-rate stay authorization.

Reservation Notes > Visit Purpose

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.

    • Section 1: Zero Rate

      • Reservation & Guest Audit (Cols 1–4): Confirmation Number | Guest Name | First Name | Last Name

      • Stay & Rate Plan Details (Cols 5–7): Check In Date | Check Out Date | Rate Code

      • Financial Posting & Folio Breakdown (Cols 8–11): Total Room Rent | Total Misc Charge | Total Charges | Total Payments

      • Visit Justification (Col 12): Purpose Of Visit

    • Section 2: Comp Reservations

      • Reservation & Guest Audit (Cols 1–4): Confirmation Number | Guest Name | First Name | Last Name

      • Stay & Rate Plan Details (Cols 5–7): Check In Date | Check Out Date | Rate Code

      • Financial Posting & Folio Breakdown (Cols 8–11): Total Room Rent | Total Misc Charge | Total Charges | Total Payments

      • Visit Justification (Col 12): Purpose Of Visit

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-30-26 at 2.14 PM.png

Background Export

Allows users to download up to 365 days of data directly to their computer in CSV format.
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 & Audit Compliance: Download in Excel or PDF format to support daily night audit balancing, monthly controller reviews, and internal complimentary room audits.

  • Filtering: Filter data by specific Rate Code (e.g., isolate COMP or SPECIAL), or filter for stays with high ancillary charges (Total Misc Charge > $0).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight zero-rate stays with high outstanding folio balances or missing Purpose Of Visit entries.

Within 📈 Revenue & Analytics & 🏷️ Rate Management:

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

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

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

Cross-Pillar Deep Dives:

  • ⚖️ Ledgers & Trial Balance: Reconcile complimentary room allowances against General Ledger control accounts in Day End Summary.

  • 💳 Payments & Transactions: Inspect non-room incidental charges and folio payment settlements in Settlement By Payment Type.