Written by: JJ Tan, Founder, Jelly

Key Takeaways

  • Hospitality stock control tracks food, drink and supplies from delivery to service so operators can compare theoretical usage against actual usage and protect margin.
  • The core formulas are COGS (opening stock plus purchases minus closing stock) and GP (net sales minus COGS), with accurate current pricing essential for reliable benchmarks.
  • Effective stock control follows five practical steps: audit and categorise stock, apply FIFO rotation, set and review par levels, count regularly, and analyse variance promptly.
  • Wet stock variance in pubs requires specific controls for line cleaning, over-pour, part-bottle weighing and legal measure compliance to avoid hidden losses.
  • Jelly automates invoice capture, keeps live recipe costs and GP margins current, and onboards in the first week at a flat £129/month per location, helping UK operators cut food costs by 3% on average.

Talk To Jelly About Your Stock Control

The Five Steps Of Stock Control In A Pub Or Restaurant

Stock control in a pub or restaurant comes down to five repeatable steps. Each one below includes the operational detail that makes it usable in a working kitchen or cellar.

  1. Audit And Categorise. Split stock into wet (draught, spirits, wine, mixers), dry store, chilled, frozen and non-food. A 60-line spirits list and a 200-line dry store need different count frequencies. Spirits and other wet stock should be counted weekly (with spot checks on high-value lines even more often), while dry store goods are counted fortnightly or monthly depending on volume. Categorising first means the count cadence matches the risk instead of the supplier’s delivery schedule.
  2. FIFO And Rotation. Date-label every delivery and push older stock forward. A Friday keg goes behind last Tuesday’s. FIFO rotation with date labelling on stock is a standard stock control practice, with ‘use by’ dates checked daily and the full stock control check (including back-of-shelf and stockroom) recorded weekly. LIFO does not apply to physical stock rotation in UK pubs and food service because it would leave older stock to spoil and create food safety risks under retained Regulation (EC) 852/2004 and the Food Safety Act 1990. FIFO is also the standard practice and the most common stock valuation approach under FRS 102.
  3. Set Par Levels. Par level equals daily usage multiplied by days between deliveries, plus a safety buffer. Order the difference between par and projected stock on delivery day. Par levels set once at opening guarantee both stockouts and spoilage as sales mix shifts. Review them monthly so they track current trading patterns.
  4. Count Regularly. Run a full count weekly at the same time each week. Add daily spot counts on the top ten cost lines: proteins, spirits and any ingredient running a recent variance. Monthly variance figures are too stale to act on. A leak running four weeks cannot be traced to a specific shift.
  5. Analyse Variance. Compare theoretical usage (POS sales multiplied by recipe quantities) against actual usage (opening stock plus purchases minus closing stock), priced per item. Express the gap as a percentage of theoretical and treat that number as the investigation target.

How To Run A Stocktake Around Service

Timing is the first operational decision because a count is only a baseline if nothing moves while you are counting it. That means counting at the end of trading or before deliveries arrive, never mid-service. Splitting wet and dry follows the same logic, so the cellar is not being counted while the bar is pouring. A count that starts at 11pm on a Sunday and finishes before Monday’s delivery is a defensible baseline. A count that runs across a shift change is harder to defend.

Use two people so one calls and one records. Lay out the sheet to match the physical walk through the storeroom instead of the supplier’s invoice order. A shelf-to-sheet layout cuts the time spent searching and reduces the risk of skipped lines.

Unit consistency keeps the numbers honest. Weigh part bottles and proteins rather than eyeballing. Convert cases to base units before recording. Spirits count in 25ml or 35ml measures, draught in pints, wine in 125ml or 175ml. A barcode confirms a bottle exists, but it does not show how much is in it.

Defensible counts rely on locked sheets, named counters, timestamped entries and no edits after submission. Count locking and audit trails linking every entry to a named user and timestamp are the controls that make a variance arguable with evidence rather than memory. When a stocktaker raises a chargeback, what was written down on the day is the document that carries weight.

A downloadable stocktake and variance sheet, laid out shelf-to-sheet and including the six-question diagnostic sequence from the variance section below, is available from Jelly’s team when you book a demo.

That sheet works for dry stock. Wet stock needs its own controls because the losses come from different places.

Wet Stock For Pubs: Cellar, Line Cleaning And Draught Yield

Wet variance behaves differently from dry variance, and the difference sits in the cellar. A well-run UK pub loses roughly 4–6% of draught beer volume to physical causes before anything has gone wrong, including line-cleaning day losses, fob at keg changeover, beer left in the keg and drip trays. That loss is real and measurable and should be logged as a stock event instead of absorbed silently into variance.

Cellar management acts as a control point. Temperature instability accelerates fob and increases line-cleaning frequency. Line cleaning should be logged as a stock event with the volume lost recorded, not treated as an afterthought. Operators should ask their stocktaker what draught allowance is applied line by line, because a blanket allowance can either excuse an honest pub or hide a real problem.

Over-pour is a measure problem rather than a training problem. A 25ml spirit served at 35ml gives away 40% extra stock on every pour, and a consistent half-measure overpour across a full spirits range adds up to thousands of pounds a year. The law fixes the measure for a reason. Under the Weights and Measures Act 1985 as amended by the Weights and Measures (Intoxicating Liquor) (Amendment) Order 1994, gin, rum, vodka and whisky must be sold for on-premises consumption in 25ml or 35ml measures. The measure functions as a legal control point. Stamped dispensing equipment must remain intact, and section 16 of the Act makes forging, altering or defacing a stamp a criminal offence.

Part bottles should be weighed instead of guessed. Eyeballed tenths are the single most common source of false wet variance on a spirits line.

Recipe Costing And Batch Cards: Where Depletion Actually Comes From

Recipe cards and batch cards for sauces, prepped stocks and batch cocktails tell the system to deplete ingredients rather than bulk orders. Without them, a POS sale of a dish removes nothing from stock at ingredient level, and the count becomes the only source of truth. With them, every sale depletes the recipe behind the dish, and the count becomes a check on that depletion instead of the entire calculation.

Wastage percentages must sit on the card. A recipe specifying 180g of protein that is consistently served at 200g produces a 10% ingredient overconsumption per serve. At 200 covers per day this accumulates rapidly. The fix sits in training or equipment calibration, but the card must reflect the actual yield instead of an idealised one.

A wrong recipe card rarely shows up as a costing error. It shows up as variance. If the card says 180g and the kitchen serves 200g, the stock loss is real and the card is the cause. Investigating the variance without checking the card first wastes time and produces the wrong corrective action. See the Restaurant Stock Management: The Ultimate UK Guide for a full walkthrough of recipe-card construction and batch costing.

Investigating Variance: A Diagnostic Sequence

A gap of 1–2% between theoretical and actual GP may be acceptable, but anything above that warrants investigation that identifies the operational cause, not just the number. The sequence below applies to a 4% variance on a food or wet line. Work through it in order and rule out data errors before blaming the team, because that route reaches the real cause fastest.

  1. Is It A Data Error? Duplicate ingredient records, counts saved as drafts rather than submitted, and deliveries received without a goods received note (GRN) are the most common sources of false variance. Rule these out before any other investigation.
  2. Is It Price Or Usage? A spike after a delivery cycle points to a supplier price change. A steady week-on-week gap points to usage. Under the Masterestaurant method, recipe re-costing is triggered automatically whenever any input price moves more than 5%; this is a method-specific rule rather than a universal industry standard, since other guidance treats the threshold as operator-set (commonly five to eight per cent) or denies that any fixed threshold works for every kitchen.
  3. Is It Portioning? Weigh three of ten plates against spec on the highest-variance protein. Most variance problems are findable in two to three hours of focused work. The portion check is usually the fastest.
  4. Is It Unrecorded Comps, Staff Food Or Voids? Pull the comp and void report by shift and by server. A comp total running at twice the weekly baseline, concentrated on one shift, signals a process problem before it suggests theft.
  5. Is It Receiving? Check delivery weights against invoices on the day, not at month end. Short shipments booked at full delivery value are a documented source of variance that disappears if the check is delayed.
  6. Is It The Recipe Card? Compare current invoice prices against the card. Recost anything that has moved more than 5%. A card built when an ingredient cost less than it does today produces a theoretical food cost that flatters the operation and a variance that looks larger than it is.

Direction matters more than any single result. Three small deficits in a row is a leak; one large one is often a counting or timing error. A variance that repeats at the same level every month is systematic and has a recoverable source.

See How Jelly Tracks Your Variance

UK Compliance: Measures, Allergens And Duty

Some variance sources are legal rather than operational. Measures, allergen records and duty all feed directly into what your stock numbers should show.

The Weights and Measures Act 1985 and the Weights and Measures (Various Foods) (Amendment) Order 1990 require still table wine sold by the glass for on-premises consumption to be sold only in 125ml or 175ml quantities, with a written statement of available measures displayed so the customer can readily see it. Dispensing equipment must be passed and stamped by an inspector, and equipment that is dismantled and reinstalled must be re-passed.

Challenge 25 functions as a stock-control point as well as a licensing one. Refused sales and age-verification logs affect what leaves the bar and should be recorded consistently. An unrecorded refusal that results in a sale creates a till entry with no corresponding stock movement.

Natasha’s Law requires allergen information to be accurate and reviewed whenever recipes or supplier brands change. The recipe card therefore acts as a compliance document as well as a costing one. When a supplier substitutes a different brand of the same product, the allergen review becomes mandatory and the recipe card must be updated before the dish is served.

For alcohol duty, HMRC’s Alcohol Duties Factsheet covers cleared-goods and duty-collected data. UK limited companies must retain stock records, including the stocktakes used to calculate year-end stock, for six years. VAT applies the standard rate to restaurant and café meals, other on-premises consumption and qualifying hot takeaway food, while most food bought into a kitchen is zero-rated (with exceptions such as confectionery, savoury snacks, ice cream, most soft drinks and all alcohol). Track the VAT position on purchases and sales separately to produce a clean COGS figure.

When Spreadsheets Stop Working And Where Jelly Fits

A spreadsheet and a weekly stocktake work for a single site with a short menu and a handful of suppliers. The tell that the model has broken is time. On average it takes 28 minutes of spreadsheet work to cost a single menu item. Multiply that across a menu refresh, add supplier price changes arriving mid-week, and the admin load displaces the operational decisions it was supposed to inform.

Jelly is the primary recommendation here. It is the best hospitality stock control software for restaurants and pubs looking to make their stock numbers trustworthy and act on variance. It captures every invoice line item automatically, keeps dish costs and GP margins live, and onboards in the first week at a flat £129/month per location. Invoices arrive by email or photo, and every line item, including quantity, SKU, price and tax, is digitised without manual entry. That digitised pricing makes the Price Alert feature possible. It flags every supplier price movement the week it happens so operators can negotiate credits or switch suppliers before the margin impact compounds. The same data feeds the recipe cards. Once POS integration with Square, EPOS Now, Toast or Lightspeed is in place, which takes about five minutes per system, sales deplete those recipes in real time. The Flash Report delivers a daily GP view without waiting for the accountant. Xero integration pushes digitised invoices across with one click. Jelly users cut food costs by 3% on average in the first three months and add approximately two percentage points to gross margins. What took half an hour now takes three minutes.

For a fuller comparison of the UK hospitality stock control software market, see the Stock Control Software: A UK Hospitality Buyer’s Guide. For POS connection detail, the Stocktake Integration With POS: Step-By-Step Guide covers the full setup flow.

Among the established platforms that appear in comparison round-ups is The Access Group. It is an enterprise-leaning platform with quote-based pricing and longer set-up projects, suited to larger managed estates with dedicated back-office teams. Jelly is built for the growing single-site-to-few-site operator. It onboards in the first week, charges a flat £129/month per location with no per-user or per-feature charges, and generates initial value from invoice automation before a stocktake has been run.

Two other platforms come up often in UK pub comparisons. Growyze is a credible alternative at £79/month (Pro) or £139/month (Premium) per site, with the longest published UK till integration list at its price point. The documented trade-off on Pro is a 30-invoice monthly reconciliation cap, and a food-led site can exceed that within a fortnight, at which point the effective price is £139. Tabology is an EPOS-first product at £39–£99/month, best suited to single-location pubs wanting bookings integrated into the till. Stock control is included in the EPOS rather than offered as a specialist back-of-house module.

See Jelly In A Live Walkthrough

Frequently Asked Questions

What Are The Five Steps Of Stock Control In A Pub Or Restaurant?

The five steps are audit and categorise, FIFO and rotation, set par levels, count regularly, and analyse variance. The full walkthrough, with count frequencies and formulas, sits in the five steps section above.

What Is The 80/20 Rule And Does It Work For Hospitality Stock?

Yes, as a counting discipline. As a rough application of the Pareto/ABC principle, about 20% of stock lines, typically proteins, seafood and premium spirits, account for roughly 70–80% of purchasing or cost value, though the exact split varies by operation. Counting those lines weekly and running the full range monthly concentrates effort where the financial exposure is highest. The 80/20 rule does not replace a full count. It sets the cadence for spot counts between full stocktakes. A spirits line running a 9% variance on a single product can represent hundreds of pounds. Weekly counts on that line catch the drift before it compounds.

FIFO Vs LIFO: Which Applies To A UK Pub Cellar?

FIFO applies, and in practice it works as a labelling and rotation discipline rather than an accounting election. Date every delivery, push older stock forward, and treat a keg as stock with a date on it. A Friday delivery goes behind last Tuesday’s. LIFO, or last in first out, has no practical application in a cellar context and is not a standard accounting method for UK hospitality stock valuation. The question matters most in the cellar because draught stock has a finite shelf life and rotation directly affects draught yield and waste.

How Do You Investigate A Stock Variance?

Start by ruling out data errors. Check for duplicate ingredient records, counts saved as drafts rather than submitted, and deliveries received without a goods received note. Once those are excluded, split price from usage. A spike after a delivery cycle points to a supplier price change, and a steady gap points to usage. Then check portioning by weighing plates against spec, pull the comp and void report by shift and server, verify delivery weights against invoices, and compare current invoice prices against the recipe card. A variance that repeats at the same level every month is systematic and has a recoverable source. One large outlier usually indicates a counting or timing error.

Is There A Free App Or Template For Hospitality Stock Control?

A stocktake and variance sheet is sufficient for a single site with a short menu and a small number of suppliers. The Beginner Stock Control Guide For UK Restaurant Owners covers the basics and includes template guidance. Once supplier count and site count grow, the manual model breaks down because invoice entry, recipe costing and variance tracking all require more time than a spreadsheet can absorb without displacing operational decisions. At that point, integrated invoice and POS data becomes the practical answer, and Jelly is the recommendation at a flat £129/month per location with first-week onboarding and no per-user charges.

Conclusion: Trustworthy Numbers, Then Action

The value of a stock control routine lies in the numbers the count produces and the decisions those numbers make possible. A count that survives a Friday night, a variance you can explain to a finance-minded owner, and a GP you can act on before month end are the outcomes the process is designed to deliver.

Jelly, recommended above, onboards in the first week at a flat £129/month per location and keeps costs and margins live from invoice through to GP.

The next step is a conversation about your site, your current process and where the numbers are breaking down.

Start Your Stock Control Conversation With Jelly