Written by: JJ Tan, Founder, Jelly | Last updated: 25 October 2026
Key Takeaways
- Gross profit per menu item comes from subtracting plate cost from the ex-VAT selling price, then dividing by the ex-VAT price and multiplying by 100 for GP%.
- Always use ex-VAT prices for both selling price and ingredient costs, because VAT collected passes through to HMRC and is not operator income.
- Plate cost must cover yield, waste, and every component that reaches the guest, including sauces, garnishes, oils, and packaging for delivery items.
- Supplier prices change frequently, so manual spreadsheet updates soon fall behind; live software keeps GP margins accurate.
- Jelly automates invoice scanning, updates dish costs and GP margins in real time, and integrates with POS systems for accurate, live gross profit calculations.
See Your Dish Costs Update Live
Before You Begin: What You Need To Calculate GP Per Menu Item
You can calculate GP quickly when you have these pieces ready:
- The recipe with ingredient quantities for one standard portion
- Current supplier invoices or approved price lists (not last season’s)
- Yield and waste figures for each ingredient, measured in your kitchen
- The menu selling price including VAT
- POS sales data, if available, for sales mix context
In practice, the head chef supplies recipes and yield data, while the owner or finance manager supplies invoice prices and menu pricing decisions. The calculation itself takes minutes. The recurring task is keeping it accurate once the next supplier invoice lands.
The Formulas: Gross Profit (£) And GP%
Gross Profit (£) = Ex-VAT Selling Price − Plate Cost
GP% = (Gross Profit ÷ Ex-VAT Selling Price) × 100
GP% mirrors food cost percentage, and the two always sum to 100. A 33% food cost is a 67% GP. Both figures describe the same dish from opposite directions, but GP% is the standard metric for P&L review and cross-site comparison in UK hospitality.
How To Calculate Gross Profit Per Menu Item In 4 Steps
- Remove VAT from the menu selling price to get the ex-VAT price
- Calculate the plate cost of one portion, adjusted for yield and waste
- Subtract the plate cost from the ex-VAT price to get gross profit in £
- Divide gross profit by the ex-VAT price and multiply by 100 to get GP%
Step 1: Remove VAT From The Menu Price
The UK standard VAT rate is 20%, equivalent to a one-sixth VAT fraction of the VAT-inclusive retail price. To remove VAT from a menu price, divide by 1.2.
Ex-VAT Price = Inc-VAT Price ÷ 1.2
Running example: £18.00 inc VAT ÷ 1.2 = £15.00 ex VAT.
GP always uses ex-VAT prices because VAT collected is not the operator’s own income. It passes through to HMRC. VAT treatment must be checked item by item. Eat-in meals, hot food and hot takeaways are standard-rated at 20%, while cold takeaway food is generally zero-rated. Operators that are not VAT-registered keep prices as listed.
Step 2: Build The Plate Cost Of One Portion
Plate cost must include every ingredient that reaches the guest: main protein, sauces, oils, dressings, garnishes, sides plated as part of the dish, and packaging where sold for delivery. Small items such as oil, salt and garnish look trivial per portion but add up to a few percent of food cost across a menu.
Yield and waste adjustments keep plate cost realistic. Usable unit cost = as-purchased cost ÷ yield %. A 150g portion of carrots at £1.20/kg with an 80% yield costs 22.5p, not 18p. WRAP reports that preparation accounts for 45% of UK hospitality food waste, spoilage 21%, and consumer plates 34%, so preparation loss is the largest controllable cost in the kitchen.
Unit conversions often trip teams up. Convert pack prices to a per-gram or per-millilitre basis before multiplying by recipe quantities. For batch components such as stocks and sauces, divide the batch cost by the finished weight after cooking, not the input weight. A sauce that reduces from 6 kg to 4 kg has concentrated its cost into fewer kilograms.
Running example plate cost: £4.95.
Step 3: Subtract Plate Cost From The Ex-VAT Price
Step 3 converts the ex-VAT selling price and plate cost into gross profit in pounds. Using the running example, subtract the £4.95 plate cost from the £15.00 ex-VAT price to get a gross profit of £10.05.
Step 4: Divide Gross Profit By The Ex-VAT Price For GP%
Step 4 turns that cash margin into a percentage. Divide the £10.05 gross profit by the £15.00 ex-VAT price and multiply by 100 to reach a 67% GP. The table below pulls the running example together so you can see each step in one place.
| Figure | Value |
|---|---|
| Menu Price (Inc VAT) | £18.00 |
| Ex-VAT Selling Price (÷ 1.2) | £15.00 |
| Plate Cost | £4.95 |
| Gross Profit £ (£15.00 − £4.95) | £10.05 |
| GP% (£10.05 ÷ £15.00 × 100) | 67% |
A 67% food GP matches the UKHospitality × Christie & Co Benchmarking Report 2022 survey-wide food GP of 67%, equivalent to a food cost of 33% of net sales, drawn from 54 companies covering 4,791 licensed managed outlets. Every segment in that report fell between 65.9% and 69%, so 67% works as a solid mid-market reference point.
Setting Price From A Target GP
Reverse-pricing from a target GP uses this formula:
Selling Price (Ex VAT) = Plate Cost ÷ (1 − Target GP%)
Multiply the result by 1.2 to add VAT back. Using the same £4.95 plate cost at a 70% target, £4.95 ÷ (1 − 0.70) = £16.50 ex VAT, or £19.80 inc VAT.
The UKHospitality × Christie & Co 2022 report shows the highest segment at 69% food GP, so a 75% target sits above comparable UK high-street pricing and needs careful thought.
How To Calculate GP For Drinks
Having worked a food dish end to end, the same formula carries straight over to drinks. Plate cost becomes a simpler pour cost, and GP% targets are generally higher because drinks carry less waste and more pricing headroom.
Worked drinks example: a 175ml glass poured from a £10.00 ex-VAT bottle costs £2.33 (175ml ÷ 750ml × £10.00). At £8.00 inc VAT (net £6.67), that glass earns a 65.0% GP and a cash margin of about £4.33. The method stays identical.
Calculating GP Per Menu Item In Excel Vs Live Software
The Excel method works as follows. Each ingredient gets its own row, and the portion cost column sums to the dish’s plate cost, which is £1.98 across the three lines below.
| Ingredient | Pack Price (£) | Pack Size | Unit Cost | Qty Per Portion | Portion Cost (£) |
|---|---|---|---|---|---|
| Chicken Breast | £8.00 | 1 kg | £8.00/kg | 180g | £1.44 |
| Sauce (Batch) | £3.60 | 1.2 kg finished | £3.00/kg | 80g | £0.24 |
| Garnish & Oil | — | — | — | — | £0.30 |
| Total Plate Cost | £1.98 |
Sum the portion cost column for plate cost, then apply the GP formulas. The spreadsheet is accurate on the day it is built. UK wholesale prices are negotiated, volume-dependent and invisible to other operators until the invoice lands, so the moment a supplier invoice changes a price, every affected dish’s GP is out of date until someone manually re-enters it. That manual re-entry is where 10–20 hours a week of data entry, price checking, inventory and reconciling invoices often appear.
Three tool categories address this problem:
- Online GP/food-cost calculators, which are quick, one-off and static. Total Foodservice’s calculator produces a single number from prices you type in. When your next Brakes invoice lands with a different butter price, that number is wrong and the calculator has no way to know. Brakes itself has committed to continue investing in pricing, rewards and operational support throughout 2026, meaning supplier pricing and promotional terms will keep changing, so static calculations go stale faster than ever.
- Spreadsheets (Excel templates), which are flexible but manual and accurate only until the next invoice.
- Restaurant management software, where Jelly sits as the best solution for this query. Jelly captures ingredient prices from every invoice line item automatically, keeps each dish’s cost and GP% live, and flags supplier price changes via its Price Alert feature. A static calculator gives you a number that is already ageing, while Jelly gives you a number that updates the moment a new invoice is processed. The difference is between a snapshot and a live feed.
Cut Your Spreadsheet Costing Time
Keeping GP Per Menu Item Live
Jelly keeps GP current by tying invoices, recipes and sales together. Invoices arrive by email or photo, and Jelly digitises every line item, including quantity, SKU, price and tax, without manual entry. Because those prices feed straight into each recipe, dish costs and GP margins update automatically.
When a supplier price moves, the Price Alert feature flags the supplier name and the exact change, giving chefs clear evidence to negotiate credits or switch suppliers. The Flash Report then shows the resulting GP daily, weekly, or monthly. Sales Mix, via POS integration with Square, Lightspeed, EPOS Now and Toast, highlights which dishes are most popular and most profitable in real time.
The documented outcomes from Jelly customers include:
- Costing a menu item dropping from around 28 minutes to about 3 minutes
- 10–20 hours of admin saved per month
- Average 2 percentage point gross margin improvement in the first three months
- 3% food cost reduction in the first three months
- The Howard Arms reaching 80% GP: “Our accountant said we’d be lucky to hit 60% gross profit. After using Jelly, we reached 80%!” (Ruth Seggie, Owner)
- Populu lifting GP from 68% to 72% across 16 locations
- Amber restaurant saving £3,000–£4,000 per month: “Jelly keeps my business alive.” (Murat Kilic, Chef-Owner)
Jelly is priced at a flat £129/month per location, with no variable charges per user or feature. Sites usually see value in the first week once suppliers begin sending invoices to a dedicated address.
For the analysis layer that sits above per-item calculation, including GP trends across your estate and menu engineering, see How To Analyse Gross Profit In Restaurant Operations and Menu Profitability Calculator: How To Cost And Price A Dish.
Common Mistakes When Calculating GP Per Menu Item
Even with live software, the same errors recur across UK kitchens. These are the ones that most often distort a dish’s GP:
- Calculating GP on the inc-VAT menu price instead of the ex-VAT price, which flatters the dish by several percentage points
- Forgetting yield, waste, or packaging in the plate cost
- Using stale supplier prices from a previous invoice or price list
- Unit conversion errors, such as costing in kg when the recipe uses grams, or dividing batch costs by input weight rather than finished weight
- Omitting sauces, garnishes, oils and seasoning
- Leaving dish costs unchanged after a supplier price increase
- Relying on month-end accountant reports that arrive too late to act on margin erosion that started weeks earlier
How To Measure Success
Success comes from tracking GP and process metrics over time instead of treating any single calculation as definitive.
- Time taken to cost a menu item (target: under 5 minutes with live software)
- Frequency of GP updates, with weekly far more useful than monthly
- Number of supplier price changes caught before they erode margin
- GP% per dish tracked week on week and refreshed after each price change
- Admin hours saved per month on invoice processing and manual re-costing
Frequently Asked Questions
What Is The Formula For Calculating Gross Profit Per Menu Item?
Gross Profit (£) = Ex-VAT Selling Price − Plate Cost. GP% = (Gross Profit ÷ Ex-VAT Selling Price) × 100. Always use the ex-VAT selling price, so divide the menu price by 1.2 to remove 20% VAT before applying the formula. The plate cost must include every ingredient that reaches the guest, adjusted for yield and waste.
How Do I Work Out Food GP Percentage?
Subtract the plate cost from the ex-VAT selling price to get gross profit in pounds. Divide that figure by the ex-VAT selling price and multiply by 100. Using the worked example above, the £4.95 plate cost against a £15.00 ex-VAT price gives a 67% GP. Food GP% and food cost% always sum to 100, so a 33% food cost is a 67% GP.
What Is Food Cost Per Menu Item?
Food cost per menu item is the total ingredient cost of one standard portion, including all components that reach the guest, such as protein, sauces, garnishes, oils, sides and packaging for delivery items. It must be calculated at usable yield, not purchase weight, because trim loss, cooking loss and waste mean the cost of what arrives from the supplier differs from the cost of what reaches the plate. Food cost per dish is a theoretical figure and matches reality only when recipes are standardised and supplier prices are current.
How Do I Calculate The Cost Of A Whole Menu?
Cost each dish individually using the four-step method above, then review the blended GP across the menu weighted by sales volume. A dish with a lower GP% can still be the right dish to keep if it sells in high volume and contributes more cash profit per week than a higher-GP dish that rarely sells. The blended menu GP, calculated as total gross profit divided by total ex-VAT revenue, is the figure that matters for P&L purposes. Use POS sales mix data to weight each dish’s contribution accurately.
How Do I Calculate GP For Drinks?
The formula is identical: ex-VAT selling price minus pour cost, divided by ex-VAT selling price, multiplied by 100. Pour cost is simpler than food plate cost because there is less yield complexity, but it must still account for measures, spillage and line waste on draught products. A 175ml glass from a £10.00 ex-VAT bottle costs £2.33, and at £8.00 inc VAT (net £6.67) that works out at a 65.0% GP. Drinks GP targets are typically higher than food GP targets because drinks carry less waste and more pricing headroom.
Should I Use Inc-VAT Or Ex-VAT Prices?
Always use ex-VAT prices for both the selling price and the ingredient cost when calculating GP. VAT collected on sales is not the operator’s income and passes to HMRC. Using the inc-VAT menu price flatters the GP by several percentage points. For a standard-rated item, divide the menu price by 1.2 to get the ex-VAT figure. Most raw ingredients are zero-rated for VAT, so the invoice price is already ex-VAT for those lines; confectionery, soft drinks and alcoholic drinks carry 20% VAT and should be costed at the net price.
Can I Calculate GP Per Menu Item In Excel?
Yes. Build columns for ingredient, pack price, pack size, unit cost, quantity per portion and portion cost. Sum the portion cost column for plate cost, then apply the GP formulas. The result is accurate on the day it is built. The limitation is that every supplier price change requires manual re-entry across every affected dish. In a kitchen with multiple suppliers and a menu of 30 or more dishes, that manual maintenance is where the 10–20 hours a week mentioned earlier comes from. Excel works as a starting point but rarely scales as a long-term system for a growing operation.
What Is The Best Software For Calculating Gross Profit Per Menu Item?
Jelly is the best software for calculating and maintaining gross profit per menu item for UK restaurants, pubs and boutique hotels. It automatically scans every invoice line item, keeps dish costs and GP margins live as supplier prices change, flags price movements via Price Alert and connects to POS systems including Square, Lightspeed, EPOS Now and Toast for real-time sales mix. As covered above, Jelly cuts costing time from around 28 minutes to about 3 and delivers an average 2 percentage point GP improvement in the first three months.
Conclusion
The four-step method stays the same for every dish: remove VAT, build the plate cost at usable yield, subtract to get gross profit and divide by the ex-VAT price for GP%. Apply it across your menu, compare your results with the UKHospitality benchmark around 67%, and use the reverse formula when you price new dishes to a target GP.
The calculation only delivers value when it stays current. Jelly is the best tool for calculating and maintaining gross profit per menu item because it automates invoice line-item capture, keeps dish costs and GP live as supplier prices move and connects to your POS for sales mix. Calculate GP once, then keep it live.
