Skip to content

Packaging Inventory Sheet: Jars, Lids, Labels, Boxes

A packaging inventory sheet: containers, closures, labels by version and shipping boxes with value, reorder levels from lead times and minimums, a free file.

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 · 6 min read

Packaging is the stock that stops production without warning. Nobody runs out of sugar by surprise. People run out of lids, or of one flavor's label, on the day the kettle is already hot. A packaging inventory sheet has a row for every container, closure, label and shipping material, counted in single pieces, with what each cost and a level to reorder at. Two things make packaging different from ingredients. Lead times and minimum orders are long and large: labels take weeks and come in thousands. And labels have versions: when the address or the net weight line changes, the old ones are a liability, not a reserve. Below is a sheet for a made-up jam maker, how to set the levels, and the file.

The short version

  • A row for every jar, lid, label, band, box and divider. Count in eaches.
  • One row for each label design, not "labels".
  • Reorder level = weeks the supplier takes × what you use in a week, plus a margin.
  • Minimum orders are big: check you have room and cash for a pallet of jars.
  • Keep labels by print run and version. Scrap old versions on purpose.
  • Count matching sets: 85 boxes need 85 dividers.
  • TaroStack takes packaging off stock when you record a batch. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Jar, 8 oz, glass each 1,440 1,000 $0.62 $892.80 OK
Lid, 70 mm, gold each 2,100 1,000 $0.11 $231.00 OK
Front label, strawberry each 380 500 $0.07 $26.60 REORDER
Front label, peach each 2,600 500 $0.07 $182.00 OK
Shrink band each 900 1,000 $0.02 $18.00 REORDER
Shipping box, 12 jars each 85 100 $0.95 $80.75 REORDER

Ten rows in all, $1,661.85 of packaging, with five to reorder: strawberry labels, shrink bands, shipping boxes, their dividers and gift boxes.

Look at the labels. There are 1,440 jars and 2,100 lids, plenty for a week. There are 380 strawberry labels. The strawberry row is one of the smallest on the sheet in dollars, $26.60, and it's the one that stops Tuesday's batch. A single row called "labels" with 6,080 on it would have looked fine.

Setting reorder levels

Item Used a week Supplier takes Used while waiting Reorder at Comes in
Jar, 8 oz 480 2 weeks 960 1,000 A pallet of 2,880
Front label, strawberry 240 2 weeks 480 500 Runs of 2,000
Shrink band 480 2 weeks 960 1,000 Bags of 5,000
Shipping box, 12 jars 40 2 weeks 80 100 Bundles of 25

The level is what you'll use before the delivery arrives, rounded up. These lead times are this maker's own suppliers'. Ask yours, and ask again before the holidays, when label printers are busiest.

Minimums. A pallet of jars is 2,880, about $1,800, and it needs a dry place to sit. A label run is 2,000 of one design. For a slow flavor that's a year of labels, so think before you print: the working out is in economic order quantity and minimum order quantity.

Sets. Boxes and dividers are used one to one. Count them together and reorder them together. The same goes for jars and lids, though lids are cheap enough to keep extra.

Labels by version

Printed Label Run Quantity Note
Mar 10 Back label, all flavors 2026-03, version 2 5,000 Old address: use up by year end or scrap
Aug 4 Front label, strawberry 2026-08, version 3 2,000 New net weight line
Aug 4 Front label, peach 2026-08, version 3 3,000

A label is a legal statement about what's in the jar. When the recipe, the allergens, the net weight or the business address changes, the label changes, and the old stock has to be kept apart from the new. Write the version on the carton of each run. Decide what happens to the old ones: this maker has 3,100 back labels with an old address, $124 worth, and a date to use or scrap them by. A change to ingredients or allergens can't wait like that. Those are scrapped the day the recipe changes.

What goes on the label is in food labeling requirements for small business. Setting levels in general is in reorder point example.

Get the sheet

Download the packaging inventory sheet. Four sheets: inventory with value and REORDER, print runs and pallets, a count sheet that works out each difference and what it's worth, 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 uses packaging: 480 jars, 480 lids, 480 bands, 480 front labels of one flavor, 480 back labels, 40 boxes, 40 dividers. Seven rows to subtract, each time, by someone whose hands are sticky. So the sheet is right on count day and drifts from there, and the label cabinet gets checked when the kettle is already on.

How TaroStack does it

TaroStack takes the packaging off with the batch.

Each product is a recipe that includes its packaging: one jar, one lid, one band, its own front label, a back label. Record a batch of 480 and all of it comes off stock.

"What could I make right now" says how many jars of strawberry the stock allows, and names the thing that stops you: the strawberry label.

A reorder list in days of cover, with each supplier's lead time and minimum order.

Each print run is a lot, so two versions of a label are counted apart.

Counting works on a phone, with no signal in the store room.

The job Spreadsheet In TaroStack
Take seven kinds of packaging off after a batch Seven subtractions Recorded with the batch
Which label runs out first Read every row What could I make right now
When to order, with a two-week wait A level you set once Days of cover, with lead times
Old label versions A note on a carton A lot of their own

TaroStack doesn't design or print labels. Stock, recipes and reordering are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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 track of packaging inventory?

Give every container, closure, label design and shipping material its own row, counted in single pieces, with a reorder level worked out from the supplier's lead time and what you use in a week.

How many labels should I keep on hand?

At least what you'll use while waiting for a reprint, plus a margin. With 240 a week and a two-week wait, that's 500. Each design is counted on its own.

What should I do with old labels after a change?

Keep them apart by version. A cosmetic change can be used up by a set date. Labels that are wrong about ingredients, allergens or weight should be scrapped when the change is made.

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.