How do I read the Ticket Revenue Report CSV download?
Your Ticket Revenue Report will show you your income made on a specific event.
Access your Report
- Under the Box Office header, click EVENTS.
- Click EVENT MANAGER next to the event you wish to view.
- Along the top header bar, click TICKET REVENUE.
- Click REVENUE DETAIL to export the CSV.
This report will scroll left to right, looking like the below.
What Each Column Means
id - each ticket in the BookTix system receives an ID number when the sale is made. This is that number.
order_item_status - This is the status of each ticket - completed means a successful sale, and it might say "exchanged" or "refunded" as well.
order_id - similar to the id of each ticket, each order also receives an id number. This number matches the second half of the confirmation number, or order number.
conf_num - This is the confirmation number, or order number, that the customer receives.
show_name - The name of the event.
show_abv - The abbreviation of the event.
performance_id - The id number assigned to the specific performance/event date.
performance_date - The performance/event date.
unix_date - This records the exact second at which the transaction was placed.
ticket_name - The name of the ticket type that has been purchased.
payment_type - The method of payment (cash or card).
gateway - The payout modality, being either stripe connect, cash, or BookTix gateway (meaning we process the payment through our payment processor, and pay you for the ticket either via check or epayment). "SC" is stripe connect, "ST" is BookTix gateway.
purchased_made - If the purchase was made through the customer portal or through the point of sale tool.
check_number - If the ticket was sold via check, the corresponding check number.
order_item_price - Posted ticket price set in the ticket plan.
order_item_flex_fee - The flex fee you would've added on to the ticket price.
order_item_service_charge - The charge from BookTix.
order_item_discount - If a discount code had been used, this will show the amount of discount applied.
order_item_adjustment - If you manually adjusted the ticket price within the POS tool, this will show that adjustment.
order_item_tax - If you've opted to add tax, this is the amount taken.
order_item_cash_paid - The amount paid in cash for this ticket.
order_item_card_paid - The amount paid via card for this ticket.
order_item_refund_adj_cash - Should be 0; reflects an internal adjustment in the system - if it's not, please let us know!
order_item_refund_adj_card - Should be 0; reflects an internal adjustment in the system - if it's not, please let us know!
order_item_service_credit - Should be 0; reflects an internal adjustment in the system - if it's not, please let us know!
exchange_order_id - If this ticket has been exchanged, it will be associated with a new order number that shows the processing of that exchange. That id number will be here.
refunded_order_id - If this ticket has been refunded, it will be associated with a new order number that shows the processing of that refund. That id number will be here.
created_at - This is the date and time at which this ticket was sold.
Related Articles
Where can I get a revenue report?
Event reports for your event will live within the event, while your Full Revenue Report (ie, all the money coming in and out of your department) will be within the Reports section. To access your event revenue report: Log in to your admin account and ...What reports can I run?
Log in to your administrator portal and access your department. Go to REPORTS to find your report options. In this section, you will find the below reports: Order History -- A chronological, searchable list of orders made to date. Revenue and Payment ...How do I use the Transaction Report Generator?
This tool generates a transaction report sorted by date, with optional filters to customize your report. Log in to your administrator portal, and access your department. In the left menu bar, go to REPORTS > Transaction Report Generator. 3. Select ...