Event reports

If you want to collect data on your event sales, then you should head to your event report by navigating to the relevant event and then selecting the Report tab. In this article we will take you through how to understand your event report, and how this can help you solve any customer queries.

What does the event report contain?

An event report contains the following:

• An XLS button which you can use to download a spreadsheet documenting your sales
• A list of all purchases on the event, and a search bar and filters which you can use to navigate them
• A table showing your sales figures per item type
• A table showing your sales figures per settlement type

Sales overview table

At the top of the Report page, you can select to view your Sales report.

The Event report- sales overview shows sales per ticket type, and also breaks down the sales into raw sales, TicketCo provision, and net sales:

• Item type - The name of your item type created under 
• Type of item - The category registered on your item type e.g. Ticket, Lodging, Video on Demand
• Amount - The number of items sold
• Checked in - The number of items checked in
• Your ticket sales - The face value of your item sales, excluding the TicketCo service fee
• Total cost of using TicketCo (TicketCo fee included TicketCo VAT) - The TicketCo fee including VAT on your sales
• Net sales - This is your ticket sales minus the total cost of using TicketCo
• (1) Paid by customer - The settlement for your sales in TicketCo consists of three parts, indicated by the numbers in this and the following columns. Step one is when the payment is confirmed by the purchaser and tickets are sent to them. 
• (2) Funds received by TicketCo - This shows the value of the sales which have been deposited and are held in your TicketCo client account. The funds are awaiting settlement.
• (3) Transferred to organiser - This shows the sales which have been transferred to you and settled. When you have received full settlement on your event, all sales will have status 3 and the final column will show 100%. 
• (3) Settled TicketCo fee included VAT - The TicketCo fee including VAT which has been settled.
• Settlement % - ([Transferred to organiser] / [Net sales]) x 100

Settlement type table

Below the sales overview, you will find the Event report- settlements table. This shows your raw sales per ticket type according to the settlement type e.g. “Online TicketCo”, “Gift Card”, "Voucher" etc. Sales may be registered as:

• Online TicketCo - Sales made through our desktop site where the customer has purchased using a bank card or other supported payment methods e.g. Vipps in Norway and Swish in Sweden
• Mobile TicketCo - Sales made through our mobile site where the customer has purchased using a bank card or other supported payment methods e.g. Vipps in Norway and Swish in Sweden
• Cash - Sales registered as cash, either via the admin app or Admin sales page
• Card sales - Payment was taken over the counter using a Zettle card terminal linked to our admin app
• Invoice sales - Sales registered as invoice from the Admin sales page
• Discount - Sum of discounts applied to purchased tickets
• Click card - Items were redeemed using a click card which the customer had already purchased
• Voucher - Items were redeemed against the value of a voucher which the customer had from a previous cancelled event
• Gift card - Items were redeemed against the value of a gift card the customer had
• Cashless - Items were redeemed against the value of a cashless card the customer had already purchased

List & filters

When you first click on the report tab, you will see the Items Report page:

This shows a list of all tickets purchased to your event. You can use the filters to view certain ticket types, or tickets purchased with gift cards, for example.

Amongst the list of items, you will be able to see:

• Check in status: this will be green if the item was scanned in or checked in, and you may also see a red banner indicated that an item was refunded or compensated
• When the order was created
• The group reference code, or group order: each order has a separate 6 letter code
• Reference code: this is the unique 5 letter code per individual ticket or item within the group order
• Customer’s name and email

Info pop up

Hit the info button if you want to look more closely at the validation details on the item. If the item was checked in (validated), you will see a timestamp displayed here. The pop up will also show you the settlement type for the order.

Editing ticket details

Click on the cog symbol next to a specific ticket in order to edit a customers’ details. You will also find options there for adding a Note to an item, or Resending the ticket to the customer. If you select Edit, you will be able to amend the name, email, phone and address connected with the order. This can prove very useful if a ticket buyer has inputted an incorrect email address when they purchased. To save the changes and resend the ticket immediately, use the Save button. If you would rather save the details but not resend the tickets, select Save without email. 

PDF tickets

Next to the cog symbol, you will find buttons to download the customer's PDF ticket and group PDF ticket. This may be useful if you want to resend tickets to a customer.

Refund checkbox

You may be able to refund some items, such as cash sales or free tickets, from this page depending on the accesses you have. 

XLS file

Click the XLS button to generate and download a spreadsheet showing all the transactions for this event. It is essentially a detailed version of the list of purchases found on the report page.

Any filters applied to the report will also be reflected on the XLS file which includes, amongst other things, information about:

• When each sale was made
• How each sale was registered, both in terms of payment type and sales channel
• The invoice in which the funds from the sale were settled to you
• Ticket ID (the code behind the customer's QR code) and ticket reference code
• Where a customer is sitting if a seat map is attached to the event
• The name of the specific event and item type purchased
• The price of the item, broken down into raw price, ticket fee and VAT
• TicketCo provision per item
• Customers' name, email, phone and any other details provided during the sale such as via the Questions tab
• Any Notes you had added to the order
• The name and email of the manager who scanned each ticket and when this occurred

Remember that the event report page and XLS file detail all sales made on that specific event, so if you want to collect a report which contains information about multiple events, you should head to your Dashboard or the Report tab instead.