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.