How To Run a Physical Inventory Count for UK Venues

Written by: JJ Tan, Founder, Jelly

Key Takeaways

• Perpetual inventory tracks theoretical stock while physical counts verify actual stock. The gap between them reveals margin leakage.
• UK venues benefit from a risk-based count schedule that focuses effort on high-value, high-risk categories such as premium proteins and alcohol.
• Physical counts work best when they are blind, based on weighing rather than estimating, and followed by variance analysis.
• Food cost percentage uses the formula (Opening Stock + Purchases − Closing Stock) ÷ Food Sales (ex-VAT) × 100, with both sides kept on a net-of-VAT basis.
• Jelly keeps the perpetual baseline accurate through automated invoice scanning and live dish costing so every physical count becomes a precise diagnostic tool.

See Jelly In Action For Your Venue

The Problem: Why The Gap Between Perpetual And Physical Stock Matters

Most UK restaurant, pub and hotel operators maintain some form of perpetual record, whether a dedicated system or a spreadsheet updated after deliveries. Without a physical count, actual food cost can run 5–15 percentage points above theoretical without anyone detecting it until the P&L no longer balances. The count is the audit that verifies the system. A reliable perpetual baseline gives the count meaning, and a physical count keeps the perpetual system grounded in reality.

The table below clarifies what each method shows.

For a deeper look at how stock control and inventory management interact day to day, see Stock Control Vs Inventory Management: Two Jobs, One System.

Talk Through Your Stock Challenges

A Practical Risk-Based Count Schedule For UK Venues

Weekly inventory is the standard for UK restaurants actively managing food cost, with monthly as the minimum frequency to detect variances before they become a significant financial problem. Running a full count on everything every week is neither practical nor necessary. The 80/20 rule applies: 80% of your variance comes from 20% of your items. Focus counting effort on high-value, high-risk categories.

A practical UK count-frequency schedule by category:

• Premium Meats And Seafood: Count daily or at every delivery. In fine-dining operations, daily inventory of high-value proteins and seafood is standard practice. High value and high spoilage risk make this essential.
• Alcohol And Cellar: Count weekly. These items carry high value and high theft risk. For pubs, a hybrid approach of weekly in-house counts on fast-moving lines combined with a proper independent stocktake monthly or six-weekly is the recommended standard.
• Fresh Produce And Dairy: Count two to three times per week. Perishable stock deteriorates quickly and ordering errors compound fast.
• Dry Goods And Frozen: Count monthly. Low value and low variance make frequent counting an inefficient use of labour.
• Full Count: Complete a full count once a month for reporting and GP calculation.

Cycle counting, which means counting a rotating subset of items rather than everything at once, gives most venues a workable middle ground. Cycle counts spread the workload, catch errors before they compound, and allow high-value categories such as proteins and alcohol to be counted weekly while low-velocity dry goods are covered monthly. For hotel operations, each outlet, such as lobby bar, restaurant bar, function stock and cellar, should be counted separately because a single building-wide count can average out a tight outlet with a leaking one and hide the problem entirely.

For pub-specific guidance on real-time stock tracking, see Pub Inventory Management: Real-Time Stock Tracking For Pubs.

How To Run A Reliable Physical Inventory Count

Preparation

Freeze deliveries before counting begins. Confirm all morning deliveries are fully logged before counters enter the walk-in, and freeze pending purchase orders and transfers in the inventory system. Print count sheets organised by storage area, such as walk-in, dry store and cellar, rather than by supplier or category. Use blind counts and keep expected figures away from the counter, because anchoring bias causes staff to unconsciously round toward what they expect to see, corrupting data on high-value proteins and alcohol.

Execution

• Weigh items instead of guessing. Count in purchase units rather than cooking units, for example 5-litre oil containers and tenths of a container rather than millilitres, to reduce unit conversion errors.
• Count by area, not by supplier. Follow a fixed route such as day fridge, night fridge, cold store and dry store. A random-order inventory is slower and more prone to counting errors.
• For alcohol, use the tenths method. Estimate to the nearest tenth of a bottle and record as a decimal, for example 0.7.

Recording

• For high-value items, two people should conduct the count, one counting and one recording, because solo counting of expensive items is more error-prone and more susceptible to manipulation.
• Record figures immediately and avoid batch-recording from memory.
• After the count, complete a shelf organisation pass to consolidate like items before the next count cycle.

For a full walkthrough of automating this process, see How To Automate Restaurant Inventory With Real-Time Tracking.

Why Physical And Perpetual Stock Figures Rarely Match

A variance between your perpetual record and your physical count is a diagnostic signal to investigate, not a problem to correct. Inventory variance analysis is not a reporting problem, it is a diagnostic problem. A single variance number is the starting point of an investigation, not the end of it.

Work through the following diagnostic sequence in order before drawing conclusions:

1. Unrecorded Waste And Spoilage: Check the waste log. Unreported wastage is one of the five primary causes of stock variance. Confirm whether the waste was recorded at the time it occurred.
2. Delivery Discrepancies: Pull the Goods Received Note for every delivery and compare it against the purchase order and supplier invoice. In one worked example, a system expecting 18 kg of chicken against a physical count of 16.5 kg was explained by the supplier physically delivering 8.5 kg while 10 kg was recorded on the GRN.
3. Over-Portioning: Confirm that staff use scales. If a recipe specifies 150 g but the team consistently plates 180 g, actual food cost on that dish is 20% above theoretical. Check portion compliance against recipe specifications.
4. Recipe Or Menu Changes: Confirm that the menu and recipes in the system match what the kitchen now serves. Using old recipes after menu changes is one of the most common restaurant inventory tracking mistakes.
5. Unit Conversion Errors: Check pack sizes carefully. Receiving one case containing 24 cans must increase available stock by 24 cans, not one unit.
6. Theft And Shrinkage: Treat residual unexplained variance as a shrinkage indicator once other causes are eliminated. Portioning inconsistency accounts for approximately 42% of inventory variance, untracked waste for 31%, shrinkage and theft for 18%, and system data errors for 9%.

Investigating the cause of every variance rather than simply adjusting stock to match the count is essential. Correcting the perpetual record without understanding the gap means the same loss will recur next week.

That investigation is only as fast as your delivery and recipe data. Jelly’s automated invoice scanning captures every line item at the point of delivery, so discrepancies between the GRN and the invoice are flagged instantly rather than discovered weeks later. Live dish costing updates GP margins in real time as each invoice lands, which makes portion drift visible the moment ingredient costs shift. The Price Alert feature flags every supplier price increase or decrease, so you know immediately whether a variance is a cost issue or a usage issue.

See How Jelly Speeds Up Variance Checks

How To Calculate Food Cost Percentage From A Physical Count

The standard formula used in UK hospitality accounting is (Opening Stock + Purchases − Closing Stock) ÷ Food Sales (ex-VAT) × 100.

A worked example in GBP:

• Opening Stock: £4,000
• + Purchases: £12,000
• − Closing Stock: £3,800
• = Cost of Goods Used: £12,200
• ÷ Food Sales (ex-VAT): £38,000
• = Food Cost Percentage: 32.1%

VAT Note: UK restaurant food-cost calculations must keep both sides on the same tax basis: supplier purchase costs excluding recoverable VAT, and sales revenue excluding VAT. Mixing VAT-inclusive costs with VAT-exclusive revenue distorts the percentage. For a 20% VAT item, including VAT-inclusive revenue without adjustment overstates GP by around 16.7%. For a 20% VAT supplier invoice, divide the gross price by 1.20 to obtain the net cost. Dividing by VAT-inclusive sales would understate the apparent food-cost percentage: using a gross £54,000 figure instead of the correct £45,000 net figure would show 28.1% instead of the true 33.8%. For current HMRC guidance on VAT treatment in hospitality, operators should confirm the applicable rate for each category of supply.

Jelly automates this by digitising every invoice line item, including quantity, SKU, price and tax, and calculating ex-VAT costs automatically. This approach keeps GP margins accurate and avoids distortion from tax-basis mismatches.

Accurate food cost figures also make waste visible. WRAP estimates that the UK hospitality and food service sector wastes around 1.1 million tonnes of food annually, with a value of approximately £3.2 billion. For stock rotation and FIFO guidance relevant to reducing that waste, the Food Standards Agency publishes guidance on food storage and shelf life applicable to UK commercial kitchens.

Introducing Jelly: The Perpetual Baseline That Makes Every Count Meaningful

Jelly helps growing restaurants, pubs and boutique hotels manage their food and beverage operations. It automates invoices, inventory and real-time menu profitability. Jelly keeps your perpetual baseline accurate so every physical count becomes a precise diagnostic tool rather than a guessing game.

Key features work together to support that baseline:

• Automated Invoice Scanning: Capture every line item via email or photo. Every quantity, SKU, price and tax figure is digitised without manual entry.
• Live Dish Costing: Update GP margins in real time as invoices land. A red percentage appears if a dish drops its margin and green if it improves.
• Price Alert: Flag every supplier price increase or decrease instantly, giving you evidence to negotiate credits or switch suppliers.
• POS Integrations: Connect with Square, EPOS Now, Lightspeed and Toast to receive item-level sales data the moment a transaction completes.
• Accounting Integration: Push data to Xero with one click, with Sage support coming soon, and cut bookkeeping time by up to 90%.

Jelly customers report cutting food costs by 3% on average in the first three months and adding 2 percentage points to gross margins. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Cairn Lodge Hotel’s Head Chef Stuart Noble reported: “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.”

Pricing is a flat £129 per month per location, with no variable charges per user or feature. Onboarding generates initial value within the first week.

Get A Personalised Jelly Walkthrough

Conclusion: Turn Every Count Into A Diagnostic Tool

The perpetual system provides the operating baseline and the physical count provides the verification layer. The gap between them is where margin leaks through the causes diagnosed above. An inventory count filed without comparing it to theoretical usage becomes a ritual with no value. The value sits in the variance analysis and the diagnostic workflow that follows.

Jelly keeps your perpetual baseline accurate with automated invoice scanning and live dish costing, so every physical count produces a meaningful variance figure rather than a number with no reference point. When the gap appears, you have the data to diagnose it immediately, not weeks later when the evidence has gone cold.

Start Turning Counts Into Insight