Skip to content

Subscription Box Inventory Spreadsheet: Count the Kits

A free subscription box inventory spreadsheet: every component of this month's box, how many boxes the stock can pack, best-by dates, leftovers, and a 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 19, 2026 · 5 min read

A subscription box is a kit. You don't sell five snacks; you sell one box that needs all five, plus a mailer, fill and a card. So the number that matters isn't how much stock you have. It's how many complete boxes you can pack, and that's set by whichever component you have least of. A subscription box inventory spreadsheet lists every component of this month's box against the subscriber count, shows the one that's short, keeps a best-by date for anything edible, and carries last month's leftovers so they get used. Below is a sheet for a made-up snack box with 310 subscribers, and the file.

The short version

  • One row for each component of this month's box, packaging included.
  • Reorder at the subscriber count: anything under it is short.
  • Boxes you can pack = the lowest count on the sheet.
  • The box's best-by is the soonest best-by inside it.
  • Leftovers get their own rows, with their dates, so they don't die on a shelf.
  • TaroStack treats the box as a recipe and tells you how many you can pack. More below.

An example sheet

Item On hand Needed Unit cost Value Status
Dark chocolate sea salt bar, 2 oz 340 310 $1.85 $629.00 OK
Chili lime cashews, 3 oz 325 310 $1.40 $455.00 OK
Hibiscus tea sachets, box of 5 298 310 $1.10 $327.80 REORDER
Maple shortbread, 2 pack 360 310 $0.95 $342.00 OK
Fig and olive crackers, 4 oz 312 310 $1.60 $499.20 OK
Mailer box, printed 420 400 $1.15 $483.00 OK

Ten rows in all, with fill, insert cards and two leftovers from October: $2,998.75 of stock.

How many boxes can you pack?

Component On hand
Chocolate bars 340
Cashews 325
Tea sachets 298
Shortbread 360
Crackers 312
Mailers, fill, cards 350 or more
Complete boxes 298

The tea came in at 310 but 12 boxes were crushed in transit, so there are 298. That's 12 boxes short of 310 subscribers, and it was found on receiving day, with a week to get a dozen more, and not on packing day. The crackers are the next risk: 312 on hand leaves two spare.

Each box holds $6.90 of products and $1.46 of packaging, $8.36 in all, before postage.

Dates

Item Lot Best by
Maple shortbread MS-1027 Dec 20, 2026
Chili lime cashews CL-1021 Jan 31, 2027
Fig and olive crackers FO-1030 Feb 28, 2027
Dark chocolate bar CH-2291 Apr 30, 2027
Hibiscus tea HT-0914 Mar 1, 2028

The shortbread sets the clock. A box packed on November 20 reaches a subscriber with about four weeks on its shortest-dated item, which this company treats as its minimum. Ask each maker for the best-by before you commit to a product, not when it arrives.

Keep the lot of each product with the month it went into. If the cashew roaster recalls CL-1021, you need to know it was the November box, all 310 of them, and who they went to. Lot codes are explained in how to create lot numbers.

Leftovers

October left 44 brittle and 61 apple chips: $121.25 of stock with dates in December. Three uses, in order: add-ons in the shop, replacements for damaged boxes, and a "best of" box. A leftover without a row and a date is a write-off waiting to happen. A sheet for stock with dates is in inventory list with expiration dates.

How many spares to order is a judgment. This company orders 3% over the subscriber count for breakage and replacements, and more for anything fragile. The reasoning is in how much inventory to keep on hand.

Get the spreadsheet

Download the subscription box inventory spreadsheet. Four sheets: inventory with value and REORDER, lots with days left, a count sheet, and a read-me. Set each "reorder at" to this month's subscriber count. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. More layouts are in inventory spreadsheet examples.

Where this stops working

Every month is a new box with new rows. The sheet gets copied, last month's numbers linger, and the subscriber count changes daily until the cut-off. Then 310 boxes are packed and somebody has to take 310 off eight rows by hand, and remember that 14 replacements went out too.

How TaroStack does it

TaroStack treats the box as a thing you make.

The box is a recipe. One of each product, a mailer, fill, a card. Next month is a new recipe, and last month's is kept.

"What could I make right now" says how many complete boxes the stock can pack and which component runs out first.

Packing is a batch. Record 310 boxes and every component comes off stock at once, from the lots you used. Those lots are noted on the batch record automatically.

Dates are on every lot. The soonest to expire is used first, and an alert flags lots close to their date, leftovers included.

One report if a maker recalls. From the cashews' lot to the boxes it went into and the customers who got them.

The job Spreadsheet In TaroStack
Boxes I can pack Find the lowest row What could I make right now
Take 310 off eight rows By hand Recorded with the batch
Leftovers going out of date Scroll and notice An alert
Which month got lot CL-1021 Search old sheets On the batch record

Stock, lots, recipes and batches 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 manage inventory for a subscription box?

List every component of the month's box against the subscriber count. The component with the lowest count sets how many complete boxes you can pack.

How much extra should I order for a subscription box?

Enough to cover breakage and replacements. The example company orders 3% over its subscriber count, and more for fragile items.

What do I do with leftover subscription box items?

Give them their own rows with their best-by dates, then use them as shop add-ons, replacements or in a later box before the date.

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.