Net Sales Report

The Net Sales Report gives a consistent snapshot of your sales, including the net of cancellations/modifications, that occurred during a particular date range. It does not include cancellations/modifications to any items that may have occurred after the specified date range.

To display data for the current day only, use the Same Day Sales Report.

Although the Inntopia System is based on Eastern Standard Time (EST), the Net Sales Report is based on the time zone configured within your CRS Company page or RMS Company page.

About the Report

The data on the report is organized to display the net quantity of items reserved (lodging, activities, rentals, etc.), items cancelled, lodging nights, and the total amount of sales made during the specified period.

Data is further organized into a series of summary reports that display:

Resellers – Sales channels, such as website or call center
Product Category – Lodging, golf, airfare, etc.
Geographical Region – Country and, if applicable, state/province where customers reside
Fulfillment Month – The month in which items are completed (check-in date, or in the case of lift tickets, etc., the month that they are used)
Marketing Source – Sales associated with the different marketing source information that agents obtain from the customer at the beginning of each sales call
Agent – Sales statistics by items Initiated (saved) and Reserved by each agent during the specified sales period

Full details of the reservations, including guest name and address, can easily be downloaded into an Excel spreadsheet and manipulated to extract specific data.

Run the Report

In Inntopia CRS, click the Reports & AR/AP tab. The Reporting, Receivables and Payables page appears.
From the list of reports, click Net Sales. The date selector appears.
In the From and Through fields, enter a date range for the data you want to include in the report. To include Year-To-Date (YTD) numbers on the report, you must enter a date in the YTD From field.
From the Format drop-down list, choose the format of the report: HTML, Excel, or XML.
Click Search. The report appears in the format you selected. Sample reports are shown below.

Show Me Column Descriptions

Net Sales

This section shows the overall net sales information.

Dates – Dates for which the report was generated (applies to each section and field on the report)
Quantity Reserved – Number of itineraries reserved
Quantity Cancelled or Modified – Number of itineraries cancelled or modified
Net Nights – Total number of nights reserved
Net Amount – Total amount of all itineraries (minus taxes and fees)
Net Taxes & Fees – Total amount of taxes and fees collected
Net Total – Total amount of all itineraries (including taxes and fees)

By Sales Channel – All Categories

This section shows combined sales information for all product categories.

Reseller ID – Unique ID number of the reseller
Reseller – Name of the reseller
Quantity Reserved – Number of itineraries reserved for the reseller
Quantity Cancelled or Modified – Number of itineraries cancelled or modified during the period selected for the reseller
Net Nights – Total number of nights reserved
Net Amount – Total amount of all itineraries (minus taxes and fees)
Net Taxes & Fees – Total amount of taxes and fees collected
Net Total – Total amount of all itineraries (including taxes and fees)

By Sales Channel – Lodging Only

This section shows sales information of lodging-only resellers.

Reseller ID – Unique ID number of the reseller
Reseller – Name of the reseller
Quantity Reserved – Number of itineraries reserved for the reseller
Quantity Cancelled or Modified – Number of itineraries cancelled or modified during the period selected for the reseller
Net Nights – Total number of nights reserved
Avg Stay – Average length of stay for all itineraries booked by the reseller during the period
Total People – Total number of people for all itineraries booked by the reseller during the period
Avg Party Size – Average number of people for all itineraries booked by the reseller during the period
Avg Rate – Average rate for all itineraries booked by the reseller during the period
Net Amount – Total amount of all itineraries (minus taxes and fees)
Net Taxes & Fees – Total amount of taxes and fees collected
Net Total – Total amount of all itineraries (including taxes and fees)

By Category

This section breaks up the sales information by each product category of items sold.

Category – Product category of items sold
Quantity Reserved – Number of itineraries booked with products in this category
Quantity Cancelled or Modified – Number of itineraries cancelled or modified during the period selected with products in this category
Net Nights – Total number of nights reserved
Avg Stay – Average length of stay for all itineraries booked with products in this category during the period
Total People – Total number of people for all itineraries booked with products in this category during the period
Avg Party Size – Average number of people for all itineraries booked with products in this category during the period
Avg Rate – Average rate for all itineraries booked with products in this category during the period
Net Amount – Total amount of all itineraries booked with products in this category (minus taxes and fees)
Net Taxes & Fees – Total amount of taxes and fees collected
Net Total – Total amount of all itineraries booked with products in this category (including taxes and fees)

By Guest Address

This section shows sales information related to geographical location.

Guest Address – Country and state/province of the guest
Net Quantity – Total number of itineraries booked for guests with addresses in each country and state/province
Net Lodging Nights – Total number of nights reserved for each guest address
Net Amount – Total amount of all itineraries (minus taxes and fees)
Net Taxes & Fees – Total amount of taxes and fees collected
Net Total – Total amount of all itineraries booked (including taxes and fees)

By Fulfillment Month

This section shows information about the month in which items are completed (check-in date or in the case of lift tickets, etc., the month the item is used).

Fulfillment Month – Month and year of the itinerary arrival date
Net Quantity – Total number of itineraries booked for each month
Net Lodging Nights – Total number of nights reserved for each month
Avg Stay – Average length of stay for all itineraries each month
Total People – Total number of people for all itineraries each month
Avg Party Size – Average number of people for all itineraries each month
Avg Rate – Average rate for all itineraries each month
Net Amount – Total amount of all itineraries (minus taxes and fees)
Net Taxes & Fees – Total amount of taxes and fees collected
Net Total – Total amount of all itineraries booked (including taxes and fees)

By Source

This section shows sales associated with the different marketing source information which agents obtain from the customer at the beginning of each sales call.

Source – Marketing source assigned to the itinerary
Net Qty – Total number of itineraries booked using this marketing source
Net Nights – Total number of nights booked using this marketing source
Net Amount – Total amount of all itineraries (minus taxes and fees)
Net Taxes & Fees – Total amount of taxes and fees collected
Net Total – Total amount of all itineraries booked (including taxes and fees)

By User ID

This section shows sales statistics by items Initiated (saved) and Reserved by each agent.

User ID – User ID of the user that initiated or reserved the itinerary
Name – Name of the user that initiated or reserved the itinerary
Net Qty – Total number of itineraries initiated or reserved by the user
Net Nights – Total number of nights booked by the user
Net Amount – Total amount of all itineraries (minus taxes and fees)