Juice Bar Inventory Template

For juice and smoothie bars working with lots of fresh produce that turns fast. Track par levels, cold storage and expiry so cold-pressed juice stays fresh and waste stays low.

Download free Excel template Fill it from supplier invoices →

Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.

Item	Category	Storage	Unit	Par Level	On Hand	To Orderƒ	Unit Cost	Valueƒ	Supplier	Expiry
Organic Kale, 24 bunches	Produce	Walk-in Cooler	case	2	1	auto	38	auto	Sunfield Organic Produce	2025-12-04
Frozen Acai Packs, 100 g x 48	Frozen Fruit	Reach-in Freezer	case	3	2	auto	72	auto	Tropic Harvest Foods	2026-08-31
Bananas, 40 lb	Produce	Prep Area	case	2	2	auto	24	auto	Sunfield Organic Produce	2025-12-06

ƒ = calculated automatically by formula.

What's included

Item
Category
Storage
Unit
Par Level
On Hand
To Order — calculated automatically
Unit Cost
Value — calculated automatically
Supplier
Expiry

Tips for using this template

Order fresh produce every one to two days in smaller amounts rather than weekly; leafy greens fade quickly.
Date-label every bottled juice at press time and pull past-date bottles at open.
Keep frozen fruit pars high as a backup when fresh deliveries are short.

Stop typing deliveries by hand

Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.

More free templates

Small Business Inventory Template Restaurant Inventory Template Reseller Inventory Spreadsheet Retail Store Inventory Template Warehouse Inventory Template Home Inventory Template Bar & Liquor Inventory Template Office Supplies Inventory Template Bakery Inventory Template Coffee Shop Inventory Spreadsheet Food Truck Inventory Template Catering Inventory Template Brewery Inventory Spreadsheet Food Pantry Inventory Template Pizza Shop Inventory Template Winery Inventory Spreadsheet