The Ticket Sales report displays the number and value of seats sold, returned, and changed by role for a range of performances, roles and sales dates. You can choose whether to display net values (excluding taxes and service charges) or total values (including taxes and service charges).
You can use this report to determine which performances have had admissions fully paid or removed over the course of a sales date range. The breakout of price types is useful for daily sales reporting purposes.
Only those performance service charges charged against the price chart’s model are included in this report.
For a more detailed report, refer to Ticket Sales by Performance.
Ticket Sales Report Criteria
The following table describes this report’s criteria:
| Criteria |
Description |
| Venue |
Enables you to filter the report by one or more venue selections.
To select more than one venue, hold CTRL or SHIFT while making your selections. |
| Series |
Specifies one or more series to include in the report.
Enter the series name and press ENTER or click  to search for the series. For more information, refer to The Find Series Dialog Box. |
| Performance Code |
Enables you to filter the report by a specific performance.
Enter the performance code or click to search for the performance. For more information, refer to The Find Performances Dialog Box. |
| Sales Date Format |
Specifies the date to use for the report:
- Date Range
- Previous 7 Days - This does not include today.
- Today
- Yesterday
This is the date that the item on the order was sold, modified or deleted.
|
| Sales From |
If you are entering a date range, this is the date from which data will be included in the report. This field is enabled for you to enter the time (hh:mm:ss). If you do not enter the time, 00:00:00 is assumed. If you want to the include data from the entire day of the date you select, set the time to 00:00:00.
Any value entered into this field will only apply if Date Range is used.
Enter a date or relative date into the field or click  or  to select the date or relative date.
For more information, refer to Using the Calendar to Select a Date and Using Relative Dates and Times.
The calendar dialog is only enabled to allow you to select the hour and minutes. Once you apply the time selection, you should modify the time to reflect the seconds. |
| Sales To |
If you are entering a date range, this is the date to which data will be included in the report. This field is enabled for you to enter the time (hh:mm:ss). If you do not enter the time, 00:00:00 is assumed. If you want to the include data from the entire day of the date you select, set the time to 23:59:59.
Any value entered into this field will only apply if Date Range is used.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using the Calendar to Select a Date and Using Relative Dates and Times.
The calendar dialog is only enabled to allow you to select the hour and minutes. Once you apply the time selection, you should modify the time to reflect the seconds. |
| Report Output By |
Enables you to group the report data by:
- Performance
- Performance Short Description
- Price Type
- Price Type Group
- Series
- User Name
- User Role Group
- User Role Name
 |
Information
Another option, Agent, is also available. By default it is disabled in the General Configuration application List|Entries page for the reports output by user/role/series/performance/description/promocode/agent list. To use this option, it must first be enabled. |
|
| Report On |
Enables you to report on:
- All Admissions
- Bundle Admissions Only
- Single Admissions Only
|
| Display Values |
Enables you to specify what values to display:
- Net Paid
- Net Paid and Total Paid
- Net Sold and Total Sold: Displays both net values (excluding taxes and service charges) and total values (including taxes and totals). When selecting this option, the report includes separate columns for taxes and service charges.
- Net Sold: Displays net values only (excluding taxes and service charges).
|
Advanced Section
The following criteria is available in the advanced section:
| Criteria |
Description |
| Performance Date Format |
Enables you to filter the report by:
- Advanced Sales: Filters for allocated tickets for performances that occur after today’s date.
- Past Sales: Filters for allocated tickets for performances that have occurred on or before today’s date.
- Performance Range: Filters for performances occurring between the date range entered in the 'Performance From' and 'Performance To' fields.
|
| Performances From |
If you are entering a date range, this is the performance date from which data will be included in the report. Only data relating to performances on or after this date will be included in the report. This date is inclusive.
Any value entered into this field will only apply if the Performance Range date format is used.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using the Calendar to Select a Date and Using Relative Dates and Times. |
| Performances To |
If you are entering a date range, this is the performance date to which data will be included in the report. Only data relating to performances on or before this date will be included in the report. This date is inclusive.
Any value entered into this field will only apply if Performance Range date format is used.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using the Calendar to Select a Date and Using Relative Dates and Times. |
| User Name |
Enables you to filter by the selected users.
Enter the user name and press ENTER or click to search for the user(s). For more information on searching for a user, refer to The Find Users Dialog Box.
This is the user who last updated the order. |
| User Role |
Enables you to filter by the selected user roles.
This is the user who last updated the order.
To select more than one user role, hold CTRL or SHIFT while making your selections. |
| User Role Group |
Enables you to filter by the selected user role groups.
This is the user who last updated the order.
To select more than one user role group, hold CTRL or SHIFT while making your selections. |
| Only Show Performances Without a Producer |
Enables you to filter the report so that only performances that do not have a producer are displayed. |
| Producer |
Enables you to filter by the selected producers.
The report will return data related to the current producer of the performance(s).
To select more than one producer, hold CTRL or SHIFT while making your selections. |
| Report on Opens or Holds |
Enables you to filter the report by:
- Open Seats and Holds:
- If no options are selected from the 'Hold Types' field, open seats and all holds will be returned within the reports results.
- If options are selected from the 'Hold Types' field and Exclude Holds is selected from the 'Include or Exclude Selected Holds' dropdown, open seats and all holds except the selected holds will be returned within the report's results.
- If options are selected from the 'Hold Types' field and Include Holds is selected from the 'Include or Exclude Selected Holds' dropdown, open seats and only the selected holds will be returned within the report's results.
- Open Seats Only: Regardless of the option selected from the 'Include or Exclude Selected Holds' dropdown, or the options selected from the 'Hold Types' field, only open seats will be returned within the report's results.
- Holds Only:
- If no options are selected from the 'Hold Types' field, all of the holds (and only holds) will be returned within the report's results.
- If options are selected from the 'Hold Types' field and Exclude Holds is selected from the 'Include or Exclude Selected Holds' dropdown, all holds except the selected holds will be returned within the report's results.
- If options are selected from the 'Hold Types' field and Include Holds is selected from the 'Include or Exclude Selected Holds' dropdown, only the selected holds will be returned within the report's results.
|
| Include or Exclude Selected Holds |
Enables you to choose whether or not to include the holds selected from the 'Hold Type' field in the report's results:
- Exclude Selected Holds: Excludes all of the options selected from the 'Hold Type' field from the report's results.
- Include Selected Holds: Includes only the options selected from the 'Hold Type' field from the report's results.
|
| Hold Type |
Enables you to filter the report by the selected hold types.
To select more than one hold type, hold CTRL or SHIFT while making your selections. |
| Display Charge Types |
Enables you to further expand the pricing breakdown by adding columns based on the selected charge types:
- Commission
- Service Charge
- Tax
|
Information
Two other options, User Tax1 and User Tax2, are available. By default they are disabled in the General Configuration application List|Entries page for the Service Charge Types list. To configure these options, they must first be enabled. For information on configuring taxes and charges, refer to Product Configuration Charges. |
|
| Display Options |
Enables you to choose the depth of the report that you would like to create:
|
| Promo Code |
Enables you to filter the report based on a promotion.
Enter the promotion and press ENTER or click to search for the promotion. For more information, refer to The Find Promotion Codes Dialog Box. |
Ticket Sales Report Output
The following image illustrates a sample report.
Ticket Sales Results (Net and Total Values Displayed by User Role)
Only those performance service charges charged against the price chart’s model are included in this report.
The following table describes the report’s output:
| Column |
Description |
| Sales |
The total number of tickets sold and the value of those tickets. If you chose to display net and total values, separate columns are included for taxes and service charges. |
| Price Changes |
Displays a count and total for those tickets that had a price type change (for example, an adult ticket modified to a junior ticket) or a ticket’s price manually overwritten.
If a price was overwritten without changing the price type, you will only see a price change, not a count. This is because there was no change to the price type, only to the value. |
| Returns |
Displays a count and total for those tickets that were returned. |
| Net Sales |
A sum of Sales, Price Changes, and Returns. |
| Net Percentages |
The percentage the line item is of the total. For example, the percentage of sold tickets that are 'Adult'. |