Written by: JJ Tan, Founder, Jelly | Last updated: 15 October 2026

Key Takeaways

  • Gross profit margin tracking works as a continuous process that catches margin erosion between monthly accounts. A one-off calculation cannot do that.
  • UK hospitality faces rising supplier costs and employment expenses, so weekly or daily margin visibility now supports survival.
  • Accurate tracking depends on a defined COGS policy, correct VAT treatment, accurate stock valuation, and a structured daily-to-quarterly cadence.
  • Traditional methods like spreadsheets and accounting software often leave gaps in visibility. Dedicated tools provide real-time data and automate invoice updates.
  • Jelly automates invoice capture, updates costs instantly, integrates with POS systems, and helps UK operators improve margins by an average of 2 percentage points in the first three months.

See How Jelly Tracks Your Margin In Real Time

Introduction: Build A Live Gross Profit Margin Tracking System

UK restaurant, pub and boutique hotel operators turning over £500,000 or more can calculate gross profit margin. The formula is not the problem. The real challenge is keeping that number accurate and live across multiple suppliers whose prices change every week, across invoices that arrive in different formats, and across sites where the kitchen team focuses on service instead of spreadsheets.

This article explains how to build a gross profit margin tracking system that stays current. UK away-from-home food and drink inflation is forecast at around 4.7% in 2026, while hospitality employment costs have risen by an average of 10.7% per person over two years, and industry data cited by IGD in September 2026 showed that 23% of UK hospitality businesses were operating at a loss, up from 15% three months earlier. In that environment, monthly tracking no longer reacts fast enough.

Talk Through Your Current Margin Tracking

Before You Begin: Core Data And Clear Ownership

Set up a tracking routine only after confirming that key data and tools are available.

  • Line-item supplier invoices
  • POS sales data
  • Recipe and dish specifications
  • Stock records
  • Accounting software (Xero, QuickBooks or Sage)

Ownership matters as much as tooling. The owner or finance manager owns the tracking cadence, the head chef or kitchen team supplies recipe and wastage data, and the operations lead reconciles across sites. Without these named owners, the routine drifts.

This process repeats daily, weekly, monthly and quarterly. Monthly accountant reports alone arrive too late to catch supplier price changes. All sales figures should exclude VAT, because this process is designed for UK VAT-registered businesses.

Why Continuous Tracking Protects Your Margin

When gross profit margin is not tracked continuously, margin erosion goes unnoticed between monthly accounts. Supplier price creep goes unchallenged because there is no data to support a challenge. Menu pricing decisions rely on figures that are weeks or months out of date.

The operational cost compounds quickly. Protein, produce and beverage costs are all volatile in 2026, with whole-bird poultry up 5–10%, beef supply tightening, and seafood categories exposed to fuel costs and weather disruption. A dish that was profitable last month may lose money today.

A documented tracking routine gives you real-time margin visibility. That visibility lets you react faster to ingredient price changes, negotiate with suppliers using evidence instead of guesswork, and spot errors before they compound across sites.

See Daily GP Tracking In Action

Step 1: Define What Belongs In COGS For Your UK Hospitality Business

Start by settling the “what counts” debate so your gross profit margin figure stays consistent and comparable over time.

Include in COGS:

  • Direct materials (food and drink ingredients)
  • Direct labour where attributable to production
  • Wastage and spoilage
  • Packaging directly tied to sales
  • Delivery commissions (for internal contribution-margin reporting)

Exclude from COGS:

  • Overheads (rent, utilities, marketing)
  • Interest
  • Corporation tax

Under FRS 102 Section 13, costs of purchase include the purchase price plus non-recoverable taxes, transport and handling, less trade discounts. Costs of conversion include direct labour and a systematic allocation of production overheads. Abnormal waste is excluded from inventory cost and expensed as incurred, while normal unavoidable wastage may be reflected in cost of goods consumed.

Delivery-platform commissions sit within distribution costs for statutory reporting, but operators may show them alongside COGS for internal contribution-margin reporting if the measure is clearly labelled.

The output of this step is a written COGS policy your team applies consistently every month. Moving a cost between cost of sales and overheads changes the gross margin figure without changing net profit, so inconsistent classification makes trends meaningless.

Step 2: Get VAT Treatment Right On Sales And Costs

Gross profit margin must be calculated on sales excluding VAT. For VAT-registered businesses, using VAT-inclusive sales inflates revenue and distorts the margin figure. This can shift a pub’s reported GP% by several points with no operational change, which makes comparisons misleading.

HMRC’s Business Income Manual (BIM31525) confirms that for VAT-registered businesses, output tax, input tax and balancing payments are carried to a VAT account, while all other entries in the accounts, including sales and purchases, are exclusive of VAT. Where sales and purchases are recorded exclusive of VAT, the VAT does not normally enter into the computation of trade profits at all.

Use net-of-VAT POS sales reports and net-of-VAT supplier invoices (where VAT is reclaimable) as inputs. The margin figure should match your accounting software’s gross profit line.

Step 3: Value Closing Stock Accurately

Accurate stock counts sit at the heart of reliable margin tracking. Every £1 by which closing stock is overstated understates cost of sales by £1 and overstates reported gross profit by £1. A stock error runs through two years’ accounts with opposite signs, making both years look strange but neither look wrong enough to catch.

Under FRS 102 Section 13, closing inventory is measured at the lower of cost and net realisable value. FIFO or weighted average costing is permitted for interchangeable items, while LIFO is not.

Run a consistent month-end stock count, value closing stock at the lower of cost and net realisable value, and reconcile against purchases. A count performed before or after the reporting date can be rolled forward or back using recorded deliveries and consumption, provided the movements are reliable and documented.

Sushi Revolution’s monthly stocktake using Jelly takes 5–20 minutes, down from 2–3 hours previously. That example shows how a streamlined stock valuation routine works in a live UK kitchen.

Step 4: Set A Tracking Cadence Across The Month And Quarter

Monthly accountant reports act as a lagging indicator. By the time the report lands, supplier price changes may already have eroded margin. A structured cadence catches problems earlier.

  • Daily: Flash check on GP margin using POS data and latest invoice costs.
  • Weekly: Price review that flags ingredient price changes and checks impact on dish margins.
  • Monthly: Full margin review that reconciles COGS, stock, wastage and delivery commissions, then compares against prior months.
  • Quarterly: Pricing decisions that adjust menu prices, renegotiate supplier contracts, or reformulate dishes based on accumulated data.

A weekly GP figure from connected data is far more useful than a monthly figure assembled from estimates. GP should be checked at least every stock take, weekly for wet stock and fortnightly or monthly for dry goods.

For kitchen-specific real-time tracking detail, see Real-Time Restaurant Profit Margin Tracking For UK Kitchens.

Step 5: Calculate Gross Profit Margin (The Formula, Briefly)

Once COGS is defined, VAT treatment is correct and stock is valued accurately, the formula becomes straightforward.

Gross Profit Margin = ((Revenue − COGS) ÷ Revenue) × 100

Worked UK example: £500,000 revenue (excluding VAT), £300,000 COGS, £200,000 gross profit, 40% gross profit margin.

The formula itself is the easy part. The tracking system in Steps 1–4 and 6–7 makes the number reliable and repeatable.

Step 6: Choose Your Tracking Method With A Clear Trade-Off

Spreadsheets

Spreadsheets offer flexibility and no software cost, yet they stay current only up to the last data entry. Costing a single menu item takes an average of 28 minutes in a spreadsheet. Across a multi-supplier operation with weekly price changes, the manual burden compounds quickly and the data drifts out of date between updates.

Accounting Software (Xero, QuickBooks, Sage)

Accounting software works well for bookkeeping, tax and statutory reporting. It reports gross profit at the account level. It does not track dish-level or ingredient-level margins, and it does not update costs in real time as supplier prices change. The view stops at the invoice level.

Dedicated Tracking (Jelly)

Dedicated tracking automates invoice capture, updates ingredient costs with every invoice, and delivers live GP margin visibility via POS integration. This approach gives you invoice-level tracking that catches margin erosion between monthly accounts. For hospitality-specific tooling comparisons, see How To Calculate Catering Profit Margins: UK Guide and Best Food Costing Software With Inventory Tracking UK 2026.

Step 7: Move From Monthly Reports To Real-Time Visibility

Connecting a POS system to a tracking method so sales data flows in automatically, and digitising invoices so costs update without manual entry, closes the gap between when margin erosion happens and when it becomes visible.

Jelly connects to Square, EPOS Now, Lightspeed and Toast as complementary tools it works alongside. Setup takes approximately five minutes and follows the same flow: open Jelly → click Integrations → sign in to the POS → grant permissions → select which POS categories to sync.

That connection automates 2–5 hours of weekly work and delivers real-time margins and sales mix data. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue.

Connect Your POS And See Live Margins

Common Mistakes In Gross Profit Calculation

What Is A Good Gross Profit Margin For A UK Business?

Benchmarks vary by revenue stream, so compare each one separately.

A well-run UK restaurant kitchen typically achieves food gross profit of 65–72%. Falling below that range signals leakage from over-ordering, waste, portioning drift or pricing that has not kept up with supplier costs.

Wet-led venues can reach 65–75% gross margin on drinks. Draught beer carries structurally lower margins than spirits or wine because of waste, spoilage and dispense loss. Around 68% or higher is realistic on wine and spirits, while 60–65% is a solid result on draught. The 2022 UKHospitality/Christie & Co Benchmarking Report found a whole-survey average of 66.0% for both wet and food margins.

For boutique hotels, Christie & Co’s Pub Accommodation Sector Analysis puts bedroom accommodation at 85–90% gross profit margins, compared with approximately 55–65% for wet sales and 65–72% for food sales. Track F&B separately from room revenue so each stream stays visible on its own terms.

A UK hospitality business consistently below 60% blended gross profit faces serious structural pressure even if the dining room is full, because volume amplifies margin loss.

“Good” depends on cost structure, location and service model, so use your own historical trend as the primary benchmark. Earlier we noted that Jelly customers’ gross margins increase on average by 2 percentage points in the first three months.

How To Find Gross Profit Margin On An Income Statement

Revenue appears at the top line of a UK income statement, excluding VAT. COGS appears in the direct costs section immediately below. Gross profit is the difference. Divide by revenue and multiply by 100 to get the margin percentage.

Under the Companies Act formats, Format 1 analyses expenses by function and includes turnover, cost of sales, gross profit or loss, distribution costs and administrative expenses. Format 2 analyses expenses by nature and has no cost of sales or gross profit line at all, so a gross margin cannot be read straight off a Format 2 profit and loss account.

Accounting software like Xero, QuickBooks and Sage will report gross profit, but they will not show dish-level or ingredient-level margin. That level of detail requires invoice-level tracking.

From 1 April 2028, Companies House will no longer accept abridged accounts, and small companies and micro-entities will have to file their profit and loss account, with an option to opt out of having it published. Operators who have relied on filleted accounts will need their margin data to be accurate and auditable.

How To Measure Success Of Your Tracking System

A tracking system works when it delivers a consistent COGS policy, accurate stock valuation, a documented cadence with named owners, and a single source of truth for margin data.

Measurable indicators include reduced admin time, faster reporting, fewer invoice discrepancies, more timely pricing decisions, and improved gross margin percentage. Jelly users typically save 10–20 hours of admin per month, and they cut food costs by 3% on average in the first three months.

Theoretical GP is what a venue should achieve based on menu costings and volume sold; actual GP is what is genuinely achieved after stock variances, waste, overpouring and unrecorded sales. A gap of 1–2% may be acceptable, but anything above that warrants investigation.

Advanced Tips And Practical Next Steps

  • Standardise across sites: Use the same COGS policy, stock count routine and tracking cadence at every location so margin data stays comparable across the estate.
  • Automate invoice capture: Jelly digitises every invoice via photo or email and integrates directly with Xero (Sage integration coming soon), so costs update without manual entry.
  • Use price alerts: Jelly’s Price Alert feature flags every single price increase or decrease, giving you concrete evidence to call a supplier, negotiate better rates, and claim credit notes.
  • Connect your POS system: Square, EPOS Now, Lightspeed and Toast all connect to Jelly in approximately five minutes, delivering item-level sales data and live dish margins.
  • Next steps: Focus on menu engineering through sales mix analysis, delivery menu creation with commission factored in, and supplier negotiation using price change data.

For a real-world example of daily menu price adjustments amid inflation, supplier negotiations, and improved delivery margins despite 30% commissions, see the Sushi Revolution case study.

Plan Your Next Margin Improvement Steps

Frequently Asked Questions About Gross Profit Tracking

How Long Does It Take To Set Up Real-Time Margin Tracking?

Jelly onboards and generates initial value in the first week. Invoice scanning begins generating price alerts and spending insights within 24 hours of the first invoice being submitted.

What If I Have Multiple Sites?

Use a central source of truth and the same cadence across all locations. Standardise your COGS policy, stock count routine and tracking cadence at every site so margin data remains comparable across the estate. Jelly is built for operators at the tipping point of expanding to 2–5 sites, providing management-level visibility without requiring physical presence at each location.

Conclusion: Turn The Formula Into A Daily Habit

The gross profit margin formula takes seconds to apply. The tracking system is what stops margin erosion between monthly accounts. That means defining COGS correctly, getting VAT treatment right, valuing stock accurately, running a documented daily-to-quarterly cadence, and choosing a method that updates costs automatically.

For UK restaurants, pubs and boutique hotels that need live gross profit margin tracking, Jelly automates invoice capture, updates dish costs with every new invoice, integrates with POS and accounting software, and delivers daily GP visibility that spreadsheets and accounting software alone cannot provide. As noted earlier, Jelly customers typically see a 2 percentage point margin improvement and around a 3% food cost reduction in the first three months.

Start Tracking Your Gross Profit Margin Today