Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Effective café stock control relies on PAR levels based on real usage data rather than guesswork or supplier recommendations.
- FIFO rotation with clear date labelling and daily spot-checks prevents spoilage and supports food safety compliance.
- Weekly tracking of waste and variance highlights patterns, reduces losses, and protects gross profit margins.
- A simple spreadsheet suits cafés with up to 30–40 SKUs, then automation helps once counts and admin consume too much time.
Why Café Stock Control Needs Its Own Approach
Café stock control works differently from restaurant inventory and needs its own system. Cafés rely on fast-moving perishables, tight margins, and short delivery cycles, so small mistakes show up quickly in profit and service.
- Short-shelf-life perishables such as milk, cream, and fresh pastries arrive on daily or every-other-day cycles, which leaves almost no margin for error.
- High-volume, low-margin items like milk and espresso beans mean that even small amounts of waste reduce profit directly.
- Supplier lead times for dairy are typically 24 hours or less, far shorter than the weekly protein deliveries a full-service restaurant manages.
- 60–70% of daily volume moves before noon, which concentrates demand into a narrow window and makes any stockout highly visible.
Food safety compliance adds another layer. The Food Standards Agency’s food safety management guidance requires UK food businesses to run a documented food safety management system. Proper stock rotation and date marking form part of that system, and inspectors will check for them. A low Food Hygiene Rating damages reputation and can affect your ability to trade.
What Is a PAR Level?
PAR stands for Periodic Automatic Replenishment. A PAR level is the minimum quantity of each item you need on hand to last until your next delivery, plus a safety buffer for unexpected demand. When your count drops to PAR, you reorder. When stock sits above PAR, you hold off.
PAR levels replace guesswork with a clear trigger. They reduce over-ordering, which creates waste, and under-ordering, which causes the Saturday morning stockout.
Step 1: Set Practical PAR Levels for Café Items
PAR levels start with a simple formula that you can apply across your menu.
PAR = (Average Daily Usage × Days Between Deliveries) + Safety Stock
To find your average daily usage, pull your usage data for the last four weeks and divide by 28 days. Safety stock for perishables usually sits between 10% and 25% of lead-time demand, with many cafés using 20–25% for critical items.
Here is a worked example for whole milk:
- Average daily usage: 12 litres
- Delivery cycle: every 2 days (Monday, Wednesday, Friday)
- Safety stock: 25% of cycle usage = 3 litres
- PAR = (12 × 2) + 3 = 27 litres
When the morning count shows 27 litres or fewer, you place an order.
For espresso beans with a weekly delivery, the calculation looks like this:
Daily usage 3kg, delivery cycle 7 days, safety stock 20%. PAR = (3 × 7) + 4.2 = 25.2kg, which rounds to 25kg.
The table below shows how the same formula applies across different items, with safety stock changing based on delivery frequency and perishability.
| Item | Daily Usage | Delivery Cycle | Safety Stock | PAR Level |
|---|---|---|---|---|
| Whole milk | 12 litres | 2 days | 25% | 27 litres |
| Oat milk | 6 litres | 2 days | 25% | 15 litres |
| Espresso beans | 3kg | 7 days | 20% | 25kg |
| Pastries (assorted) | 40 units | 1 day | 15% | 46 units |
Some café inventory guides (e.g., Coffee Shop Dashboard) recommend recalculating PAR levels monthly based on actual usage. Others suggest quarterly reviews, with more frequent adjustments for fast-moving items.
Step 2: Use FIFO and Date Rotation Every Day
FIFO means First In, First Out and keeps older stock moving before newer stock. It acts as the standard rotation method for café perishables and forms a core part of any food safety management system.
- When deliveries arrive, move existing stock to the front of the shelf and place new stock behind it.
- Label every item with its delivery date or use-by date using a permanent marker or adhesive labels.
- Train all staff to pull from the front of the shelf first, every time.
- Check date labels during daily counts and remove any items approaching their use-by date.
- Designate a clearly marked “use first” area in the fridge for items expiring within 24–48 hours.
For items with use-by dates rather than best-before dates, FEFO (First Expired, First Out) often works better. FEFO prioritises the earliest expiry date even if that item arrived later. This approach suits dairy products and ready-to-eat items.
The Food Standards Agency’s managing food safety guidance requires businesses to keep records of all suppliers and products received, including delivery dates. Inspectors can request those records at any time. Date labelling and rotation support the HACCP-based food safety management system that inspectors review.
Step 3: Build Daily and Weekly Stock Count Routines
Short, regular counts keep stock accurate without turning every week into a stocktake marathon. A mix of quick daily checks and one weekly full count gives you control with minimal disruption.
Daily checks (5–10 minutes before the morning rush) focus on the items most likely to run out. Start by counting high-turnover perishables such as milk, dairy alternatives, pastries, and coffee beans. Then compare each count against its PAR level. Any item at or below PAR goes on today’s order list. Finish by checking date labels on perishables and moving near-expiry items to the “use first” area.
Weekly full count (20–30 minutes, same day and time every week) covers every SKU. Count items in the same physical order each week so the routine becomes quick and repeatable. Use a standardised count sheet organised by storage area such as fridge, freezer, dry store, and behind the bar. Weigh open items instead of estimating partial packs. For high-value items such as premium single-origin coffee, run a two-person check.
Weekly counting is the non-negotiable cadence. Daily full counts tire staff, and monthly counts hide problems for too long. Counting at the same time each week also matters because inconsistent timing makes variance figures unreliable and hard to compare week on week.
The table below shows how a morning count compares against PAR levels and highlights what needs ordering that day.
| Item | PAR Level | This Morning’s Count | Need to Order? |
|---|---|---|---|
| Whole milk | 27 litres | 18 litres | Yes, order 9 litres |
| Oat milk | 15 litres | 12 litres | Yes, order 3 litres |
| Espresso beans | 25kg | 20kg | No, above PAR |
| Pastries | 46 units | 30 units | Yes, order 16 units |
Step 4: Track Waste and Variance Every Week
Waste tracking is essential for identifying where stock disappears. Without a record, you cannot pinpoint the cause of any shortfall.
Set up a simple waste log. A laminated sheet by the prep bench works well, or you can add a column to your spreadsheet. Record the date, item, quantity, and reason for every discard (for example, expired, spoiled, dropped, or over-prepared). Keep it to one line per event so each entry takes only a few seconds.
Variance is the difference between theoretical usage and actual usage. Theoretical usage is what you should have consumed based on sales. If you sold 200 lattes and each uses 6oz of milk, theoretical milk usage is 1,200oz, roughly 35 litres. If the physical count shows 40 litres used, you have a 5-litre variance worth investigating. A consistent inventory variance above 2% signals a process problem, and many operators aim for a variance under 1–2%.
Review waste logs weekly to spot recurring patterns, such as milk always expiring on Tuesdays or pastries consistently over-ordered on weekdays. Once you identify a pattern, adjust the following week’s order to match actual demand. A typical independent café running £40k–£80k of COGS per year can expect a 3% stocktake variance to cost £1,200–£2,400 annually, which is meaningful money for an independent operation.
Step 5: Use a Spreadsheet or POS for Faster Stock Control
Spreadsheets work well for cafés with up to 30–40 SKUs. Beyond that point, manual tracking becomes time-consuming and error-prone. A simple spreadsheet structure needs columns for item name, PAR level, current stock, variance, and reorder quantity. Basic formulas can calculate variance automatically.
If you use a POS system, check whether it offers inventory tracking. These systems can deduct stock automatically as items are sold. They still need regular physical counts to reconcile variance, but connecting a POS to your stock system moves you forward from pure manual tracking.
Jelly takes automation further by connecting your invoices, inventory, and POS data in one place. Jelly automatically scans every line item from supplier invoices and updates ingredient costs in real time. It also integrates with your POS to show live gross profit margins. Jelly eliminates the spreadsheet work entirely for café owners who spend 10–20 hours a month on manual stock admin. As Stuart Noble, Head Chef at Cairn Lodge Hotel, put it: “Price hikes were crushing our margins, I felt helpless. With Jelly, every dish cost is up-to-date at my fingertips. We slashed food costs by 5% in a month.”
Key Inventory Concepts to Refine Your System
How the 80/20 Rule Applies to Café Inventory
The Pareto principle applied to café inventory holds that roughly 80% of your stock value comes from 20% of your items. For most cafés, that top 20% includes milk, espresso beans, dairy alternatives, and a few high-volume ingredients.
The practical application is simple. Focus your daily counts on that top 20% and track their PAR levels carefully. The remaining 80% of items (syrups, packaging, and less frequently used ingredients) can be counted weekly or even monthly. Tracking four key numbers for your top 20 SKUs, on-hand quantity, PAR level, weekly usage, and waste rate, provides enough visibility to manage most of your stock risk without turning every shift into an admin exercise.
FIFO, LIFO, and JIT in a Café Context
Three inventory methods appear frequently in café stock control discussions. Each one plays a different role in practice.
- FIFO (First In, First Out): Use oldest stock first. This method suits perishables like milk and pastries and helps prevent spoilage while keeping products fresh.
- LIFO (Last In, First Out): Use newest stock first. This method rarely suits cafés because it increases spoilage risk for short-shelf-life items.
- JIT (Just In Time): Order stock to arrive exactly when needed, which reduces storage. This approach works for daily milk and fresh pastry deliveries, but it creates risk for items with longer supplier lead times.
For cafés, FIFO remains the standard for perishables. JIT works well for items delivered daily. LIFO has no practical application in café stock control and should stay out of any process that involves expiry dates.
Common Café Stock Mistakes and How to Fix Them
Most café stock control mistakes come from daily habits rather than from the overall system design.
- Setting PAR levels based on supplier recommendations instead of actual usage data.
- Leaving PAR levels unchanged across seasons, even though cold brew sales rise in summer and soup and hot drinks rise in winter.
- Counting at different times each week, which makes variance figures impossible to compare.
- Ignoring waste logs instead of reviewing them weekly to spot patterns.
- Ordering to a comfortable round number instead of the actual PAR calculation.
Data makes troubleshooting straightforward. If you consistently run out of an item, increase its PAR by 10–15%. If you consistently discard an item, reduce its PAR and explore whether you can order it more frequently in smaller quantities. Most suppliers have flexibility on delivery windows and minimum order quantities, and many will agree to changes when asked.
How to Measure Whether Your System Works
Once you have addressed common mistakes, you need a clear way to track performance. Four metrics show whether your café stock control system delivers results.
- Waste rate: Target under 4% of total purchases. Independent cafés should aim for a waste rate under 4% of purchases across both the coffee programme and food.
- Stockout frequency: Track how often you run out of best-sellers during service. The target is zero for core items.
- Inventory variance: Aim for under 2% between theoretical and actual usage per week, as discussed in Step 4.
- Gross profit margin: Expect margins to improve as waste falls and ordering becomes more precise.
A 3% reduction in waste on a café spending £60,000 per year on ingredients saves £1,800 annually. That saving matters for an independent site and grows as your system matures.
Advanced Tips and Next Steps
Once your manual system runs smoothly, a few extra steps can extend its value further.
- Recalculate PAR levels monthly using the previous month’s actual usage rather than estimates.
- Build a supplier scorecard that tracks delivery accuracy, time reliability, quality consistency, and billing accuracy so you can spot issues early.
- Negotiate delivery windows that work for your operation, such as a 5am–7am dairy window so stock is ready before the morning rush.
- Explore automation with Jelly. It eliminates manual data entry and gives you real-time margin visibility across every dish and supplier invoice.
Frequently Asked Questions
How often should I count café stock?
Daily spot-checks on high-turnover perishables such as milk, pastries, and coffee beans take 5–10 minutes and should happen before the morning rush. A full count of every SKU should happen once a week, on the same day and at the same time, ideally before deliveries arrive so your figures reflect true on-hand stock. Each month, review your variance data and recalculate PAR levels based on the previous four weeks of actual usage.
What is the golden rule for inventory management?
Stock should keep moving rather than sitting unused. Apply FIFO rigorously so the oldest product is always used first. Set PAR levels based on your own sales data instead of supplier recommendations or gut feel. Count consistently so your variance figures are comparable week on week. Stock that sits on shelves ties up cash, can spoil or go stale, and may be forgotten, and every item thrown away represents a full-cost loss with no revenue to offset it.
How do I calculate PAR levels for my café?
Use the formula: PAR = (Average Daily Usage × Days Between Deliveries) + Safety Stock. Track your actual usage for four weeks to establish a reliable daily average. As covered in Step 1, set safety stock at 10–25% of lead-time demand for perishables, with higher levels for items where a stockout disrupts service immediately, such as milk. Recalculate every month based on actual usage and adjust seasonally when demand patterns shift.
What should I do with stock approaching its use-by date?
Move it immediately to a clearly labelled “use first” area in the fridge. Incorporate it into specials, offer it to staff at a discount, or donate it to a local food redistribution scheme if it remains within date and safe to consume. Never serve food past its use-by date because it creates a food safety risk, may breach your food safety management obligations, and can damage your Food Hygiene Rating. Log every near-expiry item in your waste log, even if you ultimately use it, so you can see whether over-ordering sits behind the issue.
When should I move from spreadsheets to dedicated software?
As mentioned earlier, spreadsheets work well up to 30–40 SKUs. Signs that you have outgrown them include weekly counts taking longer than 45 minutes, waste tracking drifting away from your cost of goods calculations, recurring stockouts or waste events you cannot trace, or a manager spending three or more hours a week on inventory admin. At that point, a platform like Jelly, which automates invoice scanning, updates ingredient costs in real time, and integrates with your POS, removes the manual work and gives you live gross profit visibility without spreadsheet maintenance.
Take Control of Your Café Stock
The system in this guide has five components: PAR levels set from actual usage data, FIFO rotation with clear date labelling, daily spot-checks and weekly full counts, a waste log reviewed every week, and a spreadsheet or POS tool to hold it all together. Each component helps on its own. Together, they create a complete café stock control routine that cuts waste, prevents stockouts, and protects your gross profit margin without adding hours of admin to your week.
When you feel ready to move beyond spreadsheets, Jelly automates the entire process across invoices, inventory, and real-time profitability so you can focus on running your café rather than managing data. See how Jelly transforms café stock control in a free demo.