How to Manage Café Inventory: A Step-by-Step Guide

How to Manage Café Inventory: A Step-by-Step Guide

Written by: JJ Tan, Founder, Jelly

Key Takeaways

  • A repeatable six-step weekly system cuts café inventory admin from 10–20 hours to under two hours each month.
  • Accurate PAR levels, FIFO rotation, and a waste log deliver food-cost variance below 1% week on week.
  • Standardised recipes and weekly 15-minute stock counts let operators react to supplier price changes within 48 hours.
  • Manual systems break down beyond a single site, and dedicated software becomes essential once weekly admin exceeds three hours.
  • Book a demo, schedule a chat to see how Jelly automates the entire flow and typically pays for itself in the first week.

What You Need Before You Start

Gather the following before setting up the system:

  • Supplier invoices from the last four weeks
  • Current recipes or a working recipe list
  • A basic POS sales report (daily or weekly)
  • A quiet 30-minute window each week, on the same day and at the same time

You can run everything with a spreadsheet and a consistent routine. The aim is a repeatable process that you can refine over time.

Why a Weekly Inventory Routine Protects Your Margin

UK café staples are among the most volatile input costs in hospitality. Robusta prices rose approximately 145% from 2021 to 2025 while Arabica increases were substantially lower than 230%. On dairy, UK farmgate milk prices fell by more than 10 pence per litre for some processors between October 2025 and February 2026, then wholesale cream prices rose 24% in March 2026, all within the same quarter. Available data show foodservice price inflation around 2.9% annually in mid-2026, and UKHospitality has not reported 9% food price inflation for 2026, with foodservice costs rising faster than retail.

A structured inventory routine turns that volatility into something you can manage. Operators who track stock weekly react to price changes within 48 hours, negotiate supplier credits with hard data, and hold food-cost percentages within a 1% variance. They avoid discovering margin erosion weeks later in a monthly accountant’s report.

Step 1: Categorise and Label Every Storage Area

Divide every item in your café into four groups and label storage areas accordingly:

  • Dry goods, such as coffee beans, sugar, flour, syrups, packaging
  • Chilled, such as milk, dairy alternatives, butter, cream, fresh pastries
  • Frozen, such as bread dough, ice cream, frozen pastry
  • Beverages, such as soft drinks, juices, bottled water

Label every shelf with the category and the PAR level that you set in Step 2. Clear labelling means any team member can count stock accurately, not just the person who built the system.

Step 2: Set and Adjust PAR Levels for Key Lines

A PAR level is the quantity you want a line topped up to so that you reach the next delivery without running out and without overstocking. Start with your top 20 lines, the items that account for most of your cash spend and most of your stockouts.

The standard formula is: PAR = (average daily usage × lead time in days) + safety stock. Pull the last 3–4 weeks of POS sales data for each item, multiply by the recipe quantity, and average daily demand rather than relying on guesswork.

The table below shows how this formula translates into practical PAR levels for five high-volume items in a typical single-site UK café. It highlights how lead time and safety stock differ by item type and how that affects the final PAR level.

Item Avg Daily Usage Lead Time (days) Safety Stock PAR Level Review Frequency
Semi-skimmed milk 6 litres 2 4 litres 16 litres Weekly (first month), then monthly
Oat milk 3.5 cartons 2 4 cartons 11 cartons Weekly (first month), then monthly
Espresso beans 1.1 kg 3 2 kg 5.5 kg Monthly
House pastries 18 units 1 6 units 24 units Weekly
Butter (bulk) 0.5 kg 2 0.5 kg 1.5 kg Monthly

For perishable items such as milk, cream, and fresh pastries, keep PAR levels tight to minimise waste, and accept that an occasional stockout often costs less than routine spoilage. Review PAR levels weekly for the first month, then monthly or quarterly as patterns stabilise. Adjust them temporarily for bank holidays or local events, then return to the baseline.

Step 3: Use FIFO and a Two-Bin System to Cut Waste

FIFO, or First In First Out, means older stock is always used before newer stock. Consistent FIFO rotation can reduce food waste significantly and protects margin on high-cost items.

The two-bin method makes FIFO physical and easy to follow:

  • Bin A (front) holds stock currently in use, date-labelled on arrival.
  • Bin B (back) holds new deliveries, placed behind Bin A.

When Bin A empties, move Bin B forward and place the new delivery in Bin B. Date every item on receipt. For chilled goods, write the use-by date on the label in marker pen. This takes under two minutes per delivery and removes one of the most common causes of spoilage in café kitchens.

Step 4: Log Daily Waste and Calculate Weekly COGS

Reducing food waste in a café with a tight net margin can lift net profit meaningfully. Waste that is not recorded never appears on the P&L and quietly inflates your food-cost percentage.

Use this one-page waste log daily and keep it visible in the kitchen or in a shared Google Sheet. The example below shows how small daily waste items, such as a single carton of oat milk or three unsold croissants, add up to a measurable cost when tracked consistently.

Date Item Quantity Wasted Unit Cost (£) Total Cost (£) Reason Logged By
14/08/2026 Oat milk 1 carton £1.40 £1.40 Past use-by AM
14/08/2026 Croissants 3 units £0.85 £2.55 End of day unsold AM

At the end of each week, total the waste column and add it to your COGS calculation: COGS = Opening Stock + Purchases − Closing Stock + Waste. Divide COGS by revenue to get your food-cost percentage. Any figure above your target triggers a review of PAR levels or portion sizes before the next week begins.

Book a demo, schedule a chat to see how Jelly tracks waste and COGS automatically in real time.

Step 5: Standardise Recipes in a Central Cookbook

Every dish and drink on your menu needs a standardised recipe card that lists each ingredient, the exact quantity used, and the unit cost from your most recent supplier invoice. When a new invoice arrives with a price change, update the unit cost in the recipe card so the dish cost and gross profit margin update immediately.

Here is a flat white recipe card example:

  • Espresso (18 g), cost from the current bean invoice
  • Semi-skimmed milk (180 ml), cost from the current dairy invoice
  • Takeaway cup, lid, sleeve, cost from the current packaging invoice

This forms the foundation of accurate menu pricing. Without it, a 10p per litre increase in milk cost goes unnoticed until the monthly P&L arrives, by which time hundreds of drinks have been sold at the wrong margin.

Step 6: Run a 15-Minute Weekly Stock-Count Routine

Café owners can complete a weekly inventory count in 30–45 minutes with the right system by prioritising a top 10–15 high-cost or high-volume items list, using consistent units and a pre-prepared form, and counting systematically. With a well-labelled store and clear PAR levels already in place, most single-site operations can complete the process in around 15 minutes.

The weekly routine follows a logical sequence that builds your margin report:

  1. Count every item in your top 15 by category (dry, chilled, frozen, beverage) so you know your closing stock.
  2. Record closing stock on your count sheet so you can calculate COGS accurately.
  3. Compare against PAR levels and order the difference to maintain stock without over-ordering.
  4. Calculate COGS using the waste log from Step 4, which gives you your actual food cost for the week.
  5. Update recipe card costs if any new invoices arrived this week so your theoretical food cost stays accurate.
  6. Note any variance above 1% for investigation, because the gap between theoretical and actual cost often reveals portion drift, unlogged waste, or invoice errors.

This 15-minute routine feeds directly into your weekly margin report and gives you the data to negotiate with suppliers, adjust portion sizes, or reprice menu items before problems compound.

Common Inventory Mistakes to Avoid

  • Under-counting milk. Dairy is the highest-volume perishable in most cafés and the easiest to miscount. Weigh or measure instead of estimating.
  • Ignoring portion drift on pastries. A croissant served with an extra pat of butter or a larger slice of cake erodes margin quietly. Standardise portion sizes and check them monthly.
  • Failing to record supplier credits. If a supplier delivers short or raises a price without notice, claim the credit note immediately and log it against that invoice. Unclaimed credits reduce margin.
  • Skipping the waste log on quiet days. Waste on a Tuesday matters as much as waste on a Saturday. Gaps in the log make COGS calculations unreliable.

How to Measure Success

A well-run manual system delivers three measurable outcomes within four to six weeks:

  • The admin time savings described earlier start to appear and weekly inventory work becomes a short, focused task.
  • Variance stays within the 1% target established by the system, rather than drifting unpredictably.
  • The rapid response time to supplier price movements described earlier becomes part of the weekly routine.

If variance stays above 2% after six weeks, the most common causes are inconsistent portion sizes, unlogged waste, or invoices not being reconciled against deliveries. Address each in turn before adding extra complexity to the system.

When Manual Systems Become Unsustainable

A manual system works at one site with a stable menu and a disciplined team. It starts to break down when supplier prices change faster than the weekly count cycle, when a second site is added, or when the head chef leaves and institutional knowledge disappears.

The transition point is clear. Operators should consider dedicated inventory management software when a manager spends three or more hours a week on inventory admin tasks.

Jelly automates the entire flow described in this guide. Invoices are scanned automatically by photo or email, and every line item is digitised in real time. Ingredient costs update across every recipe the moment a new invoice arrives. The Price Alert feature flags every supplier price movement, giving operators the data to negotiate credits or switch suppliers before the week’s margin is lost. Amber restaurant in East London saves £3,000–£4,000 per month using Jelly’s invoice automation and price change alerts. Sushi Revolution reduced their monthly stocktake from 2–3 hours to 5–20 minutes after implementing Jelly.

Jelly connects with Square, Lightspeed, EPOS Now, and Toast, pulling item-level sales data in real time so gross profit margin stays live without a separate spreadsheet or a monthly accountant’s report. Setup takes under five minutes per integration.

Book a demo, schedule a chat to see the full automated flow in under 30 minutes.

Frequently Asked Questions

How often should I count stock in my café?

A weekly full count of your top 10–15 highest-cost and highest-volume items is the minimum effective cadence for a single-site café. This takes 15–30 minutes when storage is well-labelled and count sheets are pre-prepared. Daily spot-checks on perishables such as milk, dairy alternatives, and fresh pastries take 5–10 minutes before the morning rush and catch the most common sources of waste and variance. A monthly review comparing theoretical versus actual usage highlights systemic issues such as portion drift or unlogged waste. Quarterly full audits of every SKU help you review PAR levels and renegotiate supplier contracts.

Who should own the inventory process, the head chef or the owner?

The head chef should own the daily and weekly execution, including counting stock, logging waste, and updating recipe costs when invoices arrive. The owner or operations manager should own the weekly review, checking the food-cost percentage, approving orders above PAR, and acting on supplier price alerts. Separating execution from oversight creates accountability at both levels and prevents the system from collapsing when one person is absent. The critical failure point in many cafés appears when a single person owns both roles. If they are off sick or leave, the system stops. Document the process so any trained team member can run the weekly count.

How do I expand to multiple sites without duplicating admin effort?

The manual system described in this guide scales poorly beyond one site. Duplicating spreadsheets across locations creates version-control problems, makes consolidated reporting difficult, and doubles the admin burden with each new site. The practical approach is to standardise the system at your first site until food-cost variance is consistently within your target range, then move to a platform that centralises invoices, recipes, and margin reporting across all locations before opening the second site. Jelly is built for this transition. A single platform manages invoices, dish costing, and gross profit reporting across multiple sites at a flat rate of £129 per location per month, with no per-user charges.

What food-cost percentage should a UK café be targeting?

Most UK cafés target a food-cost percentage between 25% and 35%, depending on menu mix. Beverage-led operations with high coffee volumes typically sit at the lower end because espresso-based drinks carry strong margins even after bean price volatility. Food-led cafés serving cooked breakfasts or hot lunches tend to sit higher due to ingredient complexity and waste. The more useful metric is variance, which is the gap between your theoretical food cost, calculated from recipes and invoices, and your actual food cost, calculated from COGS and sales. A variance below 1% indicates the system is working. A variance above 2% signals unlogged waste, portion drift, or invoice discrepancies that need investigation.

How do I handle supplier price increases mid-week?

Under a manual system, the fastest response is to check the new invoice against the previous one line by line as soon as it arrives, update the affected recipe cards, and recalculate the gross profit margin on every dish using that ingredient. If the margin drops below your target, you can reprice the dish, substitute the ingredient, or contact the supplier to negotiate. The challenge with a manual system is the time this process takes, because every sale of the affected dish during that period is at the wrong margin. Jelly’s Price Alert feature flags every price movement the moment a new invoice is scanned, so you can make the decision the same day rather than at the end of the week.

Ready to Remove the Spreadsheet Layer Entirely?

The six-step system in this guide cuts your inventory admin and gives you accurate food-cost data. Jelly removes the remaining manual layer, including invoice entry, recipe costing, margin tracking, and supplier price monitoring, and replaces it with an automated workflow that takes minutes to set up and runs continuously in the background.

Operators using Jelly cut food costs by an average of 3% in the first three months and save 10–20 hours of admin every month. At £129 per location per month, the platform often pays for itself within the first week of catching a single supplier price increase.

Book a demo, schedule a chat and see exactly how Jelly fits into your existing operation.

Read Next