Free template
Ticket count tracker for Excel and Google Sheets
A free ticket sales tracker: type one row per count and it works out total sold, the change since the last count, sell-through, what is left, the gross and your pace, with a chart. Download it directly: no email, no signup.
Last updated
Download
Excel (.xlsx), 34 KB: formulas, a chart and a How to use sheet, for Excel or Google Sheets. CSV, 820 bytes: the example log as plain values, for any tool.
What is in the ticket count tracker?
One sheet for the show and 120 ready-made rows of daily counts. You fill in the yellow cells: the show, up to 4 ticket types with price and allocation, and each count’s date, tickets sold per type, comps and holds. Every other column is a formula; a Latest count box and a chart of sold against capacity update with it.
| Column | Filled in by | What it is |
|---|---|---|
| Date | You | The day of the count. One row per count; daily is best, but any spacing works. |
| Sold per ticket type | You | Cumulative tickets sold in each ticket type, as your ticketing platform reports them. Up to 4 types. |
| Comps | You | Complimentary tickets issued so far. |
| Holds | You | Tickets held off sale today (artist, production, sponsor). |
| Total sold | Formula | Sum of tickets sold across ticket types. |
| Change since last count | Formula | Total sold − total sold at the previous count. |
| Sold + comps | Formula | Total sold + comps: every ticket issued. |
| Sell-through | Formula | Total sold ÷ capacity. |
| Remaining | Formula | Capacity − kills − total sold − comps − holds. |
| Gross ($) | Formula | Tickets sold per type × that type’s price, added up (face value, before fees and taxes). |
| Days to show | Formula | Show date − count date. |
| Needed per day to sell out | Formula | Remaining ÷ days to show. |
| Sold per day since last count | Formula | Change since last count ÷ days since the previous count. |
| Sold per day since on-sale | Formula | Total sold ÷ days since the on-sale date. |
The example in the file
The file comes filled in with an example show so you can see every formula working: Example show at Example room, 500 cap, on sale Fri 21 Aug 2026, show Fri 16 Oct 2026. Illustrative numbers, not a real show: overwrite them with yours.
| Date | Early bird | Advance | Final | Comps | Holds | Total sold | Change | Sell-through | Remaining | Gross | Needed a day |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Fri 21 Aug | 96 | 0 | 0 | 0 | 20 | 96 | – | 19.2% | 384 | $1,920 | 6.9 |
| Sat 22 Aug | 121 | 0 | 0 | 0 | 20 | 121 | +25 | 24.2% | 359 | $2,420 | 6.5 |
| Sun 23 Aug | 134 | 0 | 0 | 0 | 20 | 134 | +13 | 26.8% | 346 | $2,680 | 6.4 |
| Mon 24 Aug | 142 | 0 | 0 | 2 | 20 | 142 | +8 | 28.4% | 336 | $2,840 | 6.3 |
| Tue 25 Aug | 150 | 3 | 0 | 2 | 20 | 153 | +11 | 30.6% | 325 | $3,075 | 6.3 |
| Fri 28 Aug | 150 | 18 | 0 | 4 | 20 | 168 | +15 | 33.6% | 308 | $3,450 | 6.3 |
| Fri 4 Sep | 150 | 41 | 0 | 6 | 20 | 191 | +23 | 38.2% | 283 | $4,025 | 6.7 |
| Fri 11 Sep | 150 | 55 | 0 | 8 | 15 | 205 | +14 | 41% | 272 | $4,375 | 7.8 |
| Fri 18 Sep | 150 | 62 | 0 | 10 | 15 | 212 | +7 | 42.4% | 263 | $4,550 | 9.4 |
How do I use it?
Download the .xlsx, fill in the yellow cells for your show and ticket types, then add one row per count with the date and the cumulative tickets sold per type, comps and holds. Every other column, the Latest count box and the chart update themselves. In Google Sheets, upload the file to Drive and open it.
- Download ticket-daily-counts.xlsx and open it. The Daily counts sheet is first.
- Fill in the show: event, venue, show date, on-sale date, capacity and kills.
- Name up to 4 ticket types with their price and allocation. The column headers pick up the names.
- After each count, add a row: the date, the tickets sold so far in each type (as your ticketing platform shows them), comps and holds.
- Read the rest: every other column, the Latest count box and the chart update on their own.
- For Google Sheets: in Google Drive choose New, then File upload, pick the .xlsx and open it with Google Sheets. Or use the CSV with any tool that reads one.
Questions
Is the ticket count tracker free?
Yes. Download the Excel file or the CSV directly: no email, no signup. Use it, change it and share it.
Does the tracker work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Its formulas only use functions that Excel, Google Sheets and LibreOffice all support.
What is the difference between comps and holds?
Comps are complimentary tickets issued at no charge, for example to the artist, press, sponsors or staff. Holds are tickets kept off general sale for the artist, production, the promoter or sponsors, and released later if not used.
Can TicketCounts.io fill in the counts for me?
TicketCounts.io does not write to spreadsheets. It emails the count instead: it connects to Eventbrite and Universe and sends scheduled, branded ticket-count reports to the people you choose.
Stop pulling counts by hand
TicketCounts.io reads tickets sold from Eventbrite or Universe and emails the count to your list on the days and time you choose, so nobody has to pull it by hand. Free for 1 active event report. New accounts get 14 days of Pro, no card needed.