Difference between revisions of "Category:Reports"

From Beds24 Wiki
Jump to navigation Jump to search
 
(72 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Category:Settings]]
+
 
[[Category:Guests_and_Bookings]]
 
 
[[Category:Daily_Use]]
 
[[Category:Daily_Use]]
''This page is about the menu REPORTS''
+
<div class="heading">Reports</div>
__TOC__
+
  This page is about the menu REPORTS
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.
 
 
 
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
 
 
 
===Cleaning and Housekeeping Reports===
 
There are several reports which are designed to manage cleaning and housekeeping.
 
 
 
*The '''Daily Unit Activity Report''' includes the unit status set in the CALENDAR
 
*The '''Daily Unit Notes''' includes the unit status and the notes for the unit set in the CALENDAR
 
*The '''Daily Activity Report''' shows only the room but not individual units
 
*'''Cleaning report'''
 
 
 
===Occupancy and Room Nights===
 
*Daily occupancy: Shows arrivals, departures, occupied rooms (stay-throuhgs), booked rooms (room nights), available rooms and occupancy for the selected period.
 
*Occupancy: Shows the occupancy per month and in total for the selected period.
 
 
 
===Revenue Reports===
 
 
 
The revenue report uses the value entered in the price field of each booking. If a booking begins and ends in different months the average daily price of the booking for each day is assigned to each month total.
 
 
 
When the booking starts and ends in different months:
 
 
 
The price of the booking can be assigned to the check-in month (booked at check-in date), the check-out month (booked at check-out date) or assigned to both months by the number of nights in each month (averaged over stay).
 
 
 
===Invoice Reports===
 
*Invoices: All invoices in the selected period.
 
*Monthly Invoice Revenue report: Show the invoice value per room.
 
 
 
===Payments===
 
All payments in the selected period.
 
 
 
===Country Report===
 
This report will show booking data by origin of guests.
 
 
 
== Custom Reports ==
 
You can create and store custom reports at 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 you can use these  to show or hide selected bookings.
+
'''Booking Logs''' show the activity on your booking page.  
  
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".
+
'''Standard Reports''' are predefined reports for which you can choose a date range and for what it applies. They can apply to bookings or rooms.  
  
 +
<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.
  
<embedvideo service="youtube">https://www.youtube.com/watch?v=cY4-NSPNaLo</embedvideo>
+
'''Custom Reports''' are based on bookings only. Available formats are tables and graphs. You can filter which bookings should be included in the report and which columns you want to display.
  
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.
+
'''Routines''' allow to automatically generate reports and send them via E-Mail.

Latest revision as of 09:32, 12 April 2022

Reports
This page is about the menu REPORTS

Booking Logs show the activity on your booking page.

Standard Reports are predefined reports for which you can choose a date range and for what it applies. They can apply to bookings or rooms.

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

Custom Reports are based on bookings only. Available formats are tables and graphs. You can filter which bookings should be included in the report and which columns you want to display.

Routines allow to automatically generate reports and send them via E-Mail.

Pages in category "Reports"

The following 7 pages are in this category, out of 7 total. download this selection of articles as a PDF book