GP Margin Calculator for Back-of-House: Free UK Tool

GP Margin Calculator for Restaurant Back-of-House Management

Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026

Key Takeaways for UK Restaurant Margins

  • Most UK restaurant operators lose margin because manual GP tracking across invoices, recipes, and POS exports is slow and error-prone.
  • Accurate dish-level GP requires removing VAT from selling prices using the 1/6th rule before applying the standard margin formula.
  • Ingredient-specific wastage percentages prevent underestimating true food costs and protect margins on every plate.
  • Menu engineering with the Stars, Plowhorses, Puzzles, and Dogs framework focuses changes on dishes that lift overall profit most effectively.
  • Jelly automates the entire GP workflow for UK restaurants; book a demo to see it in action.

Step 1 – Capture invoice line items accurately

Accurate ingredient costs sit at the heart of every GP calculation. Purchases must be recorded net of VAT so they are directly comparable with ex-VAT sales figures. This requires stripping the 20% VAT from every supplier invoice line before it enters your cost model.

For each ingredient, record supplier name, SKU or product description, net unit price, pack size, and delivery date. These fields must be updated after every invoice, not monthly, because ingredient prices shift week to week. A cost model built on last month’s prices is already out of date the moment a new invoice arrives, so real-time updates keep GP calculations reliable.

Pro tip: Create a single master ingredient register. Every recipe should draw from this register, so one price update cascades across every dish that uses that ingredient automatically, provided your system supports this structure.

Step 2 – Apply the UK GP formula with the 1/6th VAT rule

Dish-level gross profit margin follows a simple formula.

GP Margin (%) = (Net Selling Price − Net COGS) ÷ Net Selling Price × 100

The UK-specific step is removing VAT from the selling price before applying this formula. At the standard 20% VAT rate, calculate the net selling price by dividing the gross VAT-inclusive price by 1.2. This is called the 1/6th rule because the VAT element equals one sixth of the gross price.

Worked example: A burger sells for £12.00 including VAT. Net selling price = £12.00 ÷ 1.2 = £10.00. If the net food cost of that burger is £3.20, then GP Margin = (£10.00 − £3.20) ÷ £10.00 × 100 = 68%.

Using this formula on gross selling prices without removing VAT overstates net revenue and understates the true food cost percentage. That error compounds across every dish and can hide serious margin erosion.

Step 3 – Factor in realistic wastage percentages

Raw ingredient costs rarely match what reaches the plate. Trimming, cooking loss, spoilage, and portioning errors all reduce usable yield. A standard wastage allowance of 5–8% is typical across UK kitchens, although protein-heavy menus or high-volume operations may run higher.

To apply wastage to an ingredient cost, divide the net unit price by the usable yield percentage. For example, if chicken breast costs £8.00/kg net and has a 10% trim loss, the true cost per usable kilogram is £8.00 ÷ 0.90 = £8.89/kg.

Common pitfall: Many teams apply a blanket wastage percentage to every ingredient regardless of preparation method. Dry goods such as pasta or rice have near-zero wastage, while fresh fish or whole vegetables can lose 20–30% of their weight during prep. Build ingredient-specific wastage rates into your register instead of relying on a single average.

Step 4 – Calculate dish-level GP from your recipes

Dish-level GP becomes a straightforward aggregation once net ingredient costs and wastage-adjusted yields are in place. The example below shows three dishes using the formula from Step 2.

Burger (£12.00 gross / £10.00 net): Net COGS £3.20 → GP 68%
Grilled salmon (£18.00 gross / £15.00 net): Net COGS £6.30 (including 15% yield loss on fillet) → GP 58%
Margherita pizza (£14.00 gross / £11.67 net): Net COGS £2.80 → GP 76%

Pro tip: Map POS items to dish recipes using exact POS item names. A POS line item labelled “Burger Classic” linked to a recipe named “Classic Beef Burger” creates gaps in sales-mix data and produces inaccurate margin reports.

Step 5 – Roll up to restaurant-level COGS and prime-cost targets

Restaurant-level food cost percentage for a typical UK full-service site often sits between 28% and 35%. The standard formula for actual food cost percentage is: (Opening Inventory + Purchases − Closing Inventory) ÷ Total Food Sales (ex-VAT, excluding beverages and service charges) × 100.

Prime cost, which combines food cost and labour cost, gives the clearest view of kitchen financial health. For most UK full-service restaurants, a prime cost below 65% of net revenue leaves enough margin to cover overheads and generate profit.

Food cost percentages above 35% signal a problem. The dish-level GP calculations from Steps 2–4 highlight which items pull the average up. Menu engineering, covered in Step 6, then becomes the main corrective tool.

Step 6 – Run menu-engineering analysis with Stars, Plowhorses, Puzzles, and Dogs

Menu engineering classifies every dish into four categories: Stars (high margin, high popularity), Plowhorses (low margin, high popularity), Puzzles (high margin, low popularity), and Dogs (low margin, low popularity), based on gross profit contribution and sales mix percentage. A practical workflow defines an analysis period of 4–12 weeks, calculates gross profit per dish as selling price net of VAT minus actual food cost, calculates mix percentage as each item’s share of total portions sold, then plots items into the four quadrants.

The framework warns against relying on GP% alone because a dish with a 70% GP% on a £6 item generates less actual profit than one with a 60% GP% on a £14 item. Use absolute gross profit contribution per cover, not percentage alone, when ranking items.

For Plowhorses, which are popular but low-margin dishes, operators can apply subtle price increases, portion adjustments, high-cost ingredient substitution, or bundling with higher-margin add-ons rather than removing popular items. Dogs with consistently low sales and low margins are candidates for removal. Menu engineering reviews should be built into a quarterly calendar cadence at minimum, with before-and-after tracking to measure how changes move items between categories. A well-engineered menu can increase gross profit by 10–15% without adding a single new customer.

Step 7 – Transition from spreadsheet to an automated platform

The six steps above show the analytical depth required to protect margins effectively. Each step is executable in a spreadsheet, yet the time cost quickly becomes significant. At 20–30 minutes per dish for initial costing, a 40-item menu represents 13–20 hours of setup work before weekly price updates, wastage adjustments, and sales-mix pulls from the POS.

Purpose-built inventory platforms replace hours of weekly admin work on manual invoice chasing, recipe cost updates, and stock report consolidation with automated processes. Clear transition triggers include more than one site, more than three suppliers, or a head chef spending more than two hours per week on costing admin instead of kitchen operations.

How Jelly automates your GP workflow

Jelly is built specifically for UK restaurants, pubs, and boutique hotels at the £500k+ revenue stage. It automates the entire workflow described above, from invoice capture to dish-level GP, at a flat rate of £129 per month per location with no per-user fees.

Invoice scanning captures every line item, including quantity, SKU, price, and tax, via photo or email and removes manual data entry at Step 1. The Price Alert feature flags every supplier price movement the moment a new invoice is processed, giving chefs the hard data needed to negotiate credits or switch suppliers. In the Cookbook section, chefs build recipes by clicking on ingredients already populated from scanned invoices. Jelly then handles unit conversions, wastage calculations, and cost aggregation automatically. A costing task that takes 28 minutes per dish in a spreadsheet takes about three minutes in Jelly.

The Flash Report delivers a daily, weekly, or monthly view of GP margin calculated from live invoice costs and POS sales data. Jelly integrates natively with Square, EPOS Now, Lightspeed, and Toast through real-time API connections, pulling item-level sales data the moment a transaction completes. Connecting a POS typically takes around five minutes. Sushi Revolution used Jelly to set separate target gross profits on dine-in and delivery menus, accounting for 30% delivery platform commissions, and achieved 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. Across the customer base, Jelly users cut food costs by about 3% on average in the first three months.

Schedule a chat and see the full workflow running live on your own menu data.

Troubleshooting multi-site roll-ups and delivery commissions

Multi-site operators face two compounding problems: consolidating GP data across locations and accounting for delivery platform commissions that vary by channel. Consolidating data from various spreadsheet files into a single report can take days for multi-site groups. Jelly’s central dashboard aggregates invoice and GP data across all connected locations in real time and removes the consolidation step entirely.

Delivery menus also require separate attention. Delivery platforms such as Deliveroo and UberEats charge average commissions of 30%, which squeeze restaurant margins. Jelly’s Delivery Menu Creation feature allows operators to duplicate existing menu items and layer in delivery commission overheads as a separate cost line, producing an accurate GP figure for each sales channel independently. This separation prevents delivery sales from distorting the dine-in GP picture, which is a common error in manual roll-ups.

Measurable success criteria for using Jelly

Operators who implement the seven-step workflow and connect Jelly should target specific outcomes within three months. These include a 3% reduction in food cost percentage, a two-percentage-point lift in gross profit margin, and a reduction of 10–20 hours of monthly admin. These figures reflect the average results reported by Jelly customers across restaurant, pub, and hotel operations in the UK.

The two-percentage-point GP improvement becomes meaningful at scale. On £500,000 annual food revenue, two percentage points equal £10,000 in additional gross profit per year from the same menu, the same suppliers, and the same team.

See your current GP position by booking a demo and bringing your last three months of invoices.

Advanced tips – Sales Mix reports and quarterly menu re-engineering

Live GP data flowing from POS into Jelly turns the Sales Mix report into the primary tool for quarterly menu re-engineering. The report updates the Stars, Plowhorses, Puzzles, and Dogs classifications in real time and removes the need to rebuild the analysis manually each quarter.

Daypart analysis can reveal that a dish performs as a Star at dinner but a Dog at lunch, which allows operators to restrict it to dinner service and simplify daytime operations. Beverage and add-on menus should be analysed separately with the same Stars, Plowhorses, Puzzles, and Dogs framework because drinks are frequently the highest-margin items yet remain underengineered. Run the full four-quadrant analysis on starters, mains, desserts, and drinks as separate categories. A low mix percentage across an entire section may indicate a positioning or service issue rather than a problem with individual dishes.

Frequently Asked Questions

What is a good GP margin for a UK restaurant?

A good gross profit margin for a UK full-service restaurant often sits between 65% and 75% at the dish level, with an overall food cost percentage of 28–35% of net food sales. Quick-service and fast-casual concepts often target higher GP margins because they use simpler recipes and lower ingredient costs, while fine dining operations may accept slightly lower GP percentages on food if beverage margins compensate. The most useful benchmark is consistency, since a GP margin that is stable and improving quarter on quarter is more valuable than hitting a specific percentage once. Jelly customers report an average two-percentage-point GP improvement within the first three months of use.

How do you calculate GP margin with VAT in the UK?

In the UK, VAT at 20% must be removed from the selling price before calculating GP margin. Use this sequence: Net Selling Price = Gross Selling Price ÷ 1.2. Then apply: GP Margin (%) = (Net Selling Price − Net COGS) ÷ Net Selling Price × 100. Both the selling price and the ingredient costs must sit on a net-of-VAT basis for the calculation to stay accurate. Using gross VAT-inclusive figures overstates revenue and understates the true food cost percentage. This is the 1/6th rule, where the VAT element of any VAT-inclusive price equals exactly one sixth of that gross price.

How do you figure out GP margin for a single dish?

To calculate GP margin for a single dish, start by listing every ingredient in the recipe with its net unit cost and the quantity used per portion. Apply a wastage adjustment to each ingredient based on its usable yield by dividing the cost per kilogram by the decimal yield percentage. Sum all adjusted ingredient costs to get the net cost of goods sold for that dish. Divide the gross selling price by 1.2 to get the net selling price. Finally, apply the formula: GP Margin (%) = (Net Selling Price − Net COGS) ÷ Net Selling Price × 100. Repeat this process after every supplier invoice so the figure remains current.

What is the formula for GP margin in a restaurant context?

The GP margin formula used in restaurant back-of-house management is: GP Margin (%) = (Net Selling Price − Net Cost of Goods Sold) ÷ Net Selling Price × 100. At the restaurant level, this becomes: GP Margin (%) = (Total Net Food Sales − Total Net Food Cost) ÷ Total Net Food Sales × 100. Total net food sales exclude VAT, beverages, and service charges, and total net food cost is calculated as Opening Inventory + Net Purchases − Closing Inventory. Both figures must exclude VAT to produce a meaningful and comparable result.

How does Jelly differ from using a spreadsheet for GP margin calculations?

A spreadsheet requires manual data entry for every invoice, manual price updates when supplier costs change, manual unit conversions within recipes, and a separate process to pull and reconcile POS sales data. Each of these steps introduces the possibility of error and consumes time, often 10–20 hours per week for operators managing multiple suppliers and a full menu. Jelly automates all of these steps. Invoices are scanned and every line item is captured automatically, ingredient prices update in real time across every recipe that uses them, and POS sales data flows in through native integrations with Square, EPOS Now, Lightspeed, and Toast. The result is a live GP margin figure at dish and restaurant level, available at any time without manual input.

Conclusion: Protect your margins today

The seven-step workflow in this guide, from invoice capture and VAT-adjusted costing through to menu engineering and quarterly Sales Mix reviews, gives UK restaurant operators a complete and repeatable process for managing GP margins at dish and restaurant level. The manual version of this workflow remains executable but time-intensive. At scale, across multiple sites or a large menu, the spreadsheet approach accumulates errors and delays that directly cost margin.

Jelly automates every step of this workflow at £129 per month per location and delivers onboarding that generates value within the first week. Operators who connect their POS and start scanning invoices immediately gain live dish-level GP, Price Alerts on every supplier movement, and a Sales Mix report that turns quarterly menu engineering into a 30-minute task instead of a two-day project.

See exactly where your margins stand today by booking a demo.