The extras revenue report provides a breakdown of your revenue based on your extras sold for a specific date range.
You can run this report by going to Reports > Revenue > Extras.
This report is not the same as the extras report found in Reports > Extras. The extras report gives you all extra items including the reservation from which the extra was added, whereas the extra revenue report gives you just revenue information about those extra items.
How do I run an extras revenue report?
To run an extras revenue report:
Go to the Reports page. This will take you straight to the Revenue reports section.
Click on the Extras tab.
Select the date type for the report by clicking on Search by :
Stay date: date range your guests stayed at your property.Booked-on: date range your guests booked their reservations.
Enter a date range ( mandatory): select a Date from and a Date to , to indicate the first and last day of the range dates you want to include in this report.
Leave the Revenue includes tax option unticked if you wish to exclude tax in the report. If you tick this option, the tax charged for your extra items will be included in the calculation.
Click on Run report. The report will display the revenue details per extra item for the selected date range.
How do I export this report?
Click on Export at the bottom right. The report will be downloaded as a .csv file you can open in Microsoft Excel, Apple’s Numbers, or any other spreadsheet application.
.csv stands for “comma-separated values”.
Are you having trouble importing the .csv file into .xlsx (Excel format)? You can always search online for "How do I import a .csv file into a .xlsx file?". The Internet should give you some results about any needed steps to follow.
How are the report items calculated?
Find below a list of the items you will see after running this report and how Little Hotelier calculates them:
Extra : name of the extra item.
If you have manually added Other extra items to your reservations, they will appear under the name you gave them.
Revenue: total revenue from each extra item and any extra person (adult, child, infant) charges.
Credit card surcharges are excluded from the calculation.
Quantity: number of extras purchased.
When the report is based on the Stay date , keep in mind that extras that are categorised under Per booking, Per room, and Per person are included on the first night of a reservation. If the first night of the reservation does not fall within the specified date range of the report, then the extra is not accounted for in the report.
Mandatory : indicates if the extra is set up as mandatory when the guest made the booking.
This feature is set up when creating the extra item.