How to run a Master Rate Audit Report (Multi-Hotel User)
The Master Rate Audit Report will provide the following information:
Rate Name
Rate Description
Commission
Policy Assignments
Rate Access Codes
GDS platforms to which the rates are mapped
Season Start and End Dates
Rate Pricing and Rooms
Stay Restrictions
Four files are required to be run and uploaded, to produce a Master Rate Audit report. The four files are:
Bulk Price Season Import
Bulk Rate Data Import
Bulk Stay Restriction Import
Hotel Rate Audit report
Downloading Templates
Price Season
Download the price season template
Go To: Setup > Data Import > Bulk Price Season Import
Select Action: Select Download Template
Hotel Level: Select Multiple Hotel
Chain Selection: Click Select next to SiteMinder
Rate Search:
Search Type: Leave as is on Code and Name
Search By: Name ; Starts with
Type in the rate name, after the Starts with field
Status: Select Active
Please click Search Rates
If you have more than 100 rates listed in the results, make sure you select 500 or 1000 Rows per Page which you will see at the bottom of the page.
Select all rates by ticking the top box
Click Generate Report at the top
The following message will appear:
“The download generation was scheduled successfully. Click on View Downloads to see the download processing status and detail”
Select: View Download
You might have to click the refresh button a few times as this might take a while if the file is big. When status is 100% completed the file is ready to be downloaded.
Please select: Download
Open the file to view and save.
Please note: The file format must be saved as Excel Workbook (.xlsx)
Rate Data
Download the Rate Data template. Go To: Setup > Data Import > Bulk Rate Data Import
Select Action: Select Download Template
Select Rates Search Level: Select Multiple Hotel
Chain Selection: Click Select for SiteMinder chain
Rate Search
Search Type: Leave as is on Code and Name
Search By: Name ; Starts with
Type in the rate name, after the Starts with field
Status: Select Active
Click Search Rates
If you have more than 100 rates listed in the results, make sure you select 500 or 1000 Rows per Page which you will see at the bottom of the page.
Select all rates by ticking the top box
Click Generate Report at the top
The following message will appear:
“The download generation was scheduled successfully. Click on View Downloads to see the download processing status and detail”
Select: View Download
You might have to click the refresh button a few times as this might take a while if the file is big. When status is 100% completed the file is ready to be downloaded.
Select: Download
Open the file to view and save.
Please Note: The file format must be saved as Excel Workbook (.xlsx)
Stay Restriction
Download the stay restriction template.
Go To: Setup > Data Import > Bulk Stay Restriction Import
Select Action: Select Download Template
Select Rates Search Level: Select Multiple Hotel
Chain Selection: Click Select next to SiteMinder chain
Rate Search
Search Type: Leave as is on Code and Name
Search By: Name ; Starts with
Type in the rate name, after the Starts with field
Status: Select Active
Click Search Rates
If you have more than 100 rates listed in the results, make sure you select 500 or 1000 Rows per Page which you will see at the bottom of the page.
Select all rates by ticking the top box.
Click Download Template at the top of the screen
Open the file to view and save.
Please note: The file format must be saved as Excel Workbook (.xlsx)
Hotel Rate Audit
You will receive the Hotel Rate Audit report via a monthly subscription that will be set up for your user profile. The report will be emailed to you in the first week of the new month for the month prior.
Please ensure this report is downloaded and saved as Excel Workbook (.xlsx) file format
Uploading Templates
Before the four reports are uploaded it is important to check that the files are saved in the .xlsx file format or an error will result when the files are uploaded.
Click the link below to upload the four files.
A new window will open.
See image to the right.
Click Choose a file in each of the four sections and select the files to upload.
Once all four files have been selected and loaded, the blue boxes on the right will change to File Loaded
Name your report in the Output file name
Click Start Process
A processed button will appear to the right of each file upload section to indicate that the uploads have completed successfully.
A single Excel file will then automatically download at the bottom left corner of the screen.
Once the download has completed, a blue box called Process Complete will appear below the Output file name section
Click on the downloaded file to view the Master Rate Audit Report.
To refresh the page to upload new files, click on New Report