This article is a high-level overview defining all fields included in this report.
Note: the event level and account level Tickets report share the same report fields.
Note: the title of this report will display ‘cost items report’ when downloaded.
Ticket ID: Unique alphanumeric code assigned to each ticket issued by Universe. Each ticket in
an order will be assigned a unique Ticket ID.
Order ID: Unique alphanumeric code assigned to each order issued by Universe. Each ticket in
an order will be assigned a unique Ticket ID.
Date of Order: Date and time the order (transaction) was processed.
Date Attending: Start date and time of the event.
First Name: Ticket holder’s first name – note: if first/last name/email were turned off “per ticket”,
it will default to the lead buyer’s information.
Last Name: Ticket holder’s last name.
Email: Ticket holder’s email address.
Ticket Type(s): Name of the ticket type purchased.
Listing Name: Name of the event listing.
Order Status: status of the order, will display one of the following:
Paid: order has been purchased, event has not ended. Universe is holding the money (funds are in upcoming balance) - only see this if on Universe Payments.
Ended: event has ended, but 48hrs has not yet passed. Universe is holding the money (funds are in upcoming balance) - only see this if on Universe Payments.
Closed: event has ended AND 48 hrs have passed. The funds have been added to the users available balance and can be withdrawn (if on Universe Payments). The order will remain in a closed state from there on.
Closed (If processing payments via Stripe Connect): an order has been purchased. The funds have been sent to the event host’s connected Stripe account and can be withdrawn. This happens as soon as the payment is complete. Note: Stripe Connect orders and tickets should always show as closed, not as paid.
Disputed: the order has been disputed by the buyer. Dispute is not yet resolved.
Partially paid: indicates a payment plan, or payment via an asynchronous payment method (such as SOFORT, iDEAL, etc.) - will transition to paid or closed.
Ticket Status: status of the specific ticket within the order, will display one of the following:
Paid: ticket has been purchased, event has not ended. Universe is holding the money (funds are in upcoming balance) - only see this if on Universe Payments.
Ended: event has ended, but 48hrs has not yet passed. Universe is holding the money (funds are in upcoming balance) - only see this if on Universe Payments.
Closed: event has ended AND 48 hrs have passed. The funds have been added to the users available balance and can be withdrawn (if on Universe Payments). The order will remain in a closed state from there on.
Closed (If processing payments via Stripe Connect): a ticket has been purchased. The funds have been sent to the event host’s connected Stripe account and can be withdrawn. This happens as soon as the payment is complete. Note: Stripe Connect tickets should always show as closed, not as paid.
Upgraded: this specific ticket has been upgraded.
Transferred: this specific ticket has been transferred.
Partially paid: indicates a payment plan, or payment via an asynchronous payment method (such as SOFORT, iDEAL, etc.) - will transition to paid or closed.
Payment Processor: Name of the payment processor used. This will be Universe Payments (if
using Universe as your payment processor), Stripe Connect (if using Stripe), Offline Payment
(for any cash payments, or any other payments done through 3rd party card readers, like
Square) or Channel Partner (for any distributed commerce orders).
Payment Type: This will display details about the payment method, showing offline payments
(this can include cash payments, but can also include any payments completed through third
party card readers like Square), card payments, or any other payments done with alternate
payment methods (Paypal, Sofort, etc).
Payment Type Details: if this transaction was processed via the Add an Order page, this will
designate if it was a COMP or payment method OTHER. It will also pull in any notes added to the
transaction on Add an Order. If orders are being processed via the BoxOffice app, it will specify if with a card reader and the type of card reader used, payment via cash, and also the type of device used to
operate BoxOffice as well (IOS or Android). (examples: ios_square_reader / android_square_reader /
ios_third_party_reader / android_third_party_reader / ios_cash / android_cash).
Last 4 Digits: Last 4 digits of the card used for payment (if paid by credit/debit card).
Card Brand: Brand of the card used for payment (i.e., Visa, Mastercard)
Partially Refunded: Displays as True or False, and will tell you whether a partial amount has
been refunded. This will only display as True if the ticket has a partial refund, but is not
cancelled.
Fully Refunded: Displays as True or False, and will tell you if a refund has been issued in full.
In order for this to display False, the ticket must not be cancelled.
Do Not Sell Information: The value will display as true if a user has submitted a request
through our privacy page to not sell or share their personal information. The default value will
display as FALSE if the user has not submitted a request.
Listing URL: This is the URL of the Universe event display page.
Ticket Sales: This will display the ticket price (excluding tax or additional fees).
Discounts: This will display the dollar amount that was discounted from the ticket if a discount
code was used.
Universe service charge, passed to buyer: Fee charged by Universe per ticket to use the
platform. Includes processing fee if opting to use Universe Payments. This column will populate
if the event host has chosen to pass fees to the customer.
Universe service charge, included in price: Fee charged by Universe per ticket to use the
platform. Includes processing fee if opting to use Universe Payments. This column will populate
if the event host has chosen to absorb fees (it will appear as a negative value and subtract off of
the value in the ticket sales column).
Ticket sales (refunded): If there was a refund issued for the ticket (partial or full), this will
display the dollar amount that was refunded from the ticket price.
Discounts (refunded): If there was a refund issued for the discount, this will display the dollar
amount that was refunded from the discount.
Universe service charge, passed to buyer (refunded): If there was a refund issued for the
Universe service fee, and fees were passed to customers, this will display the dollar amount that
was refunded.
Universe service charge, included in price (refunded): If there was a refund issued for the
Universe service fee, and fees were absorbed, this will display the dollar amount that was
refunded.
Net Earnings: The event host’s earnings after deducting any discounts, partial refunds, and
Universe service fees. This number will include any host added taxes and additional fees. If the
event host opts to use Stripe Connect for payment processing, Stripe’s processing fees are not
factored into this net earning number. They will be further subtracted on Stripe’s own reporting.
Settlement Currency: This is the currency used to settle the order. The event host receives
funds in this currency.
Access Keys Applied: This is the access key used to purchase a locked ticket on your event.
Discount Code Applied: This is the discount code used for the order purchase.
QR Code: This is the unique QR code used for the ticket confirmation email as well as the PDF
ticket.
Upgraded To: This displays the ticket ID of the new upgraded ticket. There will be a new line
item created in the report for the upgraded ticket.
Refunded At: This is the date and time of when the ticket was refunded.
Channel Partner: This is the name of the channel partner used if the ticket is purchased
through our Distributed Commerce channels.
Channel Partner Reseller: This is the name of the specific reseller used if the ticket is
purchased through our Distributed Commerce channels. This will often be the same value as
the channel partner column.
Note: Checkout Questions will appear as their own column headers (i.e., Country, Phone
Number, or any custom questions you may have added)
Note: Any additional fees or taxes that you have added will also show up on this report and will
appear on their respective column headers