Extracts Reports
Reports in the Extracts menu extract data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Ticket Sales
Extracts > Ticket Sales
Selections:
- Sales date range
- Browse for location to save CSV file
This report summarises ticket sales for each production and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Fields included are:
- Venue
- Production start date
- Production ID
- Title
- Paid value
- Paid count
- Complementary count
- Unpaid value
- Unpaid count
Account Code Payments
Extracts > Account Code Payments
Selections:
- Sales date range
- Browse for location to save CSV file
This report extracts information about payments for tickets and products and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Fields included are:
- Sale ID
- User ID
- Payment type
- Production/product type
- Description
- Account code
- Payment date
- Value
- Operator ID
Futures
Extracts > Futures
Selections:
First to derive a list of productions:
- Performance date range
- Departments
- Projects
- Account Codes
- Option to exclude inactive productions
Then, having selected productions:
- Select to display only those performances falling within the performance date range
- Select the date range (specified previously)
- Select the type of date range (Sale Date; Allocation or Payment Date)
- Browse for location to save CSV file
This report summarises production payments falling within a specified date range – whether that be Sale, Payment or Allocation date, and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Fields included are:
- Account code
- Gross
- Net, Sales Tax
- Inside Charges
Project Sales
Extracts > Project Sales
Selections:
- Sales date range
- Project
- Browse for location to save CSV file
This report summarises sales for a specified project and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Data is summarised (Ticket counts only) by date of sale and includes a running total. Additonally there is a DaysOut column which represents the number of days out from the end of the specified date range.
The extract is typically used for graphing and year-on-year festival analysis.