Inventory Shrinking But Not Showing Up in Sales? How to Track Internal Consumption
Staff drinking coffee, eating leftover pastries, or testing new recipes — all reduce stock without being recorded. Here's how to track it without creating a toxic workplace.
The Problem Nobody Talks About
Every day, ingredients leave your inventory without ever becoming a sale. Staff make coffee for themselves, eat a croissant that's about to expire, or test a new recipe. This is all normal — but if it's not tracked, your food cost numbers become misleading.
In a small cafe, this might be just Rp 30,000-50,000 per day. But multiply by 30 days? That's Rp 900,000-1,500,000 per month unaccounted for — significant for a small business.
Why a Total Ban Doesn't Work
Forbidding staff from eating or drinking anything is counterproductive. They work 8 hours surrounded by food and drinks — it's natural they'll consume some. And if you ban it outright, they'll still consume, just secretly. The result is worse: zero data whatsoever.
A better approach: allow but track.
Create a Clear Policy
- What's allowed: For example, every staff member gets 1 free drink per shift and may eat items that would otherwise be thrown away
- What's not allowed: Taking raw ingredients home, consuming without noting it, or eating fresh menu items that could still be sold
- How to record it: Every internal consumption gets logged — either in a simple notebook or through the POS (create an "Internal" or "Staff Meal" category)
Simplest Method: A Log Book
Place a small notebook in the kitchen/bar area. Every time staff consume something, write: date, name, item. No need for detail — just enough for aggregate tracking.
At month's end, total it up. Now you know how much "staff benefit cost" actually is — and you can include this in food cost calculations separately from waste.
Better Method: Log in the POS
Some POS systems let you create Rp 0 transactions or "internal" orders. This is better because it integrates directly with reports — you can see how much internal consumption happens per month without manual counting.
Communication Is Key
Explain to the team: "This isn't about distrust. It's about making our food cost data accurate. If we don't know how much is used internally, we can't calculate real margins — and that means we can't make good business decisions."
The right framing transforms tracking from "surveillance" into "business tool." And staff who understand the context are usually more cooperative than those who are just told to comply without explanation.
How Big Is the Impact?
You might be surprised. Many cafe owners who first track internal consumption find it's 3-5% of total COGS. That's not a small number — and it's a number that was invisible in their reports until now.
Tracking isn't about eliminating internal consumption — that's a fair benefit for staff. Tracking is about making sure you know how much it costs, so you can factor it into accurate business calculations.