A supplement inventory template has to answer a question most stock sheets never ask: is this allowed to be used yet? A drum of powder that has arrived but hasn't passed its identity test is in the building and isn't available. A pallet of finished bottles waiting for release is counted and can't be shipped. So the sheet keeps released and quarantined stock on separate rows. It records every raw material and every finished batch by lot, with an expiry date, and it shows which raw lots went into which finished lot. Below is a sheet filled in for a made-up brand that fills its own capsules, and the file.
The short version
- Raw materials by lot, each with its supplier's expiry and whether its certificate and tests are in.
- Quarantined and released stock on separate rows. Only released stock is sellable.
- Finished bottles by lot, expiring no later than their shortest-dated ingredient.
- Retained samples counted, and kept out of what you can sell.
- Capsules and powder decide how many bottles you can fill; bottles and lids rarely do.
- TaroStack holds a lot until you release it and records which lots went into each batch. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Noni fruit powder, bulk | kg | 38 | 25 | $30.00 | $1,140.00 | OK |
| Vegetable capsules, size 0, empty | thousand | 96 | 60 | $9.50 | $912.00 | OK |
| Bottles, 150 cc amber | each | 1,450 | 1,000 | $0.42 | $609.00 | OK |
| Desiccant packs, 1 g | each | 900 | 1,000 | $0.04 | $36.00 | REORDER |
| Noni capsules, 90 count: released | bottle | 412 | 300 | $5.26 | $2,167.12 | OK |
| Noni capsules, 90 count: in quarantine | bottle | 600 | 0 | $5.26 | $3,156.00 | OK |
Ten rows in all, $8,503.76 of stock. More than a third of it, the 600 bottles in quarantine, can't be sold today.
What's on the shelf and what's usable
| On the shelf | Usable now | |
|---|---|---|
| Powder, lot NP-250822 (tested) | 13 kg | 13 kg |
| Powder, lot NP-251015 (identity test pending) | 25 kg | 0 |
| Finished bottles, lot NC-1006 (released) | 412 | 412 |
| Finished bottles, lot NC-1110 (waiting for release) | 600 | 0 |
The sheet says 38 kg of powder. A batch of 600 bottles takes 27 kg: 90 capsules at 500 mg is 45 g a bottle. So 38 kg looks like one batch with room to spare. In fact only 13 kg is cleared for use, which is 288 bottles. The next batch waits on a lab result, and anyone promising a ship date needs to know that.
The same goes for the order of 500 bottles. There are 1,012 on the shelf and 412 that can leave.
Lots and dates
| Received or made | Item | Lot | Quantity | Expires |
|---|---|---|---|---|
| Sep 15 | Noni fruit powder | NP-250822 | 67 kg | Aug 22, 2028 |
| Nov 3 | Noni fruit powder | NP-251015 | 25 kg | Oct 15, 2028 |
| Aug 20 | Vegetable capsules | VC-7731 | 204 thousand | Aug 1, 2029 |
| Oct 6 | Noni capsules, 90 count | NC-1006 | 600 bottles | Aug 22, 2028 |
| Nov 10 | Noni capsules, 90 count | NC-1110 | 600 bottles | Aug 22, 2028 |
Both finished lots expire on August 22, 2028, the powder's date, because a bottle can't outlast what's in it. This brand sets finished expiry at the earliest date among the ingredients. Whatever your rule, write it down and apply it the same way to every lot.
The notes column carries the chain: NC-1006 was made from powder NP-250822 and capsules VC-7731. If the powder supplier ever writes about NP-250822, both finished lots are in question, and the sheet says so in one filter.
Retained samples
Fourteen bottles sit in a cabinet, a few from every lot, kept in case a complaint or a question comes up later. They're on their own row for one reason: so nobody ships them. How many to keep, and for how long, comes from the rules for supplement makers and your own procedures.
Those rules, on manufacturing records and labels, are their own subject. A start is dietary supplement labeling requirements, and a batch record is in herbal products batch record. If someone else fills your bottles, see supplement co-packer.
Get the template
Download the supplement inventory template. Four sheets: inventory with value and REORDER, lots with days left to expiry, 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. A simpler sheet for dated stock is in inventory list with expiration dates.
Where this stops working
Quarantine on a spreadsheet is a word in a cell. Nothing stops a picker taking bottles from the cage, and nothing moves 600 bottles from one row to the other when the release is signed. The sheet is right only if someone remembers to make it right, on the day.
How TaroStack does it
TaroStack makes "not yet" a status the stock itself carries.
A lot on hold can't be sold or used. Put a new delivery or a new batch on hold. It's counted, and it's kept out of what's available until you release it.
Each batch notes its lots. Record a batch and the powder and capsules come off the lots you used, noted on the batch record automatically. The bottles get their own lot and expiry.
First expired, first out. The soonest to expire is picked first, and an alert flags lots close to their date.
Your own fields. Certificate received, identity test, release signature and date go on receiving and on the batch-record form.
One report. From a supplier's lot to every finished lot and every customer who got it.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Not released yet | A separate row, if kept up | On hold |
| Powder cleared for use | Read the notes | Available, by lot |
| Which powder is in NC-1006 | A note on the row | On the batch record |
| Lots near expiry | Sort by date | An alert |
TaroStack isn't a quality system and doesn't decide a release. Lots, expiry, batches and recalls 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.
