This article explains how to export your rate setup from the Rate Manager to a CSV file, and what each column of the Rate Export file contains.
Information
The Rate Export downloads a CSV file of your rate setup: each Rate Type's Rate Tables, Rate Periods, prices, minimum stays, deposits, and discounts, for each Category.
The export feature on the Rate Manager Chart provides a .csv file containing all selected rate setup information. The same export is also available at Reports > Management > Reservations > Rate Export.
You can use the Rate Export to simplify auditing rates. It shows the prices saved on each Rate Table, not the price for each date: see What the Export Does Not Include.
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.
Use Cases
- Audit rate setup before a season - export the Rate Periods for the coming months and review every Rate Table's prices, minimum stays, and deposits in one spreadsheet.
- Compare Categories - filter or sort the file in a spreadsheet to compare the Rate Tables each Category uses for the same Rate Type.
- Check discounts and deposits - review which Rate Tables have an X Nights Discount or a deposit set, without opening each Rate Table.
Guide
- Navigate to Charts > Rate Manager.
- Select the Property.
- Use the 'Export' icon.
On the Rate Export screen that opens:
- Select Show All Rate Type or Rate Type Period Date Range.
- Select the 'Date Range' (Rate Type Period Date Range only).
- Select the 'Property'.
- Select the 'Category'.
- Select the 'Rate Type', or leave it as None Selected to export every Rate Type.
- Leave Sort By as it is: changing it does not change the order of the rows in the file.
- Click 'Export to CSV'.
The file will download in the browser; make sure your pop-up blocker is disabled.
Your browser downloads a .csv file containing the rate setup information for the selected options.
Report Options
The report options below control which Rate Periods, properties, Categories, and Rate Types the Rate Export includes.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Show All Rate Type / Rate Type Period Date Range | Radio | Rate Type Period Date Range | Rate Type Period Date Range exports the Rate Periods that overlap the Date Range, plus rates with no Rate Period (All Year Round). Show All Rate Type exports every Rate Period, including past and future ones. |
| Date Range | Date range | This Month | Used with Rate Type Period Date Range. The dates also appear in the file name. |
| Property | Multi-select dropdown | All Selected | Shown when the database has more than one property. Limits the export to the selected properties. |
| Category | Multi-select dropdown | All Selected | Limits the export to the selected Categories. With All Selected, the file can also include Categories that the drop-down does not list. |
| Rate Type | Multi-select dropdown | None Selected | Leave it as None Selected to export every Rate Type, or select Rate Types to limit the export. Selecting a Derived Rate Type also exports the rate it is derived from. |
| Sort By | Dropdown | Property |
Options:
Choosing a different option does not change the order of the rows in the file. |
Column Headers
The Rate Export CSV has one header row, then one row for each combination of Category, Rate Type, Rate Period, and Rate Table. A Rate Type with Rate Tables in three Rate Periods for a Category has three rows for that Category, and a rate with no Rate Period shows All Year Round. The file has no totals.
The word Rate in the headings follows your property's Rate label, so a property that calls it Tariff sees TariffType_Description, TariffTable_Description, and so on.
| Column | Description |
|---|---|
| Property_Name | The property's name. |
| Property_Code | The property's code. Blank when the property has no code. |
| RateType_Description | The Rate Type's name. For BAR (Multi), the Rate Tables are those of the Best Available Rate in use on the start date of the Date Range. |
| Traditional/Chart Rate | Chart for a Rate Table with the OTA Rate structure, otherwise Traditional. |
| RateTable_RateType | The Rate Table's format: Nightly, Daily, Hourly, or Extended Stay. |
| RateTable_ChargeStyle | The Rate Table's Based On setting, written as PerNight, NightOfWeek, or NoOfNightsStay. |
| RateType_GLCode | The General Ledger (GL) Account Code set on the Rate Type, or See Category GL when the Rate Type has none. |
| RatePeriod_Description | The Rate Period's name, or All Year Round when the rate has no Rate Period. |
| RatePeriod_FromDate, RatePeriod_ToDate | The Rate Period's start and end dates. Blank for All Year Round. |
| RatePeriod_MinResPeriod | The Rate Period's own minimum stay, in days. |
| RatePeriod_NoDiscountAllowed | Yes when the Rate Period does not allow discounts. Otherwise blank. |
| Category | The Category's name. The heading is always Category, whatever your Category label. |
| RateTable_Description | The Rate Table's name. |
| RateTable_MinNightMon to RateTable_MinNightSun | The Rate Table's minimum stay for a reservation arriving on each day of the week. Maximum stays are not exported. |
| RateTable_Nightly_1st to RateTable_Nightly_7th | The seven prices saved on the Rate Table. On a Rate Table based on Night of Week (including every OTA Rate structure), they are the Monday to Sunday prices. On a Rate Table based on Per Night, they are the 1st to 7th night prices. On a Per Person Rate Table, they are the adult prices. Daily, Hourly, and No. of Nights Rate Tables show 0.00 in all seven columns. |
| 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 first deposit row of the Rate Table. |
| RateTable_Package | The packages attached to the Rate Table, if any. |
| RateTable_Discount | Yes when the Rate Table has an X Nights Discount. Otherwise blank. |
| RateTable_DiscountEveryXNight | The number of nights in the Rate Table's X Nights Discount. 0 when there is none. |
| RateTable_DiscountType | Percent or Amount. Amount also shows on a Rate Table with no X Nights Discount, so read it with RateTable_Discount. |
| RateTable_DiscountAmount | The X Nights Discount taken off the base rate, as a percentage or an amount. |
| RateType_DepositType | Despite the 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). |
| RateType_DepositAmount | A Rate Table setting: the first deposit row's amount, or its weekly amount for Per Week or Part Thereof. 0.00 for First Night. |
| RateType_DepositPercent | A Rate Table setting: the first deposit row's percentage. |
| RateTable_DepositDays | The number of days set for paying the Rate Table's first deposit. |
| RateTable_DepositWhenToPay | When the first deposit is due: From Res Made Date or Prior to Arrival. |
| RateElement | The Rate Element set on the Rate Type, if any. |
What the Export Does Not Include
The Rate Export lists the prices saved on each Rate Table, not the price for each date. The following are left out:
- Rate Manager and Control Panel rate overrides and adjustments.
- Dynamic Pricing.
- Derived Rate adjustments: the rows for a Derived Rate Type show the Rate Tables and prices of the rate it is derived from.
- The After 7th price, child prices, additional guest prices, and maximum stays.
- Deposit rows after the first one.
Because overrides and Dynamic Pricing are left out, the export can show a higher price than the Rate Manager shows for some dates.
Exporting Each Date's Rate
To export each date's rate for each Category, use the Print icon on the Rate Manager instead of the Export icon. The Print icon is shown when the Rate Manager's first drop-down is set to Category and Display is set to Rate. It asks for a date range and downloads a spreadsheet (results.xlsx) with a row of dates, one row for each row on the Rate Manager, and that date's rate in each cell (NA where there is no rate).
The spreadsheet stops one day before the end of the Date Range, so set the end date one day after the last date you need.
Related Reports
- Rate Table List Report - lists each Rate Table with the rates and settings saved on it, on screen.
- Reservation Daily Rate Breakdown Export - exports the nightly rate breakdown for reservations.
Related Articles
Comments
0 comments
Please sign in to leave a comment.