TABLE OF CONTENTS


Ticket reconciliation report

This report allows you to view your total ticket sales based on the POS transactions that have been carried out on each ticket. It should always reconcile with your daily sales reports and will not change sales values when you view data historically. There are countless possibilities for how you can use the report:

  • 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:

  1. Open IBIS Online from the main menu in the top left corner of the IBIS application.
  2. Click Reports, then Reservations, then Ticket Reconciliation
  3. The report will open showing today's date by default. Click the calendar icon to select a different date.
  4. Toggle between List or Table view, as desired.
  5. Choose to display the report figures as Tax exclusive or inclusive.
  6. Click refresh to run the report.
  7. Drag column headers on the report to group and sort information as required. See the related article for how to customise report views.

    Ticket Reconciliation Report


Pax per unit reporting 

You will need to configure the products in your ticketing database with the correct places per unit (ppu) for each pricing option. Places per unit are defined as bums on seats vs total units sold. E.g. A Jet Boat ride has Adult, Child and Photo options available to be booked, but only the adult and child should be counted as a person. Therefore the Adult and Child options will have the PPU set as 1, while the Photo is set to 0.

Editing PPU on a Product Option:

  1. Open the Ticketing screen, and tick the Show All tick box circled below in red.
  2. The PPU column will show and can be edited directly.

    PPU

  3. If you are adding 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.

    add new option

  4. The Ticket reconcilaiton report includes a Pax field so if the PPU is configured correctly in your system, it will allow 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 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?
If you report on all tickets for a date range, user or location, they will match the cash reconciliation 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 then per ticket sold.


What does the ticket # column represent?
In table view, the ticket # field shows the ticket ID when viewed in the table row. If added to the data area, then it shows the number of tickets per day (if viewed over a date range, and multiple payments were made to the same ticket, then these are counted once per day).


Ticket sales report

This report works out sales totals based on the current value of all active tickets. You can pull the report by sale date or by product date by 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.


  1. You can find the Customer Spend report in IBIS Online by clicking Reports, then Reservations. It is found under the Agent sales section.
  2. Select the date range by clicking on the calendar icon, then click Refresh.
  3. The default view shows the average spend by country.
  4. Right-click the Average spend PP column and select Sort country by this column.
  5. Toggle the sort order by average spend lowest to highest, by clicking the arrow on the Country column.


How is average spend calculated for tickets

  • Agents must group tickets together in a customer file.
  • The pax in group must be the actual number of people in the group.
  • The overall value is the total value of ticket. Deposit bookings are grossed up to their full value when the report is generated.
  • The pax in group is divided by value of ticket sales.
  • Retail spend is not included in this report currently.