Changes

''This page is about the menu REPORTS''__TOC__If you need a report that is not here please let us know, we will attempt to add any reasonable report type. If you have more than one property you can select whether you want to run a report for one property or for all.  After you have selected the time period click on one of the report buttons to generate the report. If you want to limit the report to certain rooms you can add a rooms parameter to the end of the report URL in the browser. The rooms parameter can contain one room id or a comma separated list of room id's For example adding '''&rooms=1000,1001''' to the reports URL will cause the report to show only room id's 1000 and 1001. == Standard Reports ==The system offers a range of standard reports. Definitions:*average over stay: Values are assigned to each months with booked dates by the number of nights in each month*booked at check-in date: Value of all bookings for which the check-in date falls into the month*booked at check-out date: Value of all bookings for which the check-out date falls into the month*Invoice charges: Values from the "Total Charge" field in the "Charge and Payments" tab of the booking*Revenue: Values from the "Price" field in the "Charge and Payments" tab of the booking To download and customise standard reports: 1. Generate the report 2. Right click on the reports and then "Save As" e.g. report.html 3. Go to the saved file and open it with Excel 4. Change the data as required '''Download Standard Reports''' Rright click on the report and then use your Browsers "SAVE" or "DOWNLOAD" option. This will create a file which you can then import as .csv into a spreadsheet program i.e. Excel. == Custom Reports ==You can create and store custom reports at the menu SETTINGS->REPORTS->CUSTOM REPORTS.  === General set up ===1. Create a custom report*Enter a "Report Title" which is the name under which the report will be stored.*Adjust the other criteria*Drag the items you want to the left side and the one you do not want to the right then SAVE. If will now be always available. 2. Generate a preset custom report*Use the selector to choose a report*If required adjust the criteria e.g. dates*If you want to use a custom report on the dashboard set it "Layout" = tabular. If you use info codes in booking you can use these to show or hide selected bookings. For example, if you use the code "CHECKEDIN" when guests check in and "CHECKEDOUT" when guests check out, you could create a custom reports to show custom reports by showing booking which include the info code "CHECKEDIN" and excluding those that have the info code "CHECKEDOUT".  <embedvideo servicediv class="youtubeheading">https://www.youtube.com/watch?v=cY4-NSPNaLoReports</embedvideodiv> The "Room Template" columns show the content added in SETTINGS-PROPERTIES-ROOMS-SETUP under "Room Template". These fields can contain template varialbles and also math variables which allows you to use these colums for custom calculations.   Note: There can be problems exporting data to Excel or CSV in some browsers including Internet Explorer/Edge, it works well with Chrome and Firefox. Problems also occur with Chrome and MAC. === Template variables in Custom Reports ===The columns "Property Template" and "Room Template" will show This page is about the content you have entered in SETTINGS->PROPERTIES->DESCRIPTION / SETTINGS->PROPERTIES->ROOMS->SETUP. These fields support template variables. If you enter template variables there the report will show the corresponding value from the booking. You can also use math variables to calculate values from the booking.  === Specific Custom Reports ===You can create specific reports showing only bookings which meet certain criteria.  These bookings are identified using Booking Info Codes which are automatically set by Auto Actions.  To create Info Codes go to SETTINGS - >ACCOUNT -> PREFERENCES “Booking Info Code Presets” and create the info codes you need.  For example: F&B-BB (for example for breakfast) F&B-HB (for example for half board) F&B-FB (for example for full board) AirportTransfer (for example for airport transfer)  ==== '''Example 1''': Daily breakfast report ====  1. Create your info codes as explained above. 2. Set up Auto Actions to automatically assign the Info Codes. Go to SETTINGS -> GUEST MANAGEMENT ->AUTO ACTIONS and create an Auto Action or each of your meal options.  Trigger tab: Trigger Event = After Booking Trigger Time = Immediate Booking Source = Booking.com (for example) Booking Field Contains: meal_plan=Breakfast (or Extra Breakfast - use the text the channel uses)  Booking info tab Booking Info Code : F&B-BB Booking Info Text : [NUMPEOPLE1]  3. Create Custom Report,Go to menu REPORTS - > CUSTOM REPORTS and create a new custom report with these settings: Report Title = Breakfast Check In From = Any Date Check In To = Today Check Out From = Today Check Out To = Any Date Any Booking Info Code =F&B-BB  Drag and Drop the columns for the information you want to see from the “Available Columns” to the “Show Columns”   Booking Ref Property Room Unit Full Name First Night Check Out Booking Info Specified Columns   ==== '''Example 2''': Daily Half Board report ====  1. Create your info codes as explained above. 2. Set up Auto Actions to automatically assign the Info Codes. Go to SETTINGS -> GUEST MANAGEMENT ->AUTO ACTIONS and create an Auto Action or each of your meal options.  Trigger tab: Trigger Event = After Booking Trigger Time = Immediate Booking Source = Booking.com (for example) Booking Field Contains: meal_plan=Half Board (or use the rate code for half board - use the text the channel uses)  Booking info tab Booking Info Code : F&B-HB Booking Info Text : [NUMPEOPLE1]  3. Create Custom Report,Go to REPORTS - > CUSTOM REPORTS and create a new custom report with these settings: Report Title = Half Board Check In From = Any Date Check In To = Today Check Out From = Today Check Out To = Any Date Any Booking Info Code =F&B-HB  Drag and Drop the columns for the information you want to see from the “Available Columns” to the “Show Columns”   Booking Ref Property Room Unit Full Name First Night Check Out Booking Info Specified Columns   ==== '''Example 3''': Daily Full Board report ====  1. Create your info codes as explained above. 2. Set up Auto Actions to automatically assign the Info Codes. Go to SETTINGS -> GUEST MANAGEMENT ->AUTO ACTIONS and create an Auto Action or each of your meal options.  Trigger tab: Trigger Event = After Booking Trigger Time = Immediate Booking Source = Booking.com (for example) Booking Field Contains: meal_plan=Full Board (or use the rate code for Full board - use the text the channel uses)  Booking info tab Booking Info Code : F&B-FB Booking Info Text : [NUMPEOPLE1]  3. Create Custom Report,Go to REPORTS - > CUSTOM REPORTS and create a new custom report with these settings: Report Title = Full Board Check In From = Any Date Check In To = Today Check Out From = Today Check Out To = Any Date Any Booking Info Code =F&B-FB  Drag and Drop the columns for the information you want to see from the “Available Columns” to the “Show Columns”   Booking Ref Property Room Unit Full Name First Night Check Out Booking Info Specified Columns  ==== '''Example 4''': Airport Transfer Report Daily basis====  1. Create your info codes as explained above. 2. Set up Auto Actions to automatically assign the Info Codes. Go to SETTINGS -> GUEST MANAGEMENT ->AUTO ACTIONS  Trigger tab: Trigger Event = After Booking Trigger Time = Immediate Booking Source = Booking.com (for example) Booking Field Contains: Guest Comment = airport shuttle service ( or any other valid trigger for the airport shuttle) Booking info tab Booking Info Code : AirportTransfer Booking Info Text : [NUMPEOPLE1]  3. Create Custom Report, '''(please note you might need to adjust the Check In From, Check In To, Check Out From, Check Out To" to see in advanced the airport transfer requests).'''   Go to REPORTS - > CUSTOM REPORTS and create a new custom report with these settings: Report Title = Airport Transfer Report Check In From = Any Date Check In To = Today Check Out From = Today Check Out To = Any Date Any Booking Info Code =AirportTransfer  Drag and Drop the columns for the information you want to see from the “Available Columns” to the “Show Columns”   Booking Ref Property Room Unit Full Name First Night Check Out Booking Info Specified Columns  ==== '''Example 5''': List room charges and extras individually tallied or in groups (Work in progress) ==== 1.) Create meaningful names for your charges groups. For example:

upsell item cats<span class="" style="color: #f3e504; font-size: 250%;" >{{#fas:lightbulb}} </span> If you need a report that is not here please let us know, dogs = petswe will attempt to add any reasonable report type.

2'''Custom Reports''' are based on bookings only.) Add these names into Available formats are tables and graphs. You can filter which bookings should be included in the status fields for invoice items or upsell itemsreport and which columns you want to display.