Use the Rate Export report to download your rate setup as a comma-separated values (CSV) file to review in a spreadsheet.
What the Rate Export report shows
The Rate Export report is a CSV export of the rate (or tariff, if your property uses that label) setup saved in RMS. It lists the Rate Tables and Rate Periods that each Rate Type uses in each Category, with the prices, minimum stays, deposits and X Nights Discount saved on each Rate Table. The report has no on-screen version: the CSV file is the report.
The Rate Export report shows the prices saved on each Rate Table, not the rate for each date. The export does not include Rate Manager overrides, Dynamic Pricing or Derived Rate adjustments (see What the Rate Export report leaves out).
The Rate Export report suits staff who set up or check rates. To run the report, your Security Profile needs the Access Management Reports permission and the Rate Export report permission. For details, see Security Profile access options - Glossary.
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.
When to use the Rate Export report
Properties run the Rate Export report when they need their whole rate setup in one file, for example:
- Season rate check - before a new season, the revenue manager exports the Rate Periods in that season and checks each Rate Table's prices and minimum stays in a spreadsheet.
- Record before changes - before changing Rate Tables, a System Administrator exports the current setup to keep a dated copy for comparison.
- Deposit and discount review - the reservations team checks which Rate Tables take a deposit or give an X Nights Discount, without opening each Rate Table.
How to access the Rate Export report
In the side menu of RMS, go to Reports > Management > Reservations > Rate Export.
- Select Rate Type Period Date Range and choose the Date Range, or select Show All Rate Type to include every Rate Period.
- Optional: select the Property, Category and Rate Type to include.
- Select Export to CSV.
RMS builds the CSV file and your browser downloads it. The file name holds the date and time of the export and, for a Rate Type Period Date Range export, the first and last dates of the Date Range, for example TariffExport05112026_135743_From_01112026_To_30112026.csv. The start of the file name is the same whatever your Rate label.
Please Note! When nothing matches the report options, the file still downloads, with the header row only.
Choose the Rate Export report options
The Rate Export report options decide which Rate Periods, properties, Categories and Rate Types go into the CSV file. The table below lists each option on the Report Options panel.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Show All Rate Type / Rate Type Period Date Range | Radio buttons | Rate Type Period Date Range |
Decides which Rate Periods the file includes:
|
| Date Range | Date range | This Month | The dates the Rate Periods must overlap when Rate Type Period Date Range is selected. |
| Property | Multi-select dropdown | All Selected | Limits the export to the selected properties. Shown only on a database with more than one property. |
| Category | Multi-select dropdown | All Selected | Limits the export to the selected Categories. All Selected can also include Categories the list does not show. |
| Rate Type | Multi-select dropdown | None Selected | None Selected exports every Rate Type. Selecting a Derived Rate also exports the Rate Type it is derived from. |
| Sort By | Dropdown | Property |
Options:
The choice does not change the file: RMS always sorts the rows by property name. |
What the Rate Export column headers show
The Rate Export column headers are the first row of the CSV file. After the header row, the file has one row for each combination of Category, Rate Type, Rate Period and Rate Table, and no totals.
The word Rate in the column headings follows your property's Rate label, set in Setup > Property Options > Labels (see System Labels and terminology). Property_Name, Property_Code, Category and RateElement always read the same.
The table below lists each Rate Export column in the order it appears in the file, what it shows and where the value comes from.
| Column | Description | Source / Calculation |
|---|---|---|
| Property_Name | The property's name. | The property the Category belongs to. RMS sorts the rows by this column. |
| Property_Code | The property's code. | Blank when the property has no code. |
| RateType_Description | The Rate Type's name. | For Derived Rates and multiple Best Available Rates (BAR), see How the Rate Export report calculates its figures. |
| Traditional/Chart Rate | Chart or Traditional. | Chart for a Rate Table with the Online Travel Agent (OTA) Rate structure. Traditional for the Direct Rate structure. |
| RateTable_RateType | The Rate Table's format: Nightly, Daily, Hourly or Extended Stay. | See Rates: Rate Table Formats. |
| RateTable_ChargeStyle | The Rate Table's Based On setting: PerNight, NightOfWeek or NoOfNightsStay. | Decides what the price columns hold. See Prices in the Rate Export. |
| RateType_GLCode | The General Ledger (GL) Account Code set on the Rate Type. | See Category GL when the Rate Type has no GL Account Code. |
| RatePeriod_Description | The Rate Period's name. | All Year Round when the rate has no Rate Period. A Derived Rate with a Rate Period linked for the Category shows that Rate Period. |
| RatePeriod_FromDate, RatePeriod_ToDate | The Rate Period's first and last dates. | Blank for All Year Round. |
| RatePeriod_MinResPeriod | The Rate Period's Minimum Res Period, in days. | 0 for All Year Round. Shown with two decimals (2 shows as 2.00). |
| RatePeriod_NoDiscountAllowed | Yes when the Rate Period has No Discount Allowed selected. Otherwise blank. | Rate Period setting. Always blank for All Year Round. |
| Category | The Category's name. | The heading is always Category, whatever your Category label. |
| RateTable_Description | The Rate Table's name. | The Rate Table linked to the Rate Type for this Category and Rate Period. |
| RateTable_MinNightMon to RateTable_MinNightSun | The Rate Table's minimum stay for an arrival on each day, Monday to Sunday. | Whole numbers. Maximum stays are not in the file. |
| RateTable_Nightly_1st to RateTable_Nightly_7th | The seven prices saved on the Rate Table. | Depends on the Rate Table's format and Based On setting. See Prices in the Rate Export. |
| RateTable_Nightly_WeeklyRate | The Weekly Rate on an Extended Stay Rate Table. | 0.00 on every other Rate Table. |
| RateTable_MonthlyRate | The Monthly Rate on an Extended Stay Rate Table. | 0.00 on every other Rate Table. |
| RateTable_DepositAmount | The deposit amount on the Rate Table's first deposit row. | Shown whatever that row's deposit type. Later deposit rows are not in the file. |
| RateTable_Package | The packages attached to the Rate Table, separated by commas. | Blank when the Rate Table has no packages. |
| RateTable_Discount | Yes when the Rate Table has an X Nights Discount. Otherwise blank. | See Rate Table: X Nights Discount. |
| RateTable_DiscountEveryXNight | The Number of Nights set for the X Nights Discount. | 0.00 when there is no X Nights Discount. Shown with two decimals (7 shows as 7.00). |
| RateTable_DiscountType | Percent or Amount. | Amount also shows on Rate Tables with no X Nights Discount, so check RateTable_Discount first. |
| RateTable_DiscountAmount | The X Nights Discount off the nightly rate. | A percentage or an amount, as RateTable_DiscountType shows. 0.00 when there is no discount. |
| RateType_DepositType | Despite its name, a Rate Table setting: the type of the Rate Table's first deposit row. | Amount/Percentage, Per Week or Part Thereof, or First Night. Blank for any other type. |
| RateType_DepositAmount | A Rate Table setting: the first deposit row's amount. | The weekly amount for Per Week or Part Thereof. 0.00 for First Night and any other type. |
| RateType_DepositPercent | A Rate Table setting: the percentage on the first deposit row. | Shown whatever the deposit type. |
| RateTable_DepositDays | The number of days set for paying the first deposit. | Shown with two decimals (14 shows as 14.00). |
| RateTable_DepositWhenToPay | When the first deposit is due: From Res Made Date or Prior to Arrival. | Read with RateTable_DepositDays. |
| RateElement | The Rate Element set for the Rate Type. | Blank when the Rate Type has no Rate Element. |
How the Rate Export report calculates its figures
The Rate Export report copies the rate setup saved in RMS into the CSV file. The report adds no totals and applies no tax, currency conversion or rate adjustments. The sections below explain which rows the file holds and what the price columns show.
Rows in the Rate Export
Each row in the Rate Export is one combination of Category, Rate Type, Rate Period and Rate Table. A Rate Type linked to Rate Tables in three Rate Periods for a Category has three rows for that Category, and a rate with no Rate Period has one row showing All Year Round. Identical rows appear once. RMS sorts the rows by property name only, so sort the file in your spreadsheet to put the rows in the order you need.
Rate Periods in the Rate Export
The Rate Periods in the Rate Export depend on the option you choose. With Rate Type Period Date Range, the file includes each Rate Period that shares at least one day with the Date Range, plus every rate with no Rate Period (All Year Round). With Show All Rate Type, the file includes every Rate Period, past and future. For details of each Rate Period setting, see Rate periods.
Prices in the Rate Export
Prices in the Rate Export are the prices saved on each Rate Table, shown with two decimals and no thousands separator. What the seven price columns (RateTable_Nightly_1st to RateTable_Nightly_7th) hold depends on the Rate Table's format (RateTable_RateType) and Based On setting (RateTable_ChargeStyle):
- Nightly, NightOfWeek: the Monday to Sunday prices. This includes every Nightly OTA Rate table.
- Nightly, PerNight: the 1st to 7th night prices.
- Nightly, NoOfNightsStay: 0.00 in all seven columns.
- Daily and Hourly: 0.00 in all seven columns.
- Extended Stay: the Weekly Rate and Monthly Rate in their own columns. Only an Extended Stay Rate Table based on PerNight has prices in the 1st to 6th price columns. On any other Extended Stay Rate Table, all seven show 0.00.
On a Per Adults/Children Rate Table, the price columns hold the Per Adults prices. The Per Children prices are not in the file.
Derived Rates in the Rate Export
Derived Rates in the Rate Export show the Derived Rate's name with the Rate Tables and prices of the Rate Type it is derived from. The export does not apply the Derived Rate's adjustment, so the prices match that Rate Type's prices. When you select only a Derived Rate in the Rate Type option, the file also has rows for the Rate Type it is derived from, under that Rate Type's own name. For how Derived Rates work, see Derived Rate Types.
Multi BAR rates in the Rate Export
Multi BAR rates appear in the Rate Export under the Rate Type name BAR (Multi) when the property uses multiple Best Available Rates (Multi BAR). Each BAR (Multi) row shows the Rate Tables of the Best Available Rate (BAR) Rate Type in use for that Category on the first date of the Date Range. The file does not show a change of BAR later in the Date Range. For more about Multi BAR, see Multi BAR (multiple Best Available Rates).
What the Rate Export report leaves out
The Rate Export report leaves out prices set for particular dates and some Rate Table settings. The CSV file does not include:
- Rate Manager and Control Panel rate overrides and adjustments.
- Dynamic Pricing.
- Derived Rate adjustments.
- Tax and currency conversion.
- The After 7th price, child prices, additional adult and child prices, and maximum stays.
- Deposit rows after the first one, and deposit settings on the Rate Type.
Because of these exclusions, a price in the Rate Export can differ from the rate the Rate Manager shows for a date.
Tip! To export each date's rate for each Category, use the Print icon on the Rate Manager instead. See Exporting Each Date's Rate.
Related Reports
- Rate Table List Report - lists each Rate Table with the rates and settings saved on it.
- Rate Type Detail Report - lists the full configuration of every Rate Type, including its Rate Tables.
- Reservation Daily Rate Breakdown Export - exports reservation revenue night by night.
Related Articles
Comments
0 comments
Please sign in to leave a comment.