Orders Report

This article is a high-level overview defining all fields included in this report.

 Note: the event level and account level Orders report share the same report fields.

 Note: the title of this report will display ‘host report’ when downloaded

Date Attending: Date and start time the attendees will be attending the event.
Event Start Time Date: Date when the attendees will be attending the event.
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.
Created at Date: Date the order was created.
First Name: Lead buyer’s first name.
Last Name: Lead buyer’s last name.
Email: Lead buyer’s email address.
Processed By: This field will only be populated if the order is issued via Add an Order or via the
BoxOffice app. It will display the email address of the person who was logged in to Universe and
processed the order.
Ticket Quantity: The total quantity of tickets in an order.
Add-on Quantity: The total quantity of add-ons in an order.
Ticket Types: Name of the ticket type(s) purchased.
Add-on Types: Name of the add-on type(s) purchased.
Option Types: 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).
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.

            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 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.
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.
Gross Sales: total face value of all the tickets and add-ons in the order. This is pulled from the
price entered by the event host in the Price field on the Tickets page.
Discounts: total value of any discounts applied to the order (likely via the application of
discount codes).
Universe Service Charge, Passed to Buyer: Sum of the fees charged by Universe per ticket
and per add-on 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: Sum of the fees charged by Universe per ticket
and per add-on 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 value in ticket sales column).
Ticket Sales (Refunded): If there was a refund issued for any ticket or add-on in the order
(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 for the order (net value of all tickets and add-ons in
the order) 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.
Discount Code Applied: Indicates ticket(s) in this order were purchased with a discount code.
Access Keys Applied: Indicates ticket(s) in this order were purchased with an access key.
Referral Code: Indicates any affiliate tracking codes or UTM trackers being added to the URL
that may have been used to purchase. This highlights purchases made on Ticketmaster or via
Universe emails.
Purchase Channel: Shows if the order was placed via an embedded widget, Add an Order,
BoxOffice app (version and device - Android or iOS).
Purchase Origin: the URL where the checkout widget is embedded, and where the order was
purchased, usually Universe.com or a client’s own website.
Listing Name: Name of the event listing.
Listing URL: Web address of the event listing.
Purchase Device: This column will only populate if a ticket/order is purchased via the Universe
BoxOffice app, and it will show the team mate name given to the device.
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