Restaurant Stock Management: The Ultimate UK Guide

Written by: JJ Tan, Founder, Jelly | Last updated: 9 August 2026

Key Takeaways

• Manual stock processes drain UK restaurant profit through overspend and waste. A repeatable, invoice-driven workflow built on eight foundations reverses that trend.
• Weekly physical counts, PAR levels, FIFO rotation, and variance tracking create manual foundations that deliver measurable cost control within 90 days.
• Moving from spreadsheets to automated invoice scanning and live dish costing cuts hidden labour hours and improves stock accuracy.
• Price alerts and structured supplier negotiation workflows can recover thousands of pounds each month by catching increases the same week they occur.
• UK operators using Jelly report cutting food costs by 3% and lifting gross profit by 2 points within the first three months.

Building a Reliable Restaurant Inventory Tracking System

Restaurant inventory tracking records what stock enters and leaves your kitchen so purchasing decisions rely on data, not instinct. A reliable system compares physical counts against theoretical usage to identify discrepancies, then feeds those findings into weekly food-cost calculations so you can act on variances before they compound.

A weekly stock check workflow for a UK restaurant uses the following steps:

1. Count on the same day each week, always before the delivery arrives, not from delivery notes.
2. Use two people, one counts and one records, then cross-check totals.
3. Record physical counts only, never estimate from memory or previous sheets.
4. Compare against PAR levels and flag any item sitting significantly over par.
5. Check HACCP compliance and use-by dates during the count.
6. Reconcile weekly food cost % using: (Opening stock + Purchases − Closing stock) ÷ Revenue × 100.

UK example: A restaurant with £10,000 weekly turnover targeting a 30% food cost should see roughly £3,000 in food spend. With 8% waste, that same site loses £12,480 per year, and consistent weekly counting recovers most of that loss. A downloadable PAR sheet template structures this count from day one.

Setting Practical PAR Levels for Restaurant Stock

PAR (Periodic Automatic Replenishment) sets the minimum on-hand quantity for each ingredient before a reorder triggers. The formula is: PAR level = (Average daily usage × Lead time in days) + Safety stock, where order quantity = PAR level − current stock on hand.

Use these steps to set PAR levels by category:

1. Gather 4–8 weeks of usage history per SKU before fixing any figure.
2. Segment by category. Fresh proteins and produce order 3× weekly with a 1-day buffer, dairy 2–3× weekly with a 1–2 day buffer, dry goods, frozen items, and beverages order weekly with a 3–5 day buffer.
3. Set separate weekday and weekend PARs where sales volumes differ significantly.
4. Align quantities to supplier pack sizes and round to carton multiples to avoid partial-case waste.
5. Review quarterly and after any seasonal menu change or supplier switch.

Teal Farm Pub-style example: A pub ordering chicken breast with 15 kg daily usage, a 2-day lead time, and a 1-day safety buffer sets a PAR of 45 kg. Current stock of 20 kg triggers an order of 25 kg, which removes guesswork and reduces over-ordering. A downloadable PAR sheet pre-formatted for these categories removes the setup work entirely.

See how Jelly automates PAR-level reorder triggers from your live invoice data, then book a demo to connect your suppliers in under five minutes.

FIFO Restaurant Stock Management for Compliance and Waste Control

Once PAR levels control how much you order, FIFO rotation ensures you use what you have ordered before it spoils. FIFO (First In, First Out) is not optional in UK commercial kitchens. Under the Food Safety and Hygiene (England) Regulations 2013, selling food past its use-by date is a criminal offence, and Environmental Health Officers inspect stock rotation directly during visits. FIFO acts as the primary compliance mechanism.

A practical FIFO rotation system uses these steps:

1. Check dates at every delivery and reject any item already past or close to its use-by date.
2. Place new stock behind existing stock in fridges, freezers, and dry stores every time.
3. Label every item with name and use-by date. FSA-aligned practice sets a maximum 72-hour shelf life for chilled ready-to-eat in-house prepared foods, including the day of preparation.
4. Use a weekday colour-code sticker system so any team member can identify the oldest stock at a glance.
5. Run a daily 10-minute FIFO check and pull anything at the front that is approaching its date, then prioritise it in that day’s prep.
6. Train all kitchen staff. FIFO only works when every person uses items at the front first, not just the head chef.

UK example: Incorrect stock rotation increases waste and erodes margin. A site turning over several hundred thousand pounds annually can recover substantial sums per year by implementing FIFO consistently, with 40–60% waste reduction from FIFO implementation achievable within four weeks.

Restaurant Inventory Management Excel Starter System

Single-site UK restaurants with stable menus can start with a well-structured spreadsheet. A functional restaurant inventory spreadsheet requires eight specific columns to move beyond simple counting and enable variance tracking.

The eight columns are:

1. Item name, standardised with no abbreviations.
2. Unit of measure, consistent across every row (grams, kg, litres, never mixed).
3. PAR level, calculated from the formula above.
4. Current stock, taken from physical count only.
5. Theoretical usage, based on sales data and recipes.
6. Variance, calculated as current stock minus theoretical usage.
7. Unit cost, updated from the most recent invoice.
8. Supplier, used for price comparison and negotiation reference.

Follow these steps to set up the spreadsheet:

1. List every SKU your kitchen uses, grouped by category.
2. Enter the most recent unit cost from each supplier invoice.
3. Calculate PAR levels using the formula above and enter them in column 3.
4. Conduct a physical count and enter results in column 4.
5. Add sales data from your POS to populate theoretical usage.
6. Lock the unit-of-measure column and audit it monthly. Inconsistent units are a common accuracy error in restaurant spreadsheets.

UK single-site example: A 70-cover London restaurant with 80 menu items can manage this spreadsheet in roughly 3–4 hours per week. A downloadable starter sheet pre-built with these eight columns removes the formatting work. Beyond two sites or 80+ items, the manual overhead usually outweighs the benefit.

Moving from Spreadsheets to Automated Stock Control

Manual inventory tracking using Excel creates hidden labour costs and persistent accuracy problems, including lost count sheets, inconsistent data entry, and constant recipe cost updates after every supplier price change. When procurement and inventory data live in separate documents, a time lag between deliveries and updated food-cost records becomes almost guaranteed.

The transition from spreadsheets to an automated system follows a clear sequence that builds on your existing sheet:

1. Audit your current spreadsheet and confirm the eight columns are present and units are consistent.
2. Identify your invoice flow by listing every supplier and how invoices currently arrive, such as email, paper, or portal.
3. Connect your POS. Platforms like Square, Lightspeed, EPOS Now, and Toast integrate directly with Jelly in under five minutes and deliver item-level sales data in real time.
4. Redirect supplier invoices to a dedicated inbox so every line item is scanned automatically.
5. Map POS items to dishes in a one-time step that links sales data to recipe costs.
6. Run both systems in parallel for two weeks to validate that automated figures match your manual counts.
7. Retire the spreadsheet once confidence in the automated numbers is established.

Jelly becomes the logical next step once manual foundations are in place. Invoice scanning, live dish costing, and price alerts replace the manual update cycle and free up your team. Sushi Revolution’s monthly stocktake dropped from 2–3 hours to 5–20 minutes after switching. The typical saving is 10–20 hours of admin per month. UK hospitality operators report an improvement in food cost percentage within the first three months of making this transition.

Connect your POS and supplier invoices in the first week, then schedule a demo to see the integration live.

Tracking Variance and Waste in Real Time

Variance shows the gap between what your recipes say you should have used and what your physical count shows you actually used. The formula is: Variance % = (Theoretical usage − Actual usage) ÷ Theoretical usage × 100. In unmanaged restaurant operations, inventory variance due to spoilage, waste, and shrinkage typically ranges from 3–8%, which creates a constant drain on margins.

Use this weekly variance reconciliation process:

1. Pull theoretical usage from your POS sales data and recipe costs.
2. Conduct a physical count at the same time each week.
3. Calculate variance per category and review proteins, dairy, and dry goods separately.
4. Investigate any variance above 3%. Common causes include over-portioning, unrecorded spoilage, or untracked staff meals.
5. Log findings in a variance log. A downloadable variance log template structures this by category and week.
6. Review trends monthly. A single week’s variance may be noise, while three consecutive weeks signal a process problem.

UK example: A variance on weekly revenue can equate to unexplained weekly loss that compounds into a significant annual amount. Tracking weekly rather than monthly catches this within days instead of at month-end when action comes too late.

Using Price Alerts to Negotiate with UK Suppliers

Supplier price creep is one of the most common and least visible margin threats in UK hospitality. Without line-item invoice data, price increases accumulate unnoticed until a monthly report reveals the damage, by which time weeks of margin have been lost.

The solution is a workflow that captures price changes at delivery and triggers immediate supplier challenges:

An alert-to-negotiation workflow:

1. Capture every invoice line item, manually or via automated scanning, so unit prices are recorded at delivery.
2. Compare each delivery price against the previous invoice price for the same SKU.
3. Flag any increase above a set threshold, for example 2%, for immediate review.
4. Contact the supplier within 48 hours of the flagged delivery, because faster challenges usually secure credit notes or price corrections.
5. Request a credit note or alternative SKU with documented price evidence.
6. Log the outcome, including accepted credits, rejected challenges, and supplier switches, to build a negotiation history.

Jelly’s Price Alert feature automates steps 2 and 3. Amber restaurant in East London uses Jelly’s price change alerts to spot increases the same week they happen, which enables faster supplier challenges and ingredient substitutions. The result is a consistent £3,000–£4,000 saved per month. Stuart Noble, Head Chef at Cairn Lodge Hotel, reported slashing food costs by 5% within a month of having every dish cost updated at his fingertips.

Measuring Food-Cost Percentage Impact Over 90 Days

The UK benchmark for restaurant food cost percentage is 28–35%. Tracking progress against this benchmark over 90 days confirms whether your stock management system works or needs adjustment.

Use this 90-day measurement sequence:

1. Week 1: Record your current food cost % using the formula described earlier. Treat this as your baseline.
2. Week 2–4: Implement PAR levels, FIFO, and weekly variance tracking, then record food cost % each week.
3. Month 2: Activate price alerts and begin the supplier negotiation workflow, tracking credits received.
4. Month 3: Compare current food cost % against baseline and calculate gross profit movement in percentage points.
5. Ongoing: Use a Flash Report, which gives a daily, weekly, or monthly view of GP margin calculated from invoice costs and POS sales, so you maintain visibility without waiting for month-end accounts.

2-point GP lift example: Sushi Revolution achieved gross profits 2–3% higher on average by using Jelly to set separate target GP figures for dine-in and delivery menus. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. These results match the improvements described earlier, with a 3% reduction in food costs and a 2-point GP lift.

See your current GP position before your next supplier order, then book a demo to explore Jelly’s Flash Report.

Conclusion and Next-Step Checklist

The system in this guide, built on weekly tracking, PAR levels, FIFO rotation, a starter spreadsheet, automation, variance monitoring, price alerts, and food-cost measurement, forms a complete, repeatable workflow. Each element builds on the previous one, and the cumulative effect within 90 days is a 3% reduction in food costs and a 2-point lift in gross profit for most UK operators who apply it consistently.

Assess your current process against this checklist:

• Weekly physical stock counts completed on the same day each week
• PAR levels set per SKU with category-specific safety buffers
• FIFO labelling and rotation followed by all kitchen staff
• Eight-column inventory spreadsheet, or equivalent, maintained with consistent units
• Invoice data captured at line-item level within 24 hours of delivery
• Weekly variance calculated and logged by category
• Price alerts active for all key supplier SKUs
• Food cost % tracked weekly against the 28–32% UK benchmark

Any gap in this checklist creates a margin leak. The manual foundations described here provide the right starting point. Jelly then becomes the logical automation layer once those foundations are in place, removing spreadsheet maintenance, surfacing price changes automatically, and keeping GP visible every day rather than once a month.

---

Frequently Asked Questions

What is the difference between PAR level and reorder point in a restaurant?

A PAR level is the total on-hand quantity you want to maintain for each ingredient, which acts as the target stock level before a top-up triggers. A reorder point is the quantity at which you place an order. For most UK restaurants these are the same figure, because when stock falls to the PAR level you order enough to return to that level. The distinction matters more in operations with long supplier lead times, where you may need to reorder before stock reaches the PAR level to avoid running out. The formula for both starts with average daily usage multiplied by lead time in days, plus a safety buffer, typically one day’s usage for perishables and three to five days for dry goods.

How often should a UK restaurant conduct a full stock count?

A full physical count should happen weekly for most UK restaurants and should be conducted on the same day each week before deliveries arrive. High-value or high-waste categories such as fresh proteins, seafood, and premium spirits benefit from a daily spot-check rather than waiting for the weekly count. Monthly full counts are insufficient for active margin management because a four-week gap between counts allows price changes and waste to accumulate undetected. Quarterly counts work only for slow-moving dry goods and non-perishable supplies where daily usage stays minimal and predictable.

What is a realistic food cost percentage target for a UK pub or restaurant?

The widely cited UK benchmark is 28–32% of revenue for food cost. Pubs with a strong wet trade and lighter food menus often operate at the lower end of this range. Restaurants with complex tasting menus or high-quality protein-heavy dishes may sit closer to 35%. The more useful metric is gross profit margin, the percentage of revenue remaining after food costs, which most UK operators target at 65–72%. The goal of the 90-day system in this guide is to move food cost percentage down by 3 points and gross profit up by 2 points from your current baseline, rather than chasing an industry average that may not reflect your menu mix.

Can Jelly work alongside the POS system already in use at my restaurant?

Jelly integrates natively with Square, Lightspeed, EPOS Now, and Toast through real-time API connections. Each integration delivers item-level sales data the moment a transaction completes, and setup across all four systems takes approximately five minutes. Once connected, Jelly maps POS items to dishes in your recipe book so that every sale automatically updates your live gross profit margin. For operators using other POS systems, Jelly continues to add integration partners, and invoice automation and price alerts remain available independently of the POS connection from day one.

How quickly does Jelly generate value after onboarding?

Most kitchens gain access to price alerts and spending insights within 24 hours of photographing their first invoices into Jelly, or immediately when suppliers begin sending invoices to a dedicated Jelly email address. The Price Alert feature, which flags every ingredient price increase or decrease by supplier, is typically the first feature operators act on, using it to challenge supplier invoices and claim credit notes within the first week. Dish costing and live GP margins become available once recipes are built in the Kitchen section, which takes a few hours for a typical menu. The average Jelly customer cuts food costs by 3% and adds 2 percentage points to gross margins within the first three months.