Tracking stockAll guides

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.

Boxes of band merch loaded into a tour van

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.

ItemSizePriceCostCount inCount outGiven awaySoldShould have taken
Logo tee, blackM£20£7.003018111£220
Logo tee, blackL£20£7.00363006£120
LP, red vinyl£25£13.00807109£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.

DateTownAttendanceCardCashTakenVenue cutCard feesKeptPer head
Fri 12 MarLeeds180£664£240£904£64£11£829£5.02
Sat 13 MarManchester220£810£190£1,000£0£14£986£4.55
Sun 14 MarGlasgow140£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.

ItemSizeVanLockupHomeTotalReorder at
Logo tee, blackM182404230
Logo tee, blackL301264830
LP, red vinyl711002019160

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 outFormulaWhy it matters
Sold=E2-F2-G2Count in, less count out, less giveaways
Should have taken=H2*C2What 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/AttendanceWhich rooms buy. Compare your own shows, not other bands'
Sell-through=Sold so far/Units printedHow much of the run has gone
Shows of stock left=Total left/Average sold per showHow 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

For stock: item, size, price, cost, count in, count out, given away, and sold. For shows: date, town, attendance, card, cash, venue cut and what you kept. A third sheet for where the stock is stops boxes going missing between the van and home.

Count in, less count out, less anything given away. Then multiply by the price and check it against the card and cash you took. If the two disagree, something was miscounted or sold at a different price.

Multiply the average you sell per show by the number of shows before a reprint could arrive, and add a few. When your total stock of that size falls to that number, order.

It varies too much by genre, room and price list for one figure to be useful. Track your own: it shows which towns and which kinds of show buy, which is what you need to plan stock.

Yes, but it is treated as commercial goods. It has to be declared at the border, it can't go on the carnet with your equipment, and duty and VAT may be due. Check the government guidance for musicians touring in Europe before you go.

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