Skip to content

Concession Stand Inventory Spreadsheet: Count Each Game

A free concession stand inventory spreadsheet: hot food, popcorn, candy, drinks and paper goods, a count after every event, a shopping list and dates.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 20, 2026 · 7 min read

A concession stand has an inventory problem that most small businesses don't: it's run by a different set of volunteers every time. Nobody working Friday knows what Tuesday's crew used or what's in the cabinet. So the inventory sheet has to do the remembering. It lists every item with what's on hand, the level one busy game uses, and what it costs, and it's updated by one rule: count after every event. That count gives the next shopper a list, shows the treasurer what was sold, and catches the two things that quietly cost a stand its profit: stock bought twice because nobody knew it was there, and candy and drinks that leave without being paid for. Below is a sheet for a made-up booster club, the sum that checks sales against stock, and the file.

The short version

  • One row for each item, counted in the unit you buy.
  • A level for each: what one busy game uses. Below it, it's on the shopping list.
  • Count after every event. Ten minutes, two people.
  • What was used times the price should be close to the cash.
  • Dates on hot dogs, buns and anything opened.
  • TaroStack keeps the count on a phone and the list in days of cover. More below.

An example sheet

Counted after a Friday game.

Item Unit On hand Reorder at Unit cost Value Status
Hot dogs, 8 to a pack pack 14 20 $4.60 $64.40 REORDER
Hot dog buns, 8 to a pack pack 16 20 $2.10 $33.60 REORDER
Nacho cheese, #10 can can 5 4 $9.80 $49.00 OK
Tortilla chips, 3 lb bag bag 7 6 $5.40 $37.80 OK
Popcorn kernels, 12.5 lb bag 3 2 $13.50 $40.50 OK
Candy bars, box of 36 box 4 6 $27.00 $108.00 REORDER
Bottled water, case of 40 case 9 8 $5.20 $46.80 OK
Soda, case of 36 cans case 6 6 $15.80 $94.80 REORDER

Thirteen rows in all, $640.10 of stock. Six are at or under their level: hot dogs, buns, candy, soda, sports drinks and nacho trays. That's the shopping list, and it goes to whoever shops, not into someone's head.

Setting the level

The level is what one busy game uses, so that the stand can always open. Work it out from two or three games:

Hot dogs
Packs before the homecoming game 31
Packs after 12
Used 19 packs (152 hot dogs)
Level 20 packs

A stand that plays two home games a week wants more than one game's worth after shopping. One that plays twice a month wants no more than that, because buns go stale and hot dogs have a date. Buy for the next game or two, not for the season, except for things that keep: cups, napkins, kernels, canned cheese.

Checking sales against stock

This is the sum that answers the treasurer.

Hot dogs, Friday
Counted before the game 31 packs (248)
Counted after 14 packs (112)
Used 136
Price $3.00
Sales the count expects $408.00
Hot dogs rung up or tallied 121, $363.00
Difference 15 hot dogs, $45.00

Fifteen hot dogs went somewhere. Some were dropped, some were burnt, some fed the volunteers, and some were handed to friends. All of those are normal in small numbers. The point of the sum is to know the number. If the club's rule is that each volunteer gets one free item, write those down on a tally sheet, and the difference shrinks to what's really unexplained.

Do the sum for the three or four items that carry the money: hot dogs, candy, drinks. Counting every napkin isn't worth it.

Dates and food safety

A concession stand is a food operation, usually on a temporary or seasonal permit, and the same few rules apply.

Item Rule of thumb for the sheet
Hot dogs Kept cold; watch the use-by date; freeze what won't be used by the next game
Buns Best-by date; oldest out first
Nacho cheese, opened Refrigerate, write the date opened, use within 7 days
Hot-held food at the end of the night Discard. Don't cool it and bring it back
Candy, drinks Best-by dates, checked at the start of each season

The sheet's second tab lists dated stock with days left and flags anything inside two weeks. Your health department's permit sets the actual rules for your stand. Ask them what they expect for temperatures and handwashing.

Making it work with volunteers

One owner. One person, usually the concessions chair, owns the sheet. Everyone else fills in a printed count sheet and hands it over.

A map. Tape a list inside the cabinet door: what goes on which shelf. Volunteers put things back where the count expects them.

Count in pairs. One counts, one writes. It's quicker and it's more accurate.

Lock the candy. And the cash box. A key with the chair and one with the athletic director.

Shop from the list. The warehouse club trip is where double-buying happens. Nobody shops without the current sheet.

How to count is in how to count inventory, with a blank sheet in inventory count sheet example. A sheet for selling at a table by the day is in market vendor inventory template, and for a truck in food truck inventory spreadsheet.

Get the spreadsheet

Download the concession stand inventory spreadsheet. Four sheets: inventory with value and a REORDER flag, dated stock with days left, a count sheet to print, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers, so the chair can share one copy with the treasurer.

Where this stops working

The sheet is on the chair's laptop. The count sheets are paper, in a folder, in the stand. After a tournament weekend with five crews, there are five count sheets, two of them missing, and the chair types the rest in on Tuesday. By then someone has already shopped, from memory, and bought three more cases of water.

How TaroStack does it

TaroStack lets whoever is at the stand do the count where the stock is.

Counting on a phone, with no signal. The count works in a concrete block stand with no reception and sends itself later. It can also print a count sheet.

The count shows what a difference is worth before it's posted, so fifteen hot dogs is $45, on the screen, that night.

A reorder list in days of cover. What will run out before the next game, ready to shop from.

Lots and dates. Hot dogs and buns are received with their dates, the soonest is used first, and an alert flags what's about to expire.

Every adjustment carries a reason: damaged, expired, sample, lost. Waste can be reported by reason.

The job Laptop and paper In TaroStack
The count after a game Paper, typed in later On a phone, at the stand
What's missing, in dollars A sum on Tuesday Shown at the count
The shopping list Whoever remembers The reorder list
Volunteer meals and waste Unknown An adjustment with a reason

TaroStack isn't a cash register. Stock, counting, lots and the reorder list are on Starter at $9.99 a month, for one person and up to 50 items; Growth, at $39 a month, has three people. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do you keep inventory for a concession stand?

List every item with what's on hand and the amount one busy game uses, count after every event, and shop from the items below their level.

How do you check concession stand sales against inventory?

Count an item before and after the event. What was used, times its price, should be close to what was rung up for it. The difference is waste, free items and loss.

How much food should a concession stand keep on hand?

Enough for the next game or two for anything with a date, such as hot dogs and buns. Paper goods, canned cheese and popcorn kernels keep, and can be bought for longer.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.