A kombucha brewery runs out of packaging more often than it runs out of tea. The tea and sugar for a 100-gallon batch fit on one shelf; the 800 bottles, caps and labels it needs fill a mezzanine and come from three suppliers on three lead times. So a kombucha inventory template has to put ingredients, packaging and finished bottles on one sheet, each row with an amount on hand and an amount where you reorder, and it has to give every batch of finished kombucha a lot and a best-by date. Here is one, filled in for a made-up brewery, with the file to download.
The short version
- Ingredients, packaging and finished bottles on one sheet.
- Reorder amounts set from how long each supplier takes, with labels the longest.
- Fresh flavorings (juice, puree) get a lot and a use-by the day they arrive.
- Each bottling run is a batch with its own lot and best-by, so the oldest ships first.
- TaroStack takes bottles, caps and labels off stock with every batch. More below.
An example sheet
Brightwater Ferments is a made-up Portland brewery I use in these examples. Six of its nine rows:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Black tea, organic | lb | 12 | 6 | $9.50 | $114.00 | OK |
| Green tea, organic | lb | 4 | 6 | $11.00 | $44.00 | REORDER |
| Cane sugar, organic | lb | 150 | 100 | $0.92 | $138.00 | OK |
| Ginger juice, cold pressed | gal | 3 | 2 | $38.00 | $114.00 | OK |
| Raspberry puree, aseptic | lb | 40 | 20 | $3.10 | $124.00 | OK |
| Bottles, 16 oz amber | each | 2400 | 1500 | $0.48 | $1,152.00 | OK |
The other three are caps, ginger labels, and 620 finished bottles of ginger kombucha at $1.73 each. The total is $2,947.60. Green tea and labels are under their reorder amounts.
Bottles are the biggest raw-material row by a distance: $1,152.00 of glass against $296.00 of tea and sugar together. If cash is tight, that's the row to look at.
Reorder amounts follow lead times
The brewery bottles about 480 bottles in a run and does three runs in two weeks, around 720 bottles a week.
| Item | Supplier takes | Used while waiting | Cushion | Reorder at |
|---|---|---|---|---|
| Bottles | 1 week | 720 | 780 | 1,500 |
| Caps | 1 week | 720 | 780 | 1,500 |
| Labels, ginger | 2 weeks | 720 | 780 | 1,500 |
Ginger is half of what they bottle, so two weeks of waiting uses about 720 ginger labels. With 1,100 on hand and a reorder amount of 1,500, the row has been red for a while. That's the point of the sheet: labels are printed to order, and the day you notice you're out is two weeks too late.
Lots and best-by dates
| Received or made | Item | Lot | Quantity | Date |
|---|---|---|---|---|
| Nov 9 | Ginger juice, cold pressed | GJ-1109 | 5 gal | Use by Dec 9 |
| Nov 2 | Ginger kombucha, 16 oz | GK-1102 | 480 | Best by Feb 2, 2027 |
| Nov 12 | Ginger kombucha, 16 oz | GK-1112 | 480 | Best by Feb 12, 2027 |
Cold-pressed juice is the row that spoils. It gets a row on the Lots sheet the day it arrives, and the sheet says USE FIRST when 30 days or fewer are left.
Finished bottles get a lot for each bottling run. This brewery dates its kombucha three months from bottling, kept cold; how to decide your own is in kombucha shelf life. With two lots in the cold room, GK-1102 ships before GK-1112, every time. If a keg account calls about an off bottle, the lot on the cap tells you which run, and which juice lot went into it. The pH readings for that run belong on the batch record: see kombucha HACCP plan.
Get the template
Download the kombucha inventory template. Four sheets: the inventory with value and REORDER, lots with days left, a count sheet that fills itself, 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
A bottling run touches five rows at once: bottles, caps, labels, juice, finished stock. Nobody updates five rows at the end of a bottling day. And the sheet can't see the tank: 100 gallons fermenting is stock too, and it's worth knowing that it turns into 800 bottles on Thursday.
How TaroStack does it
TaroStack treats the brew and the bottling as two recipes, and keeps the count from both.
Brewing is a batch. Tea, sugar and starter go in; a tank of kombucha comes out as its own lot. It's in stock, by the gallon, while it ferments.
Bottling is the next one. Kombucha from the tank, juice, a bottle, a cap and a label go in; finished bottles come out with a lot and a best-by. All five rows move when you record the run.
First expired, first out. Orders take the oldest lot by default, and a forecast shows what will pass its date unsold and what that costs.
Readings on the batch. Your own fields on the batch record hold pH and temperature, with a sign-off.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Bottles, caps, labels after a run | Three subtractions | Come off with the batch |
| What's in the tank | Not on the sheet | A lot, in gallons |
| Which lot ships next | Check dates by eye | Oldest first by default |
| Which juice is in which bottles | Brew log | On the batch record |
Recipes, batches, lots and expiry 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.
