The short answer
Export one row per event with its date, status, tickets sold, capacity and revenue, as a CSV file. It opens in Excel, Google Sheets or Numbers. For per-order detail, export the orders as well; for money by day, week or month, export your sales over time.
On One Ticket, Events has Export CSV for exactly that one-row-per-event file, with each event’s Ticket revenue.
Why one row per event helps
A committee meeting, a grant acquittal or an end-of-year review usually asks the same question: what did each event bring in? An orders export answers it, but only after you sort and add up hundreds of rows. A per-event export answers it straight away, and it’s the file you’ll reuse each year.
Which export answers which question
| Question | Export |
|---|---|
| What did each event make? | Events, one row per event |
| Who bought what, and when? | Orders, one row per order |
| Who’s coming, with their answers? | Attendees, one row per person |
| How did sales go over time? | Sales, per day, week or month |
| What did regulars pay by subscription? | Sales over time with a subscriptions column |
Start with the smallest file that answers the question. Every extra column is something to explain, and every name in it is personal information to look after.
Make the numbers mean the same thing
Before you send a file, check these, and write the answers in a note at the top of the sheet:
- Revenue after what? Discounts and refunds should be taken off. Booking fees the buyer paid shouldn’t be in it, or your revenue looks bigger than what you kept.
- All time or a period? A per-event file is usually all time, so a refund next month changes it. Date the file.
- Subscriptions. If regulars pay by plan, their session tickets may show as free. Their money is in the subscription payments, so add those separately: see how to see subscription income alongside ticket sales.
- Which month? If you’re totalling by month, decide whether an event belongs to the month it ran or the month tickets were bought: event date vs purchase date.
On One Ticket
Every event, one row each:
- Choose Events.
- Choose Export CSV at the top right (on a phone, it’s in the ⋯ menu).
The file is named with today’s date and has Event, Date (its first day), Status, Sold, Capacity (“Unlimited” where a ticket type has no cap) and Ticket revenue. Ticket revenue is each event’s ticket sales, all time, after discounts and refunds, without the booking fees buyers pay: the same figure as Sales on Reports. It includes every event on the list; from Archived, your archived events. The list itself shows Ticket revenue as a column too (on a phone, under what’s sold).
For a period, or other cuts:
- Reports, Export CSV at the top: each event with activity in the period, counted by event date or purchase date as you choose.
- Reports, Sales over time, Export CSV: sales per day, week or month, with Subscriptions and Total columns once you have subscription payments. Under the chart, Table rows gives the same sales by Date, Event, Ticket type or Extra, each with its own CSV.
- Orders, Export CSV: every order, with answers to your questions.
Exporting needs permission to export orders, which owners and admins have. Every export is on every plan, including Free. See The Events list and Export to a spreadsheet.
Related: How do I get a list of everyone who booked?, When do I get paid for ticket sales? and What should a post-event report include?
Answers to your questions
How do I export revenue for every event at once?
On One Ticket, choose Events, then Export CSV. You get one row per event with its ticket revenue.
Does ticket revenue include booking fees?
No. It’s ticket prices after discounts and refunds. Booking fees paid by buyers aren’t included.
Can I export revenue for just last month?
Yes. On Reports, choose the period, then Export CSV. Choose Count sales by first to decide whether last month means events held then or tickets bought then.
Will the spreadsheet open in Excel?
Yes. It’s a CSV file, which opens in Excel, Google Sheets and Numbers.
Who on my team can export?
Anyone with permission to export orders. Others on your team who can see orders still see each event’s ticket revenue on the list.