Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Free restaurant inventory tools suit single-site operations with under 150 SKUs and no need for live recipe costing or invoice-level tracking.
- Most free platforms keep essentials such as forecasting, VAT handling and supplier invoice integration behind paid upgrades.
- Spreadsheets become unsustainable once prices change frequently, multiple staff need access, or the menu grows beyond basic complexity.
- Recipe costing is the critical gap in every free option; without it, operators cannot see real-time dish margins or react to supplier price changes.
- When spreadsheets exceed two hours of weekly maintenance, see how automated invoice scanning works and move to live GP reporting.
The Problem: What “Free” Actually Means In Restaurant Inventory Software
Free covers four distinct models in this category, and most search results mix them together. The first is a freemium tier: a permanently free plan with hard feature or volume limits, such as Loyverse’s free POS or Zoho Inventory’s 50-order cap. The second is a time-limited trial: a full-featured product available for 7–14 days before a subscription is required. The third is open-source software: free to download but requiring self-hosting, technical setup and ongoing maintenance. The fourth is spreadsheets and templates: genuinely free tools that require the operator to build and maintain the system themselves.
The core confusion most operators arrive with is simple. Tools that advertise themselves as free inventory software frequently gate the inventory features such as recipe costing, purchase order tracking and multi-location stock control behind a paid tier. The free plan handles the POS or basic item list. The moment a UK operator needs invoice-level price tracking or live dish margins, the free tier stops being relevant. That is simply what “free” means in this category.
Genuinely Free Tools UK Operators Actually Use
The most commonly recommended free options for UK restaurant inventory all share the same pattern. Each covers basic stock tracking or POS, then stops short of invoice-level costing, UK VAT handling and accounting integration.
- Loyverse offers free POS and basic stock tracking. Advanced inventory features such as forecasting, alerts and variant tracking cost £25/month per store. It provides no recipe costing at any tier, no UK VAT-rate handling per line item and no Xero integration.
- Google Sheets / Excel are fully free, and the operator builds and maintains the system. They suit a single site with under 100 SKUs and one person maintaining the file. There is no live price tracking, the maintenance burden becomes significant as the operation grows, and spreadsheets alone do not satisfy MTD digital records requirements.
- Floreant POS is open source and free to download and self-host. It suits operators with technical resource to self-host. It offers no cloud sync, no UK VAT configuration out of the box, no Xero integration and requires ongoing technical maintenance.
- Sortly provides a free tier with basic item tracking and limited entries. It works for tracking physical stock counts by location. It is not built for hospitality, has no recipe costing, no supplier invoice integration and no UK VAT handling.
- Zoho Inventory offers 50 orders/month with limited warehouse and user allowances. It suits very small operations under 50 purchase orders per month. It has no recipe costing at any tier, serial and batch tracking only unlocks on paid plans, and it is not designed for hospitality VAT complexity.
A note on VAT: a single UK restaurant till receipt can mix standard-rated (20%) and zero-rated (0%) supplies on the same transaction. None of the free tools above handle this at the line-item level. For a UK operator running a mixed food and drink operation, that gap affects GP reporting accuracy and, for VAT-registered businesses, MTD for VAT requires digital records that capture the VAT treatment of each individual transaction. For each supply made, a business must record the time of supply, the net value excluding VAT and the rate of VAT charged. Certain schemes, such as the Flat Rate Scheme and margin schemes, have different or reduced record-keeping requirements.
The Excel And Google Sheets Reality Check
The VAT gap is one reason operators turn to spreadsheets instead. Free Excel templates for tracking restaurant inventory exist in large numbers, and you can download them easily. A search for “restaurant inventory management Excel free download” returns dozens. They work as a starting point. They do not work as a long-term system.
The operational failure modes are specific, and they compound each other. Version drift is the first problem. The moment two people edit the same file, or someone saves a local copy, the master sheet stops being the master. That problem feeds directly into the second issue, which is lack of invoice-level price tracking. Hardcoding prices in recipe sheets instead of linking to a live ingredient database means updating every recipe manually when prices change. With 40 recipes and shared ingredients, that becomes hundreds of cells.
Manual unit conversions add another layer of fragility. A chicken breast invoiced per kilogram but used in a recipe per portion requires a conversion that must be correct in every formula. The spreadsheet then shows what a dish cost when you built it, not what it costs today. Because the whole system depends on one person maintaining it, the maintenance burden becomes significant as the operation grows.
Small businesses typically keep track of inventory through a combination of weekly manual counts, paper delivery notes and a master spreadsheet updated by one person. For a busy pub, the physical weekly stock count takes 45 minutes to an hour, with another 45 minutes spent entering data and reconciling it. That happens before any investigation of anomalies. This approach holds up at low SKU counts with a disciplined operator. It breaks as supplier count grows, as the menu expands, and as soon as a second person needs to use the same data.
Find out what your spreadsheet time is really costing you.
Recipe Costing And Food-Cost Calculation In Free Tools
Spreadsheet maintenance is one symptom of a deeper problem. Recipe costing is the single biggest gap in every free option, and it is the point at which most UK operators hit a wall. Free tools rarely handle recipe costing, batch recipes, wastage percentages or unit conversions in any meaningful way. The reason is structural. Recipe-level costing requires exact ingredient quantities, current purchase prices from the latest supplier invoice, and automatic recalculation of plate cost and food cost percentage every time a price changes. A static template cannot do this. A free POS tier does not do this.
The practical consequence is straightforward. Stale prices are the number-one source of inaccurate food cost data and create false confidence. A dish that was profitable last week can be losing money today because a supplier quietly increased the price of one ingredient. Without invoice-level price tracking connected to live recipe costs, nobody in the kitchen knows until the monthly P&L arrives. By then, the margin is already gone.
Most restaurants target a food cost percentage of 28–35%. Free tools give operators no reliable mechanism to know whether they are inside or outside that range on any given week.
When Free Stops Working And The Threshold For Change
The recipe costing gap is one of the clearest signals that a free tool has stopped being enough. Free restaurant inventory management software is a reasonable answer below a clear threshold. Above it, it becomes a false economy. The threshold is qualitative and has consistent markers.
Free tools remain adequate when:
- The operation is single-site.
- The menu runs under roughly 100–150 SKUs.
- One person owns and maintains the inventory data.
- There is no requirement for live recipe costing.
- The operator is comfortable knowing food cost only at month-end.
Free tools become a false economy when:
- Supplier price changes need tracking at the line-item level.
- Recipe costs need to update automatically when a delivery arrives at a different price.
- The operation has more than one site.
- More than one person needs to access or update inventory data.
- The operator needs to know GP margin by dish in real time rather than by spreadsheet at month-end.
Software becomes the more practical choice over manual methods when an operator runs more than one location, has a menu with more than 60–70 items with separate recipe components, spends more than two hours per week on inventory administration, or needs real-time food cost data rather than end-of-month reports.
The admin hours, stock inaccuracy and margin leakage above that threshold cost more than the software would. The UK National Living Wage is £12.71 from April 2026. Every hour spent manually reconciling invoices and updating spreadsheet formulas is a real cost, whether the operator pays someone else to do it or does it themselves.
The Solution: What To Look For When You Upgrade With Jelly
For UK restaurant, pub and boutique hotel operators who have crossed the threshold described above, Jelly is the natural next step from free tools. It is built specifically for growing single-site and multi-site operations doing £500k+ in annual revenue. That profile has outgrown a spreadsheet but does not need an enterprise ERP.
The foundation is automated invoice scanning, which directly addresses the invoice-level price tracking gap described earlier. Every supplier invoice, captured by photo or forwarded by email, is digitised at the line-item level: quantity, SKU, price and tax. That data flows directly into live dish costing, so every recipe’s GP margin updates the moment a new delivery price is recorded. The Price Alert feature flags every supplier price increase or decrease and gives operators the hard data to challenge suppliers and claim credit notes. Amber’s chef-owner Murat Kilic reports savings of £3,000–£4,000 per month from invoice automation, Price Alert and real-time costing combined.
The Flash report gives a daily, weekly or monthly view of gross profit margin calculated from actual invoice costs and POS sales. The Sales Mix report shows which dishes are most popular and which are most profitable, so teams can engineer menus based on real numbers. All digitised invoices push to Xero in one click and satisfy MTD digital record requirements without manual re-entry.
Jelly integrates natively with Square, EPOS Now, Lightspeed and Toast via real-time API, and connecting any supported POS takes approximately five minutes. Once connected, the platform states it saves 10–20 hours of admin per month. It also claims to cut food costs by 3% on average in the first three months and add 2 percentage points to gross margins. The Howard Arms reached 80% gross profit after implementation, while Populu lifted GP from 68% to 72% across 16 locations.
Pricing is a flat £129/month per location. There are no per-user charges or variable fees. Onboarding generates initial value in the first week.
See how quickly invoice automation pays for itself.
Frequently Asked Questions
Is There A Free Excel Template For Tracking Restaurant Inventory?
Yes. Numerous free Excel and Google Sheets templates exist for restaurant inventory tracking, covering item lists, stock counts, delivery logs and basic cost calculations. They are a legitimate starting point for a single-site operator with a small menu and one person maintaining the file. They do not form a complete system, because prices do not update automatically, recipe costs do not recalculate when a supplier invoice arrives, and accuracy degrades as SKU count and team size grow.
Can I Download Free Inventory Software In Excel?
You can download free Excel-based inventory templates, but Excel itself is a spreadsheet rather than inventory software. It requires the operator to build and maintain the logic. True inventory software connects to supplier invoices, updates ingredient costs in real time, calculates live recipe margins and integrates with a POS system. None of that is available in a downloaded Excel file, regardless of how well the template is constructed.
How Do I Create An Inventory Management System In Excel?
A functional Excel inventory system for a restaurant requires a master ingredient list with current prices, recipe sheets that reference that list using linked formulas, a stock count sheet updated after each delivery, and a variance calculation comparing theoretical usage against physical counts. The critical discipline is updating ingredient prices every time a supplier invoice arrives. As noted earlier, hardcoded prices go stale the moment a supplier changes their rates. As the recipe list and SKU count grow, the maintenance time required each week rises accordingly, and many operators find the manual approach becomes difficult to sustain.
How Do Small Businesses Keep Track Of Inventory?
Most small hospitality businesses use a combination of weekly manual stock counts, paper or emailed delivery notes and a master spreadsheet maintained by one person, typically the head chef or owner. This approach works at low SKU counts with consistent discipline. It breaks when supplier count grows, when more than one person needs to update the data, or when the business needs to know food cost in real time rather than at month-end. At that point, the manual process produces data that is too slow and too inaccurate to act on.
What Are The Four Main Types Of Inventory Systems For Restaurants?
In a restaurant context, the four approaches are periodic manual counting, perpetual tracking, theoretical inventory and hybrid systems. Periodic counting means physical stocktake at set intervals, typically weekly or monthly. Perpetual tracking updates stock levels continuously as deliveries arrive and ingredients are used, usually via software. Theoretical inventory is calculated from recipes and POS sales data and shows what stock should be present. Hybrid systems combine physical counts with theoretical usage to calculate variance and identify loss. Free tools support periodic counting at best. Live recipe costing and variance analysis require a perpetual or hybrid system connected to both supplier invoices and POS sales data.
Conclusion
Free restaurant inventory management software is a real answer for operators below a clear threshold such as single-site, limited SKUs and no live recipe costing requirement. Above that threshold, the admin hours and margin leakage cost more than any paid platform. For UK restaurants, pubs and boutique hotels that need invoice-driven inventory, live dish GP margins and automated Xero integration, Jelly is the logical next step with the flat-rate pricing described above and integrations with Square, EPOS Now, Lightspeed and Toast already built. As shown above, the time and cost savings quickly outweigh the subscription.
Calculate what your current free tool is costing you.