Category:Reports - Revision history

Bjarni Bemar at 09:45, 11 June 2018

2018-06-11T09:45:17Z

← Older revision		Revision as of 09:45, 11 June 2018
Line 38:		Line 38:

	== Custom Reports ==		== Custom Reports ==
	You can create and store custom reports at the menu ~~SETTINGS~~->REPORTS->CUSTOM REPORTS.		You can create and store custom reports at the menu settings->REPORTS->CUSTOM REPORTS.

	1. Create a custom report		1. Create a custom report
Line 54:		Line 54:
	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".		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.		The "Room Template" columns show the content added in BEMAR 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.		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.

Bjarni Bemar at 09:19, 11 June 2018

2018-06-11T09:19:04Z

@@ Line 1: / Line 1: @@
- ''This page is about the menu REPORTS''
+  ''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.
@@ Line 67: / Line 54: @@
 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".
 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.
 [[Category:Reports]]

Bjarni Bemar at 16:27, 13 November 2017

2017-11-13T16:27:13Z

← Older revision		Revision as of 16:27, 13 November 2017
Line 29:		Line 29:
	The system offers a range of standard reports.		The system offers a range of standard reports.

	~~===Revenue Report===~~		Definitions:
			*average over stay: Values are assigned to each months with booked dates by the number of nights in each month
	~~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.~~		*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
	~~When the booking starts and ends~~ in ~~different months~~:		*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
	~~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).~~

	To download and customise standard reports:		To download and customise standard reports:
Line 47:		Line 46:
	4. Change the data as required		4. Change the data as required

	~~===Cleaning and Housekeeping~~ Reports~~===~~		'''Download Standard 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~~		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.
	*The '''Daily Activity Report''' shows only the room but not individual units
	*'''Cleaning report~~'''~~

	== Custom Reports ==		== Custom Reports ==

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

Line 62:		Line 57:
	*Adjust the other criteria		*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.		*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		2. Generate a preset custom report
	*Use the selector to choose a report		*Use the selector to choose a report
	*If required adjust the criteria e.g. dates		*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.		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".		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".


			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.


	[[Category:Reports]]		[[Category:Reports]]

Bjarni Bemar at 16:25, 13 November 2017

2017-11-13T16:25:15Z

← Older revision		Revision as of 16:25, 13 November 2017
Line 9:		Line 9:

	[[File:Gistiskyrsla.png]]		[[File:Gistiskyrsla.png]]



	Hér má lesa nánar um vefskil Hagstofu Íslands https://hagstofa.is/vefskil/ og eins er leiðbeiningarmyndband hér https://www.youtube.com/watch?v=af0eY4e56UY		Hér má lesa nánar um vefskil Hagstofu Íslands https://hagstofa.is/vefskil/ og eins er leiðbeiningarmyndband hér https://www.youtube.com/watch?v=af0eY4e56UY

Bjarni Bemar at 16:24, 13 November 2017

2017-11-13T16:24:51Z

← Older revision		Revision as of 16:24, 13 November 2017
Line 1:		Line 1:
	''This page is about the menu REPORTS''		''This page is about the menu REPORTS''


			'''-IS-'''

			'''Gistiskýrsla Hagstofu Íslands'''

			Til að skila inn Gistiskýrslu til Hagstofu Íslands er fyrst valin viðkomandi mánuður og næst smellt á Country Report, þar eru upplýsingar fyrir Gestakomur og Gistinætur.

			[[File:Gistiskyrsla.png]]



			Hér má lesa nánar um vefskil Hagstofu Íslands https://hagstofa.is/vefskil/ og eins er leiðbeiningarmyndband hér https://www.youtube.com/watch?v=af0eY4e56UY



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

Bjarni Bemar at 10:36, 17 April 2016

2016-04-17T10:36:21Z

← Older revision		Revision as of 10:36, 17 April 2016
Line 58:		Line 58:

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

			[[Category:Reports]]

Bjarni Bemar: Created page with " ''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 o..."

2016-04-17T10:35:19Z

Created page with " ''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 o..."

New page

''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.

===Revenue Report===

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).

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 Activity Report''' shows only the room but not individual units
*'''Cleaning report'''

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