Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026
Key Takeaways for Multi-Site UK Operators
- Multi-site UK operators often lose 4–10% of inventory value annually and £3,000–£4,000 monthly in GP through manual spreadsheet consolidation across locations.
- Static spreadsheets create outdated data, hide supplier price changes and block real-time weighted group GP visibility.
- Jelly’s four-layer system (recipe, site, menu, group) delivers live, VAT-exclusive GP figures from a single source of truth without spreadsheets.
- Live invoice scanning, POS integration and site-level yield adjustments support same-day margin decisions and typical 2–3% GP improvements.
- Ready to automate your GP visibility? Book a demo with Jelly today.
The Problem: Why Manual GP Tracking Fails Multi-Site Groups
Manual spreadsheets break down as soon as a group runs more than one kitchen. Each site builds its own file, updates prices at different times and uses slightly different formulas. The group view then depends on a manual merge that is always late and often wrong.
Errors creep in through typos, broken formulas and version-control mistakes, which distort COGS and GP figures. Supplier price changes slip through unnoticed for weeks. By the time finance teams spot a GP issue, the period has closed and the cash has already gone.
Multi-site operators also struggle to compare sites fairly. Different suppliers, yields and sales mixes make simple GP averages meaningless. Without a weighted, VAT-exclusive group roll-up, leaders cannot see which sites are performing well and which ones are quietly eroding margin.
The Solution: A Scalable, VAT-Exclusive Four-Layer GP Margin System
Jelly is built specifically for UK restaurant, pub and hotel groups at the 2–5 site stage. It removes spreadsheets by scanning every invoice line automatically and pushing live, VAT-exclusive GP figures to a central group dashboard. The platform runs across four layers: recipe, site, menu and group. Every margin figure flows from a single source of truth instead of four separate Excel files that nobody fully trusts.
All calculations run on net revenue because VAT-inclusive figures distort margin comparisons across sites and periods. UK hospitality operators must convert VAT-inclusive menu prices to VAT-exclusive amounts by dividing the gross price by (1 + VAT rate) before calculating gross profit margins. Jelly applies this conversion automatically across every dish and every site, which removes manual steps and keeps GP figures comparable and correct.
Teams that move away from manual processes stop losing margin to late data and slow reactions. See how the four-layer system works for your group.
Layer 1 – Recipe Costing with Live Price Updates
Accurate multi-site GP starts with accurate dish costing. In Jelly's Kitchen section, chefs build recipes by clicking on ingredients already populated from scanned invoices. The system handles every unit conversion and cost calculation automatically. Tasks that previously took 28 minutes per dish in a spreadsheet now take about 3 minutes in Jelly.
Ingredient costs update with every new invoice scan, so dish GP margins stay live. When a supplier raises a price, Jelly's Price Alert feature flags the change immediately, showing which ingredient moved, by how much and from which supplier. The Flash Report then surfaces the impact on overall GP daily, weekly or monthly, without manual calculation. Sushi Revolution used this live costing capability to make daily menu price adjustments amid inflation and negotiate directly with suppliers. The group achieved gross profits 2–3% higher on average.
Layer 2 – Site-Level Overrides and Waste/Prep-Loss Adjustments
Live recipe costs provide the foundation, but they describe theoretical values based on purchased quantities. Real kitchens experience yield loss during prep, and each site's setup affects those losses differently. Site-level adjustments convert theory into figures that match what actually leaves the pass.
Recipe costs are theoretical. Real kitchens have yield loss. The industry benchmark for food cost as a percentage of revenue in UK restaurants is 28–35%, so even small prep losses at the station materially affect dish-level GP accuracy. Jelly applies waste and prep-loss percentages at the ingredient level within each recipe. The costed margin then reflects what actually reaches the guest, not only what was ordered.
Site-level overrides allow each location to carry its own yield assumptions where kitchen setup or supplier differs. For example, a city-centre site receiving pre-portioned protein will carry a different yield factor than a rural pub butchering in-house. Despite these differences, both feed into the same group dashboard with their adjustments intact, which enables genuine like-for-like GP comparisons across locations. Small variances between theoretical and actual food costs are often acceptable in UK hospitality. Consistent variances above this threshold require immediate investigation, and Jelly surfaces those variances automatically.
Layer 3 – Menu Engineering with Live POS Sales Mix
Dish GP margin tells only half the story. The other half is how often each dish sells. Jelly integrates in real time with Square, EPOS Now, Toast and Lightspeed, connecting in under five minutes, to pull item-level sales data the moment each transaction completes. That data maps to Jelly dishes and produces a live sales mix that shows which items are both popular and profitable across every site.
POS integration with inventory systems enables real-time stock depletion on every sale. This provides the accurate sales data required to calculate site-specific actual versus theoretical usage and GP variances without manual spreadsheets. For multi-site operators, a head chef or operations manager can spot a low-margin dish selling at high volume at one site and act on it the same day. They can reprice, reformulate or remove the dish instead of discovering the problem in a monthly accountant's report.
Layer 4 – Group Roll-Up, Alerts and Red-Flag Dashboards
The group layer is where Jelly's value compounds for multi-site operators. Every recipe cost, site adjustment and POS sales figure rolls into a single weighted group GP figure that updates continuously. Owners and finance managers see the group margin without opening spreadsheets or chasing chefs for numbers.
Daily margin alerts flag when any site drops below its GP target, when a supplier price change pushes a dish into the red or when a site's actual food cost drifts above theoretical. Centralised performance dashboards allow UK multi-site operators to monitor GP margins, stock variance and waste across all locations from a single view, replacing fragmented spreadsheet reporting. Jelly delivers this natively at £129 per site per month with no per-user fees.
One operator using Jelly improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Amber restaurant saves £3,000–£4,000 per month through faster reactions to supplier price changes and tighter menu controls, which represents a return of about 68× on the platform cost.
Talk to the Jelly team about your current GP tracking challenges.
Why Spreadsheets Fail Multi-Site Operations
Spreadsheet-based inventory tracking carries a high risk of human error through typos, broken formulas and version-control mistakes, which directly distort COGS and gross profit calculations. Across two or more sites, that risk multiplies. Each kitchen maintains its own file, prices update at different times and the group view always requires a manual merge, so it always arrives late.
Automated inventory platforms reduce labour time dramatically for UK multi-site operators, generating stocktakes and reports automatically in seconds with instant consolidated group reporting, compared to hours or days required with spreadsheets. Jelly users consistently recover 10–20 hours of weekly admin and add an average of 2 percentage points to gross margins within the first three months. At group level, that margin recovery translates directly to the monthly cash impact described earlier.
UK hospitality and food service businesses typically achieve average net profit margins of 3–9%, which leaves almost no room for the margin drag that spreadsheet drift introduces. Jelly closes that gap by making accurate, VAT-exclusive GP data the default state rather than the result of hours of manual effort.
Frequently Asked Questions
How do you work out GP across multiple UK sites?
Calculating GP across multiple sites requires a consistent methodology applied at every location simultaneously. The formula is: GP% = (Net Revenue − Cost of Goods Sold) ÷ Net Revenue × 100. Net revenue must be VAT-exclusive at every site. The challenge for multi-site operators is that each kitchen has different suppliers, different yield rates and different sales mixes, so a simple average of site GPs produces a misleading group figure. The correct approach is a weighted roll-up. Each site's GP is weighted by its revenue contribution to produce an accurate group margin. Jelly automates this entire process, from invoice scanning at each site through to the weighted group dashboard, so the figure stays current and comparable across locations.
How should UK operators handle VAT when calculating food GP margins?
All GP margin calculations must use VAT-exclusive (net) figures on both the revenue and cost sides. On the revenue side, strip VAT from menu prices before calculating margin. For standard-rated items, divide the VAT-inclusive price by 1.20, so a £12.00 menu price becomes £10.00 net. Food ingredients purchased from suppliers are generally zero-rated for VAT purposes, but any VAT on purchases must also be excluded from cost figures. Using VAT-inclusive revenue figures inflates the denominator and understates the true GP percentage, which produces figures that are not comparable across sites or periods. Jelly applies VAT-exclusive calculations automatically across every dish and every site, which removes the risk of inconsistent treatment in manual spreadsheets.
What is the best GP calculator for multi-site chef operations in 2026?
The most effective GP calculator for a 2–5 site UK group in 2026 operates across four layers: recipe costing with live ingredient prices, site-level yield adjustments, menu-level sales mix from POS data and a weighted group roll-up with real-time alerts. Spreadsheets and single-site tools cannot deliver this because they lack live invoice scanning, POS integration and automated cross-site aggregation. Jelly is purpose-built for this operational profile. It onboards within a week, connects to Square, EPOS Now, Toast and Lightspeed in under five minutes and delivers a live group GP dashboard without manual data entry.
How do you adjust recipe costs for waste and prep loss in professional kitchens?
Waste and prep-loss adjustments apply at the ingredient level within each recipe. The standard method calculates the yield percentage for each ingredient, using usable weight ÷ purchased weight × 100, then divides the ingredient cost by the yield percentage to arrive at the true cost per usable unit. For example, a protein with 80% yield purchased at £10/kg has a true usable cost of £12.50/kg. These adjustments must be applied consistently across all sites for GP comparisons to remain meaningful. In Jelly, waste percentages are set per ingredient within the recipe builder and update automatically when invoice prices change, so the costed margin reflects real kitchen conditions rather than theoretical purchase prices.
Conclusion: Move from Manual Guesswork to Live GP Control
For UK restaurant, pub and hotel groups operating across 2–5 sites, the margin gap between what spreadsheets report and what kitchens actually produce costs real money, often around 2 GP points and £3,000–£4,000 per month. Jelly's automated four-layer GP margin calculator closes that gap by connecting invoice scanning, recipe costing, site-level adjustments, POS sales data and group dashboards into a single live system. There are no spreadsheets to merge, no version drift and no delayed data. Teams gain accurate, VAT-exclusive GP visibility across every site, updated continuously.
Jelly is a focused automated GP margin calculator for growing UK hospitality groups. At £129 per site per month with no per-user fees and onboarding within a week, it provides a fast path from manual margin guesswork to real operational control.