How to Do a Weekly Stock Count at Your Small Cafe

Why Bother Counting?

If you run a small cafe with 20-50 products on the menu, you might think formal inventory counting is overkill. You can see the milk in the fridge, you know roughly how much coffee is left, and you reorder when things look low.

The problem with eyeballing: it works until it doesn't. You run out of oat milk on a Saturday afternoon. You discover that a case of syrup has been sitting expired in the back. Or you notice at month end that your food cost is way higher than expected, but you can't pinpoint why.

A weekly stock count takes 30-45 minutes and gives you something eyeballing never will: data. And data lets you make decisions instead of guesses.

What to Count (and What to Skip)

You don't need to count every single item in your storage room. Focus on two categories:

High-value items: These are things that are expensive per unit. Coffee beans, meat, seafood, specialty ingredients. A few missing units here actually affect your margins.

High-turnover items: These are things you use a lot and reorder frequently. Milk, sugar, cups, takeaway containers. Running out of these disrupts your operation.

Skip items that are low-value AND low-turnover — napkins, stirrers, condiment packets. Count them monthly instead of weekly.

For most small cafes, you'll end up with a list of 15-25 items to count weekly. That's manageable.

When to Count

The best time: before opening on your slowest day.

Why before opening? Because nothing is moving. No one is pulling milk for lattes while you're counting milk bottles. The numbers you record match reality.

Why your slowest day? Because you have the most mental bandwidth. Trying to do a stock count before a Saturday rush is a recipe for mistakes and stress.

For most cafes, this ends up being Tuesday or Wednesday morning. Pick a day, put it on the calendar, and make it routine. The moment it becomes "we'll do it when we have time," it stops happening.

How to Record It

Use whatever you'll actually stick with. A fancy inventory app you abandon after two weeks is worse than a notebook you use consistently.

Option 1: Paper notebook. A physical notebook kept near the storage area. One page per week, columns for item name, expected quantity (based on last count minus usage plus deliveries), and actual quantity. Simple, tactile, no tech required.

Option 2: Spreadsheet. A Google Sheet or Excel file with the same columns. Advantage: you can add formulas to auto-calculate variance and track trends over weeks. Share it with your manager so multiple people have visibility.

Option 3: POS inventory module. If your POS has basic inventory tracking, use it. The advantage is that sales data and stock data live in the same system, making variance analysis easier.

Whichever you choose, record these for each item:

• Item name
• Unit of measure (bottles, kg, bags)
• Count from last week
• Deliveries received since last count
• Expected count (last week + deliveries - what you should have used based on sales)
• Actual count (what you physically counted)
• Variance (actual minus expected)

The Count Process: Step by Step

1. Print or open your count sheet. Have last week's numbers visible so you can compare.
2. Start from one end of storage and work systematically. Don't jump around. Go shelf by shelf, fridge by fridge. This prevents double-counting and missed items.
3. Count physical units, not labels. Don't trust what the box says — open it and count what's actually inside.
4. Check expiry dates as you go. This is a two-for-one: you're counting AND catching items that are about to expire. Pull anything expiring this week to the front (first-in, first-out).
5. Record immediately. Don't try to remember and write it down later. Count, write, move to the next item.
6. Calculate variance. After counting everything, compare actual vs expected. Any item with a significant variance gets flagged.

Reading the Variance: What It Tells You

Variance means the difference between what you expected to have and what you actually have. There are three scenarios:

Actual matches expected: Great. Your usage is predictable and nothing is going missing.

Actual is lower than expected (negative variance): You have less than you should. Possible causes:

• Waste. Spilled milk, dropped items, food prepped but not sold (overproduction).
• Theft. Uncomfortable to think about, but it happens. Consistent negative variance on the same item is a red flag.
• Uncounted usage. Staff drinks, taste-testing, items used for something other than customer orders (cleaning with food-grade products, etc.).
• Recording errors. Deliveries not logged, or a delivery count was wrong.

Actual is higher than expected (positive variance): You have more than you should. This usually means under-portioning (using less per serving than the recipe calls for) or a delivery that was received but not recorded.

What to Do When Numbers Are Off

Don't panic over small variances. A bottle of milk here or there is normal — measurement isn't perfect, and some waste is expected.

Focus on:

• Consistent patterns. If coffee beans are short every single week, there's a systemic issue — not random variance.
• Large one-time variances. If you're suddenly missing a case of something, investigate immediately. Was it delivered? Did someone move it?
• Trends over time. Is your milk variance getting worse week over week? That might indicate a portion control problem as a new barista gets comfortable.

When you find something off:

1. Check if it's a recording error first (most common cause).
2. Talk to the team — not accusingly, but curiously. "We've been going through more oat milk than our sales show. Any idea why?"
3. Adjust par levels or reorder quantities if usage patterns have genuinely changed.
4. If waste is the issue, look at prep processes. Are you prepping too much of something that doesn't sell?

Making It Stick

The hardest part of weekly counting isn't the counting — it's doing it every week. Here's what helps:

• Same person, same day, same time. Make it someone's specific responsibility. Shared responsibility means no one does it.
• Keep it under 45 minutes. If it takes longer, you're counting too many items. Trim the list to what actually matters.
• Act on what you find. If you count every week but never do anything with the data, the person counting will (rightly) stop caring. Review the numbers, discuss them with the team, and make at least one adjustment based on what you see.
• Celebrate accuracy. When your counts match perfectly, acknowledge it. It means the team is being careful with portions, waste, and recording.

The Bottom Line

Weekly stock counting isn't glamorous. But it's one of the highest-ROI habits a small cafe can build. It prevents stockouts, catches waste early, and gives you real data to manage your food costs — instead of guessing why the numbers don't add up at month end.

Start this week. Count 15 items. It'll take 30 minutes. Do it again next week. By the third week, it's a habit. By the end of the month, you'll wonder how you ever ran without it.