A bubble tea shop sells one thing built from eight or nine: tea, a creamer or milk, a syrup, a powder, pearls, a cup, a film or lid, and a fat straw. Run out of any one and the drink can't be sold. A bubble tea inventory sheet lists each of them in the unit it's bought in, bags, bottles, sleeves, rolls, and turns the count into the number that matters at the counter: days of stock left. It also keeps best-by dates for the powders and pearls, and notes which ones contain milk. Below is a sheet filled in for a made-up shop selling about 150 drinks a day, and the file.
The short version
- Count in the units you buy: bags, bottles, sleeves, rolls.
- Work out how many drinks one unit makes. That turns a count into days.
- Set each reorder point at the days your supplier takes, plus a few.
- Cups, film and straws stop sales as surely as pearls do.
- Dry pearls keep for months. Cooked pearls keep for hours, and aren't inventory.
- TaroStack takes every ingredient off stock when you record the day's drinks, and builds the reorder list. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Tapioca pearls, dry, 6.6 lb bag | bag | 14 | 12 | $9.80 | $137.20 | OK |
| Black tea, loose, 1.3 lb bag | bag | 9 | 6 | $11.50 | $103.50 | OK |
| Jasmine green tea, loose, 1.3 lb bag | bag | 5 | 6 | $12.75 | $63.75 | REORDER |
| Taro powder, 2.2 lb bag | bag | 7 | 6 | $10.20 | $71.40 | OK |
| Brown sugar syrup, 5.5 lb bottle | bottle | 6 | 6 | $13.00 | $78.00 | REORDER |
| Cups, 22 oz PP, sleeve of 50 | sleeve | 38 | 30 | $4.25 | $161.50 | OK |
Eleven rows in all, $1,057.35 of stock, with three to reorder: jasmine tea, brown sugar syrup and sealing film.
From bags to days
| Item | One unit makes | Used a day | On hand | Days left |
|---|---|---|---|---|
| Tapioca pearls, bag | 100 drinks | 1.2 bags | 14 | 11.7 |
| Cups, sleeve | 50 drinks | 3 sleeves | 38 | 12.7 |
| Sealing film, roll | 3,000 drinks | 0.05 rolls | 2 | 40 |
| Fat straws, box | 2,000 drinks | 0.06 boxes | 3 | 50 |
These are this shop's figures: 150 drinks a day, four in five with pearls, about 30 g of dry pearls a drink. Work out your own once, by counting drinks against a bag, and write them beside the sheet.
The supplier delivers in a week. So this shop reorders pearls at 12 bags, ten days of stock: seven for the delivery and three in case a weekend runs hot. The same sum sets every row.
Film and straws look safe at 40 and 50 days. They're on the sheet anyway, because they come from a different supplier with a longer wait, and because nothing substitutes for them. A shop can swap jasmine for black tea for an afternoon. It can't seal a cup without film.
Dates and allergens
| Received | Item | Lot | Best by | Note |
|---|---|---|---|---|
| Oct 20 | Tapioca pearls, dry | TP-2609 | Mar 20, 2027 | Use before TP-2610 |
| Nov 10 | Tapioca pearls, dry | TP-2610 | Apr 15, 2027 | |
| Nov 3 | Taro powder | TR-1183 | May 1, 2027 | Contains milk |
| Nov 3 | Non-dairy creamer | CR-5520 | Oct 1, 2027 | Contains milk protein |
| Nov 14 | Whole milk | Nov 28 | Nov 28, 2026 | Dated on the jug |
Two things here catch new shops. "Non-dairy" creamer often contains a milk protein, and this one does: read the ingredient list on every powder and write what you find in the notes. And a customer asking "is there milk in the taro?" should get an answer from the sheet, not a guess.
Cooked pearls aren't on the sheet at all. This shop cooks a small pot every few hours and throws out what's left after four, its own rule for quality. What gets counted is the dry bag.
Counting it
Count the same day every week, before the order goes in, with the shelves in the order of the sheet. Open bags count as halves. A blank count sheet is in the file, and the method is in inventory count sheet example. What a drink costs to make and whether the shop makes money is in is a bubble tea business profitable.
Get the sheet
Download the bubble tea inventory sheet. Four sheets: inventory with value and REORDER, lots with days left to their best-by, 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 coffee counter's version is in coffee shop inventory spreadsheet.
Where this stops working
The sheet is right on count day. By Thursday it's a guess, because 150 drinks a day each took a little of eight things and nobody subtracted them. A busy weekend empties a row faster than the weekly count can see.
How TaroStack does it
TaroStack does the subtracting from the recipes.
Each drink is a recipe. Tea, creamer, syrup, pearls, a cup, film and a straw, in the amounts you use. Units convert, so pearls bought by the bag and used by the gram are one item.
A day's drinks come off in one step. Record what you made, 40 taro and 110 milk tea, say, and each recipe takes its ingredients off stock, from the oldest lots. TaroStack connects to Square.
A reorder list in days of cover. Each item shows how many days it will last at the rate it's really moving, with reorder points suggested from that.
Dates on every lot. The oldest bag is used first, and an alert flags lots close to their date.
Allergens on Growth. With allergen tracking on, each item says what it contains.
| The job | Weekly sheet | In TaroStack |
|---|---|---|
| Days left of pearls | Work it out | The reorder list |
| Subtract what sold | Nobody does | Recorded with the day's drinks |
| Bags near their date | Read the labels | An alert |
| "Is there milk in it?" | Find the bag | On the item (Growth) |
Stock, recipes and the reorder list 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.
