How to run a Master Rate Audit Report (Single-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 to
Season start and end dates
Rate pricing and rooms
Stay restrictions
Requirements:
You need to run four reports and upload them to produce a Master rate audit report.
Note: If you need to verify whether a specific negotiated rate is set up as commissionable, please contact our support team who can check the configuration for you.
Download the Bulk Price Season import
Click Setup > Data Import > Bulk Price Season Import.
From the Select Action box, select Download Template .
From the Hotel Level box, select Single Hotel.
Under Rate Search, select Active under Status and click Search Rates
Under Rate Results:
Select all rates by ticking the top box
If you have more than 100 rates loaded make sure you select 500 rows per page.
Click Generate download at the top of the page.
The following message will appear " The download generation was scheduled successfully. Click on the View Downloads to see the download processing status and detail ".
Select View Downloads.
Continue to Refresh the view until the Completed status is 100%. This may take some time if you have lots of rates. When the status is 100% completed the file is ready to be downloaded.
Select Download.
Open the file to view and save. Note: The file format must be saved as an Excel workbook (.xlsx).
You now need to repeat these steps for rate data and stay restrictions.
Download the Bulk Rate Data import
Click Setup > Data Import > Bulk Rate Data Import.
From the Select Action box, select Download Template.
From the Hotel Level box, select Single Hotel.
Under Rate Search, select Active under Status and click Search Rates.
Under Rate Results:
Select all rates by ticking the top box
If you have more than 100 rates loaded make sure you select 500 rows per page.
Click Generate download at the top of the page.
The following message will appear " The download generation was scheduled successfully. Click on the View Downloads to see the download processing status and detail ".
Select View Downloads.
Continue to Refresh the view until the Completed status is 100%. This may take some time if you have lots of rates. When the status is 100% completed the file is ready to be downloaded.
Select Download.
Open the file to view and save. Note: The file format must be saved as an Excel workbook (.xlsx).
Download the Stay Restriction Import
Click Setup > Data Import > Bulk Stay Restriction Import.
From the Select Action box, select Download Template.
From the Hotel Level box, select Single Hotel.
Under Rate Search, select Active under Status and click Search Rates.
Under Rate Results:
Select all rates by ticking the top box
If you have more than 100 rates loaded make sure you select 500 rows per page.
Click Generate download at the top of the page.
The following message will appear " The download generation was scheduled successfully. Click on the View Downloads to see the download processing status and detail ".
Select View Downloads.
Continue to Refresh the view until the Completed status is 100%. This may take some time if you have lots of rates. When the status is 100% completed the file is ready to be downloaded.
Select Download.
Open the file to view and save. Note: The file format must be saved as an Excel workbook (.xlsx).
Download the Hotel Rate Audit report
Click Reports > Reports > Rates > Hotel Rate Audit.
Select Search to add your hotel.
Type in your property name and click Search. Your property will appear underneath.
Tick the box for your property and click Add Selected at the top of the page.
Under Channels select GDS.
Click Generate Report at the top of the page.
Click the disc symbol and select Excel. The hotel audit report is now downloaded.
Generate the Master Rate Audit report
When you access the Master Rate Audit upload tool, you'll see all four file upload fields displayed. Before uploading, it is important to check that the four files are saved in the .xlsx file format or an error will result.
Click on this link to upload the reports - Master rate audit report.
Upload each of your four downloaded files:
Click Choose a file for Hotel Rate Audit File
Click Choose a file for Price Season Template File
Click Choose a file for Rate Template Update File
Click Choose a file for Stay Restrictions File
Click Start Process.
The system will process your files and automatically download a single Excel file.
Open the downloaded file to view your Master Rate Audit Report.