Simple Inventory Tracking: A UK Guide for Restaurants

Written by: JJ Tan, Founder, Jelly

Key Takeaways

• A simple inventory tracking system records stock levels, locations and movements without enterprise complexity, from spreadsheets through to purpose-built software.
• Every effective system needs six core fields: SKU, item name or category, quantity on hand, reorder threshold, unit price and total value, plus location or supplier.
• Spreadsheets suit single-site operators with stable menus but fail at scale because of formula errors, missing audit trails, and no automatic invoice reconciliation.
• UK hospitality businesses should move from manual systems when they face multiple suppliers with price changes, multiple sites, staff turnover, unreconciled invoices, or unexplained margin drift.
• Jelly leads the shortlist by turning scanned supplier invoices into live stock and dish-level margins, onboarding in the first week, and costing a flat £129/month per location.

Book a demo with Jelly

Core Fields Every Simple Inventory Tracking System Needs

Every simple inventory tracking system, whether spreadsheet or software, relies on the same six core fields.

• SKU / item code — a unique identifier for every product. Excel strips leading zeros from SKUs by default, so format the column as text before entering codes.
• Item name and category — for example, “Chicken Breast / Protein”.
• Quantity on hand — updated after every delivery and count.
• Reorder threshold — the par level that triggers a new order.
• Unit price and total value — cost per unit multiplied by quantity on hand.
• Location and supplier — which storage area holds the item and which supplier it comes from.

Once the six fields are in place, two tools do most of the work. Add a SUMIF formula to total stock value by category, and apply conditional formatting to flag any row where quantity on hand falls below the reorder threshold. UK operators also need a VAT column that records whether each line is standard-rated (20%) or zero-rated, because GOV.UK’s VAT record-keeping guidance states that VAT-registered businesses should record goods in their VAT accounts even when those goods are zero-rated.

Using Excel As a Simple Inventory Tracker

Excel works well for a single site with a small number of suppliers and a disciplined weekly count routine. Microsoft’s own Excel inventory templates are the most common DIY starting point and cover the basics well.

The failure modes are well documented. A SUMIFS formula written in January to cover rows 2 to 500 will silently exclude a new SKU added in row 501 in March, producing totals that look correct but are wrong. When two people update the same cell, one change vanishes with no warning and no record of who made it. The sheet has no audit trail, no link to supplier invoices, and accuracy depends entirely on the busiest person in the kitchen remembering to update the file after every delivery.

A 2024 literature review in Frontiers of Computer Science found that about 94% of audited spreadsheets in use contained errors. That figure should give any operator pause before trusting a spreadsheet with their food cost percentage. Spreadsheets remain useful tools, but they have structural limits that discipline alone cannot remove.

Simple Inventory Tracking Systems For UK Hospitality: The Shortlist

This shortlist sets out the most practical options for UK hospitality operators, in recommended order. Jelly leads because it is the only option here built specifically around the invoice-driven workflow that growing UK kitchens need.

1. Jelly — reads every line of every supplier invoice automatically, whether by photo or email, and updates stock and dish-level gross profit in real time. It pushes invoices to Xero (Sage integration coming soon), and connects natively to Square, Lightspeed, EPOS Now and Toast in about five minutes. Onboarding completes in the first week, at a flat £129/month per location with no per-user charges. Amber restaurant in East London saves £3,000–£4,000 per month using Jelly’s invoice automation and price alerts. Sushi Revolution cut its monthly stocktake from 2–3 hours to 5–20 minutes and lifted gross profit by 2–3%.
2. Sortly — a visual, mobile-friendly inventory app with photo records, QR and barcode labels and a free tier capped at 100 items and one user, with paid tiers starting at $49/month. Sortly tracks items and assets. It does not handle recipe-level dish costing or supplier invoice capture, and costs rise as catalogues grow. Mid-contract price increases of 100–900% have been documented, with increases imposed with as little as 10–30 days’ notice.
3. Zoho Inventory — offers a free plan and tiered paid plans, with prices exclusive of local taxes. The free plan caps orders, users and locations. Pricing complexity increases across modules and users, and meaningful setup effort is required before it earns its keep in a hospitality context.
4. Skyware Inventory — a lightweight web-based tracker, free for one user and $5/month per additional user, with no stated item limits. Mobile stock-tracking is Android-only.
5. Simple Inventory Management — an ambiguous name used for at least two distinct products: Simple Inventory Manager (SIM) by SOLTI, a Windows and Android desktop application, and Smart Inventory Manager, a separate free-download barcode app. Treat this label with caution when comparing, because features and support vary significantly between them.
6. Sage UK — stock and inventory management appears only on Sage Accounting Plus at £59/month ex VAT. The module covers basic purchase orders and stock, but Sage has no native integration with Square, Lightspeed or EPOS Now, so POS data must be reconciled manually or via third-party connectors.
7. Google Sheets — not a tracking system in its own right, but the free fallback most operators start from and worth including for comparison. It is free to use with a personal Google Account, and Google Workspace Essentials Starter is available at no cost, though organisations typically need a paid Google Workspace plan starting at around $7 per user per month. It depends entirely on manual discipline and carries all the structural failure modes of any spreadsheet.

Sortly is the closest thing on this list to a like-for-like alternative, so it is worth spelling out where the two diverge. Sortly is a capable visual asset tracker for businesses that need to photograph and label physical items. For a UK hospitality operator, the critical gap is that Sortly is not designed to read supplier invoices, does not link ingredient costs to dish-level gross profit, and does not integrate with Xero or UK POS systems natively. Jelly covers all of these needs from day one. Where Sortly relies on manual data entry to keep stock current, Jelly updates stock and costs automatically every time a new invoice arrives by photo or email, so the busiest person in the kitchen can stay off the spreadsheet. The pricing structure also differs materially: Jelly’s flat £129/month per location carries no per-user charges and no item-count caps, whereas Sortly’s tiers scale by both item count and user seats, and its prices can rise mid-contract.

If none of these fit, the Inventory Tracking App Comparison For UK Hospitality 2026 and the broader Inventory Tracking System For UK Hospitality: 2026 Guide cover the wider market. Before committing to any of these, check whether you have already outgrown a spreadsheet, because that determines whether you need a tracker at all.

When a Spreadsheet Stops Being a Simple Inventory Tracking System

Five clear graduation triggers signal that a manual system now costs more than it saves.

• Multiple suppliers with weekly price changes — someone has to paste new costs over old ones, verify SKUs still align, and confirm no formula points at a column that moved. With 30 suppliers each changing prices several times a year, that becomes a standing weekly task that nobody has time to do properly.
• More than one site — separate spreadsheets for separate locations create competing versions of the same data. A typical business with around 1,000 SKUs spends roughly 20–25 hours per month on spreadsheet maintenance.
• Staff who will not keep counts updated — many small businesses run inventory on a spreadsheet only one employee fully understands; if that person leaves, tracking can fall apart overnight.
• Invoices that never reconcile to stock — without a digital link between invoices and stock records, the two figures drift apart silently.
• Margins you cannot explain — a two-percentage-point increase in food cost on a restaurant doing £500,000 a year in food sales equates to £10,000 of additional cost or lost gross margin.

At this point the manual system costs more than the software that replaces it. Add the £10,000 hit from a two-point food cost drift on £500k of sales to the hours spent maintaining the sheet, and the case is straightforward. Amber’s Chef-Owner Murat Kilic describes Jelly as keeping his business alive after moving from spreadsheet costing to automated invoice processing and real-time price alerts. Jelly is built for exactly this moment in UK kitchens: invoices in, live stock and margins out, with no reliance on the busiest person’s paperwork.

How to Automate Restaurant Inventory with Real-Time Tracking explains the practical steps for making that transition.

See your invoices turned into live margins

How UK Hospitality Businesses Actually Track Inventory

Hospitality and retail teams tend to use four main approaches, which build on one another.

• Periodic counts — a full physical stocktake at fixed intervals such as weekly or monthly. This method is accurate at the moment of counting but blind to movements in between.
• Perpetual inventory — stock records updated continuously as goods are received and sold, typically via a POS system. It improves accuracy but depends on every movement being recorded.
• Barcode scanning — barcode scanning cuts error rates from around 5% for manual entry to below 0.1% and speeds up counts significantly, which makes perpetual inventory more realistic.
• Invoice-driven tracking — the method that solves the problem the previous three share. Stock updates automatically from supplier invoices and reconciles against POS sales data, so perpetual inventory no longer depends on someone recording every movement.

For a detailed explanation of how these methods apply in a restaurant context, see Food Inventory Tracking Software for UK Restaurants.

Conclusion

The evaluation lens is straightforward. Start with the simplest system that works for your current operation, and know the triggers that signal it has stopped working. Then choose a system that keeps stock and margins live without depending on manual entry. A spreadsheet is a legitimate starting point for a single-site operator with a stable menu and disciplined weekly counts. It stops being sufficient the moment supplier prices change faster than the sheet is updated, a second site opens, or the one person who maintains it leaves.

Jelly is the best simple inventory tracking system for growing UK restaurants and pubs because it turns scanned supplier invoices into live stock and dish-level margins, onboards in the first week, and costs a flat £129/month per location. If your food cost percentage is drifting and you cannot explain why, that is the clearest signal that it is time to move.

Book a walkthrough

Frequently Asked Questions

Here are the questions UK operators ask most often when weighing up a simple tracking system.

Is There a Free App to Keep Track of Inventory?

Several free options exist for basic tracking. Sortly’s free tier covers 100 items and one user. Zoho Inventory has a free plan with limits on orders, users and locations. Skyware Inventory is free for a single user. Google Sheets is free to use with a personal Google Account, though organisations typically need a paid Google Workspace plan. All of these free options depend on manual data entry and none of them do invoice-driven dish costing or link ingredient costs to live gross profit margins. Free tiers work for a pre-growth single site, and they become a liability once supplier price changes, staff turnover or a second location enter the picture.

What Is the Best Inventory Tracker for a Small Business in the UK?

Jelly is the strongest fit for growing UK hospitality businesses for the reasons set out above, with invoice-driven stock and margins, live within the first week, at a flat per-location price. For a pre-growth single site with a short, stable menu, a spreadsheet or a free app tier is a workable starting point. Once supplier price volatility, staff turnover or multi-site complexity arrives, the manual approach costs more in lost margin and admin time than Jelly does.

What Are the Downsides of Zoho Inventory?

Zoho Inventory’s free plan caps the number of orders, users and locations, which limits its usefulness for anything beyond a very small operation. Pricing complexity increases as you add modules and users, which makes the total monthly cost harder to predict than a flat-rate platform. There is also meaningful setup effort required before Zoho Inventory earns its keep. Integrating it with a UK POS system, configuring VAT rates correctly and building out a product catalogue all take time that a busy kitchen team rarely has.

How Much Does a Simple Inventory Tracking System Cost?

Costs range from £0 for Google Sheets or free app tiers, through £40–£139 per month for bar and stock-counting apps such as 365 Pub Stocktaking, Lixor and Growyze, up to £129 per location per month for Jelly’s invoice-driven platform. Sage Accounting Plus, which includes a basic stock module, is £59/month ex VAT. Sortly’s paid tiers start at $49/month and rise steeply as item counts and user seats grow. UK prices for most inventory management software platforms are quoted excluding VAT unless stated otherwise, though some UK resellers display prices both including and excluding VAT.

Do I Need Barcode Scanning?

Barcode scanning is optional for very small operations and becomes valuable as complexity grows. For a small, stable SKU count managed by one or two people, manual entry into a spreadsheet or simple app is workable. Barcode scanning becomes worthwhile when item volume grows, multiple sites or staff members are involved, or when manual entry errors are causing stock discrepancies that take time to investigate. At that point, the accuracy gain from scanning, the one noted earlier, justifies the additional setup. Invoice-driven tracking, as Jelly provides, reduces the need for frequent manual counts by keeping stock updated automatically from supplier invoices and POS sales data.