Coffee shop inventory management, without the spreadsheet

Why most café inventory systems fail

Most independent cafés run inventory in one of three ways: a shared Google Sheet, a clipboard in the dry store, or pure memory. All three break at the same moment — when the shop gets busy. The result is the quiet 4-7% of revenue that disappears into spoilage, stockouts and over-ordering every month.

A working system has to survive a Saturday rush, a new barista's first week, and the owner being on holiday. That means it can't depend on memory or on one person being heroic.

The four numbers every café owner should know

• On-hand: How much of each item is in the shop right now.
• Par level: The minimum you want on hand before reorder.
• Weekly usage: How much you actually go through in a normal week.
• Waste rate: What % of what you bought ended up in the bin.

If you can answer those four questions for your top 20 SKUs (espresso beans, milks, cups, lids, syrups, pastries), you have an inventory system. Everything else is decoration.

Set par levels from real usage, not vibes

The most common mistake is setting par based on what a supplier rep recommended, or what last year's owner wrote on a sticky note. Par should equal average weekly usage × delivery frequency × 1.2 safety buffer.

Example: you use 12 bags of beans per week, your roaster delivers twice a week, so each cycle covers 6 bags. Par = 6 × 1.2 = ~7 bags. Below 7, reorder.

A weekly inventory rhythm that actually sticks

1. Sunday close: count the top 20 SKUs (15 minutes).
2. Monday open: compare to par; place one consolidated order.
3. Mid-week: log waste at the end of every shift — one line per item.
4. End of week: review waste-by-cause and adjust next week's prep by 15%.

The non-negotiable is the weekly count. Daily counting burns staff out; monthly counting hides problems for too long. Weekly is the cadence that holds.

From inventory to margin

Inventory data only matters if it ends up in your COGS. Each menu item has a recipe; each recipe consumes inventory. Multiply usage by cost, divide by revenue, and you have a live food-cost percentage — the single most important number a café owner can watch week to week.

Target ranges most independent cafés should aim for:

• Coffee program: 18-25% COGS
• Food / pastries: 28-35% COGS
• Waste rate: under 4% of purchases

Where Coffee Shop Dashboard fits

Coffee Shop Dashboard is the calm alternative to the inventory spreadsheet. It tracks on-hand stock, sets dynamic par levels from real usage, logs waste with one tap, and ties everything into a live COGS and profit number on the dashboard. No formulas, no broken sheets, no end-of-month panic.