Skip to content

Bubble Tea Inventory Sheet: Pearls, Tea, Cups, Days Left

A free bubble tea inventory sheet: pearls, teas, powders, syrups, cups and film, with days of stock left for each, best-by dates, allergens, and a file.

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 · 6 min read

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.

Questions people also ask

What inventory does a bubble tea shop need?

Tapioca pearls and other toppings, teas, creamer or milk, powders, syrups, cups, sealing film or lids, and fat straws.

How long do tapioca pearls last?

Dry pearls keep for months: follow the maker's date on the bag. Cooked pearls are best within a few hours, and most shops set their own limit.

How do I know when to reorder?

Work out how many days each item lasts at your usual sales, and reorder when that's down to your supplier's delivery time plus a few days.

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.