Written by: JJ Tan, Founder, Jelly
Key Takeaways for UK Hospitality Operators
- Gross profit margin (GP%) is calculated as (Revenue ex-VAT − COGS ex-VAT) ÷ Revenue ex-VAT × 100, and must be tracked separately for food, wet sales and delivery channels.
- Manual spreadsheet tracking consumes 10–20 hours per week and delivers delayed data, while Jelly’s automated invoice-to-POS workflow replaces this process entirely.
- Weekly review is essential because monthly P&L data arrives 2–4 weeks after period end, leaving no time to correct margin issues before they compound.
- UK hospitality benchmarks include 60–70% food GP and 65–72% wet GP for well-run independent operators; a 7 percentage point gap on £300,000 turnover equals £21,000 lost profit annually.
- See how Jelly automates gross profit tracking for UK restaurants, pubs and hotels.
Build a Five-Column Monthly Gross Profit Margin Dashboard
The table below gives you a ready-to-use monthly dashboard structure. Populate revenue figures directly from your POS system and COGS figures from supplier invoices, never from memory or estimates.
| Category | Revenue (ex-VAT) £ | COGS (invoices) £ | Gross Profit £ | Gross Profit % |
|---|---|---|---|---|
| Food | £28,000 | £9,800 | £18,200 | 65% |
| Wet Sales (Draught) | £18,000 | £6,120 | £11,880 | 66% |
| Wet Sales (Spirits) | £9,000 | £2,700 | £6,300 | 70% |
| Delivery (net of commission) | £5,600 | £2,240 | £3,360 | 60% |
| Total | £60,600 | £20,860 | £39,740 | 65.6% |
Food GP% and drink GP% must be tracked separately because a blended figure can mask serious problems, such as food GP at 55% hidden behind drinks GP at 70%.
This dashboard gives you the structure you need, but populating it manually from invoices and POS exports consumes the 10–20 hours per week mentioned earlier. The next section explains how to automate that workflow inside Jelly.
Set Up Monthly Gross Profit Tracking in Jelly Step by Step
The steps below configure a repeatable monthly tracking process inside Jelly.
- Connect your POS system. Open Jelly, click Integrations, sign in to your POS, grant permissions and select which categories, such as food and beverages, to sync. Setup takes approximately five minutes.
- Route invoices to Jelly. Ask suppliers to email invoices to your dedicated Jelly address, or photograph paper invoices directly into the app. Jelly scans every line item, including quantity, SKU, price and tax, automatically.
- Map dishes to ingredients. In the Kitchen section, build recipes by clicking on ingredients already populated from scanned invoices. Because unit conversions and wastage percentages are calculated instantly, removing manual lookup and calculations, what previously took 28 minutes per dish now takes approximately three minutes.
- Set GP targets by category. Enter target margins, for example 65% for food and 68% for wet sales, so Jelly can flag variances in real time.
- Review weekly, not monthly. Because of the delay mentioned earlier, weekly review provides a four-day response window for adjustments to ordering, pricing or supplier negotiations.
Use Jelly Reports for Real-Time Gross Profit Margins
Once invoices and POS data flow into Jelly, three reports deliver daily GP visibility without any manual input.
- Flash Report. This gives a daily, weekly or monthly view of GP margin calculated from invoice costs and POS sales. Operators see their actual margin the same day, not weeks later via an accountant.
- Price Alert. Every supplier price increase or decrease is flagged instantly, including the ingredient, the amount and the supplier. Chefs receive hard data to negotiate credits or switch suppliers quickly.
- Sales Mix (Menu Engineering). By integrating with POS systems via real-time API, Jelly shows which dishes are most popular and most profitable at the same time, which supports data-driven menu decisions.
Jelly also integrates directly with Xero via a one-click push of digitised invoices, supporting automated gross profit tracking by allowing cost data to flow into the accounting system continuously rather than through manual exports. This integration reduces bookkeeping time by approximately 90%.
Jelly is priced at a flat rate of £129 per site per month, with no variable charges per user or feature.
See the Flash Report and Price Alert in action for your venue.
UK Hospitality Gross Profit Benchmarks You Should Hit
The following benchmarks apply to well-run independent operators and are all calculated against net revenue after VAT.
- Restaurants (food). 60–70% food GP, 60–70% drinks GP, 60–70% combined. Below 60% combined typically indicates high food costs, drinks margin erosion or menu pricing that has not kept pace with ingredient inflation.
- Pubs (wet sales). 60–70% overall wet GP, 65–72% for a healthy wet-led pub, 55–65% blended for a gastropub.
- Cafés (blended). 65–72% blended across the whole menu. Coffee and hot drinks achieve 75–80%, while hot food and brunch deliver 55–65%.
The £21,000 annual impact described earlier, from a 7-point gap on £300,000 turnover, is a figure that automated tracking makes visible and recoverable.
Avoid These Common Gross Profit Tracking Mistakes
- Including VAT in revenue. Calculating cost percentages against gross revenue including VAT understates every cost metric by roughly 17% and makes GP appear higher than it is. Always strip VAT from both revenue and COGS before calculating margins.
- Blending food and drink GP. A blended GP of 60% can mask food GP at 55% versus drink GP at 68%. Track each category separately.
- Monthly-only review cycles. The monthly delay described earlier means operators have no time to correct issues before the next several weeks compound losses. Weekly review is the minimum viable cadence.
- Ignoring delivery commissions. Delivery commissions typically around 30% (with a published range of 25-35%) from platforms such as Deliveroo or Uber Eats, plus VAT and other fees, must be deducted from delivery revenue to calculate true net revenue and GP. Treating delivery orders as full gross revenue distorts GP% calculations materially.
Fix Invoice Issues, Recipe Drift and Multi-Site Gaps in Jelly
The following issues arise regularly in UK hospitality operations and have direct solutions inside Jelly.
- Short deliveries. Signing for 23 cases when the invoice states 24 creates direct stock loss. Jelly’s Price Alert flags invoice line-item discrepancies on the day of receipt, which enables same-week credit note requests rather than end-of-month reconciliation.
- Unnotified price increases. A 6% creep in food cost percentage can erase the entire net profit of a UK venue. Because Jelly updates ingredient costs with every new invoice, dish GP margins refresh automatically. A red percentage appears on any dish whose margin has fallen, which prompts immediate action.
- Recipe drift across sites. Jelly’s centralised Cookbook holds a single source of truth for every recipe. When an ingredient price changes at one site, the cost impact is visible across all linked locations simultaneously, which removes the spreadsheet drift that causes multi-site inconsistency.
- Theoretical versus actual GP gaps. A gap between theoretical and actual GP warrants investigation into waste, overpouring or portion drift. Jelly’s Flash Report surfaces this gap daily rather than at month end.
Frequently Asked Questions
How do you track gross profit margin monthly in a UK restaurant, pub or hotel?
The most reliable method is to pull revenue figures directly from your POS system and COGS figures from supplier invoices, then calculate GP% by category, including food, wet sales and delivery, separately for each period. Automated platforms such as Jelly connect POS and invoice data in real time, generating a daily Flash Report that shows actual GP without any manual data entry. A weekly review cadence is recommended rather than monthly, because monthly data arrives too late to correct margin issues before they compound.
How do you calculate gross profit margin in the UK?
The formula is (Revenue ex-VAT − COGS ex-VAT) ÷ Revenue ex-VAT × 100. Both revenue and costs must be recorded net of VAT, which is a pass-through item and must not appear in either line. COGS includes raw ingredients, packaging and any directly attributable supply costs such as the Soft Drinks Industry Levy on applicable beverages. It excludes rent, utilities, marketing and administrative salaries. For delivery channels, the platform commission must be deducted from gross delivery revenue before applying the formula.
What are the most common gross profit tracking mistakes in UK hospitality?
The four most damaging mistakes are calculating margins against VAT-inclusive revenue, which overstates GP by approximately 17%, blending food and drink GP into a single figure that hides category-level problems, reviewing margins monthly rather than weekly, which removes the ability to react in time, and failing to deduct third-party delivery commissions from delivery revenue before calculating GP. A fifth common error is ignoring supplier price creep, and a 6% rise in food cost percentage can eliminate an entire venue’s net profit if it goes undetected for several weeks.
Is 60% a good gross profit margin for a UK pub or restaurant?
The answer depends on the category. For a wet-led UK pub, 60% is at the lower end of acceptable, because a healthy wet-led operation targets 65–72%, and running below 62% typically indicates stock loss, overpouring or pricing issues. For a gastropub with significant food sales, a blended 60% is more understandable because food margins, often 20–35%, pull the average down. For a UK restaurant, a combined GP below 60% is a warning sign that usually indicates high food costs, drinks margin erosion or menu pricing that has not kept pace with ingredient inflation. For cafés, consistently below 60% blended indicates issues with pricing, portioning or purchasing.
Move from Spreadsheets to Automated Tracking Today
Manual gross profit margin tracking in UK restaurants, pubs and hotels consumes the 10–20 hours per week mentioned earlier, delivers data weeks too late to act on and misses supplier price changes that erode margins silently. Jelly’s automated invoice-to-POS workflow eliminates that process, as invoices are scanned automatically, dish costs update in real time and the Flash Report delivers daily GP visibility by category without any manual input.
Operators using Jelly reclaim those 10–20 hours of admin per week, cut food costs by an average of 3% in the first three months and see gross margins improve by an average of 2 percentage points. One operator improved GP from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Amber restaurant saves £3,000–£4,000 per month through faster supplier negotiations and tighter menu controls.
Jelly is available at a flat rate of £129 per site per month, integrates with Xero and connects to your POS in under five minutes.
Book a demo and see your venue’s gross profit margin tracked automatically from day one.