This article explains how to find where an unexpected amount on a reservation rate comes from when nothing for it is visible on the Rate Manager or in the Control Panel.
Overview
A reservation (booking) rate can be higher or lower than the amount set up for the Rate Type because RMS builds each night's rate from several components. Only some of these components appear on the Rate Manager or in the Control Panel, so an amount can look like an adjustment that nobody set up.
The Total Rate/Tariff Breakdown on the reservation shows every component per night in its own column. Find the column that holds the unexpected amount, then use the matching cause below to locate where that amount is set up.
Applies to: reservations at any property where the rate amount on the reservation does not match the expected Rate Type amount.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
Quick Checks
Run these checks first to identify which rate component holds the unexpected amount.
- Open the reservation and select the underlined Total Rate in the Account column to open the Total Rate/Tariff Breakdown.
- Find the stay date with the unexpected amount and read across the row to the column that holds it.
- Check whether any amount displays in red. A red amount is a manual override made on the reservation.
- Check the Rate Period and Rate Table columns for that stay date. These show which rate setup RMS used for that night.
Where Each Total Rate/Tariff Breakdown Column Is Set Up
Each column on the Total Rate/Tariff Breakdown comes from a different part of the rate setup, shown below.
| Column | Where the amount is set up |
|---|---|
| Base Rate | The Rate Table selected for the stay date by the Rate Period, or a Rate Override. |
| + Dynamic | Dynamic Pricing rules on the Rate Table. |
| + Adjustments | A Rate Adjustment in the Control Panel, or the adjustment amount on a Derived Rate Type. |
| + Additionals | Additional guest charges on the Additionals tab of the Rate Table. |
| - Additionals Adjustment | The discount applied to the Additionals, shown separately from the Base Rate discount. |
| + Package | A package on the Rate Table or the Rate Type. |
| - X Nights Dis | The X Nights Discount tab on the Rate Table. |
| - Discount | The Discount selected on the reservation. |
| + Tax | Exclusive tax. This column only appears when the property is set to Tax Exclusive. |
Possible Causes
Cause 1: Additional Guest Charges on the Rate Table
An additional guest charge can look like an adjustment because it does not appear in the Control Panel. You set the charge on the Additionals tab of the Rate Table, not as a restriction. It shows in the + Additionals column of the Total Rate/Tariff Breakdown.
RMS charges additional guests based on the Number of Guests Included in Base and the Include in Base setting for each guest type. A guest type that is not included in the base is always charged as an additional guest. For example, if the base includes 1 Adult and the Adult additional price is 40.00, a reservation for 2 Adults adds 40.00 per night.
Fix:
In the side menu of RMS, go to Charts > Rate Manager.
- Select Rates, then select Rate Tables.
- Select the Rate Table shown on the Total Rate/Tariff Breakdown for the stay date and select Edit.
- Open the Additionals tab.
- Check the Number of Guests Included in Base, the Include in Base checkbox and the price for each guest type.
- Update the settings if the charge is not intended, then select Save/Exit.
See Rate Table: Additional Guests for every option on this tab.
Cause 2: A Rate Adjustment in the Control Panel
A Rate Adjustment adds or subtracts a percentage or flat amount for the selected Categories, Rate Types and dates. It shows in the + Adjustments column, not in the Base Rate column. A Rate Adjustment with an Occupancy benchmark only applies once the property reaches that occupancy, so it can affect some reservations for a date and not others.
Fix:
In the side menu of RMS, go to Charts > Rate Manager.
- Select the Control Panel icon.
- Find any Rate Adjustment that covers the stay date, Category and Rate Type on the reservation.
- Edit or delete the Rate Adjustment if it is not intended.
Please Note! When more than one Rate Adjustment exists for the same Rate Type and date, RMS uses the newest one, and Rate Adjustments for the same Rate Type do not add together. A Derived Rate also receives the Rate Adjustment of the Rate Type it is derived from, so selecting (All) on the Rate Type step applies a Rate Adjustment to a Derived Rate twice.
Cause 3: The Adjustment on a Derived Rate Type
A Derived Rate Type calculates its price by adding or subtracting a preset percentage or flat amount from its Master Rate Type. That preset amount shows in the + Adjustments column. It is part of the Derived Rate Type setup, not a Control Panel restriction.
Fix:
- Check whether the Rate Type on the reservation is a Derived Rate Type.
- Check the adjustment amount and the Master Rate Type on the Derived Rate Type setup.
- Update the adjustment amount if it is not intended.
Cause 4: Dynamic Pricing on the Rate Table
Dynamic Pricing automatically adjusts the rate on a Rate Table by occupancy, by lead time to arrival, or by both. The adjustment shows in the + Dynamic column. Two reservations on the same dates can therefore carry different amounts.
Fix:
In the side menu of RMS, go to Charts > Rate Manager.
- Select Rates, then select Rate Tables.
- Select the Rate Table shown for the stay date and select Edit.
- Review the Dynamic Pricing rules under Occupancy and Time.
Cause 5: A Different Rate Period or Rate Table Applies to the Date
The Base Rate comes from the Rate Table linked to the Rate Period in effect for each stay date. For each stay date, RMS first looks for a Rate Lookup for the reservation's Area, then for the whole Category, and at each level uses the Rate Lookup with the shortest Rate Period covering the date. A reservation with a Bill Category uses the Category's Rate Lookups only. RMS does not choose between two Rate Lookups for the same Rate Type, Category (or Area) and Rate Period by creation date, so only one should exist.
Fix:
- Note the Rate Period and Rate Table shown on the Total Rate/Tariff Breakdown for the stay date.
- Check the Rate Lookups for the Rate Type, Category and Area to confirm which Rate Periods cover that date, and whether the reservation has a Bill Category.
- Remove or adjust the overlapping Rate Lookup if it is not intended.
See Rates: Rate Hierarchy for a worked example of overlapping Rate Periods.
Cause 6: The Rate Was Overridden
A Rate Override replaces the Base Rate with a fixed amount. You can make an override on the reservation, on the Rate Manager chart or in the Control Panel. An override made on the reservation displays in red on the Total Rate/Tariff Breakdown, and an override on the Rate Manager chart displays in red on the chart. A Control Panel Rate Override also displays in red on the chart, because the Rate Manager chart and the Control Panel save the same Rate Override record.
While a Rate Override applies to a Rate Type, RMS ignores Dynamic Pricing and that Rate Type's Control Panel Rate Adjustments. A Rate Override made in the Control Panel or on the Rate Manager chart still adds Additionals and Packages. An override made on the reservation replaces the additional guest charges for that night as well as the Base Rate, so only Packages are added. A Derived Rate priced from an overridden Rate Type still adds its own adjustment and does not display in red. A Derived Rate that is itself overridden does not add its adjustment.
Fix:
- Check the Total Rate/Tariff Breakdown and the Rate Manager chart for amounts in red.
- Check the Control Panel for a Rate Override that covers the stay date.
- Remove the Rate Override from the Control Panel or the Rate Manager chart. Reservations already made keep their amount until their rate is recalculated (see Cause 7). For an override on the reservation, select Reset to Auto Rate on the Total Rate/Tariff Breakdown. See Reset the Base Rate.
Tip! A rate overridden on a reservation is fixed. If the reservation details change later, you must update the rate manually.
Cause 7: The Rate Setup Changed After the Reservation Was Made
Changes to the rate setup only apply to new reservations, to existing reservations when RMS recalculates their rate, or when you run the Recalculate Future Rates tool. Changes such as a new Category, dates, number of guests or Rate Type can trigger a recalculation, as described in Reservation Modifications and Rate Recalculations. An existing reservation can therefore still carry an amount, such as an adjustment, that has since been removed from the setup.
Fix:
- Confirm the current rate setup is correct.
- Use Recalculate Future Rates to update future reservations on the Rate Type to the current rate setup.
Important! Recalculate Future Rates updates the Unconfirmed, Confirmed and Quote reservations that match the selected criteria. Where accommodation charges are already on the account, RMS voids them and recreates them at the new value. Check the criteria before selecting Apply.
Please Note! Recalculate Future Rates skips a reservation with a Manual Base Rate, such as a rate overridden on the reservation or kept by answering 'No' to 'Recalculate the Rate?' after moving the reservation to new dates. To include the reservation, select Reset to Auto Rate on its Total Rate/Tariff Breakdown first. See Recalculate Future Rates.
Cause 8: A Package, Discount or Tax
Packages, discounts and exclusive tax each have their own column on the Total Rate/Tariff Breakdown. Check the setup that matches the column.
- + Package: check the Rate Table Package and any Rate Type package.
- - X Nights Dis: check the X Nights Discount tab on the Rate Table. See Rate Table: X Nights Discount.
- - Discount: check the Discount selected on the reservation. See Add a Discount to a Reservation.
- + Tax: on a Tax Exclusive property, tax is added on top of the Base Rate. See Rate type tax for tax-exclusive properties.
Still Not Working?
If the unexpected amount is still not explained after working through the causes above, contact RMS Support with the following details:
- The reservation number and the stay dates affected.
- The rate you expected and the rate on the reservation.
- A screenshot of the Total Rate/Tariff Breakdown for the reservation.
- A screenshot of the Additionals tab on the Rate Table used for the stay date.
Related Articles
- Total Rate/Tariff Breakdown
- Rates: Rate Hierarchy
- Rate Table: Additional Guests
- Control Panel for rates and availability
- Troubleshooting: A Reservation Arrived from a Channel at the Wrong Rate
Comments
0 comments
Please sign in to leave a comment.