Difference between revisions of "Category:Reports"

From Beds24 Wiki
Jump to navigation Jump to search
(19 intermediate revisions by 2 users not shown)
Line 21: Line 21:
 
Definitions:
 
Definitions:
 
*average over stay: Values are assigned to each months with booked dates by the number of nights in each month
 
*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-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 month
+
*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
 
*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
 
*Revenue: Values from the "Price" field in the "Charge and Payments" tab of the booking
  
To download and customise standard reports:
+
=== Export standard report to Excel ===
  
1. Generate the report
+
1. Generate the report. The report will open in a new browser tab.
  
2. Right click on the reports and then "Save As" e.g. report.html
+
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
 
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 ==
 
== Custom Reports ==
Line 68: Line 62:
 
The columns "Property Template" and "Room Template" will show 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.  
 
The columns "Property Template" and "Room Template" will show 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.  
  
 +
===='''Example:''' Create a report in showing a column which is calculated from a value in the booking====
 +
 +
1.  In this example we will calculate 15% from the lodging price. Do do this go to SETTINGS ->PROPERTIES->ROOMS -> SETUP and add  [INVOICEUPSELLNUM0][*]0.15 as "Room Template 1"
 +
 +
2.  Create a custum report:
 +
 +
Drag the columns with the information you want to see from "Available Columns" to "Show Columns" make sure you choose the "Room Template 1" column.
 
=== Specific Custom Reports ===
 
=== Specific Custom Reports ===
 +
==== Specific Custom Reports using Sort By====
 +
 +
===== '''Example ''': Referrer report / Booking source =====
 +
 +
Go to REPORTS - > CUSTOM REPORTS  and create a new custom report with these settings:
 +
 +
Report Title = Referrer Report
 +
 +
Layout = Tabular
 +
 +
Include Totals = Sort By (or Sort By and Report if you want totals across the whole report)
 +
 +
Sort by = Referrer
 +
 +
 +
Drag and Drop the columns for the information you want to see  from the “Available Columns” to the “Show Columns” for example:
 +
 +
Referrer (required)
 +
 +
Quantity (required)
 +
 +
Booking Ref (optional)
 +
 +
Room (optional)
 +
 +
Unit (optional)
 +
 +
Full Name (optional)
 +
 +
First Night (optional)
 +
 +
Check Out (optional)
 +
 +
==== Specific Custom Reports using Info Codes ====
 
You can create specific reports showing only bookings which meet certain criteria.  
 
You can create specific reports showing only bookings which meet certain criteria.  
  
Line 87: Line 122:
  
  
==== '''Example 1''': Daily breakfast report ====  
+
===== '''Example 1''': Daily breakfast report =====  
  
 
1.  Create your info codes as explained above.
 
1.  Create your info codes as explained above.
Line 129: Line 164:
 
Any Booking Info Code =F&B-BB
 
Any Booking Info Code =F&B-BB
  
 +
Layout = Tabular
 
   
 
   
 
Drag and Drop the columns for the information you want to see  from the “Available Columns” to the “Show Columns”  
 
Drag and Drop the columns for the information you want to see  from the “Available Columns” to the “Show Columns”  
Line 150: Line 186:
  
  
==== '''Example 2''': Daily Half Board report ====  
+
===== '''Example 2''': Daily Half Board report =====  
  
 
1.  Create your info codes as explained above.
 
1.  Create your info codes as explained above.
Line 191: Line 227:
  
 
Any Booking Info Code =F&B-HB
 
Any Booking Info Code =F&B-HB
 +
 +
Layout = Tabular
  
 
   
 
   
Line 213: Line 251:
  
  
==== '''Example 3''': Daily Full Board report ====  
+
===== '''Example 3''': Daily Full Board report =====  
  
 
1.  Create your info codes as explained above.
 
1.  Create your info codes as explained above.
Line 254: Line 292:
  
 
Any Booking Info Code =F&B-FB
 
Any Booking Info Code =F&B-FB
 +
 +
Layout = Tabular
  
 
   
 
   
Line 276: Line 316:
  
  
==== '''Example 4''': Airport Transfer Report Daily basis====  
+
===== '''Example 4''': Airport Transfer Report Daily basis=====  
  
 
1.  Create your info codes as explained above.
 
1.  Create your info codes as explained above.
Line 319: Line 359:
  
 
Any Booking Info Code =AirportTransfer
 
Any Booking Info Code =AirportTransfer
 +
 +
Layout = Tabular
  
 
   
 
   
Line 341: Line 383:
  
  
==== '''Example 5''': List room charges and extras individually tallied or in groups (Work in progress) ====
+
===== '''Example 5''': List room charges and extras individually tallied or in groups =====
  
 
1.) Create meaningful identifiers for your charges groups. For example:
 
1.) Create meaningful identifiers for your charges groups. For example:
Line 372: Line 414:
  
 
This creates a column for each of your charges groups with the identifier as the column header and the total amounts at the bottom.
 
This creates a column for each of your charges groups with the identifier as the column header and the total amounts at the bottom.
 +
 +
Note: Bookings that were created before you created the identifiers won't be included in this report unless you manually add the identifier in the booking popup under 'Charges and Payments'
 +
 +
 +
==='''Example:''' Report for tax advisor===
 +
1.) If you require sums for different payment methods, first set up status descriptions for your payment methods under SETTINGS->GUEST MANAGEMENT->INVOICES "Payment Status".
 +
 +
2.) Create a custom report:
 +
*Status = Invoice Number Assigned
 +
then click on SAVE
 +
*Invoice date from / to = the period for which you want to create a report.
 +
*Layout = Tabular 2
 +
*Sort = invoice number
 +
 +
Drag the columns with the information you want to see from "Available Columns" to "Show Columns".
 +
 +
Invoice Number
 +
 +
Invoice Date
 +
 +
Invoice Item Description
 +
 +
Invoice Item Price
 +
 +
Invoice Item Vat
 +
 +
Invoice Item Vat %
 +
 +
Invoice Status Values (if you require sums for different payment methods)
 +
 +
Invoice Payments Value
 +
 +
Invoice VAT by Percantage
 +
 +
==='''Example:''' Report on  pending payments===
 +
Create a custom report:
 +
*Pending Payments = choose which types of bookings you want to include in the report
 +
*Layout = Tabular
 +
*Sort = check-in
 +
 +
Drag the columns with the information you want to see from "Available Columns" to "Show Columns". Make sure you choose the "Pending Payments" columns you want to display.

Revision as of 15:43, 7 May 2019

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.

1 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 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

1.1 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

2 Custom Reports

You can create and store custom reports at the menu SETTINGS->REPORTS->CUSTOM REPORTS.

2.1 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".


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.

2.2 Template variables in Custom Reports

The columns "Property Template" and "Room Template" will show 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.

2.2.1 Example: Create a report in showing a column which is calculated from a value in the booking

1. In this example we will calculate 15% from the lodging price. Do do this go to SETTINGS ->PROPERTIES->ROOMS -> SETUP and add [INVOICEUPSELLNUM0][*]0.15 as "Room Template 1"

2. Create a custum report:

Drag the columns with the information you want to see from "Available Columns" to "Show Columns" make sure you choose the "Room Template 1" column.

2.3 Specific Custom Reports

2.3.1 Specific Custom Reports using Sort By

2.3.1.1 Example : Referrer report / Booking source

Go to REPORTS - > CUSTOM REPORTS and create a new custom report with these settings:

Report Title = Referrer Report

Layout = Tabular

Include Totals = Sort By (or Sort By and Report if you want totals across the whole report)

Sort by = Referrer


Drag and Drop the columns for the information you want to see from the “Available Columns” to the “Show Columns” for example:

Referrer (required)

Quantity (required)

Booking Ref (optional)

Room (optional)

Unit (optional)

Full Name (optional)

First Night (optional)

Check Out (optional)

2.3.2 Specific Custom Reports using Info Codes

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)


2.3.2.1 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 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

Layout = Tabular

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


2.3.2.2 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

Layout = Tabular


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


2.3.2.3 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

Layout = Tabular


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


2.3.2.4 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

Layout = Tabular


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


2.3.2.5 Example 5: List room charges and extras individually tallied or in groups

1.) Create meaningful identifiers for your charges groups. For example:

Room charges, upsell item cleaning = Room

upsell item breakfast = Breakfast

upsell items cats, dogs = Pets.

2.) Insert these identifiers into the status fields for invoice items or upsell items

The status fields are not directly accessible. You have to append the content to the description field with a pipe (|).

Invoice items:

Settings > Guest Management > Invoicing > Invoice Item Room Description: Your description|Your identifier

Upsell items:

Settings > Properties > Upsell Items > Description: Your description|Your identifier

By adding the same identifier to multiple upsell items or invoice items you pool them into a group

3.) Create a custom report. Use the fields that you need and make sure to use the field 'Invoice Status Values'

  • Layout = 'Tabular'
  • Include Totals = 'Report'

This creates a column for each of your charges groups with the identifier as the column header and the total amounts at the bottom.

Note: Bookings that were created before you created the identifiers won't be included in this report unless you manually add the identifier in the booking popup under 'Charges and Payments'


2.4 Example: Report for tax advisor

1.) If you require sums for different payment methods, first set up status descriptions for your payment methods under SETTINGS->GUEST MANAGEMENT->INVOICES "Payment Status".

2.) Create a custom report:

  • Status = Invoice Number Assigned

then click on SAVE

  • Invoice date from / to = the period for which you want to create a report.
  • Layout = Tabular 2
  • Sort = invoice number

Drag the columns with the information you want to see from "Available Columns" to "Show Columns".

Invoice Number

Invoice Date

Invoice Item Description

Invoice Item Price

Invoice Item Vat

Invoice Item Vat %

Invoice Status Values (if you require sums for different payment methods)

Invoice Payments Value

Invoice VAT by Percantage

2.5 Example: Report on pending payments

Create a custom report:

  • Pending Payments = choose which types of bookings you want to include in the report
  • Layout = Tabular
  • Sort = check-in

Drag the columns with the information you want to see from "Available Columns" to "Show Columns". Make sure you choose the "Pending Payments" columns you want to display.

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