How to Do a Quick and Accurate Weekly Inventory Count at Your Cafe

Why Inventory Counts Are Non-Negotiable (But Don't Need to Be Painful)

Inventory counts — physically counting everything you have — is one of the most avoided tasks among cafe owners. It takes time, it's boring, and the results are often disappointing ("where did 5 liters of milk go?").

But without regular stock takes, you're essentially running a business without knowing how much money is leaking every week. Over-portioning, waste, expired stock, even loss — none of it shows up until you count.

The good news: inventory counts don't have to be a big production. With the right system, you can do it in 30-45 minutes every week. Here's how.

Step 1: Decide What to Count

The first mistake: trying to count everything every week. You don't need to know how many straws you have left every Monday.

Prioritize based on two criteria:

1. Cost value. Your most expensive ingredients per unit. For most cafes: coffee beans, fresh milk, chocolate, cheese, protein.
2. Usage volume. Ingredients you use the most. Milk might not be as expensive as coffee beans per gram, but you're using dozens of liters per week.

Create a "Top 10-15 items" list that represents the majority of your food cost. These get counted weekly. Everything else (condiments, straws, cups, etc.) can be counted monthly.

Example list for a coffee-and-pastry cafe:

• Coffee beans (all varieties)
• Fresh milk
• Non-dairy milk (oat, almond)
• Sugar (granulated + simple syrup)
• Chocolate / cocoa
• Matcha powder
• Whipped cream / heavy cream
• Butter
• Flour
• Fresh fruit (frequently used items)

Step 2: Pick a Consistent Day and Time

Inventory counts must happen at the same time every week. This matters because you're comparing this week's numbers against last week's — if the timing is different, the comparison isn't apples-to-apples.

Recommendations:

• Day: Monday morning (before opening) or Sunday evening (after closing). This gives you a clean boundary between operating weeks.
• Before supplier deliveries. Count stock before new goods arrive, not after. If your supplier delivers Monday morning, count Sunday evening.

Consistency matters more than the specific day. The key: same time, every week.

Step 3: Use Consistent Units

This is what often makes data useless: counting with units that keep changing.

Set a standard unit for each item and always use it:

• Coffee beans: kilograms (not "bags")
• Milk: liters
• Sugar: kilograms
• Fruit: kilograms or pieces (pick one, don't mix)

If your milk comes in 1-liter cartons, count full cartons + estimate the contents of opened ones. "3 full cartons + half a carton" = 3.5 liters. Always convert to the base unit.

Step 4: Count Efficiently

To speed up the process:

Prepare the form beforehand. Don't count while figuring out what to count. Print a form or open a spreadsheet with your fixed item list — just fill in numbers.

Count in one direction. Start at one end of storage and move systematically. Don't jump around. A consistent path reduces the risk of double-counting or missing items.

One person counts, one person records. If possible, two people make the process faster and more accurate. The counter focuses on numbers, the recorder focuses on the form.

Weigh, don't estimate. For opened items (half-empty coffee bags, partially used sugar boxes), use a scale. Visual estimation is notoriously inaccurate — "looks like half" could mean 30% or 70%.

Step 5: Calculate Variance

After counting physical stock, compare it against what should be there. This is the core of inventory counting.

The formula:

Opening Stock + Purchases - Theoretical Usage = Expected Stock

Expected Stock - Actual Stock = Variance

"Theoretical usage" comes from your POS data: if you sold 150 lattes this week and your latte recipe uses 200ml of milk, theoretical milk usage for lattes = 30 liters.

Example:

• Opening milk stock: 40 liters
• Purchases this week: 60 liters
• Theoretical usage (from POS): 85 liters
• Expected stock: 40 + 60 - 85 = 15 liters
• Actual stock (counted): 12 liters
• Variance: -3 liters (3 liters unaccounted for)

A variance of 3 liters out of 85 liters used is about 3.5%. Is that a lot? Depends on your tolerance, but generally variance under 5% is considered acceptable for cafes.

Step 6: Investigate High Variance

If variance exceeds your tolerance (say, 5%), find out why:

• Over-portioning. The most common cause. Baristas pouring more milk than the recipe calls for. Solution: scales, jiggers, or markings on pitchers.
• Unrecorded waste. Expired milk that got tossed, spilled ingredients, remade wrong orders — all of this should be logged.
• Internal consumption. Staff drinking coffee, tasting, training — all should be entered in the POS as internal orders.
• Receiving errors. Did the supplier deliver 9 liters but the invoice says 10? Always check deliveries on arrival.
• Inaccurate recipes. Maybe the recipe says 200ml of milk per latte, but in practice baristas use 230ml because the recipe is unrealistic for the actual cup size.

Step 7: Track and Compare Over Time

One stock take gives you a snapshot. But the real value comes from trends.

Record data every week in a simple spreadsheet:

• Columns: Item | Opening Stock | Purchases | Theoretical Usage | Expected Stock | Actual Stock | Variance | Variance %
• One sheet per month, one row per item per week

After a month, you can see:

• Is variance improving or getting worse?
• Which items are consistently problematic?
• Is variance higher during certain shifts or on certain days?

These trends are far more valuable than any single week's absolute numbers.

Tips for Making Stock Takes Sustainable

An inventory count done once and then abandoned is worthless. Some tips for making it a habit:

• Schedule it in the calendar. Treat it like any other work task. Not "when I get around to it" — but "every Monday at 7am."
• Delegate. You don't always have to be the one counting. Train your manager or senior staff to do it. You just review the results.
• Don't skip. If you skip a week, your trend data gets a gap. A quick and slightly rough count is better than no count at all.
• Celebrate improvement. If variance drops from 8% to 4% in a month, that's an achievement. Communicate it to your team — they need to know their effort (more consistent portioning, logging waste) is making a difference.

30 Minutes That Can Save Thousands

Investing 30-45 minutes per week in inventory counts can identify leaks that would never appear in your sales reports. If your variance is 5% of total food cost and your food cost is $1,000 per month, that's $50 disappearing — every month. Over a year, $600.

Inventory counts won't stop all loss. But knowing the numbers is the first step to fixing them. You can't fix what you don't measure.