This article describes the Rate Table List report, which lists your configured Rate Tables and the rate values they hold for a selected period.
Overview
The Rate Table List report produces a printable list of the Rate Tables set up in RMS, showing the rate amounts and key settings each one holds for the selected period.
It can be produced for the Nightly, Daily, or Hourly rate Format, and the report heading changes to match (for example Nightly Rate Table List). Revenue and reservations staff typically run it to review or audit rate setup across the property in one place, rather than opening each Rate Table individually.
Use Cases
- Audit rate setup before a season - the Revenue Manager lists every Nightly Rate Table to review the day-by-day rates and weekly totals in one place.
- Check guest and deposit settings - Reservations reviews the base and additional-guest charges and the deposit values configured across Rate Tables.
- Spot inconsistencies - an operator scans the list to find Rate Tables where a day of the week or a setting differs from the rest.
Report Options
The report options control the period covered and which rate Format is listed.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Rate Period Between | Date range | Today | Lists Rate Tables with rate values effective within the selected date range. |
| Nightly / Daily / Hourly | Radio | Nightly |
Selects which rate Format to list, and sets the report heading. Options:
|
Column Headers
One row is listed for each Rate Table. The columns below appear on the Nightly and Daily lists - the Daily list uses the same layout, with the Mon to Sun columns showing the daily rate for each day. The Hourly list uses a different layout, described under Daily and Hourly Variants below.
| Column | Description | Source / Calculation |
|---|---|---|
| Description | The name of the Rate Table. | The property's configured Rate Tables. |
| Per Person | Whether the Rate Table uses a Per Adults/Children (per person) Format. Yes or No. | See Rate Table: Per Adult/Per Children. |
| Mon, Tue, Wed, Thu, Fri, Sat, Sun | The rate amount configured for each night of the week. | Night/Day of the Week values. See Data Sources & Calculations. |
| After 7th | The rate applied from the 7th night of the reservation. | Numbered night of stay value. |
| Weekly Rate | The total of the seven nightly rates for the week. | Sum of Mon to Sun (for example 250 × 7 = 1,750). |
| 7th Discount | discount on the 7th night | - |
| Base (A / C) | The number of Adults (A) and Children (C) included in the base rate before additional-guest charges apply (the Person Base). | See Rate Table: Additional Guests. |
| Extra (A / C) | The charge for each additional Adult (A) or Child (C) beyond the base. | Additional Guest Prices. See Rate Table: Additional Guests. |
| Min Res | Minimum stay required on the reservation. | Min Res as set on Rate Table. |
| Days To Return | Contact Support for information. | |
| Dep $ | The deposit amount that applies to the Rate Table. | Rate Table deposit setting. |
| Dep % | The deposit percentage that applies to the Rate Table. | Rate Table deposit setting. |
| Sundries | Contact Support for information. | |
| Discount Extras | Contact Support for information. |
Daily and Hourly Variants
Selecting Daily lists the Daily-format Rate Tables using the same columns as the Nightly list above, with the Mon to Sun columns showing the daily rate for each day.
Selecting Hourly lists the Hourly-format Rate Tables using a different layout: Description, the rate for each hour (1st to 10th), After 10th (the rate from the 11th hour onward), Days To Return, Dep $, Dep %, and Sundries. The per-day, Weekly Rate, and additional-guest columns do not appear on the Hourly list.
Data Sources & Calculations
Day of the week rates (Mon to Sun)
When a Rate Table is configured with a Night of the Week or Day of the Week basis, a different rate can be set for each day. The Mon to Sun columns show the value held for each day. See Daily Rate Table: Day of the Week.
Weekly Rate
The Weekly Rate is the total of the seven daily rates for the week. For a Rate Table with a flat nightly rate of 250, the Weekly Rate is 1,750 (250 × 7).
Base and additional guests
The Base columns show the Person Base - the number of Adults and Children included in the rate before additional-guest charges apply. The Extra columns show the price charged for each additional Adult or Child beyond the base. These settings are configured on the Rate Table's additional-guest options. See Rate Table: Additional Guests.
Related Reports
- Rate Variance Report - highlights differences between expected and charged rates.
- Quoted Rate Variance Report - compares quoted rates against the rate that applied.
- Reservation Daily Rate Breakdown Export - exports the per-night rate breakdown for reservations.
Related Articles
Comments
0 comments
Please sign in to leave a comment.