This article is a high-level overview defining all fields included in this report.
Note: the event level and account level Cancellations report share the same report fields.
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 was placed.
Date Attending: Date (YYYY-MM-DD) and time of the event or timeslot’s start time.
First Name: Ticket holder’s first name.
Last Name: Ticket holder’s last name.
Email: Ticket holder’s email address.
Ticket Type(s): Name of the ticket type(s) purchased and subsequently cancelled.
Option Type(s): Name of the add-on option purchased. This will only display if you have added
options to any of your add-on items (i.e., t-shirt sizes).
Listing Name: Name of the event listing.
Order Status: status of the order. On this report, the status will always display ‘Cancelled’.
Ticket Status: status of the specific ticket within the order. On this report, the status will always
display ‘Cancelled’.
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: Web address of the event listing.
Ticket Sales: This will display the ticket price (excluding tax or additional fees).
Discounts: total value of any discounts applied to the order (likely via the application of
discount codes).
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: event host receives funds in this currency.
Access Keys Applied: Indicates ticket(s) in this order were purchased with an access key.
Discount Code Applied: Indicates ticket(s) in this order were purchased with a discount code.
QR Code: Universe generates a QR code for each booked ticket which will be used at the event
to scan the ticket. This alphanumeric code will appear under the QR code on the confirmation
email and PDF.
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 will display the date and time that 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.
Cancelled At: The time the cancellation occurred.
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