Written by: JJ Tan, Founder, Jelly
Key Takeaways for UK Pub Operators
- UK pubs face rising ingredient costs that outpace manual spreadsheet tracking, which can quietly remove over £20,000 in margin each year for £500k+ operations.
- Manual recipe costing takes around 28 minutes per dish and becomes outdated as soon as supplier prices change, creating blind spots in gross profit monitoring.
- A pub recipe costing calculator automates ingredient pricing, yield adjustments, and VAT calculations to give live food cost percentages and clear gross profit visibility.
- Common costing mistakes, such as ignoring yield loss, omitting small ingredients, and using VAT-inclusive prices, can distort food cost reports by 2–4 percentage points.
- Switch to Jelly’s automated pub recipe costing calculator to remove spreadsheet drift and protect 2026 margins. Book a demo, schedule a chat.
How a Pub Recipe Costing Calculator Works
A pub recipe costing calculator works out the ingredient cost of each dish on a pub menu. It combines supplier invoice prices, yield-adjusted quantities, and waste factors to produce an accurate cost per portion and a gross profit percentage. An effective calculator updates automatically when supplier prices change, uses VAT-exclusive revenue as the denominator, and connects with POS sales data to give operators a live view of margin for every dish.
Step-by-Step Recipe Costing for a Sunday Roast
This seven-step workflow applies to any pub dish. A Sunday roast with beef sirloin illustrates each step.
- List every ingredient with its as-purchased (AP) price. Pull prices directly from the most recent supplier invoice. Using a supplier’s list price rather than the actual invoice price can create a 10–20% difference in the cost figure. For the Sunday roast, use beef sirloin at £18.50/kg from the current invoice.
- Measure trim yield. Weigh the ingredient before and after trimming. Beef sirloin (trimmed) typically yields 75–85% of its purchased weight. Using 80% yield, the yield-adjusted cost is £18.50 ÷ 0.80, which equals £23.13/kg.
- Apply cooking yield. Roasted proteins lose moisture during cooking. Roasted or braised proteins lose an additional 15–30% of trimmed weight from moisture evaporation. At 20% cooking loss, the final as-served cost is £23.13 ÷ 0.80, which equals £28.91/kg.
- Calculate portion cost for each ingredient. A 200 g beef portion costs £28.91 × 0.200, which equals £5.78. Repeat this for every component such as roast potatoes, Yorkshire pudding, seasonal vegetables, and gravy. Omitting small ingredients such as oils, salt, and base sauces can add 1.5–4.5 food-cost points.
- Sum all ingredient costs to reach plate cost. Use the same figures that appear in Template 1. Example total: beef £5.78 + potatoes £0.14 + Yorkshire pudding £0.28 + vegetables £0.15 + gravy and condiments £0.37 equals a £6.72 plate cost.
- Add a waste buffer. A structured recipe costing process adds a 5–10% waste factor for spillage, spoilage, and over-portioning. At 5%, £6.72 × 1.05 equals a £7.06 real on-plate cost.
- Calculate food cost percentage and target selling price. Divide plate cost by the target food cost percentage to get the net (ex-VAT) selling price. At a 32% target, £7.06 ÷ 0.32 equals £22.06 net. Multiply by 1.20 for the VAT-inclusive menu price, which gives £26.47.
Setting Pub Menu Prices with 20% VAT
The standard VAT rate for hot food consumed on pub premises remains 20% in 2026. All cost and margin calculations should use net (ex-VAT) revenue as the denominator. Using the VAT-inclusive sticker price directly understates the true food cost percentage.
The two formulas every pub operator needs are:
- Net price (ex-VAT) = gross menu price ÷ 1.20
- Gross menu price (VAT-inclusive) = net price × 1.20
For most UK pubs in 2026, a practical operating band for food cost is 28–35% on VAT-exclusive revenue, which equates to 65–72% gross profit, with roast-heavy menus often running toward the higher end.
A Sunday roast priced at £26.47 (VAT-inclusive) has a net selling price of £22.06. With a plate cost of £7.06, food cost percentage equals (£7.06 ÷ £22.06) × 100, which is 32.0%. That sits within the target band. If beef prices rise 10% next week and the spreadsheet is not updated, that dish silently moves to around 35.2%, and no one notices. This risk shows why operators benefit from a system that updates automatically, although well-maintained manual templates still offer a useful starting point.
Live Food Cost Tracking Without Spreadsheets
The two templates below provide a starting point for manual tracking. They are designed for quick copying into Excel or Google Sheets.
Template 1: Single Dish Costing Sheet
| Ingredient | AP Price (£/kg) | Yield % | Yield-Adjusted Cost (£/kg) | Qty Used (kg) | Portion Cost (£) |
|---|---|---|---|---|---|
| Beef sirloin | 18.50 | 64% (trim + cook) | 28.91 | 0.200 | 5.78 |
| Roast potatoes | 0.80 | 85% | 0.94 | 0.150 (raw) | 0.14 |
| Seasonal veg | 1.20 | 80% | 1.50 | 0.100 | 0.15 |
| Yorkshire pudding | — | 100% | — | — | 0.28 |
| Gravy + condiments | — | 100% | — | — | 0.37 |
| Plate cost (pre-waste) | — | — | — | — | 6.72 |
| + 5% waste buffer | — | — | — | — | 7.06 |
Template 2: Batch Costing Sheet for a 20-Portion Sunday Roast
| Ingredient | Batch Qty (kg) | AP Cost (£) | Yield % | Yield-Adjusted Batch Cost (£) |
|---|---|---|---|---|
| Beef sirloin | 5.00 | 92.50 | 64% | 144.53 |
| Roast potatoes | 3.00 | 2.40 | 85% | 2.82 |
| Seasonal veg | 2.00 | 2.40 | 80% | 3.00 |
| Yorkshire puddings | — | 5.60 | 100% | 5.60 |
| Gravy + condiments | — | 7.40 | 100% | 7.40 |
| Total batch cost (+ 5% waste) | — | — | — | 172.00 |
| Cost per portion (÷ 20) | — | — | — | £8.60 |
These templates are accurate at the moment they are built. Problems start when prices move. When a beef supplier raises prices mid-week, every cell referencing that ingredient must be updated manually across every dish that uses it. An automated system processes supplier invoices directly, updates cost prices in real time, and triggers alerts the moment an ingredient price increases.
Jelly performs this work automatically. Every invoice, captured by photo or email, is scanned line by line. Ingredient costs update across every recipe instantly. The Flash Report gives a daily GP view by integrating with POS systems including Square, Lightspeed, EPOS Now, and Toast. The templates above demand hours of maintenance, while Jelly handles the same work in the background.
Amber restaurant in East London saves £3,000–£4,000 per month using Jelly’s automated invoice scanning and live costing, which delivers a 68× return on investment.
Common Pub Costing Mistakes to Avoid
The following errors consistently erode pub margins and often go unnoticed in manual systems.
- Ignoring yield and cooking loss. Costing a recipe using as-purchased weight understates real plate cost by 22–27% on average. Operators who skip yield factor often see food cost reports that appear 2–4 points better than the actual P&L.
- Using VAT-inclusive prices as the denominator. Using VAT-inclusive prices is one of six common recipe-costing errors that distort margins. Always calculate food cost percentage against net (ex-VAT) revenue.
- Omitting small ingredients. Oils, spices, and base sauces can add 1.5–4.5 food-cost points in an eight-condiment dish.
- Ignoring delivery commission on delivery menus. A dish priced for dine-in at 32% food cost becomes loss-making at a 30% delivery commission without a separate delivery menu price. Sushi Revolution uses Jelly to set separate target gross profits on dine-in and delivery menus, accounting for 30% delivery commissions, which results in actual gross profits 2–3% higher on average.
- Stale supplier prices. Animal protein prices can fluctuate throughout the year, and even small movements compound quickly across a menu. To prevent margin drift, costing sheets should be updated whenever a key input price changes by more than 5%, which is the point where a single ingredient can shift overall food cost by a full percentage point.
When Spreadsheets Become a Liability
The checklist below helps identify when manual costing starts to damage control rather than support it.
- Supplier prices change more than once per month and the spreadsheet is not updated in time.
- The kitchen team spends more than 5 hours per week on invoice processing and cost checking.
- GP figures are only available at month-end via the accountant.
- The pub operates more than one site and costing data sits in separate, inconsistent files.
- Delivery menus are priced from the same cost sheet as dine-in menus.
- Portion sizes vary between services because there is no live cost consequence visible to the team.
- Supplier price increases are suspected but there is no data to challenge them in negotiations.
If three or more of these apply, the cost of staying on spreadsheets exceeds the cost of switching. Jelly onboards in under a week. POS connection takes about five minutes. Price alerts go live within 24 hours of the first invoice.
Replace your food cost calculator UK spreadsheet with live data. Book a demo, schedule a chat.
Frequently Asked Questions
How long does it take to get Jelly up and running?
Most pubs generate value within the first week. The setup process involves forwarding supplier invoices to a dedicated Jelly email address or photographing them directly into the app. Price alerts and spending insights go live within 24 hours of the first invoice being processed. Connecting a POS system takes about five minutes. No lengthy onboarding project or dedicated IT resource is required.
Is Jelly suitable for a pub turning over £500k or more?
Jelly is built specifically for operators at this stage. Pubs at £500k+ turnover typically have multiple suppliers, a menu of 20–40 dishes, and a finance manager or owner who needs accurate GP data without waiting for a monthly accountant report. Jelly’s Flash Report, Price Alert, and Sales Mix features provide that visibility daily rather than monthly. The flat-rate pricing of £129 per location per month keeps costs predictable as the business grows.
Can Jelly handle multiple pub sites?
Yes. Jelly supports multi-site operations with per-location cost and margin data accessible from a single platform. Each site has its own invoice feed, recipe library, and GP reporting. Owners and finance managers can compare performance across locations without consolidating separate spreadsheets. This becomes particularly valuable when expanding from one site to two or three, where manual costing processes break down fastest.
How does Jelly keep recipe costs accurate when supplier prices change?
Every invoice processed by Jelly, whether received by email or photographed in the kitchen, is scanned line by line. Each ingredient price is extracted and updated across every recipe that uses it. The gross profit margin for every dish updates in real time. A red indicator appears when a dish drops below its target margin, and a green one appears when it improves. The Price Alert feature flags every price increase or decrease by supplier and ingredient, which gives chefs the data to negotiate credits or switch suppliers before the margin damage compounds.
What about data security and accuracy?
Jelly digitises every invoice line item, including quantity, SKU, price, and tax, and integrates directly with Xero for accounting. This removes the manual re-keying that introduces errors in spreadsheet-based processes and cuts bookkeeping time by 90%. Invoice data is held securely on Jelly’s platform and is accessible only to authorised users. Because the system is automated rather than reliant on manual input, management can trust the figures without checking them against paper records.
Conclusion: Protect Your Pub’s Margins This Week
Manual spreadsheets worked when menus were small and supplier prices stayed stable. In 2026, with pub dish prices rising at 4.2% year-on-year and ingredient costs moving weekly, they create risk. Every hour spent updating a cost sheet is an hour not spent on the floor, on the menu, or on supplier negotiations. Every stale price in a spreadsheet means a dish sold at the wrong margin.
Jelly replaces the spreadsheet with a live pub recipe costing calculator that updates the moment an invoice arrives. Dish costs, GP percentages, price alerts, and sales mix data are available daily rather than at month-end. The Howard Arms reached 80% gross profit after switching. Amber achieved the savings detailed earlier. Sushi Revolution opened a second site.