Written by: JJ Tan, Founder, Jelly
Key Takeaways for UK Pub Operators
- UK ingredient price volatility and manual spreadsheet admin (10–20 hours weekly) make frequent, accurate menu costing essential to protect 68–72% GP targets.
- A reliable costing sheet needs a master ingredient list, sub-recipe batch tabs, menu item recipe cards, waste and VAT buffers, and a live summary dashboard.
- Spreadsheets break down at scale through version chaos, missed price updates across linked recipes, and the lack of real-time margin alerts.
- Modern automated platforms scan invoices, update every recipe cost live, and deliver daily GP visibility without manual data entry.
- Jelly automates the entire invoice-to-margin workflow for UK pubs; book a demo today to replace spreadsheet admin with real-time profitability tracking.
The Problem: Manual Recipe Costing Erodes Your GP
Costing a single dish in a spreadsheet takes an average of 28 minutes. Across a pub menu, that workload quickly becomes several hours before all prices are current. Meanwhile, UK food pubs and casual dining operations target a food cost of 28–32% of net (ex-VAT) revenue, and pub owners can lose potential GP through waste, over-pouring, shrinkage and inaccurate stock counts. The month-end accountant report arrives weeks after the damage is done. By then, a dish that was profitable has been sold hundreds of times at a loss, with no realistic way to recover that margin.
See how Jelly gives you real-time margin visibility without the spreadsheet admin.
Why Spreadsheets Break Down at Scale
These margin losses build up because of how spreadsheets handle ingredient data. Each price change in a spreadsheet requires manually locating the ingredient, updating its cost, and propagating the change to every recipe that uses it, and missed updates leave menu margins inaccurate. One ingredient can appear in thirty recipes, and missing 2–5 percentage points in food cost accuracy on £50,000 monthly revenue equals £1,000–£2,500 in lost profit per month.
Version chaos then compounds the problem. When a second person edits the file, variants like stock_FINAL_v3_KITCHEN.xlsx appear on desktops, nobody trusts the numbers, and nobody acts on them. When the person who built the sheet leaves, the file becomes a black box, and as menus grow, cross-sheet references can become fragile, slow to recalculate and prone to error.
An automated workflow works differently. It scans every invoice line item on arrival, updates ingredient costs across every recipe instantly, and surfaces a red margin flag the moment a dish drops below target. No manual intervention is required.
The Solution Category: Live Recipe-Costing and Menu-Profitability Systems
Modern recipe-costing platforms connect three live data sets: ingredient quantities per recipe, current purchase costs from supplier invoices, and sales volume from the POS. A multi-location restaurant group using spreadsheet-based reconciliation operated with an elevated food cost for several weeks before the variance was detected, a delay that automated flagging eliminates entirely. This gap between real costs and reported costs is exactly what modern systems close.
Jelly sits in this category and is built specifically for UK pubs, restaurants and boutique hotels at the £500k+ revenue stage. Invoices arrive by photo or email, Jelly digitises every line item, dish costs update in real time, and the Flash Report delivers daily GP visibility without waiting for an accountant. Jelly users cut food costs by 3% on average in the first three months.
Master Ingredient List Tab for UK Pack Sizes, Yield and VAT
A single master ingredient table forms the base of any reliable pub costing sheet. Every ingredient lives here once, and every recipe tab pulls from it. The table needs at least six columns: ingredient name, UK pack size (for example 5 kg bag, 10 L drum, 30 L keg), pack price ex-VAT, yield percentage, cost per usable unit, and a unique ID for lookup formulas.
Food cost percentage must always be calculated against net (ex-VAT) revenue, and using the VAT-inclusive menu price understates the true food cost percentage, so every price entered here must be the supplier ex-VAT figure. Yield percentage is non-negotiable, and without yield tracking, spreadsheets understate actual ingredient costs. For example, Roma tomatoes at 93% yield have a true usable cost meaningfully higher than the invoice price per kilogram, because the 7% trim you discard still appears on the invoice and must be recovered through menu pricing.
Sub-Recipe Batch Costing for Gravies, Sauces and Keg Beer
Batch items such as pub gravy, béarnaise, ale batter and keg beer by the pint need costing as standalone sub-recipes before they touch a finished plate. Each sub-recipe tab pulls ingredient costs from the master list, applies a batch yield that accounts for reduction, evaporation and trim, and outputs a cost per portion or per litre. That single figure then drops into the menu item recipe card as one line.
Build shared components such as sauces as sub-recipes and update the sub-recipe once so every dish using it reflects the change automatically. For keg beer, divide the keg ex-VAT price by the number of sellable pints after accounting for line waste and head, typically 3–5% loss on a 30-litre keg, to reach a true cost per pint.
Menu Item Recipe Cards for Portion Cost, GP% and Live Margin
Each menu item needs its own recipe card that lists every component, including main protein, sub-recipe portions, garnish, sauce, starch, oil and seasoning. All components on the plate must be costed, including sauces, garnishes, oil, butter, salt, spices, bread and side dishes, which can add £1–2 per portion beyond the main ingredient. The card then calculates total portion cost, applies the waste buffer, divides by the target GP to produce the ex-VAT selling price, and multiplies by 1.20 to show the VAT-inclusive menu price. GP% appears as a live cell, and when the master ingredient list updates, this figure moves with it.
Pub Waste and VAT Buffers That Protect Margin
UK restaurant operators often apply a wastage buffer for trim, spillage and dropped plates before determining the ex-VAT selling price. For most pub kitchens, a 2–5% buffer is a practical starting point, rising to 10% for high-trim proteins. On the VAT side, menu prices displayed to customers in the UK must be VAT-inclusive, and pricing is performed ex-VAT first with VAT added only at the final step by multiplying the ex-VAT price by 1.20. Never calculate GP% against the VAT-inclusive price, because that approach understates your true food cost percentage by roughly 17%.
Build Your Pub Costing Sheet in Five Clear Steps
- Create the Master Ingredient List tab. Enter every ingredient with UK pack size, ex-VAT pack price, yield percentage and a UNIQUE_ID column. Use a formula to calculate cost per usable unit automatically.
- Build Sub-Recipe tabs for every batch item. Reference the master list via VLOOKUP or named ranges. Record batch yield and output a cost per portion or per litre.
- Create a Menu Item Recipe Card tab for each dish. Pull ingredient costs from the master list and sub-recipe tabs, then sum them to a total portion cost.
- Apply the waste buffer and VAT formula. First, multiply portion cost by (1 + waste buffer %) to cover operational losses. Then divide this adjusted cost by (1 − target GP%) to find the ex-VAT selling price that delivers your target margin. Finally, multiply that figure by 1.20 to add VAT and reach the customer-facing menu price.
- Build a Menu Summary tab. List every dish with its portion cost, ex-VAT price, GP% and a conditional-format flag, set to red if GP% falls below target, so margin problems are visible at a glance.
Worked Example: Costing Steak & Ale Pie and Fish & Chips
For a Steak & Ale Pie, assume braised beef at £1.80 per portion after yield, ale reduction sub-recipe at £0.22 per portion, shortcrust pastry at £0.18 per portion, mash at £0.14 per portion, and garnish and seasoning at £0.12 per portion. Total ingredient cost is £2.46. Apply a 5% waste buffer to reach £2.58. At a 70% GP target, ex-VAT price equals £2.58 ÷ 0.30, which is £8.60. VAT-inclusive menu price equals £8.60 × 1.20, which is £10.32, rounded to £10.50. Achieved GP at a £10.50 menu price is (£8.75 ex-VAT − £2.58) ÷ £8.75, which equals 70.5%.
For Fish & Chips, assume battered cod fillet at £2.10 per portion after yield and batter sub-recipe, chips at £0.28 per portion, mushy peas at £0.09 per portion, tartare sauce at £0.11 per portion, and lemon and garnish at £0.04 per portion. Total cost is £2.62. Apply a 5% waste buffer to reach £2.75. At 70% GP, ex-VAT price equals £2.75 ÷ 0.30, which is £9.17. VAT-inclusive menu price equals £9.17 × 1.20, which is £11.00. Both dishes sit within the target range established earlier.
Practical Benefits Once Your Sheet Is Live
A working costing sheet delivers immediate operational clarity across the business. Owners can see which dishes are dragging GP below the 68–72% casual dining benchmark before the month-end report. That same real-time view lets head chefs identify over-portioned proteins within a week of launch. Finance managers can model the impact of a supplier price increase across the entire menu in minutes rather than days.
The sheet also creates a defensible baseline for supplier negotiations. When a distributor raises beef prices, the cost impact on every dish containing beef is quantified immediately. The weekly admin burden mentioned earlier, often 10–20 hours, still misses real-time cost changes, while automated systems flag margin problems instantly so operators can act before damage compounds.
Discover how Jelly automates the invoice-to-margin workflow your spreadsheet cannot.
Neutral Evaluation: Spreadsheets, Legacy Systems and Modern Platforms
A Google Sheets costing template costs nothing and can be operational tonight. It handles a smaller menu reasonably well when one person maintains it diligently. Beyond that, updating ingredient prices monthly takes time and allows errors to compound across linked recipes, and multi-site operations quickly produce irreconcilable parallel files.
Legacy systems such as Kitchen Cut offer structured recipe databases but are typically priced for large chains with dedicated office teams. They often lack the dynamic, real-time invoice-to-margin connection that growing independents need. Newer all-in-one platforms like MarketMan and Nory provide broad feature sets but carry longer onboarding timelines and higher complexity, which creates friction for kitchens where the head chef is not a power user.
Jelly occupies a distinct position. It onboards in under a week, charges a flat £129 per month per location with no per-user fees, and connects to POS systems including Square, Lightspeed, EPOS Now and Toast in under five minutes. Before using Jelly, Chef Murat Kilic of Amber relied on manual spreadsheet costing; after switching, the restaurant consistently saves £3,000–£4,000 per month. The Howard Arms reached 80% gross profit after adopting Jelly, compared with a projected 60% under the previous manual process.
Frequently Asked Questions
How long does it take to build a pub recipe costing spreadsheet from scratch?
Building a functional three-tab sheet, covering the master ingredient list, sub-recipe batch costing and menu item recipe cards, can take several hours for a typical menu, assuming ingredient prices and pack sizes are to hand. The ongoing maintenance burden is the real cost. Updating prices after each delivery run and propagating changes across affected recipes can add several hours per week for a busy pub kitchen. Jelly eliminates that ongoing burden by scanning invoices automatically and updating all dish costs in real time, reducing the 28-minute manual process to approximately three minutes.
How should VAT be handled in a pub recipe costing spreadsheet?
All ingredient costs must be entered ex-VAT, using the net price on the supplier invoice. GP% must be calculated against the ex-VAT selling price, not the VAT-inclusive menu price. To arrive at the menu price, divide the portion cost, including waste buffer, by (1 − target GP%), then multiply by 1.20 to add standard-rate VAT. Using the VAT-inclusive price in your GP formula understates true food cost percentage by approximately 17%, which can make a loss-making dish appear profitable on paper. Some cold food and takeaway items may qualify for zero-rating, so always confirm VAT treatment by category with your accountant.
Can Jelly integrate with my existing POS system?
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, which enables the Flash Report to show live GP% without manual data entry. Setup follows the same flow across all four systems. Open Jelly, click Integrations, sign in to the POS, grant permissions and select which categories to sync. The process takes around five minutes. The only common friction point is lacking admin access to the POS account, and Jelly flags this requirement upfront. For operators on other POS systems, Jelly plans to add further partners in the future.
When should a pub move beyond a spreadsheet to dedicated recipe-costing software?
Three clear signals show when a spreadsheet has reached its limit. First, the menu grows with shared sub-recipes, and cross-sheet lookup chains become fragile and error-prone. Second, ingredient prices change more than once a week across multiple suppliers, which makes accurate manual updates difficult to sustain. Third, the business operates across more than one site, and two parallel spreadsheets do not consolidate, so site-level performance comparison becomes a monthly manual reconciliation job. At any of these points, the hidden cost of inaccurate margins, with industry estimates suggesting 2–5 percentage points of food cost variance on a manual system, exceeds the cost of automation by a wide margin.
What GP% should a UK pub target for food dishes?
UK food pubs and casual dining operations typically target a food GP of 68–72%, which corresponds to a food cost of 28–32% of net (ex-VAT) revenue. A food cost above 35% is a red flag that indicates portion sizes are too large, recipes are not being followed, or supplier costs are too high. Gastropubs tend to target 65–72% GP on food, while premium and destination food pubs may push toward 72–78% blended GP when wet sales are factored in. These benchmarks assume all costing is performed against ex-VAT revenue and that a waste buffer of at least 2–5% has been applied to each dish.
Conclusion: Move from Spreadsheet to Real-Time Profitability
A well-built pub menu recipe costing spreadsheet, with a master ingredient list, sub-recipe batch tabs and live recipe cards with GP% formulas, becomes a genuine operational asset. It creates pricing discipline, surfaces loss-making dishes and gives head chefs a defensible basis for supplier conversations. You can build it tonight using the five-step structure above.
The ceiling is real, though. Manual price updates, version conflicts, forgotten VAT adjustments and the significant admin time that spreadsheets demand are structural limitations of the format, not issues that discipline alone can solve. Jelly removes those constraints. Invoices are scanned automatically, ingredient costs update across every recipe the moment a new delivery arrives, and the GP% for every dish on your menu is live, accurate and visible to owners, finance managers and head chefs at the same time, without a single formula to maintain.
The results speak for themselves. Sushi Revolution, The Howard Arms and Amber all achieved the margin improvements detailed earlier. The spreadsheet gets you started. Jelly keeps you profitable.
Move from manual costing to real-time menu profitability this week.