Where do I find it?
Reporting > Operational Reports > Daily Sales Report
What does it mean?
The Daily Sales Report gives you a quick overview of revenue from direct sales, indirect sales and third-party products.
Each day’s figures are compared with two benchmarks: the same date in the previous year and the forecast for that date. For these comparisons to work, last year’s data must already be loaded into Palisis and a forecast must be uploaded.
The report is sent automatically by email to the configured recipients every night at around 2.00 am. It includes the revenue from the previous day, so the report builds up incrementally: a new day is added each morning.
Important: Unredeemed vouchers are not included in this report.
Below is an example of a Daily Sales Report.
Here is what each section means:
DATE — The date of the sales.
PASSENGER — The number of passengers, based on check-ins:
TOTAL — Total passengers on that date.
FCST — Forecasted number of passengers.
Prev. Y — Passengers on the same date last year.
DEV. % — Percentage deviation from the forecast.
GROSS SALES — Gross revenue, excluding unredeemed vouchers:
TOTAL — Total gross revenue on that date.
FCST — Forecasted gross revenue.
Prev. Y — Gross revenue on the same date last year.
DEV. % — Percentage deviation from the forecast.
NET DIRECT SALE — Revenue from direct sales.
NET INDIRECT SALE — Revenue from redeemed vouchers, excluding agent commissions.
REVENUE PRODUCTS — Revenue generated by products:
TOTAL — Total product revenue on that date.
FCST — Forecasted product revenue.
Prev. Y — Product revenue on the same date last year.
REVENUE – 3rd PARTY — Commission earned from third-party supplier sales.
REVENUE (Gross Sales – Commissions) — The sum of Gross Sales, Net Direct Sale, Net Indirect Sale, Revenue Products and Revenue 3rd Party.
Net Average Ticket — The average ticket price, calculated as (Net Direct Sales + Net Indirect Sales) ÷ Passengers.
At the bottom of the report, you will also see:
TOTAL MTD — Month-to-date total, from the 1st of the month to the current date.
TOTAL YTD — Year-to-date total, from 1 January to the current date.
What should I do?
If you are interested in this report, please contact your Customer Success Manager or reach out to our support team.
Once our team confirms that the report has been enabled for your account, you can activate and configure it by going to Reporting > Operational Report > Daily Sales Report. Switch on the Active toggle, enter the recipients’ email addresses separated by commas, and upload a forecast file.
The next section explains the required format for the forecast CSV file.
Please note: The Daily Sales Report will show blank figures if no forecast has been uploaded.
How to upload the forecast
You have two options:
Manual entry — Enter the figures individually by selecting the date and month (
), then filling in the values for that month (
).CSV upload — Upload a .CSV file containing all the figures for the whole year. This is usually the quicker and simpler option. You can download the forecast upload template at the end of this article.
Important: If you upload the forecast partway through the year, the report will not include forecast values for dates before the upload.
Please make sure every column contains a value. Do not leave any cells empty. If no value is available, enter 0.
What if the previous year figures are not available?
If last year’s data is not yet in the system, please let your Customer Success Manager or our support team know that you would like the previous year’s figures loaded into Palisis. You will need to provide the data using the attached template at the end of this article so we can populate the previous year’s figures in the Daily Sales Report.
Please do not change the time format or make any other changes to the template, as only the supported format can be processed.