Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Excel works for single-site operations with under 100 SKUs, one person updating stock, and no recipe costing or multi-channel sales.
- Once a kitchen exceeds roughly 300 SKUs or adds suppliers, recipe costing, or a second site, spreadsheet limits start to erode margin every week.
- Manual stock tasks consume 10–20 hours per week; automated systems cut this to 4–6 hours and reduce hidden food-cost creep.
- Recipe costing that takes 5–10 minutes per dish in Excel takes around 3 minutes in Jelly, with live GP margins and automatic price updates across recipes.
- Jelly provides automated invoice scanning, live dish costing, supplier price alerts, POS integration, and flat £129/month per-location pricing for growing UK kitchens.
See Jelly Working With Your Menu
When Excel Still Works For Stock Control
Excel remains a legitimate stock control tool under a narrow set of conditions. A single-site business selling through one channel, running a straightforward fulfilment model, can run well on a well-organised spreadsheet at its current stage. In hospitality terms, that means:
- One site
- One person responsible for updating stock
- Fewer than 100 SKUs
- No recipe or dish costing requirement
- No multi-channel sales (no delivery platforms, no second till system)
For example, a smaller single-site pub with a simple bar operation and no kitchen costing requirement can avoid £129/month on software and instead use a weekly stock count with a spreadsheet or a purpose-built pub stock app costing a one-off £97, with annual software spend typically around £600–£800. A well-maintained spreadsheet, used as a starting point with a clear ceiling, gives a reasonable answer at that stage. For a practical template to build from, the bar stock control spreadsheet guide covers the before state in detail.
The ceiling arrives the moment any one of those conditions changes. Counting stock more often than you reorder signals that a business has outgrown spreadsheets, because counting is what you do when you no longer trust your own records.
What Is the Real Cost of Managing Stock in Excel?
Once that ceiling is crossed, the cost of Excel stops being a licence fee and becomes time, margin erosion, and delayed visibility.
Restaurant managers spend 10–20 hours per week on manual inventory tasks such as data entry, price checking, and reconciling invoices. After automation, that figure drops to 4–6 hours. Dish costing is where the burden concentrates most: costing a single menu item in a spreadsheet typically takes around 5–10 minutes per recipe because there is no automatic yield, sub-recipe roll-up, or price propagation. That time goes into unit conversions across dozens of SKUs from multiple suppliers, fluctuating prices, and batch recipes.
The margin risk builds quietly in the background. Food cost creep, where ingredient prices rise while the recipe-cost model stays static, compounds over months. On a restaurant doing $2 million in annual food revenue, a two-point food cost drift represents $40,000 in lost margin per year. Because most operators only see the damage when the monthly accountant’s report arrives, the reaction usually comes too late to recover the margin already lost.
Supplier price creep compounds the problem further. Spreadsheets only reflect current ingredient prices when someone manually updates them. They do not automatically account for yield loss, roll sub-recipe costs into parent recipes, or flag which dishes are affected when a supplier price changes. The theoretical food cost slowly diverges from reality every week, and most operators only catch it at the monthly or quarterly P&L. At that point, the investigation often ends in inconclusive finger-pointing at waste and over-portioning.
Manual invoice reconciliation also carries direct accounts payable risk. Errors damage supplier relationships and can halt the delivery of essential goods. That risk grows with every additional supplier added to the operation.
Calculate Your Time And Margin Gain
Stock Control Software Vs Excel At A Glance
The table below highlights the operational differences that matter most as a kitchen grows: upfront cost, how stock updates happen, recipe costing speed, and supplier price tracking.
| Feature | Excel | Jelly |
|---|---|---|
| Upfront Cost | No upfront software cost because it is included with Microsoft 365, but using it for stock control still creates hidden costs in manual labour, errors, and stockouts | Flat £129/month per location, with no variable charge per user or feature |
| Stock Updates | Manual entry; prices only update when someone manually edits the file | Automated via invoice scanning; ingredient costs update with every new invoice |
| Recipe And Dish Costing | Around 5–10 minutes per recipe (see above); no automatic yield, sub-recipe roll-up, or price propagation | 3 minutes per dish; unit conversions, yield, and maths handled automatically; GP margins live |
| Supplier Price Tracking | No alerts; price changes only visible when the file is manually updated | Price Alert feature flags every increase or decrease by ingredient and supplier in real time |
Where Excel Struggles With Recipe And Dish Costing
Recipe and dish costing is the area where Excel most visibly fails a growing kitchen. The problem comes from structure, not operator skill. A dish with twelve ingredients from four suppliers arrives in different pack sizes and units. Costing it requires manual unit conversions, a manually maintained trim and yield table, and a sub-recipe cost rolled up into the parent recipe. Every one of those steps must be repeated whenever a supplier changes a price. Sub-recipes such as demi-glace, gremolata, and polenta are frequently not individually costed, so parent recipes undercount true dish cost; the more components a dish has, the more likely the stated recipe cost is an undercount.
In Jelly’s Kitchen section, a chef builds a dish recipe by clicking on ingredients already populated from scanned invoices. Jelly handles all unit conversions and maths automatically. What used to take 28 minutes takes around 3 minutes. Because ingredient costs update with every new invoice, the gross profit margin for every dish stays live. A red percentage flag appears if a dish drops its margin, and a green one appears if it grows. Jelly users add an average of 2 percentage points to gross margins in the first three months.
The delivery menu use case shows this value in practice. Jelly allows operators to duplicate existing menu items and factor in delivery commission overheads to build a separate, profitable delivery menu. That calculation is hard to maintain accurately in a spreadsheet when commission rates and ingredient costs both move.
What Changes With A Second Site Or Second Sales Channel
The second site is the most common switching trigger for operators. The moment a second location opens, the physical presence that kept a single-site spreadsheet honest disappears. There is no longer one person who knows where every delivery note is. Stock counts happen at different times and to different standards, with no consolidated view of group-wide costs.
Sushi Revolution’s monthly stocktake using Jelly takes 5–20 minutes, down from 2–3 hours previously, and they opened their second restaurant in June with that process in place. That time saving makes multi-site expansion operationally viable without adding headcount.
A second sales channel, such as a delivery platform, a second till system, or a private dining operation, creates the same problem in a different form. POS-linked sales mix data turns stock control into menu profitability decisions. Jelly integrates natively with Square, EPOS Now, Toast, and Lightspeed, pulling item-level sales data in real time so operators can see which dishes are most popular and which are most profitable. Connecting a POS automates 2–5 hours of weekly work and delivers real-time margins and sales mix data. These systems are complementary tools Jelly works alongside, and the integration is what makes the margin visibility possible.
For operators managing multiple sites, the multi-site buyer’s guide covers consolidation and central purchasing considerations in detail.
How Much Does Stock Control Software Cost in the UK?
For a growing kitchen, the meaningful comparison is the licence fee versus the margin currently invisible to the business.
The UK market in 2026 follows clear tiers. Entry-level cloud tools run £30–£100 per month for one location. Mid-market systems sit at £300–£1,500 per month for multi-location operations with advanced integrations. Enterprise WMS starts at £2,000+ per month, often with implementation costs of £10,000–£50,000 and long contracts.
Jelly sits outside that tiering model by design. At a flat £129/month per location, with no variable charge per user or feature, it is priced for growing kitchens rather than enterprise procurement teams. Jelly users cut food costs by 3% on average in the first three months, alongside the gross margin improvement noted earlier. Against 10–20 hours of admin time per week, the licence fee becomes a small line item compared with the margin currently hidden in spreadsheets.
How To Migrate Off Excel Without Losing Your Data
Migration anxiety keeps many operators on spreadsheets longer than they should stay. The practical reality is considerably less painful than most forum threads suggest.
Jelly onboards and generates initial value in the first week. Price alerts and spending insights are available once suppliers send invoices to a dedicated email address, or less than 24 hours after invoices are photographed into Jelly. The first-week playbook is straightforward:
- Connect your POS via Integrations, sign in to the POS, grant permissions, and select categories to sync
- Map POS items to dishes in the Kitchen section
- Start with price alerts as the fastest route to immediate, actionable value
On data preparation, standardising SKU naming conventions and cleaning duplicates before migration is time well spent, because every hour spent cleaning data saves three hours of troubleshooting after go-live. For most operators, that means a half-day of spreadsheet housekeeping before the switch, rather than a multi-week project.
What Operators Say After Leaving Excel
Operator scepticism about vendor-written comparison content is understandable. Most software comparison articles are written by the software vendor. The evidence below comes from operators who use Jelly in working kitchens.
Stuart Noble, Head Chef at Cairn Lodge Hotel, describes the supplier price visibility Jelly provides: “Price hikes were crushing our margins, I felt helpless. With Jelly, every dish cost is up-to-date at my fingertips. We slashed food costs by 5% in a month, it is a game changer.”
Ruth Seggie, Owner of The Howard Arms, shares the impact on gross profit: “Our accountant said we would be lucky to hit 60% gross profit. After using Jelly, we reached 80%. Now I sleep better knowing my costs are under control and can react instantly, not weeks later.”
These stories reflect what happens when a kitchen moves from delayed, static spreadsheet data to live dish costing and automated supplier price tracking.
Frequently Asked Questions
Is Excel Still Relevant In 2026?
As of 2026, Excel remains relevant for stock control for single-site operators with under 100 SKUs, one sales channel, no sync complexity, a single person managing stock, no need for real-time accuracy, and simple in/out tracking without kitting, bundling, serial numbers or lot/expiry management. It cannot handle live dish costing, supplier price tracking, or multi-site consolidation. Once a kitchen adds multiple suppliers, recipe costing, a second site, or a POS channel, Excel’s structural limits start to create margin risk that compounds weekly.
Can I Use Excel For Inventory Management?
Excel works for basic stock counts at a single site with one person updating. A well-maintained spreadsheet with reorder point formulas and a fixed counting day gives a legitimate starting point. It breaks when you add multiple suppliers, recipe costing, a second site, or a POS channel, because spreadsheets do not sync in real time, cannot automatically propagate price changes across recipes, and have no mechanism for flagging which dishes are affected when a supplier changes a price.
How Much Does Inventory Software Cost In The UK?
Jelly charges a flat £129/month per location with no variable charge per user or feature. As covered above, UK stock control software ranges from entry-level cloud tools to mid-market and enterprise WMS, with Jelly positioned as a simple flat-fee option for growing kitchens.
What Is ABC Analysis?
ABC analysis is an inventory management method that categorises stock into three groups (A, B and C) based on each item’s value to the business, typically its annual consumption value, so that the most important products receive the closest attention and resources. Typically, around 20% of items generate 80% of revenue, and these are “A” items that should be counted most frequently, often daily or twice-weekly. “B” items are counted weekly, and lower-value “C” items monthly. The approach focuses management attention on the stock that matters most to margin, rather than applying the same counting cadence to every SKU regardless of value.
How Long Does It Take To Migrate Off Excel?
As outlined in the migration section, Jelly generates initial value in the first week, with price alerts available within 24 hours of invoice submission. Cleaning SKU naming conventions and removing duplicates from existing spreadsheet data before migration is the main preparation task, taking four to twelve hours for the item list of a typical SME, depending on how many duplicates exist and whether a naming convention has ever been agreed; customers and suppliers are quicker.
The Decision
Excel works well for the job it was built for. The problem starts when a growing kitchen asks it to handle live costing, supplier price alerts, sub-recipe rollup, and multi-site consolidation. It has no mechanism for live dish costing, supplier price alerts, sub-recipe rollup, or multi-site consolidation. The margin erosion that follows, through food cost creep, unnoticed supplier price increases, and delayed GP visibility, is real and cumulative, and operators usually see it only when the accountant’s report arrives.
An effective solution for a growing UK hospitality kitchen needs automated invoice scanning, live dish costing, supplier price alerts, POS integration, fast onboarding, and flat predictable pricing. Jelly delivers all of that at £129/month per location, built specifically for growing kitchens of restaurants, pubs, and boutique hotels.
For operators expanding to multiple sites, the multi-site buyer’s guide covers consolidation considerations in detail. For restaurants and pubs evaluating the full back-of-house picture, the restaurant and pubs buyer’s guide is the next step.
Talk Through Your Numbers With Jelly