This article is a high-level overview defining all fields included in this report.
Note: the event level and account level Add-ons report share the same report fields.
Add-on ID: Unique alphanumeric code assigned to each add-on issued by Universe. Each add-
on in an order will be assigned a unique Add-on ID.
Order ID: Unique alphanumeric code assigned to each order issued by Universe. Each order
can contain many individual tickets and add-ons.
Date of Order: Date (YYYY-MM-DD) and time that the order was created.
Created at Date: Date (YYYY-MM-DD) that the order was created.
Date Attending: Date (YYYY-MM-DD) and time of the event or timeslot’s start time.
Event Start Time Date: Date (YYYY-MM-DD) of the event or timeslot’s start time.
First Name: Add-on holder’s first name.
Last Name: Add-on holder’s last name.
Email: Add-on holder’s email.
Add-on Type(s): Name of the add-on purchased.
Option Type(s): Name of the add-on option purchased. This will only display if you have added
options to any of your add-ons (i.e., t-shirt sizes).
SKU: Stock keeping unit number. This will only display if that field has been inputted on the
add-on creation.
Listing Name: This is the title of the 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 add-on 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 of any discounts used.
Universe Service Charge, Passed to Buyer: Total Universe service charge that has been
passed to the buyer in the ticket price.
Universe Service Charge, Included in Price: Total Universe service charge that has been
absorbed into the ticket price.
Tax on Universe Service Charge, Passed to Buyer: Total tax on the Universe service charge
that has been passed to the buyer in the ticket price.
Tax on Universe Service Charge, Included in Price: Total Tax on the Universe service
charge that has been absorbed into the ticket price.
Ticket Sales (Refunded): If there was a refund issued for the add-on (partial or full), this will
display the dollar amount that was refunded from the add-on 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.
Tax on Universe Service Charge, Passed to Buyer (Refunded): If there was a refund issued
for the tax charged on the Universe service fee, and fees were passed to customers, this will
display the dollar amount that was refunded.
Tax on Universe Service Charge, Included in Price (Refunded): If there was a refund issued
for the tax charged on the Universe service fee, and fees were absorbed, this will display the
dollar amount that was refunded.
Net Earnings: The event host’s earnings on this add-on 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.
Refunded At: This is the date and time of when the add-on was refunded.
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