Skip to content

Snack Inventory Template: Ingredients, Pouches, Batches

An inventory template for a snack maker: ingredients, packaging and finished pouches on one list, the batches the shelf can cover, lots and best-by 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 21, 2026 · 7 min read

A snack maker's inventory is three kinds of stock on one list: ingredients bought by the case, packaging bought by the thousand, and finished pouches counted one by one. Each row has a unit, an amount on hand, a level to reorder at, and a cost. That covers "what do we have". It doesn't cover the question a maker actually asks on Monday, which is how many batches can the shelf make, so the page adds that sum. And because a snack mix puts one supplier's almonds into hundreds of pouches, a second sheet keeps each delivery's lot and each batch's best-by date. The example is a made-up maker of snack mixes.

The short version

  • One list: ingredients, packaging, finished goods, each in the unit you buy or sell it in.
  • A reorder level for every row, and a status that says when you're at or under it.
  • Work out how many batches each ingredient covers. The smallest number is what you can make.
  • Write the lot of every delivery, and a batch code and best-by date for every batch.
  • Count finished pouches weekly and ingredients monthly.
  • TaroStack takes ingredients off the shelf as you record a batch. More below.

An example list

Counted in the third week of November.

Item Unit On hand Reorder at Unit cost Value Status
Almonds, roasted, 25 lb case case 6 4 $118.00 $708.00 OK
Cashews, roasted, 25 lb case case 2 3 $142.00 $284.00 REORDER
Pretzel twists, 12 lb case case 9 6 $21.50 $193.50 OK
Sesame sticks, 15 lb case case 4 4 $38.00 $152.00 REORDER
Dried cranberries, 25 lb case case 3 2 $64.00 $192.00 OK
Seasoning blend, 5 lb tub tub 5 3 $27.00 $135.00 OK

Ten rows in all, $4,586.70 at cost, with four to reorder: cashews, sesame sticks, printed pouches and the cranberry almond mix. The other four rows are the pouches, the shipping cases, and the two finished mixes: 860 pouches of nut and pretzel mix and 340 of cranberry almond.

Nearly half the value, $2,176.20, is finished pouches. That's normal the week after a big batch, and it's the stock with a date on it.

How many batches is that?

One batch of nut and pretzel mix is 480 pouches of 6 oz: 180 lb.

Ingredient In a batch On hand Batches covered Status on the list
Almonds 45 lb 150 lb 3.3 OK
Cashews 27 lb 50 lb 1.9 REORDER
Pretzel twists 60 lb 108 lb 1.8 OK
Sesame sticks 36 lb 60 lb 1.7 REORDER
Seasoning blend 12 lb 25 lb 2.1 OK
Printed pouches 480 2,000 4.2 REORDER

The shelf makes one batch. The second stops at sesame sticks, then pretzels, then cashews.

The list and the sum disagree twice. Pretzels read OK, nine cases against a level of six, and cover fewer than two batches, because a batch takes five cases. Pouches read REORDER and cover more than four. A reorder level in cases says nothing about batches unless it was set from the recipe.

Set the level from the recipe. If this maker mixes twice a week and pretzels take a week to arrive, the pretzels used while waiting are two batches, ten cases, and the level should be above that, not six. The sum is in reorder point example, and the cushion on top in safety stock formula. Pouches are different: a printed pouch can take weeks, so its level is high for a reason.

Deliveries and batches, with their lots

Received or made Item Lot or batch Quantity Best by Note
Nov 9 Almonds, roasted, 25 lb case Lot AL-26-3310 6 May 9, 2027 Tree nut. Certificate with the delivery
Nov 12 Sesame sticks, 15 lb case Lot SS-48812 4 Feb 12, 2027 Wheat, sesame, soy on the supplier's label
Nov 17 Nut and pretzel mix, 6 oz pouch Batch NP-1117 480 Mar 17, 2027 Best by four months from mixing

A snack mix is the case where lots matter most. If the nut importer phones about almond lot AL-26-3310, the question is which batches it went into and which shops got them. A maker who wrote the almond lot on each batch's sheet can answer in minutes. One who didn't recalls everything made since November 9.

Two more things on this sheet:

The shortest date sets the batch's date. This maker gives a mix four months, from its own shelf-life checks. The sesame sticks in batch NP-1117 are best by February 12, a month before the pouch's date. Either the pouch's date comes forward or older sesame sticks don't go into a mix. Decide which, and write it down. What a test involves is in shelf life testing.

Allergens come in with ingredients. The sesame sticks' label lists wheat, sesame and soy. Every time a supplier or a product changes, read the new label against your own: see allergen matrix template and food allergen labeling requirements.

Counting

Count finished pouches every week, by batch, oldest first, and ship the oldest first. Count ingredients and packaging once a month, with opened cases as a fraction: half a case of almonds is 0.5. The file's count sheet takes what the list said and what you found, and works out the difference at cost. A plan for what to count when is in cycle count form. If the business is still on paper, the plan it grows from is in snack business plan.

Get the template

Download the snack inventory template. The list with values and a status for each row, a sheet for deliveries and batches with lots and best-by dates, a count sheet and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

Every batch changes eight rows, and nobody types eight rows after mixing 180 lb of snack mix. So by Thursday the list is Monday's count. The batches-covered table has to be redone by hand for each mix. And the link between an almond lot and the pouches it went into is only as good as a handwritten line on a batch sheet.

How TaroStack does it

In TaroStack the recipe does the typing.

Recording a batch takes its ingredients off the shelf and puts the finished pouches on, from the recipe, with unit conversion: buy by the case, mix by the pound.

"What could I make right now" is the batches-covered table, for every recipe, from what's actually on hand.

The batch notes which lots it used, automatically, and the lot it makes carries your code and best-by date.

First-expired-first-out by default when picking, with lots close to their date flagged.

One recall report: which supplier lots went into which batches, which customers got them, and what's still on your shelf.

The job Spreadsheet In TaroStack
Stock after a batch Retype eight rows Recorded with the batch
How many batches the shelf covers A table for each mix What could I make right now
Which pouches hold almond lot AL-26-3310 Read the batch sheets The recall report
Which pouches ship first Check dates by hand First-expired-first-out

Lots, dates, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). Allergen tracking is on Growth. 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

What should a snack inventory list include?

Ingredients, packaging and finished goods, each with its unit, the amount on hand, a reorder level and a cost. Add a sheet for deliveries and batches with each lot and best-by date.

How do I know how many batches my stock will make?

Divide what's on hand of each ingredient by what one batch uses. The smallest answer is the number of batches you can make. In the example, sesame sticks cover 1.7 batches, so the shelf makes one.

Why track lot numbers for snack ingredients?

Because one delivery of nuts goes into hundreds of pouches. With the lot written on each batch, a supplier's recall notice leads to the batches and the shops. Without it, everything made since the delivery is in doubt.

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.