A cup of coffee looks like a single item on the shelf, but inside, milk, a shot, syrup, and the cup all melt together. Portion-based consumption makes traditional unit stock tracking misleading.
If sales are not tied to recipes, inventory discrepancies grow and costs become blurred. Cafe stock control is a chain stretching from the menu card to the warehouse shelf.
In this article, we covered recipes, modifiers, waste, supply, and counting routines. The goal is to ensure every sale correctly deducts the raw materials.
Table of Contents
Why is cafe stock management difficult?
The unit of sale and the unit of raw material are often different. When a latte is sold, milliliters of milk and grams of coffee are deducted.
Open products, unweighed usage, and tasting waste widen the discrepancy. A kitchen without recipes turns counting into guesswork.
Fast service during peak hours loosens recording discipline. Lax record-keeping disrupts the next day's count.
Although cafe and restaurant processes look similar, the portion scale is smaller. Small deviations turn into large amounts at high volumes.
You can read about the general restaurant framework from the what is a restaurant management system article. Cafe inventory is the application of that framework at the portion scale.
Portion recipe
A standard recipe must be defined for every menu item. The recipe specifies which raw materials and in what quantities a sale consumes.
Items like shots, milk, syrup, cups, and lids must be on separate lines. A recipe crammed onto a single line does not produce analytics.
Unit consistency is critical; grams and milliliters must not be mixed. The wrong unit generates errors that compound stock deductions.
Recipe currency is also a must; when the menu changes, the recipe must be updated on the same day. An old recipe ties correct sales to the wrong stock.
We explained the BOM logic at a basic level in the what is a product recipe BOM article. A cafe recipe is the same logic adapted to smaller portions.
Modifier effect
An extra shot, almond milk, or syrup change alters the recipe instantly. If the modifier is not reflected in stock, the discrepancy grows.
The added or subtracted raw material amount of every modifier must be defined. Free-text "special requests" do not produce stock deductions.
The distinction between paid and free modifiers affects costs. Free extras silently erode gross profit.
Barista training must also cover sticking to defined modifiers. Undefined changes make reports unreliable.
We covered the modifier and tip side in the cafe modifier and tip management article. Defined options protect both revenue and stock.
Waste tracking
Cafe waste consists of spilled milk, burnt shots, spoiled dough, and tastings. These must not be confused with sales deductions.
Waste records must be logged with a reason code during the same shift. Waste left until the end of the day rounds off the quantities.
If training waste is tracked separately, the true loss becomes visible. An increase in waste during a new staff period is an expected curve.
Items with high waste require recipe or equipment checks. Constantly spilled milk may indicate a process error.
Establish kitchen waste discipline together with the kitchen waste tracking article. The same recording language should be used at the cafe bar as well.
Supply planning
Cafe supply must be based on sales forecasts and recipe consumption. Ordering by eye creates either excess stock or shortages.
Milk and fresh products require short cycles; dry coffee can be kept longer. Order frequency should be separated according to shelf life.
Unit and code consistency is important on the supplier card. Entering the same product with two codes breaks the count.
The minimum stock threshold can be defined separately for busy weekends. A single threshold assumes weekdays and weekends are the same.
We explained the supplier card layout in the supplier cards and multi-codes article. A clean card structure cuts off ordering errors right from the start.
Counting routine
Daily quick counts focus on critical open items. Weekly full counts cover the warehouse and the bar together.
Open milk and syrups must be measured by weight or scale. Eyeballing it does not match recipe deduction.
The counting time should be chosen close to shift closing. A count done in the middle of a busy service misses movement.
For items with discrepancies, first check the recipe and modifiers. Pressing waste immediately erases the root cause.
To tie the count with the shift closing, use the shift opening closing X Z report discipline. Closing and counting must proceed in the same language.
Portion cost
Recipe cost is the real basis of the menu price. When raw material prices change, portion costs must be recalculated.
The cost impact of modifiers must be tracked separately. If the extra shot fee does not cover the added cost, profit melts away.
The difference between theoretical cost and actual consumption shows waste and portion variance. This difference produces training or equipment decisions.
Menu engineering should not look at popularity alone. High sales with low margins can bloat turnover and kill profit.
We deepened portion cost calculations in the restaurant portion and recipe cost article. Cafe menus should also be read with the same cost discipline.
Reporting
A daily report should put sales, theoretical consumption, and waste summaries side by side. Turnover alone does not tell the story of stock health.
Modifier intensity and free extra ratios should be monitored in weekly reports. These two items silently erode margins.
In the monthly overview, supply price changes and recipe costs are read together. If price increases are not reflected on the menu, profits shrink.
Connecting the report to action is essential; at least one prescription or process correction should be targeted every month. The distributed PDF alone is not enough.
You can adapt the manager KPI set from the daily KPI set for managers article to the cafe scale. The same clarity is required in a small business.
Along with the existing system
EQLEM is a solution platform; it does not replace your existing ERP system. While cafe operations proceed on the ground, financial record discipline remains in place.
Stock and cost cards can continue on the Mikro or Logo side. The platform completes recipe deduction and shift logging.
The restaurant web side is mature; mobile coverage may be partial. Channel expectations must be clarified from the start during setup.
Until double data entry ends, recipes and accounting inventory diverge. Writing a single sale differently in two places destroys trust.
Read this model together with the how to end double data entry article. Without a single source of truth, portion costs become debatable.
Points to consider
Sales deductions without recipes are the most common breakage point in cafe inventory. A recipe must be attached as soon as a menu item is created.
Leaving modifiers as free text blinds the inventory. Defined options must be made mandatory.
Cash register (ÖKC) firmware updates are outside the scope of this article. Inventory control and fiscal device software should not be confused.
The expectation of mobile usage should not be exaggerated; the restaurant web is mature, mobile may be partial. The scope must be clearly written in the contract.
Evaluate integration boundaries along with the on-prem agent article. Vague connections inflate subsequent maintenance burdens.
Frequently asked questions
Is a separate recipe required for every coffee?
Yes; if the size and milk type are different, a separate recipe or modifier must be defined.
Do modifiers affect inventory?
They must; if extra shots or milk changes are not reflected in raw material deductions, the inventory count will be corrupted.
Do we need to change our existing ERP?
No need; EQLEM works alongside your existing ERP system and does not touch your financial record structure.
Is the mobile application full-featured?
The restaurant web side is mature; mobile coverage may be partial and is separately confirmed during setup.
Cafe inventory is kept by tracking portions, not by counting units. A variance in count is inevitable without linking recipes and modifiers.
Log waste in the same shift and track free extras separately. The difference between theoretical cost and actual consumption indicates the need for training.
Tie procurement to recipe consumption; eyeball ordering produces either excess or shortage. Align counting closer to shift closing.
Leaving your existing ERP in place and strengthening cafe operations is a low-risk path. Recipe stock separates before double entry ends.
Do not exaggerate mobile scope; the web is mature, mobile may be partial. Defining the scope upfront cuts off later debates.
By talking to the EQLEM team,you can clarify your cafe inventory and recipe scope. A short meeting makes it easier to bring portion tracking to the field.