The purpose of this document is to provide instructions for Customers to run reports needed when migrating from Hotel Sales & CateringPro (HSP) to Amadeus Sales & Event Management (ASEM). The reports offer a record of data in HSP which can be used as a reference upon deactivation of the system, allowing for a seamless transition to ASEM.   

Summary 

Customer will use the Hotel Sales & CateringPro application to run the following suggested reports: 

• GRC 12 Months 

• Revenue by Arrival 
• Group Arrivals – Front Desk/Operations 
• Group-Resume 
• Function Agenda Details 
• Forecast – Forecast by Day 

• BEO – Custom BEO 
• BEO – Custom Banquet Check 
• Function-Resume 
• Menu Items 

Prerequisites 

• Customer must have an active user/logon to the HSP application 
• Customer must have the access right to Run Reports 

 

Groups 

 

GRC 12 Months

This Report will list all Groups by Arriving Month by Status.  It will show the Group Name, Salesperson, Group Type, Arrival Date, Contract Due Date, Definite Date, Daily Room Night Totals, Total Net Nights, Total Net ADR, & Total Net Revenue.  There is a separate section for Pickup-Actual Nights/ADR/Rev.   

• Login to HSP 
• Click on the Reports Icon (left Menu) 
• Click on the Group Tab 
• Under the Operations Section, Click on the report named “GRC 12 Months” 

• Click Preview 
• Enter Starting Month, Months to Display & other parameters 
• Click the “View Report” button 
• Click the Export to Excel option     

**please note this report is not available in Excel format. 

 

Revenue by Arrival  

This Report will list all Groups by Arrival Date.  It will show the Group Name, Salesperson, Group Type, Status, Arrival Date, Departure Date, Date Created, Contract Due Date, Definite Date, Cancelled Date, Release Date (Cut-off), Deposit Due Date, Deposit Rec’d Date, Total Block, Total Net Nights, Total Net ADR, Total Net Revenue, Pickup-Actual Nights/ADR/Rev, & linked Function Revenues. 

• Login to HSP 
• Click on the Reports Icon (left Menu) 

• Click on the Group Tab 
• Under the Revenue Section, Click on the report named “Revenue by Arrival” 
• Click Preview 
• Enter Date Range & other parameters 
• Click the “View Report” button 

• Click the Export to Excel option  

 

Group Arrivals – Front Desk/Operations 

This Report will list all Groups by Arrival Date.  It will show the Group Name, Salesperson, Group Type, Status, Arrival Date, Departure Date, Comp Policy, Billing Instructions, Reservation Method, Parking, Baggage, Group Code & Total Block Nights. 

• Login to HSP 

• Click on the Reports Icon (left Menu) 
• Click on the Group Tab 
• Under the Revenue Section, Click on the report named “Group Arrivals-Front Desk/Operations” 
• Click Preview 
• Enter Date Range & other parameters 

• Click the “View Report” button 
• Click the Export to Excel option  

  

Resume 

This Report will list all Groups by Arrival Date.  It will provide a more detail of each group block including Daily Room Types/Rates.  It will also show Travel Agent details, Contract/Reservation/Accounting options, Resume Notes, plus Linked Function details.   

• Login to HSP 
• Click on the Reports Icon (left Menu) 
• Click on the Group Tab 
• Under the Operations Section, Click on the report named “Resume” 
• Click Preview 

• Enter Date Range & other parameters 
• Click the “View Report” button 
• Click the Export to Excel option 

 

Functions/BEOs 

 

Function Agenda Details  

This Report will list all Functions by Function Date.  It will show the Function Name, Salesperson, Function Dates, Times, Status, Event Type, # of People, Assigned Function Room, Setup, Catering Manager, & Payment Method.  It also includes Function Agenda Details.   

• Login to HSP 
• Click on the Reports Icon (left Menu) 

• Click on the Function Tab 
• Under the Operations Section, Click on the report named “Function Agenda Details” 
• Click Preview 
• Enter Date Range & other parameters 
• Click the “View Report” button 

• Click the Export to Excel option     

 

Forecast – Forecast by Day  

This Report will list all Functions by actual Assigned Date & should be used for future Functions.  It will show the Function Name, Sales Manager, Catering Manager, Status, Function Type, Event Type, Count, Revenue Source, Revenues by Food, Room Rental, Beverage, AV, Misc, Service & Grand Total.  

• Login to HSP 

• Click on the Reports Icon (left Menu) 
• Click on the Function Tab 
• Under the Revenue Section, Click on the report named “Forecast-Forecast by Day” 
• Click Preview 
• Enter Date Range & other parameters 

• Click the “View Report” button 
• Click the Export to Excel option  

 

Function Actuals – BEO Ordered/Billed 

This Report will list all BEOs by BEO Date & should be used for tracking past Function Revenues.  It will show the Function Name, BEO Name, BEO Date, BEO ID #, Folio #, GTD #, Actual Food Revenue, Room Rental Revenue, AV Revenue, Staff Revenue, Misc. Revenue, Parking Revenue, Total Tax, Total Service Charge, Grand Totals & Payment Methods. 

• Login to HSP 
• Click on the Reports Icon (left Menu) 
• Click on the Function Tab 
• Under the Revenue Section, Click on the report named “Function Actuals-BEO Ordered/Billed” 
• Click Preview 

• Enter Date Range & other parameters 
• Click the “View Report” button 
• Click the Export to Excel option  

  

BEO – Custom BEO 

This Report will list all BEOs by BEO Date within a 31-day period & should be used to reference future BEOs.  It will show the Actual BEO that contains all Function Details & Items Order.  It also includes an Estimated Charges section. 

• Login to HSP 
• Click on the Reports Icon (left Menu) 
• Click on the Function Tab 
• Under the Operations Section, Click on the report named “BEO-Custom BEO” 

• Click Preview 
• Enter Date Range & other parameters 
• Click the “View Report” button 
• Click the Export to Excel option  

 

BEO – Custom Banquet Check 

This Report will list all Banquet Checks by BEO Date & should be used to reference past BEOs.  It will show the Actual Banquet Check that contains Function Details & Items Order.   

• Login to HSP 
• Click on the Reports Icon (left Menu) 
• Click on the Function Tab 

• Under the Operations Section, Click on the report named “BEO-Custom Banquet Check” 
• Click Preview 
• Enter Date Range & other parameters 
• Click the “View Report” button 
• Click the Export to Excel option  

 

Resume 

This Report will list all Functions by main Function Date.  It will provide a more detail of each individual Function including Agenda Summary, Accounting options, & Resume Notes.   

• Login to HSP 
• Click on the Reports Icon (left Menu) 

• Click on the Function Tab 
• Under the Operations Section, Click on the report named “Resume” 
• Click Preview 
• Enter Date Range & other parameters 
• Click the “View Report” button 

• Click the Export to Excel option 

 

Menu Items 

This Report will list all Menu Items from the Customize section of the hSP system broken down by Menu Type/Category.  It will provide a full list of all Menu Items including their Description, Charge to Category, Unit Price, Tax Breakdown, Service Charge Breakdown & List order #.  

• Login to HSP 

• Click on the Reports Icon (left Menu) 
• Click on the System Tab 
• Click on the report named “Menu Items” 
• Click Preview 
• Select any parameters (if needed) 

• Click the “View Report” button 
• Click the Export to Excel option 

 

Troubleshooting 

Please reference our online Report Guide Overview & Help Documents: http://www.hotelsalespro.com/support/report-guide-overview.htm 

For any additional questions, please contact our Support Desk @ hospitality.support@amadeus.com.