Net Sales Report

Created by Alex Savchuk, Modified on Thu, Oct 30 at 12:53 PM by Vania Viegas

This report shows the revenue from Resevations sales with regards to Room Charges, Incidentals & Fees for a desired date range.

Run this report to understand the performance of your property in terms of revenue, occupancy, and pricing strategy.

The net sales report also helps you understand the demographics of your customers and their buying patterns so that you can craft your marketing campaigns accordingly.


Note: The net sales report does NOT include revenue from the Account Master folios and only shows revenue from Reservations.


This report can be run for an individual property or all properties for a multi-property setup

 

What can I use the Net Sales Report for?

Click on the different uses of the report to jump to the explanation of how to set it up.


The net sales report has many uses, and the most common uses are below:

  • Which OTA/Channels have the maximum sales of reservations.
  • Which day of the week has the maximum sales.
  • Top-selling room classes.
  • Most attractive Rate Plans.
  1. From the Main menu, Click on Reports
  2. Under Performance Reports, click on Net Sales


How to set up this report

Step 1: Select the date range from a list of predefined options or a custom date range


Step 2: Select the inputs for the summary section of the report based on the below options:


a) Group By options for the Summary and Detailed view of the report based on any of the below:

  1. Channel
  2. Corporate/Member Account
  3. Group
  4. Guest Profile Account
  5. Travel Agent
  6. Guest Country
  7. User Booked
  8. Consumption Date
  9. Booking Day
  10. Market Segment
  11. Promo Code
  12. Rate Plan
  13. Referral
  14. Room class
  15. Room number
  16. State
  17. Zip code


b) Sort Report By the specified options to see the summary accordingly

  1. Name
  2. Booking Nights %
  3. Total Revenue
  4. Cancel %
  5. Average Stay
  6. ADR
  7. RevPar


Below is an example of the report grouped by "Channel" and Sorted by "Total Revenue"


Step 3: Customize the detailed View as desired

This groups the Detailed section of the report based on options selected in the drop-down list


Example: If "Week" is selected from the drop-down, then each row in the detailed view represents the week of the year and displays the report data based on reservations staying that week. See example below:



Step 4: Select the "Advanced Inputs" for the report:


a) Booked on date range: Generates the report based on reservations booked on the date range. If you would like to include reservations from all time without any restrictions, then select "All"

b) Include Inactive/Obsolete Rooms: Includes the reservation information booked in rooms that are currently Inactive/Obsolete.

c) Exclude Periods with Zero Sales: When this option is "On", the report displays only the periods where sales have occurred, and the periods with "0" sales are not shown in the detailed view.


Report Output

The report separates data according to the date range's "Group By Option" in the columns below.

NET BOOKINGS: This is the total number of bookings for each "Group By" category for the date range specified.The net bookings are classified into the below:

  • Net Reservations: This is the Total Reservations-Total Cancellations for that day
  • Net Room Nights:
  • Booking Nights %:

NET REVENUE:

PERFORMANCE:


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article