Written by: JJ Tan, Founder, Jelly
Key Takeaways for UK Hospitality Teams
- Real-time food costing replaces manual spreadsheets with automated invoice capture and live POS integration, cutting the 2–4 week lag that erodes gross profit.
- UK operators should hold food cost below 30% of net revenue, as anything above 35% leaves too little margin for labour, rent and overheads.
- Jelly’s five-step invoice-to-GP workflow digitises supplier invoices, converts units automatically and updates every recipe cost the moment a price changes.
- Native integrations with Square, EPOS Now, Lightspeed and Toast deliver item-level sales data in real time, enabling daily Flash Reports and Sales Mix analysis.
- See how Jelly replaces spreadsheet lag with live margin visibility and protect your restaurant’s profitability.
The Problem: Why Spreadsheets No Longer Deliver Visibility
Manual food cost tracking often carries a lag of 2-4 weeks between purchase and visibility of insights. By the time a spreadsheet is updated, prices have already moved. Restaurants can run with elevated food costs for several weeks before spreadsheet-based reconciliation detects the issue. That delay pushes corrective action far too late. For UK operators, a food cost percentage above 35% of net revenue is a red flag that leaves insufficient gross profit to cover labour, rent and overheads.
The problem compounds at scale. As hospitality businesses grow, manual workflows multiply inefficiencies through more vendors, more invoices, more locations and greater operational complexity. Owners and finance managers lose the ability to move quickly with confidence. Chefs negotiate blind, suspecting supplier price creep but lacking the hard data to challenge it.
Before using Jelly, Chef Murat Kilic of Amber restaurant in East London relied on tedious manual costing and spreadsheets that made it hard to see price changes quickly, negotiate with suppliers or adjust menu pricing in time to protect GP.
See how Jelly eliminates spreadsheet lag and delivers live margin visibility for your team.
What Real-Time Food Costing Means in Practice
Real-time food costing is the continuous, automated calculation of a dish’s gross profit margin using live ingredient costs and live POS sales data. Unlike static spreadsheet costing, which provides a fixed, point-in-time estimate, real-time food costing software updates COGS and food cost percentage continuously as POS sales and purchases are recorded. When a supplier raises the price of an ingredient, every recipe containing that ingredient updates instantly. When a dish is sold, the margin is recalculated against the current cost, not last month’s.
How Invoice Automation Feeds Live Gross Profit
Jelly’s invoice-to-GP workflow follows five steps that remove manual effort at every stage.
- Photo or email capture: Kitchen staff photograph a paper invoice or forward a supplier email. Jelly ingests both formats automatically.
- Line-item digitisation: Jelly scans every line, including quantity, SKU, unit price and tax, without manual data entry. This delivers the raw cost data that feeds all downstream reporting.
- Automatic unit conversion: Ingredients arrive in cases, kilograms or litres. Jelly converts every unit to the recipe-level measure so dish costs calculate correctly regardless of how a supplier invoices.
- Live recipe costing: Each recipe in Jelly’s Cookbook updates the moment a new invoice price lands. A red margin indicator flags any dish that has dropped below its target GP, and a green indicator confirms dishes that have improved.
- POS-synced sales mix: Jelly’s Sales Mix report pulls item-level transaction data from the connected POS in real time. It combines live costs with live sales to produce an up-to-the-minute Flash Report of gross profit by dish, day or period.
Jelly automates supplier invoice processing and enables real-time costing for Amber restaurant, saving Murat Kilic £3,000–£4,000 per month, which delivers approximately 68× ROI on the platform cost.
POS Integrations That Power Daily Food Cost Reports
Jelly integrates natively with four POS systems via real-time API, each delivering item-level sales data the moment a transaction completes. Connecting any supported POS takes approximately five minutes and follows the same flow: open Jelly, click Integrations, sign in to the POS, grant permissions and select which categories to sync. POS-to-dish linking only surfaces items sold since the integration was connected, which keeps the mapping clean and free of legacy menu clutter.
- Square: Real-time API integration with user-led setup via Jelly. Square’s integrated POS syncs sales, inventory and operational data in real time across connected platforms, which makes it a strong complement to Jelly’s invoice automation.
- EPOS Now: Real-time API pulling item-level sales mapped to Jelly dishes, with discount and refund calculations handled at individual line level. EPOS Now integrations automatically sync sales and inventory data with accounting software such as Xero, and Jelly sits alongside that flow to deliver live GP. This POS is popular with independent and single-site UK operators.
- Lightspeed: Jelly’s closest POS partner, listed on the Lightspeed marketplace. The focus is on the Lightspeed Restaurant product, which suits operators scaling to multiple sites.
- Toast: Real-time API with item-level sales mapped to Jelly dishes. Restaurants automating inventory management can reduce food waste, and Jelly’s integration extends that benefit to live margin reporting.
Connecting a POS automates 2–5 hours of weekly work and delivers real-time margins and sales mix data from day one.
Real-Time Costing vs Theoretical Costing
Theoretical food cost is what a dish should cost based on a recipe at a fixed point in time. Actual food cost is what it genuinely costs once waste, portioning variance, supplier price changes and receiving discrepancies are accounted for. Restaurant operators consider an Actual vs Theoretical (AvT) variance under 2 percentage points as healthy control by viewing variance at item, location and category level. The gap between theoretical food cost (e.g. 28%) and actual cost (e.g. 34%) is usually caused by unrecorded waste, over-portioning, receiving discrepancies or theft. Jelly closes that gap by connecting recipe specs, live invoice prices and POS sales data in a single automated workflow.
The 30/30/30 Rule for Daily Margin Control
A practical benchmark for UK full-service operators is to keep food cost below 30% of net revenue, labour below 30% and combined overheads below 30%. That structure leaves at least 10% net profit. Weekly stock checks and real-time food cost tracking allow UK operators to catch purchasing or wastage issues before they compound, whereas monthly figures arrive too late to act on effectively. Achieving and holding the sub-30% target established earlier requires weekly, ideally daily, visibility. Jelly’s Flash Report delivers that daily view automatically.
Why Spreadsheets Fall Behind: Direct Comparison
| Capability | Manual Spreadsheets | Automated Real-Time System | Business Impact |
|---|---|---|---|
| Price variance detection | Catches 18% of price variances, 5–7 day alert lag | Catches 98% of price variances, alerts in under 15 minutes | A mid-month price spike on high-volume ingredients creates £3,800+ margin exposure before detection in manual workflows vs £380 with automated alerts |
| Recipe cost accuracy | Costs go stale between manual updates, AvT variance untracked for weeks | COGS and food cost % update continuously as invoices and POS sales are recorded | A 2-point food cost improvement on £1M annual food spend recovers £20,000 per year |
| Decision latency | Variance visible only after the fact, investigations become retrospective | Owner can act in week two rather than waiting until week six when the monthly report arrives | Operators automating invoice matching recover the majority of flagged invoice discrepancies within the first 90 days |
Replace your spreadsheet workflow in under a week and see Jelly’s live dashboard in action.
Jelly’s 7-Step Implementation Checklist
- Create your Jelly account and add your first location at a flat rate per site, with no per-user fees.
- Set up a dedicated supplier email address so invoices arrive directly into Jelly, or photograph paper invoices via the mobile app. Price alerts go live within 24 hours.
- Connect your POS, such as Square, EPOS Now, Lightspeed or Toast, via Jelly’s Integrations tab. This follows the same quick setup described earlier, so ensure you have admin access to your POS account before starting.
- Select which POS categories, such as food and beverages, to sync. Only items sold after connection surface for mapping, which keeps the dish list clean.
- Build your Cookbook by clicking on ingredients already populated from scanned invoices. Jelly handles all unit conversions and wastage calculations automatically, which reduces dish costing from 28 minutes to approximately 3 minutes per item.
- Once your recipes are costed, enable Price Alerts so every supplier price movement is flagged instantly. Your team then has the evidence needed to negotiate credits or switch suppliers before margin erosion builds.
- With recipes and alerts in place, review your daily Flash Report each morning to track GP margin against target. Use the Sales Mix to identify which dishes to promote, reprice or remove.
How FIFO Supports Accurate Real-Time Costing
Under UK GAAP (FRS 102), common inventory cost methods for UK businesses include FIFO and weighted average cost. For perishable food stock, FIFO is the practical standard because it mirrors physical stock rotation and produces a closing stock value closest to current replacement cost. In a real-time costing workflow, FIFO discipline means the cost assigned to each dish sold reflects the oldest stock on hand. That stock comes from the batch most recently received at the price captured on the latest invoice. Perpetual inventory systems integrated with POS automatically deduct ingredients from stock via recipe-level costing upon each sale, delivering live theoretical-versus-actual variance data that supports accurate FIFO-based GP reporting.
How to Evaluate Real-Time Food Costing Platforms
Growing UK operators can assess real-time food costing platforms across four practical dimensions.
- Onboarding speed: Jelly generates initial value in the first week. Price alerts go live within 24 hours of the first invoice, and POS integration takes only a few minutes. Complex all-in-one platforms can take months to configure.
- Data freshness: Automated invoice capture closes the visibility lag to under four hours, compared with 24–72 hours for manual entry. Jelly’s Flash Report updates daily, and the Sales Mix updates with every POS transaction.
- Supplier negotiation support: Jelly’s Price Alert feature flags every price increase or decrease by ingredient and supplier. This provides the concrete evidence needed to claim credit notes or renegotiate terms. Jelly’s Price Changes feature gives Amber real-time insights into ingredient price fluctuations, enabling immediate pricing decisions, ingredient substitutions and supplier switches.
- Multi-site visibility: Each additional location connects on the same flat monthly rate. Owners and finance managers access a central dashboard across all sites without relying on individual chefs to compile reports. Sushi Revolution used Jelly to support the opening of a second restaurant, achieving gross profits 2–3% higher on average across both dine-in and delivery menus.
Frequently Asked Questions
How long does it take to set up Jelly and see the first results?
Most operators see their first actionable data within 24 hours. Once suppliers begin sending invoices to a dedicated Jelly email address, or the kitchen photographs the first paper invoice, Price Alerts go live immediately. Connecting a POS system takes only a few minutes. Dish costing through the Cookbook can begin as soon as ingredients are populated from scanned invoices, which typically happens within the first day. Customers consistently report meaningful GP improvements within the first three months, with Jelly users cutting food costs by 3% on average in that period.
Can my accountant or finance manager access Jelly directly?
Yes. Jelly’s flat-rate pricing per location per month includes no per-user fees, so owners, finance managers and head chefs can all access the platform simultaneously. Digitised invoices push directly into Xero with one click, which reduces bookkeeping time by 90%. Sage integration is also in development. Because the data is automated rather than manually entered, management can trust the figures without checking them against paper records.
How does Jelly handle delivery menu costing given commission charges?
Jelly’s Delivery Menu Creation feature allows operators to duplicate existing menu items and factor in delivery platform commission overheads, typically around 30%, to build a separate, profitable delivery menu. Sushi Revolution uses this capability to set distinct target gross profits for dine-in and delivery, which ensures delivery dishes remain profitable after commission is deducted. The live costing engine updates delivery margins automatically whenever ingredient prices change, so a dish that was profitable on delivery last week does not silently become a loss-maker today.
Is Jelly suitable for a single-site operator, or is it designed for multi-site groups?
Jelly is built for operators at the tipping point of growth, including single-site businesses turning over £500k or more and those expanding to 2–5 locations. The platform is effective at one site, where it replaces spreadsheets and saves 10–20 hours of admin per month. It also works across multiple sites, where it provides a central source of truth for owners who can no longer be physically present everywhere. The flat per-location pricing means there is no penalty for adding sites as the business grows.
Conclusion
Volatile supplier prices, manual invoice entry and month-end reports that arrive too late combine to erode margins silently. Spreadsheets cannot catch price variances fast enough, cannot update recipe costs automatically and cannot surface the daily GP visibility that growing UK restaurants, pubs and boutique hotels need to make confident decisions.
Jelly addresses each of these problems through automated invoice capture, live recipe costing and real-time POS integration. Customers achieve an average 2-percentage-point GP lift within three months. Amber saves £3,000–£4,000 every month. Operators reduce Xero bookkeeping time by 90%. The platform goes live within a week, runs on a simple per-location monthly fee and requires no complex setup.
Find out how quickly Jelly can put live gross profit data in your hands and get started this week.