Skip to content

Smoothie Shop Inventory Sheet: Frozen, Fresh, and Waste

A free smoothie shop inventory sheet: frozen fruit by the case, fresh produce with use-by dates, add-ins, cups, and reorder points set by delivery days.

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 smoothie shop has two kinds of stock, and they fail in opposite ways. Frozen fruit keeps for a year or more, so the risk is running out. Fresh produce and dairy keep for days, so the risk is throwing them away. A smoothie shop inventory sheet handles both: frozen fruit by the case with a reorder point tied to delivery days, and fresh items with a use-by date and a plan for what's left. It also covers add-ins, cups and straws. Below is a sheet filled in for a made-up shop, the sums behind its reorder points, and the file.

The short version

  • Frozen fruit by the case. Reorder point = cases used a day × days until the next delivery, plus a day.
  • Fresh produce and dairy on the Lots sheet with use-by dates.
  • Decide in advance what happens to fresh stock on its last good day.
  • Protein powders and nut butters carry allergens: note them.
  • Count before each order, not once a month.
  • TaroStack takes fruit off stock when you record the day's smoothies, and flags what's about to expire. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Strawberries, frozen, 30 lb case case 6 4 $54.00 $324.00 OK
Mango chunks, frozen, 30 lb case case 3 4 $61.50 $184.50 REORDER
Blueberries, frozen, 30 lb case case 4 3 $72.00 $288.00 OK
Bananas, 40 lb case case 2 2 $24.00 $48.00 REORDER
Spinach, 2.5 lb bag bag 5 4 $7.25 $36.25 OK
Greek yogurt, 32 lb pail pail 2 2 $49.00 $98.00 REORDER

Eleven rows in all, $1,610.45 of stock, with mango, bananas and yogurt to reorder.

Reorder points from delivery days

The distributor delivers Monday and Thursday. The longest gap is Thursday to Monday, four days.

Item Used a day × 5 days (4 and a spare) Reorder at
Strawberries, frozen 0.8 case 4.0 4
Mango, frozen 0.8 case 4.0 4
Blueberries, frozen 0.6 case 3.0 3

A 30 lb case at 5 oz a smoothie is 96 smoothies. This shop goes through about 77 strawberry smoothies' worth a day, 0.8 of a case. Mango is at 3 cases with a 4-case reorder point: on Thursday's order it goes, or Sunday afternoon is mango-free.

For frozen fruit, err high. A spare case costs freezer space and nothing else.

Fresh stock: dates and a plan

Received Item Use by The plan for what's left
Nov 16 Bananas, 3 cases Nov 21 Day 5: peel, portion and freeze
Nov 16 Spinach, 6 bags Nov 24 Day 7: into the green smoothie special
Nov 12 Greek yogurt, 3 pails Dec 10 Dated by the dairy

For fresh stock, err low, and have an exit. Bananas are the classic: they arrive green, are perfect for two days, and are brown by day six. This shop peels and freezes whatever's left on day five. Frozen banana makes a thicker smoothie anyway, and a case that would have been $24 in the bin becomes next week's stock.

The sheet flags anything inside five days of its date USE FIRST. For this shop that's most of the fresh rows, most of the time, which is the point: the flag is a daily to-do list.

Write the waste down. When something is thrown away, note what, how much and why. A month of notes shows whether the answer is ordering less, or a better day-five plan.

Allergens

Item Contains
Whey protein, vanilla Milk
Greek yogurt Milk
Peanut butter Peanuts
Almond milk Tree nuts

A smoothie shop has four of the major allergens within arm's reach of one blender. Keep what each item contains on the sheet, where the person at the counter can check it. Blender cleaning between allergen drinks is a procedure, not an inventory matter, and it matters more.

A walk-in freezer has its own sheet in freezer inventory sheet, and the count itself is in inventory count sheet example. Cups and lids are compared in how to package smoothies for sale.

Get the sheet

Download the smoothie shop inventory sheet. Four sheets: inventory with value and REORDER, lots with days left to their use-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.

Where this stops working

The count is right on Monday and Thursday mornings. In between, 200 smoothies a day each took five ounces of this and a banana of that. Nobody subtracts them, so the reorder points only work on count days, and the waste notes depend on someone writing on a clipboard with wet hands.

How TaroStack does it

TaroStack keeps the count moving between counts.

Each smoothie is a recipe. Five ounces of strawberries, half a banana, a scoop of yogurt, a cup, a lid. Units convert: fruit bought by the case and used by the ounce is one item.

A day's smoothies come off in one step. Record what you made and each recipe takes its ingredients off stock, from the oldest lots. TaroStack connects to Square.

Use-by on every lot. Fresh deliveries go in with their dates. The soonest to expire is used first, and an alert flags what's close, with its value.

Waste has a reason. Throwing something away is an adjustment with a reason, so the month's waste is a report in dollars, not a clipboard.

A reorder list in days of cover, ready before Thursday's order.

The job Count sheet In TaroStack
Cases left between counts Unknown Stock on hand, after each day's record
Bananas on day 5 Remember An alert
What waste cost this month Add up notes Waste by reason
Thursday's order Count, then work it out The reorder list

Stock, recipes, expiry 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 smoothie shop need?

Frozen fruit, fresh produce such as bananas and greens, a dairy or dairy-free base, add-ins like protein powder and nut butter, and cups, lids and straws.

How do I reduce waste in a smoothie shop?

Order fresh items for the days until the next delivery, put a use-by on each delivery, and decide ahead what happens on the last good day, such as freezing bananas.

How much frozen fruit does a smoothie shop use?

It depends on sales and recipes. At 5 oz a smoothie, a 30 lb case makes 96.

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.