A spice inventory list for a business is a row for each bulk spice, counted in pounds, with what's on hand, where you reorder, the cost a pound, and the supplier. A kitchen-cabinet list stops there. A spice business needs two more things: the supplier's lot number on every bag that comes in, and a shelf of its own for the spices that are allergens. Spices get recalled, and when your paprika supplier calls about one lot, the list is how you find out which of your blends it went into. Below is the list, filled in for a made-up two-person blend business, and the sheet to download.
The short version
- Count bulk spices in pounds, and jars and labels in eaches, all on one list.
- Set a reorder amount for each: about what you blend in the supplier's lead time, and a week more.
- Write down the supplier's lot and best-by date for every bag you receive.
- Keep sesame and mustard on their own shelf, and say so on the list.
- TaroStack records which lot of each spice went into each batch of blend. More below.
The list
Eleven rows for the example business, which blends in a rented kitchen two days a week. The first six:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Paprika, smoked | lb | 18 | 10 | $7.40 | $133.20 | OK |
| Cumin, ground | lb | 9 | 10 | $6.10 | $54.90 | REORDER |
| Black pepper, 16 mesh | lb | 22 | 10 | $9.80 | $215.60 | OK |
| Garlic, granulated | lb | 30 | 15 | $4.95 | $148.50 | OK |
| Onion powder | lb | 12 | 15 | $4.20 | $50.40 | REORDER |
| Sea salt, fine | lb | 80 | 40 | $0.62 | $49.60 | OK |
The rest are ancho chili powder, ground mustard seed, toasted sesame seed, 4 oz jars and their labels. The shelf is worth $1,145.60 in all, and three rows say REORDER: cumin, onion powder and sesame.
Jars and labels belong on the same list. A blending day that ends with 40 lb of rub and 12 jars isn't finished.
How to set the reorder amount
Take cumin. The business uses about 5 lb of it in a blending week, and the importer delivers in a week. So 5 lb covers the wait. Add a second week for a late truck or a big order and the reorder amount is 10 lb. At 9 lb the sheet turns the row red.
Black pepper runs the other way. It's the expensive row ($215.60 sitting there), it keeps well whole or cracked, and the importer's price breaks at 25 lb. Buying it a bag at a time is the right call even though it ties up money. My advice is to let the costly, slow spices sit a little lean and never run out of the cheap ones every blend needs.
Lots and best-by dates
The second sheet is where a spice business earns the word "business". Each bag received gets a row:
| Received | Item | Supplier lot | Quantity | Best by |
|---|---|---|---|---|
| Sep 14 | Paprika, smoked | PK-25-3317 | 25 lb | Sep 30, 2027 |
| Jun 2 | Cumin, ground | CU-24-9042 | 25 lb | Dec 15, 2026 |
| Oct 5 | Sesame seed, toasted | SS-25-0721 | 10 lb | Apr 30, 2027 |
The sheet counts the days left on each and says USE FIRST inside 30 days. The cumin from June is the one to finish before anybody opens a new bag.
Ground spices fade faster than whole ones, and the best-by on the bag is the supplier's. Type it as printed. What matters more is the lot. When a recall notice names lot PK-25-3317, you want to answer two questions in a few minutes: do we still have any, and which batches of which blends used it? The second answer needs a batch sheet that writes down the lot of every spice that went in. How to number your own batches is in how to create lot numbers.
The allergen shelf
Sesame is a major food allergen under federal law, alongside milk, eggs, fish, shellfish, tree nuts, peanuts, wheat and soy. Mustard isn't on the U.S. list, but it is on Canada's, and buyers ask about it. Keep both on a shelf of their own with their own scoops, and put "allergen shelf" in the Where kept column so the count sheet sends people there last. Label rules for blends are in spice labeling requirements, and sesame's in sesame labeling requirements.
Get the spreadsheet
Download the spice inventory list. Four sheets: the list with value and REORDER, lots with days left, a count sheet that fills itself from the list, 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
A list knows what you had the last time you typed. It doesn't know that Tuesday's batch of taco seasoning took 6 lb of cumin, so somebody has to subtract. And it can't tell you which blend got which lot unless you've been writing lots on every batch sheet and can find the right one in the binder.
How TaroStack does it
TaroStack is the list and the batch sheets in one place.
Receiving records the lot. Each bag comes in with the supplier's lot and best-by date, typed or scanned from the case label.
A blend is a recipe. Record a batch of taco seasoning and the cumin, paprika and salt come off stock, each from the lot that expires first. The batch record notes which lots it used, automatically, and the blend gets a lot of its own.
One report for a recall. Start from the supplier's lot and see every batch it went into, what's still on your shelf, and which customers got it.
Allergens on the label, checked. On Growth, with allergen tracking on, each item says what it contains, and a batch won't start if the blend's label leaves out an allergen in its ingredients.
| The job | List and binder | In TaroStack |
|---|---|---|
| Pounds on hand | Subtract after each batch | Comes off when the batch is recorded |
| Which lot went in | Written on the batch sheet, if remembered | Recorded with the batch |
| A supplier's recall | Read every batch sheet | One report |
| What to order | Scan for red | A reorder list |
Lots, recipes, batches and recalls are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes, with allergen tracking). 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.
