Written by: JJ Tan, Founder, Jelly
Key Takeaways for Pub Operators
- Manual recipe costing in spreadsheets collapses under real pub pressure because supplier prices change constantly and data goes stale within days.
- Three core metrics, portion cost, food-cost percentage, and gross-profit margin, must update in real time to protect profitability on every dish and drink.
- Automated costing tools provide live portion costs, ml-level drinks costing, batch scaling, supplier price alerts, and POS integration without manual data entry.
- UK pubs using automated systems report measurable gains, including up to £4,000 in monthly savings, measurable food-cost reductions in the first month, and gross-profit improvements averaging 2 points within three months.
- See how automated costing protects your margins, with same-day setup for most pubs.
The Problem: Manual Costing Creates Stale Data and Hidden Margin Loss
Pub operators typically spend 10–20 hours per week on manual data entry, price checking, and invoice reconciliation. That time comes directly out of strategic work such as menu pricing, supplier negotiations, and site expansion planning. Manual processes also create a deeper issue because the data is already stale by the time it reaches a decision-maker.
Three metrics determine whether a pub is profitable on any given dish or drink, and they work together as a system. Portion cost is the total ingredient cost of one serving, so for a Sunday roast that means beef, vegetables, gravy, and Yorkshire pudding priced to the gram. This raw cost becomes meaningful only when expressed against the selling price. Food-cost percentage is portion cost divided by selling price, so a roast selling at £18 with a £5.40 ingredient cost carries a 30% food-cost percentage. Gross-profit margin is the inverse, with 70p in every £1 of revenue remaining after ingredient costs. For drinks, the same logic applies in millilitres, and a 568 ml pint of lager poured from a keg must be costed per ml to produce an accurate GP figure. When supplier prices move and these calculations do not update in real time, the margin figure on the menu board becomes fiction.
Why Free Spreadsheet Templates Break as Your Pub Grows
Given these challenges, many operators start with free spreadsheet templates as a first attempt at structured costing. A free spreadsheet template works adequately when one chef manages one site with a handful of suppliers. The model breaks down as soon as any of those variables multiply. With ten or more suppliers, each updating prices on different cycles, manual price entry becomes a full-time job. Across two or more sites, different chefs build recipes in different formats, which makes cross-site GP comparisons unreliable.
Spreadsheets also carry no alerting capability. A supplier quietly raising the price of a key ingredient by 8% will not trigger any notification, and the operator discovers the margin erosion only when the monthly accounts arrive, weeks too late to renegotiate or reprice. Templates work as a reasonable starting point for a single-site pub with a stable supplier base. They remain an interim step before automation, not a permanent solution.
The Solution: Automated Recipe Costing with Live, Linked Data
Automated pub recipe costing software replaces the manual update cycle with a continuous data flow. The core capabilities that matter for UK pub operations are clear and practical.
- Live portion costing: every dish and drink cost updates automatically when a new invoice is processed, so the GP figure stays current.
- Drinks costing in ml: spirits, wines, and draught beer are costed at the millilitre level, which removes the rounding errors that build up in manual beverage calculations.
- Batch recipe scaling: a recipe built for 10 covers scales accurately to 60 without manual recalculation, and portion cost integrity holds across service volumes.
- Real-time supplier price alerts: every invoice line item is scanned on arrival, and any price movement triggers an immediate notification so operators can negotiate credits, switch suppliers, or adjust menu prices before margin disappears.
- POS integration: connecting sales data to recipe costs produces a live GP margin per dish, updated with every transaction.
Invoice scanning and POS integration work together as a closed loop. The invoice scan updates ingredient costs, and the POS feed updates sales revenue. The system calculates GP margin continuously with no manual input from the kitchen team.
How to Choose a Pub Recipe Costing Tool That Teams Will Use
Software only delivers value when the kitchen team actually uses it. Head chefs are not administrators, and a tool that demands lengthy training or complex data entry will be abandoned within weeks. Because adoption failure is the single biggest risk when choosing software, onboarding speed and interface simplicity become primary selection criteria, not secondary ones.
A practical decision framework for pub operators weighs four factors. First, how quickly the platform generates its first useful output, such as a price alert or a live dish cost, after setup. Second, whether it handles drinks costing in ml natively or forces workarounds. Third, whether it integrates with the POS system already in use. Fourth, what the total cost of ownership looks like, including setup fees, per-user charges, and any variable pricing that scales unpredictably with transaction volume.
Manual spreadsheets score well only on upfront cost. Automated platforms score better on every operational dimension once a pub exceeds a handful of suppliers or begins operating across more than one site. The comparison table below shows how five tools perform against these criteria, with onboarding speed as a key differentiator.
Comparison of Five Pub Recipe Costing Tools
| Tool | Drinks costing in ml | Real-time price alerts | Onboarding to first value |
|---|---|---|---|
| Jelly | Yes, native ml unit conversion across all beverage recipes | Yes, triggered per invoice line item on every scan | Under 24 hours, with price alerts active as soon as the first invoice is received |
| MarketMan | Yes, unit conversion available within recipe builder | Yes, price change notifications available | Typically several weeks, with implementation support required for full setup |
| Nory | Yes, supports beverage costing within its recipe module | Yes, cost variance alerts included in the platform | Weeks to months, as the feature-rich platform requires structured onboarding |
| Kitchen Cut | Yes, legacy platform supports unit-level beverage costing | Limited, with price change visibility less dynamic than newer platforms | Weeks to months, designed for large chains with dedicated office teams |
| Excel / Google Sheets | Manual, requiring operators to build and maintain ml conversion formulas | None, because no alerting capability exists and changes appear only on manual review | Immediate to set up, with zero time-to-value on price alerts because the feature does not exist |
Jelly charges a flat rate of £129 per location per month with no per-user fees. MarketMan and Nory operate on tiered pricing models that vary by feature set and site count. Kitchen Cut is typically priced for large chain operators and carries a higher total cost of ownership. Excel and Google Sheets carry no software cost but impose a significant ongoing labour cost in manual maintenance.
Measurable Results from UK Pubs Using Automated Costing
Amber, a Mediterranean restaurant in East London run by Chef-Owner Murat Kilic, saves £3,000–£4,000 every month using Jelly, achieving approximately 68 times return on investment. Before automation, Murat managed supplier invoices and dish costing manually in spreadsheets, which made it difficult to react to price changes quickly enough to protect GP. Jelly’s invoice scanning and price alert features now surface cost movements in the same week they occur, enabling immediate supplier negotiations and menu price adjustments.
Stuart Noble, Head Chef at Cairn Lodge Hotel, reduced food costs by 5% within one month of using Jelly. Across Jelly’s customer base, operators see an average gross-profit improvement of 2 percentage points within the first three months. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Populu lifted GP from 68% to 72% across 16 locations.
The pattern across these outcomes is consistent. The speed of the feedback loop, from invoice arrival to price alert to decision, determines how much margin is protected. Manual processes introduce a lag of days or weeks, while automated scanning closes that lag to hours.
Frequently Asked Questions
Can I cost drinks in ml?
Yes. Jelly handles unit conversion natively, so you can build beverage recipes in millilitres, whether that is a 25 ml spirit measure, a 175 ml wine pour, or a 568 ml pint of draught lager. The platform calculates the cost per ml from your scanned invoices and applies it directly to each recipe. This produces an accurate portion cost and GP margin for every drink on your menu without any manual formula work.
How quickly can we go live?
Pubs can often generate their first price alerts within 24 hours of setup. The process involves forwarding supplier invoices to a dedicated Jelly email address or photographing them directly into the app. Jelly scans every line item automatically. Connecting a supported POS system takes approximately five minutes. Full recipe costing becomes available as soon as your ingredients are populated from scanned invoices, which typically happens within the first day of use.
Will it work with my existing POS?
Jelly integrates natively with Square, Lightspeed, EPOS Now, and Toast via real-time API. Each integration delivers item-level sales data the moment a transaction completes, and Jelly uses this data to calculate live GP margins per dish. Setup follows the same flow across all four systems and takes around five minutes. For POS systems outside this list, Jelly is actively expanding its integration partners.
How does batch-recipe scaling affect portion costs?
When you scale a recipe in Jelly, for example from a base of 10 covers to 60, the platform recalculates every ingredient quantity and its associated cost automatically, using the current prices from your most recent scanned invoices. Wastage percentages entered at the ingredient level remain preserved through the scaling calculation, so the portion cost figure stays accurate regardless of batch size. This removes the manual recalculation errors that typically occur when kitchen teams scale recipes in spreadsheets.
Conclusion: Turn Recipe Costing into a Real-Time Margin Control System
The shift from manual spreadsheets to automated recipe costing represents an operational upgrade, not just a technology change. Pubs that rely on monthly accounts to discover margin problems always react to damage that has already occurred. Automated invoice scanning, real-time price alerts, live portion costs in ml, and POS-connected GP reporting move that feedback loop from weeks to hours. The result is a kitchen team that spends less time on administration and more time on the decisions that protect and grow margin. Amber’s 68x return on investment shows the financial impact, and Cairn Lodge’s 5% food-cost reduction reinforces the point. The average Jelly customer adds 2 percentage points to gross profit within three months. Start protecting your margins today and see live results on day one.