How to run a report
To run a report in Little Hotelier:
Click on the Reports tab.
Select one of the 10 report types:
Revenue - read the revenue reports article to learn about the many available options
Check In - who is checking in and out over the selected date range
Payments - payments captured in Little Hotelier for individual credit cards or supported payment gateways
Extras - a breakdown of all the extra items purchased including the category of the extra and the reservation from which the extra was added.
Housekeeping - today's cleaning schedule for your property
Government - tax report for Australia and New Zealand
Statistics - a view to analyse your property's data
Daily Transactions - a summary of payments and reservations
Guests - details of all guests who stayed at your property
Spanish police report - only for properties in Spain. Article available in Spanish: Little Hotelier Front Desk - Hoja de registro para las autoridades policiales
Enter a date range (Date from * and Date to *). Please note: You can generate reports for a maximum of 365 days at a time.
Enter any other fields for that report
Click Run Report
You can export reports as a .CSV file for opening in Microsoft Excel or Apple’s Numbers application by clicking on Export.
You can print reports by clicking on Print at the bottom the report.
For more details on each report scroll down or click on the link to the report above.
Check-in report
The Check In report allows you to view who is checking in and checking out of your property over a selected date range.
Under the Check In section, you can Print Registration Forms for your guests.
Payments report
The payments report allows you to view payments captured in Little Hotelier for your selected date range. Information is available on individual credit cards and any other supported payment types.
You can select individual or all Transaction Type, Payment Type or Card Type
The Payments Report includes Date, Time, User, Reservation Number, Guest Name, Payment Gateway, Transaction Type, Payment Type, Card Type, Description, Total
Extras report
The Extras report provides you with a breakdown of all the extra items purchased within the specified date range. This report includes information like the category of the extra and the reservation from which the extra was added.
Note: This report is not the same as the Revenue Extra report that displays only the total revenue for each extra item.
The report can be run for all or a single Extra Category.
Housekeeping report
The Housekeeping report helps manage the cleaning schedule for your property and can be printed and passed on to the housekeeping staff as required.
When you open the Housekeeping report tab, the report for "Today" is displayed as default, however, by using the buttons at the top, you can also quickly switch to a view of "Tomorrow" or a custom date range - "Select dates". If the custom date range option is selected, the date selection is limited to a period of 7 days, so that the data displayed is easily viewable without a lot of scrolling.
The housekeeping report can be run for up to 4 weeks into the past or the future from the current date.
Cleaning Status
For each room the cleaning status will be blank initially, and you can manually set it to one of the following: Cleaned, Uncleaned or Skip Cleaning.
You can choose to only see rooms with a certain cleaning status in your report by using the drop down menu under "Show rooms with: Cleaning status". If you don't select a specific status, all rooms will be visible.
Room Number and Room Type
For each day, the rooms will be listed in alphabetical order according to the name of the physical room (under "Room Number" although this might not be a number). For each room, the Room Type is also indicated in the report right after the room name.
Room Status
The Room Status will show as one of the following:
Unoccupied: no reservation for this room on the night of the chosen date, nor the night prior
Check out only: there was a reservation for this room on the night prior to the chosen date, so the guests are checking out today, but there is no reservation for guests staying on the night of the chosen date
Check in only: there is a reservation for guests staying on the night of the chosen date, they are checking in on that day and there was no reservation for the night prior to the chosen date
Check out/in: there is a reservation for guests staying on the night of the chosen date, they are checking in on that day and there was a different reservation for the night prior to the chosen date, so those guests will be checking out today
Occupied - (number): there is a reservation for guests staying on the night of the chosen date, and they have been staying in the room already for the number of nights indicated. For example if the status shows up as "Occupied - (2)" it means that the guests have already spent 2 nights at the hotel and they are also staying for one more night (or more)
You can choose to only see rooms with a certain room status in your report by using the drop down menu under "Show rooms with: Room status". If you don't select a specific status, all rooms will be visible.
Guests
The types of guests will show as numbers beside icons. A bust of a person for adults, a smaller icon of a full person for children and a baby stroller for infants.
Room Notes
Make work easier for yourself and your Housekeeping staff by leaving notes about any room for a chosen date by clicking on Add Note and a previously added note can be edited at any time by clicking on Edit next to the note.
Print Report
You can print the report with the "Print Report" button. The report printed will be a direct reflection of the data shown on the page, which means if there are filters applied, the data on the printed report will also be filtered.
Printing a report provides flexibility to your Housekeeping staff without having to log into the system.
If you leave the Cleaning Status blank for all rooms, the housekeeping staff can write the current status on the printed page while going through the rooms, but it is advised to also input the status of the rooms in the system afterwards.
Government report
The Government report can be generated for properties in Australia and New Zealand to meet tax requirements.
You need to enter the following required fields to generate the report:
Total single bed - enter the total number of single beds owned
Total double bed - enter the total number of double beds owned
Total full time - enter the number of full-time employees
Total part time - enter the number of part-time employees
Total casual - enter the number of casual employees
There are different fields for Australian and New Zealand based properties.
Statistics report
You can generate a statistics report in Little Hotelier to view and analyse your property's data.
You need to Search By Stay Date or Booked-on but there is no date limit when running this report.
The Statistics Report will be generated with the following data for your selected date range:
Please note: Should a reservation appear in the unallocated section on the calendar, these will not be counted towards any room night report item or average occupancy but will count towards the other report items.
* this item is only available when Stay Date is selected.
Report item | Description / Calculation |
*Total room nights | The number of rooms multiplied by the number of nights in a specific period. |
*Closed room nights | Number of nights with a room closure. |
Occupied room nights | Number of nights with reservations. |
*Unoccupied Room Nights | Number of nights with no reservations. |
*Average occupancy | The percentage of available rooms occupied. |
Average length of stay | The average length of time that the guests stay at your property for the selected date range. |
Average lead time | On average how many days in advance your rooms booked before the check-in date |
Average revenue per booking | The average revenue generated per booking. |
*Revenue per available room (RevPar) | The daily room revenue generated per available room. Room closures are excluded from the calculation. |
Average Daily Rate (ADR) | The average price paid per room. |
Cancelled reservation | Total value of all cancelled reservations. |
Daily transaction report
The Daily Transactions report consists of :
Payment Summary - total payments captured in Little Hotelier for a selected date range, broken down into different payment types (cash, credit card, payment gateway etc).
Reservation Summary - details of your property's reservations
Checked in - How many check ins have taken place
Checked out - How many check outs have taken place
Cancellations - How many cancellations have occurred
Check In Pending - How many check ins are pending
Check Out Pending - How many check outs are pending
Guests report
The Guests Report allows you to view the details of all guests who stayed at your property for your selected date.
The Guests Report includes Check-in date, Check-out date, First name, Last name, Email and Phone number for the Guests staying at your property during the date range selected.