Coffee Shop Inventory: Mistakes vs the Right Method (Masterestaurant)

How do you take inventory for a coffee shop?

Coffee shop inventory runs on two rhythms, a daily count of coffee, milk and cups and a monthly count of everything else, closed out by a weekly reconciliation against theoretical usage.

The reason is about cash, not tidiness: behind a bar, three or four items carry almost all of the cost of what you sell, and if you count them once a month you discover the leak when there is no longer any way to tell which shift opened it. Everything else (syrups, cookies, napkins, sugar packets, cleaning supplies) moves slowly and holds up to a monthly count without the number losing meaning.

What does NOT work is counting everything at the same frequency, because the sheet gets long, the barista fills it in from memory at closing and the figure ends up as a signed guess.

Step 1: write the standard recipe for each drink in grams and milliliters

The first step is writing down how much of each item SHOULD go out per drink, because without a standard recipe there is no theoretical usage, and without theoretical usage the count has nothing to be compared against.

Weigh the shot on a one-gram scale, measure the milk for each size with the pitcher the barista really uses, and log the cup, lid, sleeve and stirrer as items with their unit cost, since in a low-ticket business they weigh more than the owner thinks. Every POS modifier (extra shot, oat milk, large size) needs its own line in the recipe, or the theoretical figure will come up short every week.

The deliverable is one card per drink with quantities and cost, and you verify it this way: two different baristas make the same drink and the scale shows the same weight within a few grams.

Step 2: count coffee, milk and cups every day at closing

The daily count covers only the items that move a bar's cash, meaning the beans (in sealed bags and in the hopper), each type of milk and the cups with their lids, and it happens at closing, at the same time and by the same person. It takes a few minutes if the sheet follows the physical order of the storeroom and the fridge, left to right, and if the hopper is weighed instead of eyeballed.

Open bags go on the scale, while sealed ones are counted by unit. Milk is logged in whole liters plus the fraction left in the open carton, and the steamed pitcher dumped at closing is recorded as waste with its reason, because that liter also left the inventory.

The deliverable is a signed daily sheet with ending stock, and you verify it when one day's ending stock is exactly the next day's opening stock, with no jumps nobody can explain.

Step 3: run the monthly count and value it at replacement cost

Once a month you count everything else and value it at what it would cost to buy again today, not at what it cost six weeks ago, because coffee shop inventory turns so fast that the old price no longer describes your cash.

The pressure comes from outside: the USDA Economic Research Service forecasts that food-away-from-home prices in the U.S. will rise 3.5% in 2026, and that comes after a 3.8% increase between May 2024 and May 2025 measured by the U.S. Bureau of Labor Statistics. With that momentum, valuing stock at the old invoice disguises your cost of goods sold and makes you believe the margin is healthy.

The deliverable is the monthly inventory valued by category (dry goods, disposables, refrigerated and cleaning), and you verify it when cost of goods sold closes with the usual formula: beginning inventory plus purchases minus ending inventory.

Step 4: reconcile actual usage against theoretical every week

The weekly reconciliation is the step that turns counting into money, and it means multiplying POS sales by the standard recipe to get theoretical usage, then subtracting the actual usage that came out of your counts. For example, if the POS logged 900 medium lattes at 240 milliliters of milk each, theoretical usage is 216 liters; if your counts show 240 went out, 24 liters are missing that someone over-steamed, gave away or poured out.

That gap is read by item and by shift, never as a total, because a total does not tell you who to talk to on Monday. In the Masterestaurant method that Diego F. Parra applies, variance is worked against the 32% food cost ceiling per product, which is a MAXIMUM and not a target. The deliverable is a weekly variance table by item, and you verify it when every relevant gap has a written cause and an owner.

What are the most common mistakes when taking coffee shop inventory?

The mistake that repeats most is counting without reconciling, because a spotless sheet nobody compares with theoretical usage stays a file and never becomes a control.

Next comes leaving modifiers out of the POS: if the extra shot or plant milk is charged «by hand», theoretical usage comes up short and the leak looks like the barista's fault when it belongs to the system.

Another stumble is changing the person who counts every week, which is hard to avoid in a trade where the BLS projects 1,078,500 annual openings for food and beverage serving workers between 2025 and 2035; with that turnover, the method has to be written down and trained, and cannot live in one person's head. And the worst is adjusting the count so it balances, which destroys exactly the information you were looking for. My position is firm: an honest gap is worth more than a pretty balance.

Do you need software or artificial intelligence to run inventory?

To start, you do not need expensive software, you need the standard recipe and the discipline of counting, and the tool comes later to save you hours, never to replace judgment.

Adoption is still a minority practice, since Restaurant Dive, citing the National Restaurant Association, reports that 26% of U.S. operators use artificial intelligence tools in 2026. What would happen if you connected an ordering forecast system to a POS without modifiers and to recipes nobody ever weighed?

The forecast would learn from false data, ask you for extra milk every week, and you would pay the supplier for waste the algorithm treats as normal demand, month after month, without anyone noticing. That is why the order matters: first recipes and counts on a spreadsheet for a few months, and only once theoretical usage is reliable, the POS integration and the automatic forecast.

How do you know your coffee shop inventory is done right?

Your inventory is done right when the weekly variance between actual and theoretical usage is small and explained item by item for several weeks in a row, not when the sheet is complete.

Check this closing list: every drink on the menu has a weighed recipe card, every modifier has its own POS button, the daily coffee, milk and cup sheet is signed and has no jumps, the monthly inventory is valued at replacement cost and every gap in the weekly table has a cause and an owner.

Waste logged with its reason matters beyond your bar, because ReFED calculates that 9.73 million tons (77.6%) of U.S. restaurant and foodservice surplus ended up in landfills in 2024. If even one item on the list is missing, start there this week, and the first action is weighing each barista's shot tomorrow morning before opening.

The differences that move a coffee shop's cash

The first difference is the question being asked. Bad inventory asks how much I have; good inventory asks how much I SHOULD have used and how much I did, and only the second points to the item, the shift and the recipe where capital leaked.

A bar example: if your recipe sets 18 grams per shot and the POS logged 1,200 single-shot drinks in a week, theoretical usage is 21.6 kilos of beans; if actual usage came to 24 kilos, 2.4 kilos left unpaid, and that is a grinder and technique problem, not a purchasing one. Be honest about what a count cannot see.

According to ReFED (2024), nearly 70% of the surplus from U.S. restaurants and foodservice is uneaten plate waste, and no inventory measures that, because the product was already sold and paid for. In a coffee shop the half-eaten slice of cake is a menu engineering and portion question, while milk poured down the drain behind the bar is inventory.

The differences that move a coffee shop's cash — in practice

Mixing the two ends with blaming the barista for a decision made on the menu. The third difference is people. The BLS projects a steady stream of openings every year for food and beverage serving workers in the U.S. from 2025 to 2035, and every new barista arrives with their own hand for the shot and the foam, so the method ties inventory to the written recipe and the marked pitcher rather than to the memory of whoever left.

What happens if you keep counting only on the last day of the month? First, four weeks of variance arrive blended and nobody can tell which shift caused it; then the owner hedges with safety stock, idle inventory grows and cash flow tightens just as replenishment gets pricier; finally the fix becomes a menu price increase that guests notice. I got this wrong for years, asking teams to count everything weekly, and they hated it.

ABC resolved the tension between control and barista hours: count a little, well, every day, and everything once a month.