TABLE OF CONTENTS
- Ticket reconciliation report
- Pax per unit reporting
- Ticket reconciliation report FAQ's
- Ticket sales report
- Customer spend report
- How is the average spend calculated for tickets
Ticket reconciliation report
This report provides a view of total ticket sales based on POS transactions processed for each ticket. It always reconciles with daily sales reports and ensures historical data remains unchanged. There are countless ways to utilise this report, including:
- Tickets sold per country of origin or extra info (i.e. marketing data)
- Ticket sales by operator or product
- Ticket sales by category, product region, or product grouping
- Tickets by status or sale type
- Ticket sales by user or location
- Ticket sales by sale date, product date or transaction date
- Show ticket value, commission amount, commission rate, and sale value
You can view the Ticket Reconciliation report in List or Table view. The list view allows you to see the details of each ticket, whereas the table view is perfect for displaying a summary of your ticket sales data. To run the Ticket Reconciliation report:
- Open IBIS Online from the main menu in the top left corner of the IBIS application.
- Click Reports, then Reservations, then Ticket Reconciliation
- The report will open showing today's date by default. Click the calendar icon to select a different date.
- Toggle between List and Table view, as desired.
- Choose to display the report figures as Tax exclusive or inclusive.
- Click refresh to run the report.
- Drag column headers on the report to group and sort information as required. See the related article for how to customise report views.
Pax per unit reporting
You must configure products in your ticketing database with the correct places per unit (PPU) for each pricing option. PPU represents "bums on seats" rather than total units sold. For example, in a Jet Boat ride with Adult, Child, and Photo options, only the Adult and Child count as passengers. Therefore, their PPU is set to 1, while the Photo option is set to 0.
Editing PPU on a Product Option:
- Open the Ticketing screen, and tick the Show All tick box circled below in red.
- The PPU column will show and can be edited directly.
- If you add a new option on the fly, you can specify whether or not to count as a person in the tickbox. If you do not see this option available, contact IBIS Support for help enabling it.
- The Ticket reconciliation report includes a Pax field, so if the PPU is configured correctly in your system, it allows you to report on how many Pax are travelling with you.
Please note the following limitations
The pax figures will always display the current pax regardless of when the Ticket Reconciliation report is run. This means if a ticket is cancelled, the pax will change to 0.
Tickets appear each time there is a new POS transaction on the Ticket Reconcilation report. This means pax counts will doubled in this circumstance. You can avoid issues by creating a new ticket for any additional pax you wish to add, instead of editing an existing ticket.
Ticket reconciliation report FAQ's
Why don't referrals show on the Ticket Reconciliation report?
A ticket at status "referral" will only show on the Ticket Reconciliation report once it has been confirmed. A confirmed referral ticket shows the ticket value in the Value column and $0 in the Sale column.
Cancelled and refunded tickets
When a paid ticket is cancelled and refunded, the ticket will appear twice on the Ticket Reconciliation report. This is because the report is based on the transaction date, and there are 2 separate transactions for this ticket. See below for an example.
Why is the ticket value different from the ticket sale value?
The value is the amount the ticket is worth. The sale is the amount of each transaction processed on the ticket. If the sale type is deposit, the value will show as the full ticket value, whereas the sale will only show the amount taken at Point of Sale.
Will the Ticket Reconciliation match the cash reconciliation report?
Reporting on all tickets for a date range, user, or location will align with the Sales report for the same criteria—no adjustments needed!
What are the percentage commission totals?
Percentage commission totals are your average commission percentage per POS transaction rather than per ticket sold.
What does the ticket # column represent?
In the table view, the Ticket # field displays the ticket ID within each row. When added to the data area, it shows the number of tickets per day. If viewed over a date range, tickets with multiple payments are counted once per day.
Ticket sales report
This report calculates sales totals based on the current value of all active tickets. Users can generate the report by sale date or product date using the drop-down menu next to the date selector.
This report can change historically if tickets are edited and cancelled as the data always shows the current value.
Customer spend report
The Customer spend report was designed for Information Centres to give you an average spend and overall spend per pax across a specified date range. The report can be run in Table (default) or List view.
The Customer spend report will only work for agents using the Customer Ticket screen to capture all tickets in a group.
- You can find the Customer Spend report in IBIS Online by clicking Reports, then Reservations. It is found under the Agent sales section.
- Select the date range by clicking on the calendar icon, then click Refresh.
- The default view shows the average spend by country.
- Right-click the Average spend PP column and select Sort country by this column.
- Toggle the sort order by average spend lowest to highest, by clicking the arrow on the Country column.
How is the average spend calculated for tickets
Agents must group tickets within a customer file.
The number of passengers (pax) in the group must reflect the actual number of people in the booking.
The total value represents the full ticket price. Deposit bookings are adjusted to their full value when the report is generated.
The pax count is divided by the total ticket sales value.
Retail spend is not currently included in this report.