A tea business holds its stock in two forms at once: pounds of loose leaf and herbs in the back, and boxes or tins on the shelf. The same leaf is in both. A tea inventory template has to count each form in its own unit, give every bag of leaf a row with its supplier's lot and best-by date, and track the sachets, boxes and tins that run out long before the tea does. Below is a template filled in for a made-up herbal tea business, and the file to download.
The short version
- Leaf and herbs in pounds, one row each, with a reorder amount.
- Packaging in eaches: sachets, boxes, tins, labels.
- Finished stock by product, each packing run with a lot and a best-by.
- Know how many boxes a pound of blend makes, so the two counts can be checked against each other.
- TaroStack converts pounds to boxes when you record a packing run and keeps the lots. More below.
An example sheet
Māmaki Mana Tea is a made-up Hawaiʻi tea business I use in these examples. It has eight rows:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Māmaki leaf, dried | lb | 26 | 15 | $22.00 | $572.00 | OK |
| Lemongrass, cut | lb | 9 | 5 | $9.50 | $85.50 | OK |
| Hibiscus, cut | lb | 4 | 5 | $8.20 | $32.80 | REORDER |
| Ginger, dried pieces | lb | 6 | 4 | $11.40 | $68.40 | OK |
| Pyramid sachets, empty | each | 9000 | 6000 | $0.035 | $315.00 | OK |
| Boxes, 15 count | each | 700 | 800 | $0.62 | $434.00 | REORDER |
The last two rows are 260 two-ounce tins and 190 finished boxes of māmaki mint at $4.87 each. The total is $2,732.00. Hibiscus and the printed boxes are under their reorder amounts.
Printed boxes are the row to watch. They cost 62 cents and take the printer three weeks. This business packs about 250 boxes a week, so three weeks of waiting uses 750, and 800 is barely a cushion. At 700 they should already be on order.
Pounds to boxes
One sachet holds 2.5 grams, and a box holds 15, so a box is 37.5 grams of blend. A pound is 453.6 grams.
| Grams in a box | 37.5 |
| Boxes from a pound of blend | 12 (453.6 ÷ 37.5 = 12.1) |
| Pounds of blend for a 240-box run | 20 |
| Sachets for the run | 3,600 |
That table is how you check one count against the other. If a 240-box run took 23 lb of blend off the shelf where it should have taken 20, something's off: overfilled sachets, a spill, or a count that was wrong to begin with.
It also tells you what the stock in the back can become. Twenty-six pounds of māmaki won't make 26 times 12 boxes, because the blend is only part māmaki. If the recipe is 60% māmaki, a 20 lb run uses 12 lb of it, and 26 lb covers two runs.
Lots and best-by dates
| Received or packed | Item | Lot | Quantity | Best by |
|---|---|---|---|---|
| Sep 22 | Māmaki leaf, dried | MK-0922 | 40 lb | Sep 22, 2027 |
| Apr 14 | Hibiscus, cut | HB-24-6610 | 22 lb | Dec 14, 2026 |
| Oct 26 | Māmaki mint, box of 15 | MM-1026 | 240 | Apr 26, 2028 |
| Nov 10 | Māmaki mint, box of 15 | MM-1110 | 120 | May 10, 2028 |
Dried herbs are imported, and imported botanicals are recalled from time to time. The importer's lot number on each bag, written down the day it arrives, is what lets you answer "did we use any of it, and in which boxes?" The hibiscus from April is the short-dated row, and the sheet flags it USE FIRST inside 30 days.
This business dates finished boxes 18 months from packing, and ships MM-1026 before MM-1110. Rules for what the box has to say are in tea business license, and package choices in how to package tea for sale.
Get the template
Download the tea 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
Six blends share four herbs. Each packing run pulls from several leaf rows in different proportions, plus sachets and boxes. Then the online store sells boxes all day without telling the spreadsheet. The sheet is right on the morning you count and drifts from there.
How TaroStack does it
TaroStack holds the blend as a recipe, so the pounds and the boxes stay in step.
A blend is a recipe, and a box is another. The blend recipe lists each herb by weight. The box recipe takes 37.5 grams of blend, 15 sachets and a printed box. Record a run of 240 and the māmaki, the mint, the sachets and the boxes all come off, from the lot that expires first.
It says what you can make. "What could I make right now" shows how many boxes the leaf and packaging on hand allow, and which one runs out first.
Lots on every batch. The batch record notes the importer's lot for each herb, so a recall of one bag of hibiscus is one report: the boxes it went into and the customers who got them.
Selling online. Connect your Shopify store, and we set it up with you.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Herbs used by a packing run | Work out each one | Come off with the batch |
| Boxes the leaf on hand can make | Arithmetic | Shown for you |
| Which hibiscus lot is in which box | Packing notes | On the batch record |
| Printed boxes running low | Watch for red | A reorder list |
Recipes, batches and lots 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.
