Skip to content

Kombucha Inventory Template: Tea, Bottles, Batches

A free kombucha inventory template for a small brewery: tea, sugar and flavorings, bottles and caps, finished bottles by batch with a best-by, and reorders.

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 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.

Questions people also ask

What inventory does a kombucha brewery need to track?

Tea, sugar, flavorings, bottles or cans, caps, labels, kegs, and finished product by batch. Kombucha still in the tank is worth tracking too.

How do you track kombucha batches?

Give each brew and each bottling run a lot number, write it on the tank and the case, and keep the tea, sugar and juice lots that went in with it.

How much does a bottle of kombucha cost to make?

In this example, $1.73 for a 16 oz bottle, most of it the bottle, cap and label. The full plan is in kombucha business plan.

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.