Standard-Reports

From Beds24 Wiki
Revision as of 19:08, 20 March 2020 by Annette (talk | contribs)
Jump to navigation Jump to search
This page is about the menu REPORTS->STANDARD REPORTS

1 Generate reports

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.


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 selected period
  • booked at check-out date: Value of all bookings for which the check-out date falls into the selected period
  • 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


  • Monthly Room Charges - This will report the Room only Charges for bookings in a selected period.
  • Monthly Extra Charges - This will report ALL Extra Charges for bookings in a selected period.

If you need a report that is not here please let us know, we will attempt to add any reasonable report type.

2 Export standard report to Excel

1. Generate the report. The report will open in a new browser tab.

2. Select "Save As" in your browser. The report will be saved to your computer as something like 'report.html'.

3. Go to the saved file and open it with Excel