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 visible if using Universe Payments.
Ended: Event has ended, but 48 hours have not yet passed. Universe is holding the money (funds are in upcoming balance). Only visible if using Universe Payments.
Closed: Event has ended and 48 hours have passed. The funds have been added to the user’s 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.
Cancelled: All tickets in the order have been cancelled.
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 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 visible if using Universe Payments.
Ended: Event has ended, but 48 hours have not yet passed. Universe is holding the money (funds are in upcoming balance). Only visible if using Universe Payments.
Closed: Event has ended and 48 hours have passed. The funds have been added to the user’s 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.
Cancelled: This specific ticket has been cancelled.
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 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 other payments through third-party card readers like Square), or Channel Partner (for distributed commerce orders).
Payment Type: Displays details about the payment method, showing offline payments (including cash or third-party card reader payments like Square), card payments, or other alternate payment methods (e.g., PayPal).
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 processed via the BoxOffice app, it will specify if with a card reader and the type of card reader used, payment via cash, and the type of device used (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 tells you whether a partial amount has been refunded. Displays as True only if the ticket has a partial refund but is not cancelled.
Fully Refunded: Displays as True or False, and tells you if a refund has been issued in full. For this to display False, the add-on must not be cancelled.
Do Not Sell Information: Displays as True if a user has submitted a request through our privacy page to not sell or share their personal information. The default value displays as False if the user has not submitted a request.
Listing URL: URL of the Universe event display page.
Ticket Sales: Displays the ticket price (excluding tax or additional fees).
Discounts: Displays the dollar amount of any discounts used.
Universe Service Charge, Passed to Buyer: Total Universe service charge passed to the buyer in the ticket price.
Universe Service Charge, Included in Price: Total Universe service charge absorbed into the ticket price.
Tax on Universe Service Charge, Passed to Buyer: Total tax on the Universe service charge passed to the buyer.
Tax on Universe Service Charge, Included in Price: Total tax on the Universe service charge absorbed into the ticket price.
Ticket Sales (Refunded): Displays the dollar amount refunded from the add-on price (partial or full).
Discounts (Refunded): Displays the dollar amount refunded from the discount.
Universe Service Charge, Passed to Buyer (Refunded): Displays the refunded dollar amount of the Universe service fee (if fees were passed to customers).
Universe Service Charge, Included in Price (Refunded): Displays the refunded dollar amount of the Universe service fee (if fees were absorbed).
Tax on Universe Service Charge, Passed to Buyer (Refunded): Displays the refunded dollar amount of tax on the Universe service fee (if fees were passed to customers).
Tax on Universe Service Charge, Included in Price (Refunded): Displays the refunded dollar amount of tax on the Universe service fee (if fees were absorbed).
Net Earnings: The event host’s earnings on this add-on after deducting discounts, partial refunds, and Universe service fees. This number includes any host-added taxes and additional fees. If the event host uses Stripe Connect for payment processing, Stripe’s processing fees are not factored into this number and are deducted on Stripe’s own reporting.
Settlement Currency: The currency used to settle the order. The event host receives funds in this currency.
Access Keys Applied: The access key used to purchase a locked ticket on your event.
Discount Code Applied: The discount code used for the order purchase.
QR Code: The unique QR code used for the ticket confirmation email and PDF ticket.
Refunded At: The date and time when the add-on was refunded.
Note: Checkout Questions will appear as their own column headers (e.g., Country, Phone Number, or any custom questions you have added).
Note: Any additional fees or taxes added will also appear in this report under their respective column headers.