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.
