Tour merch spreadsheet: the sheets, columns and formulas you need
9 minute read. Last checked November 2026.
A tour merch spreadsheet has three jobs: tell you what stock you have and where it is, tell you what each show made, and warn you before something runs out. Most go wrong because they try to do all three on one sheet. Use three, and let formulas do the checking.

Sheet one: stock per show
One row per item and size, one block per show. Count in before doors, count out after, and the difference is what you sold.
| Item | Size | Price | Cost | Count in | Count out | Given away | Sold | Should have taken |
|---|---|---|---|---|---|---|---|---|
| Logo tee, black | M | £20 | £7.00 | 30 | 18 | 1 | 11 | £220 |
| Logo tee, black | L | £20 | £7.00 | 36 | 30 | 0 | 6 | £120 |
| LP, red vinyl | £25 | £13.00 | 80 | 71 | 0 | 9 | £225 |
Give every item and size its own row, and name them the same way every time: "Logo tee, black, M", not "black tee med" one night and "logo M" the next. Totals across a tour only work if the names match.
Sheet two: shows
One row per show. This is the sheet you read back at the end of the tour.
| Date | Town | Attendance | Card | Cash | Taken | Venue cut | Card fees | Kept | Per head |
|---|---|---|---|---|---|---|---|---|---|
| Fri 12 Mar | Leeds | 180 | £664 | £240 | £904 | £64 | £11 | £829 | £5.02 |
| Sat 13 Mar | Manchester | 220 | £810 | £190 | £1,000 | £0 | £14 | £986 | £4.55 |
| Sun 14 Mar | Glasgow | 140 | £410 | £165 | £575 | £0 | £7 | £568 | £4.11 |
Sheet three: where the stock is
Stock is rarely all in one place. Without this sheet, nobody knows whether the other box of mediums is in the van, at the lockup or at the drummer's house.
| Item | Size | Van | Lockup | Home | Total | Reorder at |
|---|---|---|---|---|---|---|
| Logo tee, black | M | 18 | 24 | 0 | 42 | 30 |
| Logo tee, black | L | 30 | 12 | 6 | 48 | 30 |
| LP, red vinyl | 71 | 100 | 20 | 191 | 60 |
Every time stock moves, change two cells: take it off where it left and add it where it arrived. If the total changes when you move stock, something was typed wrong.
The formulas
Written for Google Sheets or Excel, with the stock sheet's columns lettered A to I as in the table above, starting at row 2.
| What it works out | Formula | Why it matters |
|---|---|---|
| Sold | =E2-F2-G2 | Count in, less count out, less giveaways |
| Should have taken | =H2*C2 | What the sales of this row should have brought in |
| Show total check | =SUM(I2:I40) | Compare with card plus cash. A gap means a miscount or a wrong price |
| Profit on the row | =H2*(C2-D2) | What the row made after the cost of the stock |
| Per head | =Taken/Attendance | Which rooms buy. Compare your own shows, not other bands' |
| Sell-through | =Sold so far/Units printed | How much of the run has gone |
| Shows of stock left | =Total left/Average sold per show | How long until this size runs out |
When to reorder mid-tour
Running out of mediums with eight shows left is the most expensive mistake in merch. The reorder point is the stock level at which you must order now for the new stock to arrive in time.
- Work out the average sold per show for the size. Say 9 mediums a night.
- Count the shows between now and when a reprint could reach you. If the printer needs ten days and you play six shows in that time, that is 6 shows.
- Multiply: 9 × 6 = 54. Add a few for a busy night, so 60.
- When mediums across the van and lockup drop to 60, order. Not when the box is empty.
- Set the "Reorder at" column on sheet three to that number, and colour the row when the total falls below it.
Ask your printer for their turnaround before the tour starts, and where they can deliver. A reprint sent to the venue three dates ahead is often easier than one sent home.
Reading the tour back
- Per head by town tells you where to bring more next time, and where the room was full but nobody bought.
- Sold by size, added across the tour, is your next print order. Order what sold, not what you ordered last time.
- Card against cash tells you how much float to carry. In most rooms now, cash is the smaller share.
- Kept, less the cost of what sold, is the tour's merch profit. That is the figure to put next to fuel and accommodation.
- Giveaways added up. It is always more than anyone thinks.
If the tour leaves the UK
Merch taken abroad to sell is treated as commercial goods, and it is handled differently from your instruments. An ATA Carnet covers equipment you bring back; goods for sale, such as band merchandise, can't go on it. Merch has to be declared at the border, and import duty and VAT may be due in the country you enter.
- Keep a list of exactly what crosses each border: item, quantity, what it is made of, where it was made, and its value. Sheet three is most of this already.
- Keep what you sold in each country separate, in that country's currency.
- Count what comes back, and keep the paperwork that shows it left the UK with you.
- Read the government guidance for musicians touring in Europe before you plan the run, and ask a customs agent if the stock is worth more than a few boxes.
The rules differ by country and change. Treat this as a checklist of what to track, not as customs advice.
Where spreadsheets fall down
- No signal at the back of the room, so the sheet doesn't open.
- Two people selling, one sheet.
- Sales aren't recorded as they happen, so the only numbers are the counts at each end of the night.
- Nobody fills it in at 1am, so the tour's numbers have gaps.
- One wrong formula dragged down a column, and every total after it is wrong.
Common questions
Sources
How Count In does this
Count In is this spreadsheet, kept up to date by the sales themselves. One tap a sale, with no signal, and the stock, show and location sheets fill themselves in. It warns you when a size is running low, and you can still download everything as a spreadsheet.
Start free