Free coffee shop inventory spreadsheet

A ready-made inventory sheet for a coffee shop: twenty items most cafés stock, with the unit to count in, the pack size and a starting par level. Open it in Excel or Google Sheets and adjust it to your shop.

Download the template (CSV)Free. No email needed.
Coffee shop inventory count on a phone

What's in the template

CategoryItemCount inPackPar
CoffeeEspresso beansbag5 lb4
CoffeeDecaf beansbag2 lb1
CoffeeCold brew coarse grindbag5 lb2
DairyWhole milkgal1 gal12
DairyOat milkcarton32 fl oz12
DairyAlmond milkcarton32 fl oz6
DairyHalf and halfqt1 qt4
SyrupsVanilla syrupbottle750 ml3
SyrupsCaramel syrupbottle750 ml2
SyrupsChocolate saucebottle64 oz1
TeaMatcha powderbag1 lb1
TeaChai concentratecarton32 fl oz4
CupsHot cups 12 ozsleeve50 pcs6
CupsHot cups 16 ozsleeve50 pcs6
CupsHot lids 12/16 ozsleeve100 pcs6
CupsCold cups 16 ozsleeve50 pcs4
CupsStrawsbox500 pcs1
FoodCroissantspcs124
FoodMuffinspcs112
SuppliesNapkinspack500 pcs2

Columns in the file: Category, Item, Count unit, Pack size, Par level, On hand, Unit cost, Value, Order qty. Par levels are a starting point for a café selling about 100 drinks a day with deliveries twice a week — replace them with your own once you know your weekly usage.

How to count a coffee shop

Same time, same order

Count before opening or after close, when nothing is moving. Walk the shop in the same order every time — fridge, back shelf, bar, front — and keep the sheet in that order.

Count what's printed on the box

Count milk in cartons and gallons, beans in bags, cups in sleeves. Open packs as a fraction: half a bag is 0.5. Convert to grams and ounces later, not at the shelf.

Weekly for the fast stuff

Milk, beans, syrups, cups and pastries every week; cleaning supplies and napkins monthly. A count that takes more than 15 minutes won't happen.

Turning counts into numbers

Usage = last count + what you received − this count. If you had 10 cartons of oat milk, received 24 and now have 12, you used 22 this week.

Value on hand = on hand × unit cost. Add it up for the inventory value on your balance sheet.

Order quantity = par level − on hand, rounded up to whole packs.

Food cost % = (beginning inventory + purchases − ending inventory) ÷ sales. Our food cost guide walks through it with real numbers.

When the spreadsheet stops working

A sheet tells you what you have. It can't tell you what you should have — that takes your sales and recipes. Most cafés outgrow it when they want to know where the milk went, what a latte really costs, or want the order list written for them.

ShelfMule does those three things: stock comes off by recipe from your Square or Clover sales, staff count on their phones, and the shopping list builds itself. See how it works.

Questions

How do you do inventory for a coffee shop?

Count every item at the same time each week, in the units printed on the package, walking the shop in a fixed order. Then work out usage (last count + received − this count) and compare it with what your sales say you should have used.

What should be on a coffee shop inventory list?

Beans (regular, decaf, cold brew), every milk and alternative milk, syrups and sauces, tea and matcha, cups, lids, sleeves and straws by size, pastries and food, and supplies like napkins. The template above has twenty common items to start from.

How often should a café take inventory?

Weekly for fast, expensive items — milk, beans, syrups, cups, pastries — and monthly for everything else.

Is the template free?

Yes. It's a CSV file that opens in Excel, Google Sheets or Numbers. No sign-up.

Count less. Know more.

Connect your POS, add your stock items, do your first count — about an hour, and the numbers start working for you the same evening. From $59/month, no contract.

Get started