2,912
edits
Changes
Jump to navigation
Jump to search
[[Category:Settings]][[Category:Guests_and_Bookings]]
''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. <div class== 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 Chargeheading" 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'''</div> 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 page is about the menu SETTINGS->REPORTS->CUSTOM REPORTS. 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 Logs''' show the activity on your booking you can use these to show or hide selected bookingspage.
For example, if '''Standard Reports''' are predefined reports for which you use the code "CHECKEDIN" when guests check in can choose a date range and "CHECKEDOUT" when guests check out, you could create a custom reports for what it applies. They can apply to show custom reports by showing booking which include the info code "CHECKEDIN" and excluding those that have the info code "CHECKEDOUT"bookings or rooms.
<embedvideo service="youtube">https://www'''Custom Reports''' are based on bookings only.youtubeAvailable formats are tables and graphs. You can filter which bookings should be included in the report and which columns you want to display.com/watch?v=cY4-NSPNaLo</embedvideo>
Note: There can be problems exporting data '''Routines''' allow to Excel or CSV in some browsers including Internet Explorer/Edge, it works well with Chrome automatically generate reports and Firefoxsend them via E-Mail.
no edit summary
[[Category:Daily_Use]]
<span class="" style="color: #f3e504; font-size: 250%;" >{{#fas:lightbulb}} </span> If you need a report that is not here please let us know, we will attempt to add any reasonable report type.
