ThunderTix logo

Support Forum

Understanding the Settlement Reports - Wed - Jan 18, 2023 - 11:38am

  • We provide two different Settlement Reports: one is available from the Event Manager for each event and includes data across all Dates & Times (performances) across that event.  Then for each Date & Time, we have a Settlement Report dedicated to that particular show time.

    The report can be customized to show only those columns you wish to display. For example, many of our music venues do not wish to share the revenue they retain from ticketing fees, so they elect to remove those from the report. This allows our clients to share the Settlement Report with pertinent revenue with their performers. (See How do I remove fees, shipping, refunds, etc. from the Event Settlement Report?)

    The report is broken into four primary sections. Let's discuss each: 

    Item - sales and revenue data on tickets, products, and other items


    • Total Tickets -  includes the total quantity of tickets sold and the resulting revenue from those sales. Coupons, comps, and discounts reduce the dollar amount shown, so the Total Tickets' Amount column reflects the after discount revenue. The Quantity (QTY) column includes all tickets processed in orders even comps and discounted tickets. Below Total Tickets is a breakdown of ticket types at their full face value and the full value (before discounts) and number of coupons used. 
    • Products - the same as Total Tickets but for any merchandise, concessions, or add-ons to ticket purchases.
      Fees - Any optional fees for tickets or shipping you wish to add to your orders are reflected here by each type include the quantity charged and the total dollar amounts collected. This is your revenue and not shared with ThunderTix.
    • Refunds - Refunds processed for any tickets are shown here. Note that these are already reflected in your Total Tickets and Products and the breakdown by type in those line items. This also includes refunds to a gift card.
      Total Collected - This is the total dollar amount that is delivered to you from your payment gateway (less any applicable fees that Stripe, Square, or your other payment gateway retains). Since money is never sent to ThunderTix, no amount shown in this line item is delivered to ThunderTix by your gateway.
    • Sales Tax - If you charge sales tax on tickets or merchandise, that amount is reflected here.
    • Gross - The Total Collected less the Sales Tax is reflected here.
    • Gift Cards Redeemed - If a gift card was used in the purchase, the amount is displayed here. This is purely informational, and any totals shown in the lines above may have been paid with a gift card.


    Other Details - informational data


    • Orders - The total number of orders processed across the event or individual performance
    • Package Orders - The number of events or performances that were sold as part of a package or season pass
      Blocked Seats - For reserved seating, if you blocked seats from sale due to obstructed view or other factors, the count of seats is included here. 
    • Tickets or Products Exchanged - Each item shows any tickets or products that were exchanged into your performance from another event, or those that were moved to another performance.
    • Open Orders from Reservations - If there are any reservations awaiting payment, they are displayed here. (See How Reservations Work: Reserving tickets or seats for payment at a future date.)
    • Open Reserved Tickets - This is the total count of tickets on reserve from the orders in the line above.
    • Reductions from the Original Price - We sum each type of discount (comps, coupons, etc) as a separate line item. These amounts are already reflected in the Items section at the beginning of the report.
    • Barcodes Scanned - If you are scanning tickets at the door, you will see a count of tickets scanned here. This is important to see how well your staff are monitoring the entrances. (For Dates & Times, we have an individual report of barcodes and the orders to which they belonged under the Reports column.)


    Tickets - count of ticket by type


    • Tickets are processed by the public or by the box office as a logged in user. They may be either sold (or comped) or exchanged. We show the total number of tickets potentially available via the number of available seats or capacity of your venue, those blocked from sale, the resulting available amount for sale, and finally, the total sold.


    Payment Breakdown - details on payments


    • This is a straightforward summary of the total revenue collected, any gift cards redeemed, and any debits or credits from exchanges. The Gross will match the Gross amount in the Items sections at the start of the document. NOTE: the Multiple column includes any payments made in multiple payments. For example, if an order had split payments with part paid in cash and part by card, this amount is reflected here. 

    How Flex Passes are broken out-


    • We don't count flex passes as package tickets sold in the report, because they can be redeemed on any number of shows as desired by your patrons. Since they are not counted in the report, they are not included as revenue. They also won't be counted as revenue at the time the customer redeems their flex pass. Flex Passes are counted as revenue when the package is initially purchased.