Skip to content

Supplement Inventory Template: Lots, Dates, Quarantine

A free supplement inventory template: raw powders and capsules by lot with expiry, released and quarantined stock on separate rows, retained samples, 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 · 6 min read

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.

Questions people also ask

How do you track supplement inventory?

By lot. Every raw material and every finished batch has a lot number and an expiry date, and stock that isn't released yet is kept apart from stock that is.

What expiry date goes on a finished supplement?

That's for your own procedures and any testing you do. The example brand uses the earliest expiry among the ingredients.

What is quarantine in supplement inventory?

Stock that has arrived or been made but isn't cleared for use or sale yet. It's counted, and it isn't available.

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.