Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Manual menu costing takes 28 minutes per dish and 6–18 hours per month, which becomes unsustainable once menus exceed 30–40 dishes or supplier prices change frequently.
- A six-tab Excel template can deliver accurate GP figures for a single-site pub tonight, but static prices and manual invoice entry create hidden labour costs that often reach 10–20 hours weekly.
- Spreadsheets break at scale, as version conflicts, multi-site reconciliation, and key-person dependency turn the file into an abandoned black box within three months.
- Real-time invoice scanning and automatic recipe updates remove the lag between supplier price changes and margin visibility, cutting food costs by an average of 3% within the first quarter.
- Operators ready to replace their spreadsheet with live GP data can book a demo with Jelly and watch automated costing in action.
The Problem: Manual Menu Costing Is Costing UK Pubs Time and Margin
Costing a single dish manually takes an average of 28 minutes, including pulling ingredient prices from invoices, converting units, applying wastage, and checking the GP figure against target. Manual menu costing for a standard pub menu takes 6–18 hours per month for owners, head chefs, and finance managers who already work at full capacity.
The day-to-day reality is a chef juggling paper invoices between service, a finance manager waiting until month-end to see whether food cost has crept above target, and a margin that erodes quietly in the gap between those two events. One ingredient can appear in thirty recipes, so a single supplier price change makes margin figures quietly wrong until someone manually updates every affected recipe, and that update rarely happens in full.
The GP target varies by operation type. Community locals and beer-heavy, food-minimal pubs can target 68–72% gross profit in 2026 due to their lower cost base and higher margins on volume, while food-focused pubs often target 62–68% gross profit as food brings volume but carries lower margins offset by higher per-head spend. Wet-led operations and food-led operations therefore need separate GP benchmarks built into any costing model from the start.
Book a demo, schedule a chat and see how Jelly keeps those targets live without manual recalculation.
The Solution Starts Here: Build Your Pub Menu Costing Spreadsheet
Before exploring automated options, a clear manual costing model shows exactly where the process starts to break at scale. The template below uses six tabs, and each tab feeds the next.
Tab 1: Ingredient Master Setup
Use these columns: Ingredient Name, Supplier, Pack Size, Pack Cost (ex-VAT), Unit, Cost Per Unit, VAT Rate.
Use this key formula for Cost Per Unit (column F, starting F2):
=D2/C2
For the VAT toggle, add a helper column G labelled “VAT-Inclusive Pack Cost” and use:
=D2*(1+G2)
All costing must use ex-VAT figures. Using gross VAT-inclusive revenue instead of net ex-VAT revenue understates food cost percentage by approximately 17%, which makes every dish look more profitable than it is.
Tab 2: Recipe Breakdown Per Dish
Use these columns: Ingredient, Quantity Used, Unit, Cost Per Unit (linked from Tab 1), Line Cost, Wastage %, True Cost.
Link Cost Per Unit back to the Ingredient Master with VLOOKUP:
=VLOOKUP(A2,IngredientMaster!A:F,6,0)
Use this Line Cost formula (column E):
=B2*D2
Calculate True Cost with wastage (column G), applying the standard 10% wastage uplift used across UK restaurant kitchens to cover trim, spillage, and dropped plates:
=E2*(1+F2)
Sum column G for total dish cost.
Tab 3: GP Calculator For Each Dish
Use these columns: Dish Name, Total Recipe Cost, Menu Price (inc. VAT), Net Menu Price (ex-VAT), Food Cost %, GP %.
Use this Net Menu Price formula (column D). UK operators calculate the ex-VAT selling price, then add VAT as a final step by multiplying the net price by 1.20 to produce the customer-facing menu price, so the reverse is:
=C2/1.2
Use this Food Cost % formula (column E):
=B2/D2
Use this GP % formula (column F):
=1-E2
Apply conditional formatting with a red fill if F2 is below your target, such as 0.65 for food-led or 0.68 for wet-led, and green if above.
Tab 4: Waste and Overhead Buffer
Add a fixed overhead allocation per dish, such as gas, electricity, and packaging, as a flat pence figure, then recalculate true GP with:
=((D2-B2-H2)/D2)
Here H2 is your overhead allocation per cover. Regular stock checks against par levels can reduce food costs by cutting over-ordering and wastage, so revisit this tab weekly.
Tab 5: Menu Overview and GP Flags
Pull dish name and GP % from Tab 3 into a summary table so you can see performance at a glance. Add a flag column with this formula:
=IF(F2<0.65,"REVIEW","OK")
Sort by GP % in ascending order to surface your worst performers immediately.
Tab 6: Time-Sink Calculator For Admin Hours
Track minutes spent updating each tab per week, then multiply by your hourly cost rate to convert that time into a monetary figure. This tab exists to make the hidden labour cost of the spreadsheet visible, and once your menu exceeds 40 dishes, the weekly hours logged here typically exceed the value the spreadsheet delivers, making this the most important tab for deciding when to automate.
2026 UK Pub GP and Food Cost Benchmarks
| Operation Type | Target Food Cost % | Target GP % | Red Flag Above |
|---|---|---|---|
| Food pub / casual dining | 28–32% | 68–72% | 35% |
| Food-focused / gastropub | 30–35% | 62–68% | 35% |
| Wet-led / community local | 20–28% | 68–72% | 30% |
Test the template tonight, then check Tab 6 after one week and note the hours logged.
Why Spreadsheets Break at Scale
The addition of a second person editing the file creates version and edit conflicts, such as files named stock_FINAL_v3_KITCHEN.xlsx, which increases the risk of inconsistent or broken calculations and causes users to stop trusting the numbers. At a single site with a stable menu and infrequent supplier changes, the spreadsheet above is adequate. The problems emerge in four specific scenarios.
Static prices. After a supplier price increase, most recipes contain outdated costs, and the cascade effect described earlier means recalculation is rarely completed in full.
No invoice scanning. Every price update requires manual re-entry from a paper or PDF invoice, and there is no mechanism to flag that a line-item price has changed since the last delivery.
Key-person dependency. When the original builder leaves, the spreadsheet encodes its author's assumptions in formulas nobody else has read, becoming a black box that is abandoned within three months.
| Workflow Step | Manual Spreadsheet | Automated (Jelly) |
|---|---|---|
| Invoice capture | Manual data entry per line item | Photo or email, every line item digitised automatically |
| Price change detection | Spotted only on next manual review | Price Alert flags every increase or decrease immediately |
| Dish GP update after price change | Manual recalculation across all affected recipes | Live recalculation on every dish the moment an invoice is processed |
| Weekly admin time | 10–20 hours | Reduced to minutes, monthly stocktake drops from 2–3 hours to 5–20 minutes |
When Spreadsheets Stop Scaling
The template in this article will surface your margin problems, but it will not fix them in real time. Before using Jelly, Chef Murat Kilic of Amber relied on manual costing and pricing with spreadsheets, and after switching, Jelly's price change alerts surfaced supplier increases the same week they happened, enabling credits, supplier switches, and tighter menu controls that now save £3,000–£4,000 per month.
Jelly automates the entire flow from invoice to dish GP. Invoices arrive by photo or email, every line item is digitised without manual entry, ingredient costs update across every recipe instantly, and the Flash Report delivers a daily GP view integrated with POS data from Square, Lightspeed, EPOS Now, and Toast, which are systems many UK pub operators already run alongside Jelly. Sushi Revolution uses Jelly to set separate target gross profits on dine-in and delivery menus, accounting for 30% delivery commissions, resulting in actual gross profits 2–3% higher on average. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue.
Jelly costs £129 per location per month, using a flat rate with no per-user charges.
How to Evaluate Any Menu Costing Method
Five criteria determine whether a spreadsheet, a legacy system, or a modern platform fits a £500k+ pub site.
- Ease of use. A head chef should cost a new dish without a finance manager present. Jelly reduces dish costing from 28 minutes to approximately 3 minutes by building recipes from ingredients already populated from scanned invoices.
- Onboarding speed. A system that takes months to configure delays value. Jelly generates initial value within the first week, and price alerts are live within 24 hours of the first invoice being photographed.
- Data accuracy. Static systems rely on manual updates. A static spreadsheet value ignores preparation waste and yield losses from trimming, cooking, and portioning, so the calculated portion cost underestimates the true cost of goods sold even before any price movement occurs.
- Reporting depth. Month-end reports arrive too late to act on supplier price changes. Daily Flash Reports and Sales Mix data from a live POS integration give operators the visibility needed to make same-week decisions.
- Operational fit. A system built for large chains with dedicated office teams does not suit a growing independent. Jelly is designed specifically for operators at the £500k+ stage expanding to two to five sites.
Frequently Asked Questions
Handling VAT Correctly in a Pub Menu Costing Spreadsheet
All food cost percentages and GP calculations must use ex-VAT net figures. The standard UK VAT rate for hot food and dine-in meals is 20%. To extract the net price from a VAT-inclusive menu price, divide by 1.20, and do not subtract 20% directly, because that produces an incorrect net figure. For example, a £12 menu price divided by 1.20 gives a £10 net selling price. If your dish costs £2.50 in ingredients, your food cost percentage is 25% and your GP is 75%. Cold takeaway food is generally zero-rated, so apply the correct VAT treatment per item type within the same spreadsheet to avoid distorting your GP calculations.
Deciding When a Spreadsheet Is Enough for a Single-Site Pub
A well-built spreadsheet is a practical starting point for a single-site operation with a stable menu and infrequent supplier changes. The template in this article gives you a working GP view tonight. The limitations become operational rather than theoretical once your menu exceeds 30–40 dishes, your supplier prices change more than once a month, or you add a second site. At that point, the weekly admin time required to keep the spreadsheet accurate typically exceeds 10–20 hours, and the risk of outdated costs silently eroding your GP becomes material. Jelly is designed for operators at exactly that tipping point.
Jelly Integrations With Existing POS Systems
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, feeding directly into GP and Sales Mix reports. Connecting any supported POS takes approximately five minutes. If your POS is not yet on the supported list, Jelly continues to add integration partners, and the invoice automation and dish costing features operate independently of POS connection from day one.
Managing Multi-Site Pub Operations With Jelly
A shared spreadsheet cannot maintain consistent recipe costs across multiple sites because supplier prices, delivery terms, and local availability differ by location. Each site tends to drift to its own ingredient names, and consolidating performance across sites requires manual reconciliation. Jelly maintains a centralised ingredient and recipe database that updates in real time as invoices arrive at each location, giving owners and operations managers a single source of truth across all sites without any manual consolidation work.
Choosing a Wastage Percentage in a Pub Costing Spreadsheet
A 10% wastage uplift is the standard starting point for most UK pub kitchens, covering trim, spillage, and dropped plates. Apply it by multiplying your summed ingredient cost by 1.10 before entering the GP pricing formula. For draught beer, a 12% wastage buffer is more appropriate to account for line loss and pouring inefficiency. Spirits typically carry a 5% wastage allowance, though real-world overpour can add a further 8–12% to true cost. Review your wastage assumptions quarterly against actual stock variance figures, because serving a protein at 220g instead of the 180g spec increases the protein's own cost contribution by approximately 22%, which contributes to overall plate-cost variance but does not raise total plate cost by 22%.
Conclusion: From Spreadsheet to Real-Time Control
The spreadsheet template in this article gives UK pub operators a working menu costing system they can build and use tonight. It applies the correct ex-VAT formulas, embeds 2026 GP benchmarks, accounts for wastage, and flags low-margin dishes automatically. For a single-site operation getting started with structured costing, it is the right tool.
The ceiling is real. Static prices, manual invoice entry, version conflicts, and the absence of live GP recalculation mean the spreadsheet starts working against you as soon as your operation grows, your menu changes, or your suppliers move prices. The 10–20 hours of weekly admin it demands is time that does not return.
Jelly removes that ceiling. Invoices are digitised automatically, ingredient costs update across every recipe the moment a new delivery arrives, and GP is visible in real time, not at month-end. Operators using Jelly cut food costs by an average of 3% and add 2 percentage points to gross margins within the first three months.
See Jelly in action and discover how automated GP control replaces your spreadsheet from day one.