This article explains how to configure an Extended Stay Rate Table based on Per Night in RMS, where nightly rate amounts are applied sequentially from the first to the last night of a reservation, with optional weekly and monthly rate tiers for longer stays.

Overview

A Rate Table defines the fee structure for a specific rate type. The Extended Stay Rate Table, based on Per Night, applies nightly rate amounts sequentially from the first to the last night of a reservation, regardless of the day of the week each night falls on.

The Rate Table can incorporate various elements, such as Length-of-Stay Restrictions, additional guest fees, Dynamic Pricing rules, and package components. Many of these factors are configurable across multiple layers of rate components for greater flexibility.

Additionally, Length-of-Stay Restrictions set within the Rate Table will take precedence over any restrictions defined at the Rate Type or Rate Period level.

Please Note! A Rate Table using the Per Night format will display 'N/A' for these rates on the Rate Manager Chart. Because each night of a stay can be a different amount, the rate cannot be resolved to a single per-date value before the reservation length is known. See Users See 'N/A' on the Rate Manager Chart for the full list of reasons rates display as N/A.

Please Note! With the Extended Stay format, the monthly rate is determined based on the calendar month corresponding to the arrival date. If the reservation's length of stay does not cover an entire calendar month, the weekly rate will be applied instead.

Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.

Configuration

The Extended Stay Rate Table, based on Per Night, allows you to configure nightly rates applied sequentially across the stay, alongside optional weekly and monthly rates for longer reservations. You can also set a cap on the number of cycles for which the weekly or monthly rate applies. Once this limit is reached, the Best Available Rate will be used for any additional nights beyond the capped period.

Please Note! A Rate Type and Rate Table can only be linked in a Rate Lookup if they are set up within the same rate structure. The Extended Stay Rate Table based on Per Night can only be created under the Direct rate structure.

1. Navigate to Charts > Rate Manager.
2. Select Rates.
3. Select Rate Tables.
   
    
4. Select Add.
   
    
5. Enter a unique Description.
6. Select Direct Rate for Rate Structure.
7. Select the Extended Stay Format.
8. Select Per Night for Based On.
9. Enter the Person Base (the number of guests included in the rates below).
10. Enter the Rate Amounts.
11. Select Don't Loop Back to Lower Period (Optional).
12. Enter the Number of Cycles (Optional).
    Setting a cap on the number of cycles for a weekly or monthly block will apply the Best Available Rate to any additional stay dates once the cap is reached.
13. Configure any additional Rate Features (Optional).
14. Select Save/Exit.
    
     

Please Note! Creating a rate table does not make the rate bookable. To activate the rate, the Rate Table must be linked within the Rate Lookup or through the New Rate Wizard.

Extended Stay Rate Calculations

Extended Stay rates offer enhanced flexibility for longer-term reservations by combining nightly, weekly, and monthly rate values to calculate the total cost of a stay. With the Per Night format, the nightly rate amounts are applied sequentially from the first to the last night - Night 1 costs apply on the first night of every reservation, Night 2 costs on the second night, and so on, regardless of the day of the week.

If the nightly, weekly, or monthly rate amounts are not set, they will be excluded from the calculation once a reservation reaches the corresponding length of stay, and the next available rate block will be applied instead.

Please Note! Weekly and monthly rates are evenly distributed across the reservation stay dates, which impacts individual transactions when using the nightly rate and the allocation of revenue per stay date.

Nightly

Based on the Rate Table, reservations of six nights or fewer will be charged according to the sequential nightly rate amounts specified in the Extended Stay Rate Table. The rate for the first night is always applied on the arrival night, the second-night rate on the following night, and so on.

Weekly

A reservation of seven nights will be charged at the weekly rate rather than the nightly rate. This weekly rate will apply to each seven-night segment of the reservation. For reservations of fourteen, twenty-one, or twenty-eight nights, the weekly rate will be applied to each seven-day block of the stay.

A nine-night reservation will apply the weekly rate for the first seven nights and then revert to the sequential nightly rate for the remaining two nights, starting again from Night 1 of the nightly rate sequence.

Monthly

The monthly rate applies to each calendar month, based upon the arrival date. Any reservation dates beyond the calendar month will be charged at the nightly and/or weekly rate for the remaining stay, using the sequential Per Night amounts for any remaining individual nights.

Don't Loop Back to Lower Period

The 'Don't Loop Back to Lower Period' feature is commonly used by properties that have distinct Rate Types for Nightly, Weekly, and Monthly Rates. When enabled, this feature prevents the system from reverting to a lower rate tier after a guest has qualified for a higher rate period (such as weekly or monthly). Instead, it automatically prorates the cost based on the applicable rate for the selected period, ensuring a more accurate and fair pricing structure.

Using the example rate table above (Night 1 $250.00, Night 2 $225.00, Weekly rate $700.00), a stay extending past a 7-night weekly block is calculated as follows:

Don't Loop Back to Lower Period: disabled

After a weekly block, the nightly sequence restarts from Night 1:

• One Week + One Night = $950.00 ($700.00 weekly + $250.00 Night 1 restart)
• One Week + Two Nights = $1,175.00 ($700.00 weekly + $250.00 Night 1 + $225.00 Night 2 restart)

Don't Loop Back to Lower Period: enabled

Additional nights beyond the weekly block are prorated against the weekly rate:

• One Week + One Night = $800.00 ($700.00 ÷ 7 × 8 nights)
• One Week + Two Nights = $900 ($700.00 ÷ 7 × 9 nights)

Please Note! For an Extended Stay Rate Table where you are only entering weekly or monthly pricing, we recommend setting a minimum and/or maximum length of stay within either the Rate Table or the Rate Type.