SUMMARY (FIRST SHEET/TAB)

The Sales Report Export contains three sheets. The first one is a summary and breakdown of your sales and refunds for the time frame or events you've selected. This summary include:

The number of sales
The number of refunds
The native fees
The balance refunded
Amount Due

Underneath, you will see a breakdown of your sales and refunds by event, and then ticket type. The layout is the same as the remittance report, and it includes:

Group - If your event was organised by a Club/Society, or any other organisation you've assigned a group to
Finance Code - Your finance code recorded against the ticket type if you assigned one (Nominal Code, Department Code, Cost Centre)
Event and ticket details (Event name, Event ID, Ticket Type)
Transaction Type - Sale, Refund or Payment Plan
Booking fee details - Booking Fee Type (Absorb or Pass on), Booking fee, and Booking fee adjustment if you've topped up the default booking fee
Face Value per sale - The amount paid for the ticket minus the Native fees
Balance Refunded - The total balance refunded for the ticket type
Promo Code Value - If ticket buyers have used a promo code as part of the transaction, the total promo code value is recorded here
Native fees breakdown - Native fees inclusive of VAT, VAT on Native fees, Native fees exclusive of VAT
Amount Due - The amount due to you from all transactions for that ticket type. It includes the face value of the ticket + any booking fee adjustment you've made to our standard booking fee, minus any promo code applied. It is net of our fees.

SALES (SECOND SHEET/TAB)

Purchase ID
Event details - Event name and location
Date purchased - Date and time of the ticket purchase
Checked in - this tells you whether the ticket was redeemed and when
Balance Refunded - Balance refunded for this purchase (could be partial or full)
User details - first name, surname and email address
Quantity - The number of tickets covered by the transaction. This field is defunct and always x1 because we've separated each ticket out onto its own line to support the refund process. Each line used to be a transaction, not a single ticket.
Ticket - The ticket type purchased. Some events have multiple ticket types (e.g. student tickets vs guest tickets).
Finance Code - Your finance code recorded against the ticket type if you assigned one (Nominal Code, Department Code, Cost Centre)
Overall Price - The total price the user paid for the ticket. It’s face value + booking fee (less any discount from a promo code)
VAT rate (0%, 9%, 20%, 23% or exempt)
Booking fee type - Records whether the booking fee is ‘passed on’ to the user on top of the face value ticket or ‘absorbed’ as part of the face value ticket price.
Face Value - The amount paid for the ticket minus the Native booking fee and any promo code applied
Booking fee - value of the booking fee
Promo Code - If ticket buyers have used a promo code as part of the transaction, the promo code value is recorded here
Refund status - Refunded, Pending, Rejected or none
Amount Due - The amount due to you from all transactions for that ticket type. It includes the face value of the ticket + any booking fee adjustment you've made to our standard booking fee, minus any promo code applied. It is net of our fees.
Payout ID - The ID of the payout this transaction was included in
Native fees - Native fees inclusive of VAT

REFUNDS (THIRD SHEET/TAB)

Refund ID - transaction ID for the refund
Amount - Amount refunded (could be part of the ticket purchase or the ticket purchase price in full)
Promo Code £ - If ticket buyers have used a promo code as part of the transaction, the promo code value is recorded here
Partial Refund - YES or NO
Booking fee - value of the booking fee
Refund status - Refunded, Pending, Rejected or none
Event and ticket details (Event name and Ticket Name)
Purchase details - Purchase date and time, and purchase ID this refund relates to
User details - first name, surname and email address
Request details - Request timestamp, who the refund was requested by (whether it was requested by the student or a member of staff), the refund request reason, who approved or rejected the refund, when it was approved if approved
Refunded - The date and time of the refund
Payout ID - The ID of the payout this transaction was included in

Understanding the Sales Report Fields & Filters

Understanding the Sales Report 📈