http://co-reception.com/wiki/index.php?action=history&feed=atom&title=Standard-ReportsStandard-Reports - Revision history2026-04-29T03:06:03ZRevision history for this page on the wikiMediaWiki 1.32.0http://co-reception.com/wiki/index.php?title=Standard-Reports&diff=16676&oldid=prevWeins: 1 revision imported2021-05-19T01:33:28Z<p>1 revision imported</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #222; text-align: center;">Revision as of 01:33, 19 May 2021</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>Weinshttp://co-reception.com/wiki/index.php?title=Standard-Reports&diff=16675&oldid=prevBeds24>Annette at 12:36, 16 October 20202020-10-16T12:36:03Z<p></p>
<p><b>New page</b></p><div>[[Category:Settings]]<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 />
== Generate reports ==<br />
<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 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 />
<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 />
<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 />
<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 />
<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>Beds24>Annette