Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026
Key takeaways for UK restaurant operators
- A procurement dashboard pulls live invoice, supplier, and POS data into one view so you can track food cost percentage, gross profit margin, and supplier price variance in real time.
- Eight core KPIs, including supplier price variance, theoretical versus actual food cost, and menu-item gross profit, drive better weekly decisions on pricing, purchasing, and menu design.
- Manual Excel dashboards provide static snapshots, while Jelly automates invoice capture, POS integration, and live recipe costing so every margin stays current.
- Operators using Jelly report £3,000–£4,000 monthly savings and the margin improvements detailed in the case studies below, typically within the first 90 days.
- Talk to Jelly’s team to see a live procurement dashboard built on your own supplier data in under a week.
Eight hospitality KPIs that protect your gross profit
The following eight metrics form the core of an effective restaurant procurement dashboard because they measure margin leakage you can control through better buying and tighter recipes. Before diving into each KPI, note that The National Restaurant Association benchmarks food cost percentage between 28% and 35% for full-service restaurants. Industry sources recommend targeting a 2–3% variance between theoretical and actual food cost for well-run operations, while UKHospitality benchmarks address overall food-cost percentages (28–35%) rather than variance. A 5% variance on £100,000 in monthly food sales represents £5,000 in lost profit.
1. Supplier price variance is the difference between the price on a purchase order and the price on the received invoice. Target ≤2%. When invoiced unit prices deviate from purchase orders by more than 2–3%, food cost variance increases before any plate is prepared.
2. Theoretical vs actual food cost compares what a dish should cost, based on recipes, with what invoices and stock counts show you actually spent. The gap exposes waste, theft, and portioning errors. UK benchmark: ≤2% variance.
3. Menu-item gross profit is revenue minus direct ingredient cost per dish. Contribution margin shows how much profit each menu item generates after direct costs and underpins menu engineering and pricing strategy.
4. Yield-adjusted cost per portion reflects the true cost of a portion after trim loss and cooking reduction. A protein with a 70% yield ratio has a very different true cost per portion from a fabricated product with 95% usable yield.
5. Purchase-order accuracy tracks the percentage of orders received exactly as specified. Low accuracy inflates costs and distorts stock counts.
6. Invoice cycle time measures the days between invoice receipt and approval. Manual processing of a single hospitality invoice is time-consuming and costly, so cycle time directly affects cash flow.
7. Stock-out frequency records how often a menu item is unavailable because ingredients ran short. Teams without real-time inventory visibility order on rough estimates, which drives over-ordering, waste, or service disruption.
8. Weekly spend by supplier shows total invoiced value per supplier per week. This view supports spend concentration analysis and gives you leverage in negotiations.
How to create a procurement dashboard that chefs actually use
The following eight-step sequence assumes access to supplier invoices, a supported POS system, and basic spreadsheet literacy. Steps 1–4 describe a manual build. From step 5 onwards, Jelly replaces the manual work and turns the dashboard into a live system.
Step 1 — Define your objectives. Procurement dashboards work best when each metric links to a clear business decision or goal. For a UK restaurant, typical targets include food cost below 35%, supplier price variance below 2%, and a weekly GP figure that matches your Flash Report.
Step 2 — Identify and consolidate data sources. List every supplier, their invoice format (paper, PDF, email), and your POS system. Vendors use inconsistent formats, abbreviations, and price structures, which forces staff to interpret terminology, retype line items, reconcile substitutions, and verify deliveries. In a manual build, this step alone consumes several hours per week and slows every other task that depends on accurate data.
Step 3 — Map data fields to the eight KPIs. In Excel, create columns for supplier name, invoice date, SKU, unit price, quantity, and total. This first sheet becomes your invoice log. Add a second sheet for recipe costs so you can calculate theoretical food cost. Add a third sheet for POS sales pulled manually from your till reports, which gives you the actual sales data needed to compute variance. Aligning data sources across systems prevents silos and inconsistencies.
Step 4 — Build variance formulas. Calculate theoretical food cost from recipe sheets, then subtract actual cost from invoices. Flag any line where variance exceeds 2%. At this stage, the manual dashboard is functional but static. It reflects last week’s prices, not today’s, so it behaves more like a report than a live control panel.
Troubleshooting: If your variance figure looks implausibly low, check that your POS sales export excludes VAT, service charges, and beverages. If it looks implausibly high, verify that your invoice totals exclude non-food items.
Step 5 — Automate invoice capture with Jelly. Forward supplier invoices to your dedicated Jelly email address or photograph paper invoices directly in the app. Jelly digitises every line item, including quantity, SKU, price, and tax, within seconds, without manual rekeying. This single step removes 10–20 hours per week of manual data entry and turns your static spreadsheet into a live data feed.
Step 6 — Connect your POS. Jelly integrates natively with Square, EPOS Now, Lightspeed, and Toast through real-time APIs. Connecting any supported POS takes about five minutes: open Jelly, click Integrations, sign in to your POS, grant permissions, then select which categories to sync. Item-level sales data flows into Jelly as soon as a transaction completes, and the Flash Report shows a live GP margin based on actual costs and actual sales.
Troubleshooting: The most common friction point is missing admin access to your POS account. Jelly flags this requirement upfront so setup does not stall halfway through.
Step 7 — Activate Price Alerts. Jelly’s Price Alert feature flags every ingredient price increase or decrease in the same week it appears on an invoice, including the supplier and the exact variance. Chefs gain concrete evidence for negotiations and can request credits or switch suppliers without spending hours cross-referencing spreadsheets.
Step 8 — Build live dish costings in the Kitchen section. Using ingredients already populated from scanned invoices, chefs build recipes by clicking on existing SKUs. Jelly handles unit conversions and wastage calculations automatically. A task that previously took 28 minutes per dish in a spreadsheet now takes under three minutes in Jelly. As new invoices arrive, every dish cost and GP margin updates in real time.
Troubleshooting: If a dish margin turns red unexpectedly, check whether a new invoice includes a price increase on a core ingredient. The Price Alert will already have flagged it, so you can call your supplier with specific figures.
See how Jelly’s live dashboard replaces the manual eight-step process and walk through your own supplier data in under a week.
Real procurement dashboard results from UK restaurants
Amber, a Mediterranean restaurant in East London, implemented Jelly’s invoice automation, price change alerts, and real-time recipe costing. The team now saves £3,000–£4,000 per month through supplier credits, better buying decisions, and tighter menu controls, which equates to roughly 68× return on the platform cost. Chef-Owner Murat Kilic puts it simply: “Jelly keeps my business alive.”
Sushi Revolution, a modern Japanese restaurant in South London, uses Jelly to set separate target gross profits on dine-in and delivery menus, accounting for 30% delivery platform commissions. Actual gross profits are 2–3% higher on average as a result, and this approach supported the opening of a second site.
Populu lifted GP from 68% to 72% across 16 locations after connecting Jelly’s POS integration. A single-site operator improved gross profit from 65% to 72% within 12 weeks on about £500,000 in revenue. These outcomes match Jelly’s platform averages, where users cut food costs by 3% and add two percentage points to gross margin within the first 90 days.
Operational leakage from weak food cost control can drain profit from UK hospitality businesses. A live procurement dashboard converts that leakage into recoverable margin.
Procurement dashboard Excel template for a manual start
A practical starting template mirrors the eight KPIs across three linked sheets. The Invoice Log tracks supplier, date, SKU, unit price, quantity, and total. The Recipe Costing sheet holds dish name, ingredient SKUs, yield percentage, cost per portion, and target GP percentage. The Weekly Summary shows actual food cost percentage, theoretical food cost percentage, variance, spend by supplier, stock-out count, and invoice cycle time. Conditional formatting flags any food cost above 35% or variance above 2% in red.
Any Excel template remains only as current as the last manual update. Many hospitality operators still rely on spreadsheets, WhatsApp chains, and paper invoices, and 8–12% of payments in F&B hospitality are at risk from duplicate payments, overbilling, and coding errors when procurement stays manual. The template works as a diagnostic tool. Jelly then replaces it as the operational system.
Ready to move beyond static templates? Jelly’s team will build a live dashboard using your actual invoices and show it in action.
Why most kitchen dashboards fail and how Jelly avoids it
Three failure modes explain most abandoned procurement dashboards in UK hospitality. Manual data entry creates a lag that turns the dashboard into a historical report. By the time a price increase appears in a spreadsheet, the kitchen has already absorbed the cost across dozens of covers. Chef buy-in then collapses when the tool demands heavy time investment. Costing a single menu item manually takes about 28 minutes in a spreadsheet, which is unrealistic during a busy service week. Static pricing assumptions finally bake last month’s supplier rates into dish costings that drive today’s menu decisions.
Jelly sidesteps all three problems. Invoice scanning removes manual entry. The Kitchen section cuts dish costing to under three minutes per item. Every new invoice automatically updates ingredient prices, so dish GP margins stay current without manual refresh. The Price Alert feature surfaces price changes in the same week they occur, not the same month an accountant files a report.
Your 90-day procurement dashboard success checklist
Week 1: Suppliers forward invoices to the Jelly email address or the team photographs paper invoices. Price Alerts run in the background. The POS connects in under five minutes.
Weeks 2–4: The kitchen costs all core dishes in the Kitchen section. The Flash Report shows daily GP. The first supplier negotiation uses Price Alert data as evidence.
Days 30–60: The team tracks food cost percentage weekly against the 28–35% benchmark. Theoretical versus actual variance holds at 2% or less. Invoice cycle time falls as manual processing disappears.
Days 60–90: Food cost drops by about 3%. Gross profit margin rises by roughly two percentage points. Admin time falls by 10–20 hours per week. Delivery menu GP stays protected against platform commission through separate target GP settings.
Jelly charges a flat rate of £129 per month per location, with no per-user fees, variable charges, or implementation costs beyond the five-minute POS setup.
Start your 90-day roadmap this week and see how Jelly delivers these results in your own kitchen.
Frequently Asked Questions
How long does it take to set up a procurement dashboard with Jelly?
Most operators see initial value within the first week. The fastest route is to forward supplier invoices to a dedicated Jelly email address so Jelly can begin digitising line items immediately. The kitchen can also photograph paper invoices directly in the app, with data available in under 24 hours. Connecting a supported POS system such as Square, EPOS Now, Lightspeed, or Toast takes about five minutes. Dish costing in the Kitchen section can start as soon as the first invoices are scanned because ingredients are already populated from those invoices.
What is the difference between theoretical and actual food cost, and why does it matter?
Theoretical food cost is what a dish should cost based on its recipe and current ingredient prices. Actual food cost is what the kitchen has spent, calculated from invoices and stock counts over a set period. The variance between the two reveals waste, portioning errors, theft, and supplier overcharges. Industry best practice keeps this variance at 2% or less. As noted earlier, even a 5% variance can cost £5,000 per month on £100,000 in sales, which would otherwise flow directly to your bottom line. Jelly keeps both figures live and updates them automatically whenever a new invoice is scanned.
How does Jelly’s Price Alert feature support supplier negotiations?
Every time a supplier invoice contains a price that differs from the previous invoice for the same SKU, Jelly’s Price Alert flags the change. The alert shows the ingredient, the supplier, the previous price, the new price, and the percentage movement. Chefs and owners gain concrete, timestamped evidence for supplier conversations, whether they request a credit note, negotiate a better rate, or assess an alternative supplier. Operators using Price Alerts report faster reactions to price swings and measurable reductions in food cost within the first month.
What does Jelly cost, and are there any hidden fees?
The platform runs on a flat rate of £129 per month per location, as outlined in the 90-day checklist. There are no per-user charges, feature tiers, or variable fees based on invoice volume or number of suppliers. All features, including invoice scanning, Price Alerts, Flash Report, Kitchen costing, POS integration, and Xero accounting integration, are included at that price. A business saving £3,000–£4,000 per month through tighter procurement controls sees a return on investment of roughly 23–31× the monthly platform cost.
Which POS systems does Jelly integrate with?
Jelly integrates natively with Square, EPOS Now, Lightspeed, and Toast through real-time APIs. Each integration delivers item-level sales data as soon as a transaction completes, which allows the Flash Report to show a live gross profit margin based on actual costs and sales. Setup follows the same short flow across all four systems and requires admin access to the POS account. Jelly plans to expand its integration partners for operators using other POS systems.