Skip to main content
All CollectionsGDS
GDS by SiteMinder - Run a Master Rate Audit Report (Multi-Hotel User)
GDS by SiteMinder - Run a Master Rate Audit Report (Multi-Hotel User)
Updated over a year ago

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:

  1. Bulk Price Season Import

  2. Bulk Rate Data Import

  3. Bulk Stay Restriction Import

  4. Hotel Rate Audit report

Downloading Templates

Price Season

Download the price season template

Go To: Setup > Data Import > Bulk Price Season Import

User-added image

Select Action: Select Download Template

Hotel Level: Select Multiple Hotel

Chain Selection: Click Select next to SiteMinder

User-added image

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

User-added image

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

User-added image

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)

User-added image

Rate Data

Download the Rate Data template. Go To: Setup > Data Import > Bulk Rate Data Import

User-added image


Select Action: Select Download Template
Select Rates Search Level: Select Multiple Hotel

User-added image

Chain Selection: Click Select for SiteMinder chain

User-added image

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

User-added image
  • 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

User-added image

The following message will appear:
“The download generation was scheduled successfully. Click on View Downloads to see the download processing status and detail”

User-added image


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)

User-added image

Stay Restriction

Download the stay restriction template.
Go To: Setup > Data Import > Bulk Stay Restriction Import

User-added image

  • Select Action: Select Download Template

  • Select Rates Search Level: Select Multiple Hotel

  • Chain Selection: Click Select next to SiteMinder chain

User-added image

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

User-added image

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)

User-added image

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

User-added image
  • 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

User-added image
Did this answer your question?