How to Automatically Track Supplier Price Increases

How to Track Supplier Price Increases Automatically

Written by: JJ Tan, Founder, Jelly | Last updated: 24 August 2026

Key Takeaways for UK Restaurant Operators

  • Frequent supplier price changes can quietly remove £3,000–£4,000 from monthly profit if no real-time monitoring exists.
  • Manual invoice checking and data entry consume 10–20 hours per month and allow margin erosion before anyone notices.
  • A seven-step automated workflow using your existing Xero and POS can surface price alerts within the first week.
  • Automated OCR extraction, unit normalisation, and live margin linking support faster supplier negotiations and credit recovery.
  • Operators can see a live Jelly walkthrough and start automated price tracking this week.

Step 1: Set Up a Dedicated Supplier-Invoice Inbox and Photo Route

Start by assigning a single email address exclusively for supplier invoices, for example invoices@yourrestaurant.com, and instruct every supplier to send PDFs or images there. For paper invoices that arrive with deliveries, create a simple mobile photo habit: one photo per invoice, taken at the point of receipt before the delivery driver leaves.

Consistency at this stage determines the accuracy of every downstream step, because the system can only track price changes for invoices it receives. A missed invoice means a missed price alert, and any cost increase on that invoice will erode your margin unnoticed until the next delivery.

Pro Tip – Jelly automates inbox capture: Forward your supplier invoice email to your dedicated Jelly inbox, or photograph invoices directly into the Jelly mobile app. Jelly begins processing within minutes of receipt, with no manual upload queue to manage. See the invoice inbox setup in action during a live demo.

Step 2: Turn On Automatic Line-Item OCR Extraction

Optical character recognition (OCR) reads every line of an invoice and extracts the SKU, quantity, unit of measure, net price, and tax code. Manual data entry has an average error rate of 1–4% at the field level, and each error can distort your margin picture. Automated extraction removes that error rate and creates a timestamped, auditable record of every price at the moment it was billed.

Pro Tip – Jelly automates line-level capture: Jelly’s invoice scanning engine captures quantity, SKU, price, and tax from every line without manual input. The extracted data feeds directly into your ingredient cost library, updating prices the same day the invoice arrives. Watch Jelly scan and extract invoice lines live in a demo.

Step 3: Normalise Pack Sizes, VAT, and Surcharges

Price comparisons only work when every item uses the same basis. A 5 kg bag of flour and a 25 kg sack become comparable once both are expressed as a price per kilogram. A VAT-inclusive invoice line also needs conversion before comparison with a VAT-exclusive line. Convert every line to a common unit such as price per kg, per litre, or per each, and strip VAT before any comparison, because VAT is a pass-through item that does not affect food cost.

Surcharges such as fuel levies and refrigerated transport should be allocated proportionally across the order rather than treated as a separate overhead. This allocation keeps the resulting unit cost comparable from period to period and reveals the true landed cost of each ingredient.

Pro Tip – Jelly automates unit and VAT rules: Jelly handles all unit conversions and VAT exclusions automatically when you build dish recipes in the Kitchen section. A chef clicks an ingredient already populated from scanned invoices, and Jelly calculates the normalised cost instantly. What previously took 28 minutes per dish now takes three.

Step 4: Use Percentage and Pound Thresholds for Meaningful Alerts

Price alerts only help when they highlight real issues instead of noise. A percentage-only threshold can trigger false alerts when low-cost items fluctuate by a penny or two, while a pound-only threshold can miss significant percentage increases on expensive ingredients. Many operations solve this by using a combined rule: alert when a unit price moves by 5% or more and by at least £0.05.

This dual filter suppresses rounding effects on cheap items while catching meaningful changes across the full cost spectrum. Fuel surcharges and delivery minimums should be tracked separately and excluded from ingredient price-change alerts to keep the signal clean. A common source of false alerts is a multipack-versus-single-unit mismatch; these are eliminated by normalising all records to a common basis before any comparison is run.

Pro Tip – Jelly filters out noise automatically: Jelly’s Price Alert feature flags every ingredient price increase or decrease, by how much, and from which supplier, without any threshold configuration. The system surfaces only meaningful changes and gives chefs and owners concrete evidence to negotiate credits or switch suppliers.

Step 5: Connect Updated Costs to Live Recipe and Menu Margins

Price alerts only become useful when they show which dishes lose money after a change. Restaurants using automated pricing alerts respond to ingredient cost changes within 48 hours, compared to 2–4 weeks for periodic manual review. Every day of delay removes margin.

Link each ingredient in your cost library to the recipes that use it. When a supplier updates a price, every affected dish GP recalculates automatically. Any dish that falls below your target margin is then flagged for review so you can adjust price, portion, or recipe.

Pro Tip – Jelly keeps GP live by dish: Ingredient costs in Jelly update with every new invoice, so the gross profit margin for every dish stays live. A red percentage appears when a dish drops below target and green when it improves. Sushi Revolution uses this to set separate GP targets for dine-in and delivery menus, accounting for 30% delivery commissions, and achieves actual gross profits 2–3% higher on average.

Step 6: Send Cleaned Invoice Data to Xero with One Click

Once invoice lines are extracted, normalised, and matched to ingredients, the same data should flow into your accounting platform without re-keying. The alternative is manual accounts payable work, which is prone to error and often slows payments. These mistakes can damage supplier relationships if payments are delayed or misapplied.

Automated posting to Xero creates a clean, auditable bill record with correct VAT treatment and supplier coding. Your finance data then matches your cost-control data, and both update from the same invoice source.

Pro Tip – Jelly posts directly into Xero: Jelly’s one-click Xero integration pushes digitised invoices directly into Xero and reduces bookkeeping time by 90%. The same invoice that triggered a price alert also becomes a correctly coded Xero bill, with no double-handling and no re-entry.

Step 7: Export Price-Change Evidence for Supplier Negotiations

Clear evidence turns awkward supplier conversations into straightforward corrections. Overbilled invoice lines can show significant differences from the agreed price, yet recovering those overcharges is difficult without a timestamped record of what was agreed versus what was billed. A structured export that shows SKU, agreed price, billed price, variance in pounds and percentage, and invoice date gives buyers the facts needed to negotiate from a strong position.

Pro Tip – Jelly prepares negotiation-ready exports: Amber restaurant’s Chef-Owner Murat Kilic uses Jelly’s Price Changes feature to spot ingredient price fluctuations and act quickly on supplier switches, ingredient substitutions, and credit note claims, consistently saving £3,000–£4,000 per month.

Troubleshooting: Fix the Three Most Common False Alerts

Once your workflow runs smoothly, the next priority is reducing noise from false alerts. Most issues come from three predictable patterns, each with a simple fix.

  • Pack-size changes: A supplier switches from 5 kg bags to 10 kg sacks, and the unit price appears to halve, which triggers a false decrease alert. Resolution: ensure normalisation to price-per-kg runs before any comparison, not after. In Jelly, unit conversions apply at the point of invoice scanning, so pack-size changes do not distort the cost library.
  • Fuel surcharges and delivery fees: These appear as new line items on invoices and can be misread as ingredient price increases. Resolution: categorise surcharge lines separately during OCR extraction and exclude them from ingredient price-change comparisons. Track them independently to monitor total landed cost over time.
  • Multi-site invoice consolidation: A supplier sends one consolidated invoice covering multiple sites at blended prices. Resolution: split invoices by site before extraction, or use a platform that assigns invoice lines to individual locations. Jelly supports multi-site operations, keeping each location’s cost data clean and separately reportable.

Measure Success: Three KPIs for Your Price-Tracking Workflow

Three simple KPIs confirm that your workflow functions correctly and delivers real financial impact.

  1. First price alert within seven days: If no alerts fire in the first week, invoices are not reaching the system or OCR extraction has failed. Check the supplier inbox and re-scan any missing invoices.
  2. 10–20 hours of admin recovered per month: Track the time previously spent on manual price checking, invoice re-keying, and spreadsheet reconciliation. Jelly users consistently recover this block within the first month.
  3. 2-percentage-point GP improvement within three months: Amber restaurant achieves these savings through faster reactions to price changes, credit note recovery, and tighter menu controls. Jelly customers see gross margins increase by an average of two percentage points in the first three months.

Advanced Next Steps: Delivery Menus and Multi-Site Roll-Outs

Once the core workflow runs reliably, two extensions can protect even more margin. First, delivery menu engineering: duplicate existing menu items in Jelly, apply the delivery commission overhead, typically 25–30%, and set a separate GP target. Jelly calculates the minimum selling price required to hit that target and prevents the common mistake of running delivery at a loss. Sushi Revolution applies this approach across both dine-in and delivery channels.

Second, multi-site roll-out: connect each location’s supplier inbox and POS to Jelly independently. Owners and operations managers gain a consolidated view of spending, price alerts, and GP across all sites from a single dashboard, without relying on chefs to compile reports. Jelly works alongside Square, Lightspeed, EPOS Now, and Toast via real-time API, with POS connection taking approximately five minutes per site.

Conclusion: Put Automated Margin Protection in Place This Week

Manual price checking cannot keep pace with a market where supplier prices change frequently and many invoices contain at least one incorrectly billed line. The seven-step workflow of a dedicated invoice inbox, OCR extraction, unit normalisation, threshold alerts, live margin linking, one-click Xero posting, and negotiation exports closes that gap and surfaces actionable data inside the first week.

Jelly automates every step of this workflow at a flat rate of £129 per location per month, with no per-user charges and no lengthy onboarding. Operators connect their existing Xero account and POS system in under five minutes and receive their first price alerts within days of the first invoice arriving.

Schedule a Jelly demo and see how automated price tracking can protect your margins this week.

Frequently Asked Questions

How quickly does Jelly start generating price alerts after setup?

Jelly generates price alerts within the same week invoices begin arriving. Once suppliers are directed to your dedicated Jelly inbox or your team starts photographing paper invoices into the app, Jelly scans every line item and flags any price movement immediately. Most operators see their first meaningful alert within the first two to three days of invoices flowing through the system. There is no waiting period, no manual configuration of ingredient libraries from scratch, and no lengthy onboarding process. The system populates your ingredient cost data directly from the invoices themselves.

Does Jelly handle VAT correctly when calculating ingredient costs and dish margins?

Yes. Jelly extracts VAT from every invoice line during OCR scanning and calculates all ingredient costs and dish margins on a VAT-exclusive basis. This approach matches food cost control practice, because VAT is a pass-through item that does not affect your actual cost of goods. When invoice data is pushed to Xero in one click, the VAT coding is preserved and posted correctly to your Xero account, so your bookkeeping and your food cost reporting remain consistent without manual reconciliation.

Which POS systems does Jelly integrate with, and how long does connection take?

Jelly works alongside Square, Lightspeed, EPOS Now, and Toast via real-time API. Each integration delivers item-level sales data the moment a transaction completes and enables live GP calculations that combine your invoice costs with your actual sales mix. Connecting any supported POS takes approximately five minutes and follows the same flow across all four systems: open Jelly, click Integrations, sign in to your POS, grant permissions, and select which categories to sync. The only common friction point is lacking admin access to the POS account, and Jelly flags this requirement upfront so it can be resolved before setup begins.

Can Jelly track prices across multiple suppliers and sites simultaneously?

Jelly is built for operators running one to several sites with multiple suppliers. Each supplier’s invoices are processed separately, so price alerts identify not just which ingredient has changed but which supplier changed it and by how much. For multi-site operators, each location connects its own supplier inbox and POS independently, while owners and operations managers access a consolidated view of spending, alerts, and GP across all locations from a single dashboard. This setup removes the need for chefs to compile cross-site reports and gives management a reliable, automated source of truth.

What evidence does Jelly provide for supplier negotiations and credit note claims?

Jelly’s Price Alert feature creates a timestamped record of every price movement at the line-item level, showing the SKU, the previous agreed price, the newly billed price, the variance in both pounds and percentage, and the invoice date. This data is available to export and provides the concrete, document-backed evidence needed to challenge a supplier, request a credit note for overbilling, or negotiate a better rate. Operators who use this feature consistently, such as Amber restaurant in East London, recover thousands of pounds per month through credits and better buying decisions that would otherwise go unnoticed in a manual process.

Read Next