Skip to content

Tea Inventory Template for a Small Tea Business

A free tea inventory template for a tea blender or seller: leaf and herbs by the pound with supplier lots, sachets, boxes and tins, finished stock, 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 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.

Questions people also ask

How do you keep track of tea inventory?

Count leaf and herbs in pounds and finished boxes or tins in eaches, on the same sheet, and know how many boxes a pound of blend makes so the two can be checked.

How long does loose leaf tea last?

Kept sealed, dry and dark, most dried teas and herbs are good for a year or two. Go by the supplier's best-by date and use the oldest lot first.

How do I start a small tea business?

The numbers for an herbal tea line, from blending to boxes, are in herbal tea 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.

TaroStack for Shopify

Free for 14 days.