https://wiki.test.visitgroup.com/index.php?action=history&feed=atom&title=Standard-ReportsStandard-Reports - Revision history2026-10-26T11:13:32ZRevision history for this page on the wikiMediaWiki 1.41.1https://wiki.test.visitgroup.com/index.php?title=Standard-Reports&diff=2277&oldid=prevAdmin at 13:48, 22 July 20242024-07-22T13:48:32Z<p></p>
<p><b>New page</b></p><div><br />
[[Category:Daily_Use]]<br />
[[Category:Reports]]<br />
<div class="heading">Standard Reports</div><br />
This page is about the menu REPORTS > STANDARD REPORTS<br />
__TOC__<br />
=Summary=<br />
<div class="summarybox"><br />
Standard reports are preset reports which are available across all properties, groups of properties or individual properties. <br />
<br />
Standard reports can be exported to Excel or .csv and send automatically via Email using the "Routines" function. <br />
<br />
You also have the option to create your own custom reports in REPORTS > CUSTOM REPORTS<br />
</div><br />
<br />
= How to generate reports =<br />
If you have more than one property you can select whether you want to run a report for one property or for all. <br />
<br />
After you have selected the time period and which bookings you want to include in the report click on one of the report buttons to generate the report.<br />
<br />
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.<br />
<br />
The rooms parameter can contain one room id or a comma separated list of room id's<br />
<br />
For example adding '''&rooms=1000,1001''' to the reports URL will cause the report to show only room id's 1000 and 1001.<br />
<br />
Definitions:<br />
*average over stay: Values are assigned to each months with booked dates by the number of nights in each month<br />
*by check-in date: Value of all bookings for which the check-in date falls into the selected period<br />
*by check-out date: Value of all bookings for which the check-out date falls into the selected period<br />
*by booking date: Value of all bookings for which the booking date date falls into the selected period<br />
*Invoice charges: Values from the "Total Charge" field in the "Charge and Payments" tab of the booking<br />
*Revenue: Values from the "Price" field in the "Charge and Payments" tab of the booking<br />
<br />
'''Monthly Room Charges''' - This will report the Room only Charges for bookings in a selected period. <br />
<br />
'''Monthly Extra Charges''' - This will report ALL Extra Charges for bookings in a selected period. <br />
<br />
'''Daily Financial Summary''' - Financial information per day<br />
*Room Revenue = Charges without extras (lodging only)<br />
*Daily Revenue = Charges including all extras<br />
*Average Daily Revenue = Daily Revenue ./. Number of booked nights<br />
*Revenue per Available Room = Daily Revenue ./. Rooms open for sale <br />
*Revenue per Guest = Daily Revenue ./. Guests<br />
<br />
<span class="" style="color: #f3e504; font-size: 150%;" >{{#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.<br />
<br />
== Bedding Report==<br />
'''Step 1''': Go to {{#fas:cog}} (SETTINGS) ACCOUNT > PREFERENCES and add Info Codes for the bed types you have the Info Codes have to start with BED_ Examples:<br />
<br />
BED_DOUBLE<br />
<br />
BED_TWIN<br />
<br />
BED_SINGLE<br />
<br />
<br />
'''Step 2''': Add the applicable Info Code on the "Info" tab of the booking. <br />
<br />
'''Step 3''': Generate a "Group Arrivals" report<br />
<br />
== Export standard report to Excel ==<br />
<br />
1. Generate the report. The report will open in a new browser tab.<br />
<br />
2. Select "Save As" in your browser. The report will be saved to your computer as something like 'report.html'.<br />
<br />
3. Go to the saved file and open it with Excel</div>Admin