How to Read Your Café EPOS Margin Report in 5 Steps

August 23, 2026

Written by: JJ Tan, Founder, Jelly

Key Takeaways

EPOS sales data alone cannot reveal true margins, so you need live ingredient costs mapped to recipes to prevent weeks of lost profit.
Accurate margin reporting depends on four inputs: admin access, supplier invoices, recipe data with wastage, and current ingredient prices.
UK cafés should target a blended gross profit of 65–75%, where low-margin items like a 55% full breakfast drag down high performers such as a 78% flat white.
Five repeatable steps, from locating the report to interpreting the sales mix, turn raw EPOS numbers into clear margin decisions.
Automating this workflow with Jelly delivers daily Flash Reports and instant Price Alerts, freeing hours each week and typically lifting GP by two percentage points within the first quarter.

Before You Run Your First Margin Report

Accurate margin reporting starts with four essentials in place before you export a single figure.

Admin-level access to your EPOS back office
Supplier invoices covering the same period as your sales data
Recipe data with portion weights and wastage percentages for each menu item
Current ingredient prices from each supplier

Without all four elements, your gross profit figure becomes an estimate at best. For independent UK cafés, a healthy gross profit target is 65–75% (implying COGS of 25–35% of net revenue). This benchmark gives you a clear reference point, and reacting quickly when you drift away from it separates operators who protect margin from those who only discover problems at month-end.

Café EPOS Margin Report Example Table

The table below illustrates how different menu items contribute to a blended 68% margin, showing why high-volume, high-margin items like the flat white are critical to protect, while low-margin items like the full breakfast require immediate attention. Figures use UK category benchmarks and are net of VAT.

Menu Item	Net Sales (£)	COGS (£)	Gross Profit (£)	GP Margin (%)
Flat White (200 sold)	700	154	546	78%
Croissant (120 sold)	360	90	270	75%
Chicken Sandwich (80 sold)	480	182	298	62%
Full Breakfast (50 sold)	475	214	261	55%
Blended Smoothie (60 sold)	270	76	194	72%

The blended margin across these five lines sits at approximately 68%, which falls squarely within the target range established earlier. The full breakfast at 55% acts as a drag, while the flat white at 78% functions as the engine. That relationship between volume and margin forms the starting point for every margin conversation.

See how Jelly builds this table automatically from your invoices and EPOS data, updated every day.

Step 1: Find Your EPOS Gross-Profit or Margin Report

Each of Jelly's four integration partners surfaces sales data in a slightly different location, so follow the path for your system.

EPOS Now: Log in to the Back Office, select Reports, then choose Product Sales or Category Sales. EPOS Now is popular with independent and single-site UK operators and surfaces item-level sales that Jelly pulls via real-time API.
Square: Open Square Dashboard on the web, go to Reports, then select the Custom tab to access the Custom Report Builder. Square's Custom Report Builder lets you select metrics such as gross sales and net sales, group by item or category, and filter by date range. The Custom Report Builder requires the reports permission to be enabled for your account.
Lightspeed: Navigate to Reports, then Sales, then Sales by Item or Sales by Category. Lightspeed includes 40+ built-in sales and profit reports covering items sold, gross profits and multi-location performance.
Toast: Go to Reports, then Sales, then Sales Summary. Toast's Sales Category Summary card breaks down item counts and sales amounts by user-defined categories to support margin analysis. In the UK, Toast’s sales reports include VAT in gross sales, so use net sales data for margin calculations.

Step 2: Export or View Clean Sales Data

Once you have located the correct report, apply two filters before exporting so the numbers you work with reflect reality.

Set the date range to the period you want to analyse, with a full trading week as the minimum useful unit. Weekly COGS tracking is essential because monthly tracking is too late to spot supplier, waste or pricing issues.
Set the category filter to separate food and beverage lines. Mixing them produces a blended figure that hides which category underperforms.

Export as CSV wherever possible. Clean sales-by-item CSV exports that retain categories, modifiers and timestamps are non-negotiable for menu engineering and costing tools. Toast supports direct CSV and XLS download from the report screen. Square, Lightspeed and EPOS Now all offer CSV export from their respective report views.

Step 3: Map EPOS Sales Lines to Costed Recipes

An EPOS export shows what sold and at what price, but it does not know what each item cost to make. The mapping step connects each EPOS line item to a recipe with costed ingredients so you can calculate real margins.

List every EPOS item in your export.
Match each item to a recipe that specifies ingredients, quantities and portion weights.
Apply a wastage percentage to each ingredient, typically 5–10% for fresh produce.
Multiply ingredient quantities by current supplier prices from your most recent invoices.

This stage is where most operators hit a wall. Ingredient prices change with every delivery, and manually updating a spreadsheet after each invoice becomes the single biggest source of margin blind spots. The gap between ideal food cost based on standardised recipes and actual food cost after waste and errors directly reveals hidden profit loss. Step 4 shows how to turn these live costs into percentages, and the Advanced Tips section later explains how to automate the entire update cycle.

Step 4: Calculate Live Gross-Profit Percentages

Once your ingredient costs are current, whether updated manually or via automation, the calculation itself stays simple. Apply the formula at item level, then roll up to a blended figure.

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

Net sales must exclude VAT. For accurate gross profit calculations in hospitality, revenue must exclude VAT because VAT belongs to tax authorities. If your EPOS total is VAT-inclusive, divide by 1.20 for standard-rated items before applying the formula.

Consider a worked example. A chicken sandwich sells for £6.00 net, while ingredients and packaging cost £2.28. Gross profit is £3.72, and GP margin is (£3.72 ÷ £6.00) × 100, which equals 62%. Sandwiches and wraps can achieve healthy GP percentages in a well-run independent UK café, so this item performs in range. A full breakfast at 55% sits toward the lower end for hot food and brunch items in UK cafés and warrants a portion or pricing review.

Target the 65–75% blended margin discussed in the prerequisites across your full menu. Consistently below 60% indicates issues with pricing, portioning or purchasing that require immediate attention.

Step 5: Read the Sales-Mix View for Actionable Insight

Volume and margin only become useful when you read them together. A high-margin item that sells rarely contributes little to overall GP, while a low-margin item that sells constantly drags the blended figure down.

Segment your menu into four groups.

High volume, high margin — protect and promote these (for example, the flat white)
High volume, low margin — reprice, re-portion or reformulate (for example, the full breakfast)
Low volume, high margin — increase visibility through upselling
Low volume, low margin — treat these as candidates for removal

When you apply this segmentation to your own menu, look particularly at low-volume, high-margin items in the sides and extras categories. UK operators are using sides, extras and bread-led dishes as margin-recovery levers because these categories deliver strong price growth with lower perceived risk to guests than increases on core mains. Your sales-mix view will show you exactly where those opportunities sit in your own menu.

Common Margin Mistakes and How to Fix Them

Missing recipe links: If an EPOS item has no recipe attached, its COGS is zero and your margin appears artificially high. Audit unmapped items after every menu change.
Stale ingredient prices: A recipe costed in January using January prices will show the wrong margin in August. Most restaurants set recipe costs once when a dish is created and then leave them static, allowing ingredient costs to drift while menu prices remain fixed. Update prices with every invoice.
Discount and refund miscalculations: Use net sales after discounts and refunds, not gross sales. Common mistakes include using gross sales instead of net sales, which inflates the revenue figure and understates true food cost percentage.
VAT-inclusive revenue: Mixing VAT-inclusive sales with VAT-exclusive invoice costs produces a margin figure that sits several percentage points too high.
Uncaptured modifiers: Uncaptured modifiers such as alternative milks, extra shots and syrups are a common operational margin killer in cafés. Ensure every modifier has a cost attached in your recipe.

Success Indicators for Your New Margin Process

A repeatable weekly margin reporting process delivers measurable outcomes within 90 days.

2–5 hours of weekly admin time recovered from manual data entry and price checking
Supplier price increases identified within days rather than weeks
A 2-percentage-point improvement in blended GP margin, as an independent UK café using recipe costing linked to live purchase prices can reduce food cost within the first few months
Confidence in the numbers when presenting to investors, accountants or co-owners

One operator using Jelly improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Populu lifted GP from 68% to 72% across 16 locations. These outcomes reflect the impact of replacing manual exports with automated, invoice-linked costing.

Advanced Automation Tips and Next Steps

Manual EPOS exports give you a solid starting point, yet they demand discipline, time and regular spreadsheet updates after every delivery. Three upgrades move your operation from reactive to proactive.

Automated invoice scanning: Jelly captures every line item from supplier invoices via photo or email, which removes manual data entry and keeps ingredient prices current.
Real-time Price Alerts: Jelly's Price Alert feature flags every price increase or decrease by ingredient and supplier the moment a new invoice is processed, giving you evidence to negotiate credits or switch suppliers before the margin impact compounds.
Daily Flash Reports: By integrating with your EPOS via real-time API, Jelly's Flash Report delivers a daily gross profit figure calculated from live costs and live sales, with no spreadsheet and no delay.

Connecting any of Jelly's four supported EPOS systems takes approximately five minutes. Open Jelly, click Integrations, sign in to your EPOS, grant permissions, then select which categories to sync. From that point, every sale updates your margin automatically.

See the Flash Report running on your own data within the first week.

Frequently Asked Questions

What is a healthy gross profit margin for an independent UK café?

A blended gross profit margin of 65–75% is a solid, achievable target for a well-run independent UK café. Drink-focused cafés, primarily coffee with light snacks, often sit toward the upper end of this range because beverages carry lower waste and higher scalability than food. Food-led cafés with sandwiches, hot dishes and brunch menus tend to sit toward the lower end due to fresh ingredient costs, spoilage and prep labour. Consistently below 60% signals a pricing, portioning or purchasing problem that needs immediate attention. Above 75% for a full-menu café is unusual and may indicate a data error rather than exceptional performance.

How often should I recalculate margins after a supplier price increase?

Gross profit margin should be recalculated promptly after any supplier price increase so you can detect margin erosion before it affects profitability. Weekly tracking is the minimum effective cadence for most independent cafés, and monthly tracking is too slow to catch the cumulative impact of ingredient cost changes, particularly for high-volatility items such as fresh dairy, eggs, leafy greens and seasonal produce. If an ingredient cost changes significantly, a menu review should be triggered for every dish that uses it. Jelly's Price Alert feature automates this process by flagging every price movement the moment a new invoice is scanned, so you never need to wait for a monthly report to discover a margin problem.

Can my existing EPOS system give me live ingredient costs?

Your EPOS system records sales transactions and delivers item-level sales data via real-time API integration with Jelly, but it does not track live ingredient costs. To get live ingredient costs, you need a layer that sits between your invoices and your EPOS, scanning every invoice line item, mapping ingredients to recipes and recalculating dish margins automatically. That is exactly what Jelly does. It integrates with all four EPOS systems via real-time API and combines live sales data with live invoice costs to produce a gross profit figure that stays current without manual spreadsheet work.

What data do I need before I can trust my margin report?

Four things must be in place for a margin report to be reliable. First, you need net sales data (excluding VAT) from your EPOS, filtered by item and category for the period in question. Second, you need supplier invoices covering the same period, with line-item prices for every ingredient purchased. Third, you need a costed recipe for every menu item, including portion weights and wastage percentages. Fourth, you need a mapping between each EPOS item and its corresponding recipe, so that sales volume can be multiplied by accurate ingredient costs. If any of these four elements is missing or out of date, particularly ingredient prices, the resulting margin figure will be wrong. Jelly automates the invoice and recipe-costing elements, so the only manual step is the initial recipe build, which takes around three minutes per dish once your ingredients are loaded from scanned invoices.

Conclusion: Turn EPOS Data into Daily Margin Protection

Generating an accurate café EPOS margin report follows a repeatable five-step process. You locate the sales report in your EPOS, export clean net-sales data by item and category, map each item to a costed recipe, calculate gross profit percentages against the UK benchmark established at the start, and interpret the sales mix to identify high-volume low-margin items that need attention. Common mistakes, such as stale ingredient prices, uncaptured modifiers, VAT errors and missing recipe links, become fixable once you know where to look.

Keeping the process current presents the harder challenge. Ingredient prices change with every delivery, and a dish that hit 68% margin in January may be running at 61% in August if no one has updated the recipe costs. Manual spreadsheet workflows cannot keep pace with that reality, and the 10–20 hours of weekly admin they consume is time that should be spent running the business.

Jelly removes the manual work entirely. It scans every invoice, updates every recipe cost, integrates with your EPOS in under five minutes and delivers a daily Flash Report showing your true gross profit, alongside Price Alerts that flag supplier increases the moment they arrive. Customers consistently achieve the GP lift described in the Success Indicators section within the first three months.

Find out how quickly Jelly turns your EPOS data into daily margin protection.