Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Xero can track basic inventory and post COGS but cannot handle recipe costing, ingredient-level tracking, or real-time margin analysis essential for café profitability.
- Most independent cafés operate on tight 3–5% net profit margins, which makes accurate, timely inventory data critical under Making Tax Digital requirements from April 2026.
- Common workarounds like spreadsheets for recipe costing are time-consuming, error-prone, and quickly become outdated when supplier prices change.
- Jelly automates invoice scanning, updates ingredient costs in real-time, and pushes clean data to Xero, reducing bookkeeping time by 90% while delivering live dish costing in just 3 minutes per menu item.
- UK cafés using Jelly save 10–20 hours monthly and add 2 percentage points to gross margins.
Why Café Inventory Management Demands More Than Xero
Picture a UK café owner reviewing their monthly P&L. Food costs have crept up by three percentage points, and the report offers no explanation. A supplier price hike on milk, untracked wastage at the espresso bar, or over-portioning on pastries could all be responsible. By the time the accountant’s report arrives, the damage is done and the window to react has closed.
This is the operational reality for most independent cafés. Most restaurants operate on net profit margins of just 3–5%, which leaves almost no room for error. Under Making Tax Digital, self-employed businesses earning over £50,000 must keep digital COGS records and submit quarterly updates from April 2026. The pressure to maintain accurate, timely financial data has never been greater, yet many cafés still reconcile invoices in spreadsheets.
If spreadsheet chaos slows you down, you can book a demo and see how Jelly can automate your café inventory today.
Can Xero Be Used for Inventory Management?
Xero can track basic inventory, but it has significant limitations for cafés. Knowing what Xero does well, and where it stops, helps you design a realistic inventory workflow.
Xero’s native inventory handles the following reliably:
- Tracking finished goods and simple stock items such as bags of retail coffee or packaged merchandise
- Automatically posting COGS when tracked items are sold, which keeps the P&L aligned without manual journal entries
- Providing basic inventory valuation using the average cost method (AVCO), which is accepted under UK GAAP (FRS 102) and by HMRC
Xero falls short for cafés in several key areas:
- No recipe costing — Xero cannot break a latte down into espresso, milk, and syrup components.
- No real-time ingredient tracking — stock levels only update when invoices are raised in Xero, not when ingredients are consumed.
- No supplier price alerts — a milk price increase goes unnoticed until someone reviews the invoice manually.
- No wastage tracking — spillage, spoilage, and over-pouring go entirely unrecorded.
- Single-location only — Xero holds a single stock pool with no multi-location visibility, and Xero Inventory Plus, which adds basic multi-location features, is available in the US only as of mid-2026.
- No batch or expiry tracking — Xero has no native lot, batch, serial, or expiry-date fields in any tier, which creates a critical gap for perishable ingredients.
- No bill of materials — Xero has no assembly, kitting, or manufacturing workflow, so recipe-based ingredient depletion requires an external tool.
Xero’s own restaurant accounting guide frames Xero as accounting software that usually needs third-party inventory tools when operational depth is required. For cafés, that operational depth is essential.
How to Set Up Tracked Inventory in Xero for Your Café
The steps below configure Xero’s native tracked inventory using café-specific examples. This setup works for retail items but cannot handle recipe-based depletion, which the next section addresses.
- Create inventory categories — Navigate to Settings → Chart of Accounts and set up categories such as Coffee, Milk, Pastries, and Packaging. This structure keeps stock organised and simplifies reporting.
- Enable tracked items — Go to Business → Products and Services, click “New Item,” and tick the “I track this item” box. Enter the item name (for example, “Espresso Beans – House Blend”) and link it to your COGS account and Inventory Asset account. Xero’s official tracked inventory learning path covers this setup in detail.
- Set up units of measure — Define how you purchase each item. Coffee beans may be purchased in 5kg bags. Xero tracks at the unit level you define, so choose the purchase unit as your tracked unit.
- Configure COGS accounts — Ensure each tracked item links to the correct COGS account. Xero automatically posts COGS when a tracked item is sold, using the average cost method.
- Enter opening stock balances — Record current stock quantities and values to establish accurate starting points.
- Run regular stocktakes — Xero’s Inventory Item Summary report shows stock levels and values, and physical counts verify accuracy. Xero recommends conducting stocktakes monthly or quarterly to catch discrepancies early.
When a customer orders a latte, Xero cannot automatically deduct 18.5g of espresso, 200ml of milk, and 15ml of syrup from your inventory. That ingredient-level depletion requires a dedicated café inventory tool.
How to Track Recipe Costs in Xero
Xero cannot cost recipes or track ingredient-level margins. Many cafés rely on spreadsheet formulas that multiply ingredient costs by recipe quantities, and this workaround carries serious operational risks.
In many independent coffee shops, prime beverage costs quietly fluctuate between 18% and 35% without explanation, with the root cause typically being invisible, unmetered waste at the espresso bar rather than wholesale price spikes. Costing a single dish in a spreadsheet takes approximately 28 minutes of manual work. Spreadsheets become outdated the moment a supplier changes prices, and errors compound across dozens of menu items with no real-time visibility into margin erosion.
Jelly transforms this workflow. Jelly automatically scans supplier invoices, digitises every line item, and updates ingredient costs in real-time. Recipe costs recalculate instantly, which shows exactly which dishes are profitable and which are quietly losing money. Jelly cuts that earlier 28-minute costing time to just 3 minutes per dish.
Best Xero Inventory Apps for Cafés
Several third-party tools integrate with Xero to provide the operational depth that cafés require. The table below compares three relevant options for UK café operators.
| Feature | MarketMan | Nory | Jelly |
|---|---|---|---|
| Setup time | Varies (24–48 hours to 2–4 weeks typical) | 4–12 weeks | Under 1 week |
| Invoice scanning | Yes | Yes | Yes (photo or email) |
| Recipe costing | Yes | Yes | Yes (3 minutes per dish) |
| Xero integration | Yes | Yes | Yes (one-click push) |
| Pricing | Custom quotes | Custom quotes | £129/month per location |
MarketMan is a comprehensive inventory platform used by larger restaurant groups. It offers recipe costing and supplier management but requires significant setup time and investment. This makes it better suited to multi-site operations with dedicated back-office teams. MarketMan’s setup time varies: the vendor states most restaurants are fully onboarded within 24–48 hours, while other sources quote 2–4 weeks for single-location implementations, though some users report 6–12 weeks in practice.
Nory is an AI-powered operations platform that includes inventory management alongside labour scheduling and sales forecasting. It is powerful but complex. Onboarding can take months, and the feature set may overwhelm single-site cafés.
Jelly is built specifically for growing restaurants, pubs, and boutique hotels, along with bars and catering operations. It automates invoice scanning via email or photo, provides real-time dish costing, and integrates directly with Xero. Setup takes under a week, and the flat £129/month pricing includes all features with no per-user fees. As one operations director put it: “All the tools on the market require so much manual work. Jelly is so simple to use, I can’t see myself running the business without it.”
Schedule a chat with the Jelly team and see how it fits your café’s workflow.
How to Automate Café Inventory with Jelly
Jelly replaces the manual invoice-to-spreadsheet workflow with a four-step automated process.
- Scan invoices — Forward supplier invoices to Jelly’s dedicated email address or photograph them with your phone. Jelly automatically digitises every line item, including quantity, SKU, price, and VAT.
- Update ingredient costs — As invoices are processed, ingredient costs update in real-time. Jelly’s Price Alert feature flags every price increase or decrease and provides concrete evidence for supplier negotiations.
- Sync with Xero — Jelly pushes digitised invoices directly to Xero with one click, which reduces bookkeeping time by 90%. Your accountant receives clean, accurate data without manual data entry.
- Monitor margins in real-time — With POS integration, Jelly calculates gross profit margins daily. You see exactly which dishes are profitable and which need price adjustments.
Amber, a Mediterranean restaurant in East London, saves £3,000–£4,000 per month using Jelly—a 68× return on investment. Chef-Owner Murat Kilic previously relied on tedious manual costing with spreadsheets. Now, Jelly’s automated invoice processing and real-time costing keep his margins protected. “Jelly keeps my business alive,” he says.
As mentioned in the takeaways, Jelly users save significant admin time and typically see a clear uplift in gross margins within the first three months.
Weekly Stocktake and Wastage Workflow
Most independent cafés run inventory via a shared Google Sheet, a clipboard in the dry store, or pure memory, and all three fail when the shop gets busy, resulting in a quiet 4–7% of revenue lost monthly to spoilage, stockouts, and over-ordering. A structured weekly rhythm prevents this. Start with a focused stocktake, then capture wastage as it happens, and finally review patterns so you can adjust ordering and prep.
- Conduct weekly stocktakes — Count your top 20 SKUs at Sunday close. With Jelly, this takes 15–20 minutes. Some users report 2–3 hours for manual stocktakes.
- Log wastage in real-time — Then record spillage, spoilage, and over-pouring as they happen so you can see where losses occur. In a busy café processing 300 milk-based drinks daily, pouring just two excess ounces of milk per drink wastes over 4.5 gallons every day, draining more than $6,500 in pure profit over a single year.
- Apply the 80/20 rule — Next, focus on your highest-value items: espresso beans, milk, syrups, and pastries. These top 20 SKUs drive most of the stock control benefit.
- Set par levels — Use your usage data to calculate average weekly usage × delivery frequency × 1.2 safety buffer. Reorder when stock falls below par so you avoid both stockouts and over-stocking.
- Review waste-by-cause weekly — Finally, review wastage by cause and adjust next week’s prep by up to 15% based on waste patterns. This closes the loop between counting, logging, and improving.
How to Use Xero Reports for Margin Analysis
Once your stocktakes and wastage logs are in place, the next step is turning that data into actionable margin insights. Xero and Jelly serve distinct but complementary roles in this analysis. Xero’s UK COGS guidance recommends tracking COGS at least monthly, with weekly tracking for high-volume stock to provide more timely profitability insights. In practice, Xero’s Profit & Loss report shows overall COGS and gross profit, but only after inventory adjustments have been entered manually.
Jelly’s Flash Report provides daily, weekly, or monthly gross profit margins calculated from actual ingredient costs drawn from invoices and sales data from POS integration. The Sales Mix report shows which dishes are most popular and most profitable, which enables data-driven menu decisions. Sushi Revolution uses Jelly to set separate target gross profits on dine-in and delivery menus, accounting for 30% delivery commissions, resulting in actual gross profits 2–3% higher on average.
Your accountant stays in Xero, and your kitchen team works in Jelly. Both systems receive accurate, timely data without duplication.
Common Mistakes and the 80/20 Rule
Several recurring mistakes undermine café margins, and the 80/20 rule helps you focus on the fixes that matter most.
- Inconsistent data entry — Manual processes break down when the café gets busy, and gaps appear in your records. Automation removes this weak point and keeps data consistent.
- Ignoring supplier price changes — A sudden spike in food cost percentage often points to waste, theft, or pricing issues with a supplier. Jelly’s Price Alert catches these changes the same week they happen, which prevents slow, hidden margin erosion.
- Not tracking recipe costs — Without accurate recipe costing, pricing decisions rely on guesswork. A dish that worked last month may quietly lose money today if ingredient prices rise.
- Over-stocking perishables — Buying in bulk only saves money when everything is used before it spoils. Xero’s UK COGS guidance recommends reviewing inventory management to avoid overstocking. Applying the 80/20 rule keeps focus on high-turnover items, which reduces waste where it matters most.
FAQ
Can Xero track ingredients?
Xero’s native inventory tracks finished goods and simple stock items but cannot break down recipes into individual ingredients. When a latte is sold, Xero has no mechanism to automatically deduct espresso, milk, and syrup from separate stock accounts. For ingredient-level tracking, a dedicated café inventory tool like Jelly is required. Jelly integrates directly with Xero, so the accounting records remain accurate while the kitchen team works with live ingredient data.
How much does Jelly cost?
Jelly charges a flat rate of £129 per month per location. This price includes all features, such as automated invoice scanning, recipe costing, price alerts, Xero integration, and POS connectivity, with no per-user or per-feature fees. There are no custom quotes or variable charges based on the number of invoices processed or dishes costed.
How long does Jelly take to set up?
Most cafés are operational within a week. Once suppliers begin sending invoices to a dedicated Jelly email address, price alerts and spending insights become available immediately. Alternatively, invoices can be photographed directly into Jelly within 24 hours of setup. POS integration takes approximately five minutes and follows the same flow across all supported systems: open Jelly, click Integrations, sign in to the POS, grant permissions, and select which categories to sync.
What is the 80/20 rule in café inventory?
The 80/20 rule, also known as the Pareto Principle, suggests that roughly 80% of your portfolio’s value often comes from about 20% of your holdings, though the exact ratio can vary. For cafés, this means directing inventory management effort toward high-value, high-turnover items such as espresso beans, milk, premium syrups, and pastries rather than attempting to track every SKU with equal rigour. Focusing weekly stocktakes and par-level reviews on these top items delivers most of the accuracy benefit with a fraction of the time investment.
Does Jelly comply with Making Tax Digital requirements?
Jelly integrates directly with Xero, which handles MTD for VAT and MTD for Income Tax submissions. When Jelly pushes digitised invoices to Xero with correct VAT treatment applied at the line-item level, Xero holds the compliant digital records required under MTD. This setup means café owners using Jelly alongside Xero maintain the digital audit trail that HMRC requires, without any additional manual record-keeping.
Move Beyond Spreadsheets
Xero handles café accounting with precision, but it lacks the operational depth a working kitchen needs. Spreadsheets fill the gap temporarily, yet they cost hours of admin time every week and hide margin erosion until it is too late to act. Jelly bridges this gap by automating invoice processing, providing real-time recipe costing, and syncing seamlessly with Xero.
Cafés using Jelly save meaningful admin time, improve gross margins, and gain the visibility needed to negotiate confidently with suppliers. As one café owner put it: “Our accountant said we’d be lucky to hit 60% gross profit. After using Jelly, we reached 80%!”