Connect Your Café POS to Automatic Inventory Tracking

Connect Your Café POS to Automatic Inventory Tracking

Written by: JJ Tan, Founder, Jelly

Key Takeaways for Busy Café Teams

  • Automatic ingredient deduction links every POS sale to real-time recipe-based stock reduction, which removes manual entry and delivers live gross-profit visibility.
  • Connecting your POS (Square, Lightspeed, EPOS Now, or Toast) takes roughly five minutes, and Jelly then surfaces only newly sold items for clean, focused recipe mapping.
  • Accurate recipe mapping, covering every drink variant and modifier, keeps theoretical usage close to actual consumption and exposes waste, portion drift, and margin leaks within days rather than quarters.
  • Daily Flash Reports and waste-logging tools highlight variances early, typically saving 2–5 admin hours per week and improving gross margin by around two percentage points within three months.
  • Ready to automate your café’s inventory tracking? See Jelly in a live walkthrough and have your POS connected and first recipes mapped in a single session.

Before You Begin: What to Gather for a Smooth Setup

The process owner is typically the café owner or head chef. Before connecting your POS, gather the following:

  • Recent supplier invoices (digital or photographed) covering your core ingredients
  • Written recipes with exact quantities for your top-selling items, such as lattes, cappuccinos, syrups, and baked goods
  • Admin-level access to your POS account
  • A completed opening physical stock count to establish a clean baseline

This preparation protects thousands of pounds in margin each year. For a typical UK independent café with £40k–£80k annual COGS, a 3% stock variance equates to £1,200–£2,400 in lost margin per year, and a 5% variance equates to £2,000–£4,000. Connecting your POS to ingredient-level tracking closes that gap by making waste and portioning drift visible the same week they occur, rather than at a quarterly stocktake. The first step in that process is establishing the POS connection itself.

Step 1: Connect Your POS in Five Minutes

Jelly integrates natively with Square, Lightspeed, EPOS Now, and Toast through real-time API connections. Each integration delivers item-level sales data the moment a transaction completes. The setup sequence is identical across all four systems:

  1. Open Jelly and navigate to Integrations
  2. Select your POS provider (Square, Lightspeed, EPOS Now, or Toast)
  3. Sign in to your POS account when prompted
  4. Grant the required data permissions
  5. Select which POS categories to sync, typically Food and Beverages

The only common friction point is lacking admin access to your POS account, and Jelly flags this requirement upfront so you can resolve it before starting. Once you have cleared that hurdle, the connection completes in approximately five minutes. After the integration goes live, Jelly surfaces only menu items sold from that point forward, which keeps your mapping list clean and free of legacy menu clutter. Jelly’s flat monthly fee is £129 per location, with no per-user charges and no hidden feature tiers.

Step 2: Map Recipes to POS Items for Automatic Deductions

Recipe mapping activates automatic ingredient deduction and underpins accurate food cost comparisons. Correct item-level mapping of every POS menu item to its corresponding recipe is the foundational step for comparing theoretical food cost against actual food cost. In Jelly’s Kitchen section, the process works as follows:

  1. Open the Cookbook and create a new dish
  2. Click to add ingredients, which are already populated from your scanned invoices
  3. Enter the exact quantity used per serving, for example 18g beans, 200ml milk, 10ml vanilla syrup
  4. Apply a yield percentage where relevant, such as milk steaming loss
  5. Link the completed recipe to the corresponding POS item name
  6. Repeat for each menu variant, including alt-milk options, decaf, and takeaway versions

Cafés should map each menu variant, including eat-in versus takeaway versions of the same drink, to a single recipe so that sales deplete the same stock quantities regardless of which POS product code is used. The table below shows how recipe mapping translates into live gross profit visibility for two common café items.

Menu Item Key Ingredients & Quantities Estimated Unit Cost Live GP %
Flat White (£3.50) 18g beans, 160ml whole milk, 10ml syrup ~£0.65 ~81%
Blueberry Muffin (£2.80) 60g flour, 30g blueberries, 20g butter, 15g sugar, 1 egg ~£0.55 ~80%

Ingredient costs in Jelly update automatically with every new invoice scan. Before using Jelly, Chef Murat Kilic of Amber relied on manual spreadsheet costing; after switching, Jelly’s real-time costing and price change alerts enabled faster reactions to ingredient price swings and consistent monthly savings of £3,000–£4,000.

Step 3: Track Variance and Log Waste for Café Drinks

Once recipes are mapped, Jelly calculates theoretical usage automatically by multiplying POS sales by recipe quantities. Theoretical usage for flat whites, for example, is calculated as units sold multiplied by 18g beans per serve; actual usage is opening stock plus purchases minus closing stock; variance equals actual minus theoretical.

Accurate variance data depends on logging waste at the point it occurs. The recommended fields for each waste entry are:

  • Ingredient, for example whole milk, oat milk, or house blend beans
  • Quantity and unit, for example 400ml or 15g
  • Reason code, such as burnt shot, end-of-day milk dump, dropped pastry, or staff drink
  • Date and time

In UK cafés, unlogged waste and write-offs typically account for 25–35% of total stocktake variance, so waste logging becomes the single highest-impact operational habit to establish. Recipe drift of just 2g on a flat white, from an 18g recipe to 20g actual, at £30/kg beans and 60,000 drinks per year costs roughly £350 in lost margin on that drink alone. Jelly’s Flash Report surfaces theoretical versus actual gaps daily, weekly, or monthly so you can act before the variance compounds.

How POS Systems and Jelly Work Together on Inventory

POS systems record every sale at item level, but ingredient-level stock deduction requires a connected inventory layer that holds your recipes. On their own, Square, Lightspeed, EPOS Now, and Toast record what was sold, not what was consumed from your ingredient store. Jelly sits alongside your POS and uses its real-time sales feed to drive automatic ingredient deductions based on your mapped recipes.

The result is live stock levels, live GP percentages, and variance alerts, all without a separate manual process. Accurate ingredient-level tracking depends on correct recipe setup, portion control, delivery records, waste reporting, and regular physical stocktakes. Jelly automates the calculation layer so your team only needs to handle the physical count.

The Right App for Monitoring Café Stock

For UK cafés turning over £500k or more, the right tool connects to your existing POS in minutes, updates ingredient costs from scanned invoices automatically, and delivers live GP percentages without requiring a dedicated back-office team. Jelly is built precisely for this profile.

At £129 per location per month, with a flat fee and no per-user charges, Jelly automates the full flow from supplier invoice to dish cost to margin report. Operators using Jelly report gross profit improvements of 2 percentage points on average, and monthly stocktakes that now take significantly less time. Other inventory solutions offer broader feature sets at greater complexity and cost, and many legacy platforms are built for large chains with dedicated office teams. Jelly is designed for growing independent and multi-site operators who need results in the first week, not after months of onboarding.

Find out if Jelly fits your café’s workflow and see how it handles your current menu and suppliers.

Troubleshooting Common Café Issues

The three most frequent issues UK café operators encounter after connecting their POS are missing recipe mappings, refund handling, and fluctuating milk prices.

Missing mappings: If a POS item has no linked recipe, Jelly will not deduct any ingredients for that sale. Run a weekly check of unmapped items, which appear clearly in the Jelly interface. Modifier mapping errors are common when recipes do not switch ingredients for alt milks, decaf, syrups, or gluten-free options; in busy cafés, modifiers can represent 20–40% of transactions and produce incorrect theoretical usage deductions. Map every modifier variant to its correct recipe.

Refund handling: Jelly processes discount and refund calculations at the individual line level, which keeps margin data accurate regardless of transaction complexity. No manual adjustment is needed when a drink is returned or remade.

Fluctuating milk prices: Whole milk, oat milk, and almond milk prices shift frequently. Jelly’s Price Alert feature flags every invoice line where a price has changed, giving you the data to renegotiate with your dairy supplier or adjust menu pricing before the margin impact accumulates. Jelly’s price change alerts provide concrete evidence for supplier negotiations, enabling credit notes and better buying terms.

Measure Success with Five Clear Café Metrics

Within the first three months of connecting your POS to Jelly, track these five metrics to quantify the operational and financial impact. Together, they measure both the time you save and the margin you protect:

  • Admin time saved: Connecting a POS automates 2–5 hours of weekly work that previously went into obtaining real-time margins and sales mix data.
  • GP improvement: Jelly customers see gross margin improvements of 2 percentage points on average in the first three months, and one operator improved GP from 65% to 72% within 12 weeks on approximately £500,000 in revenue.
  • Food cost reduction: Cloud-based inventory tools integrated with EPOS systems can reduce food waste by 20–30% for hospitality operators once variance tracking becomes routine.
  • Price alert response time: Ingredient price changes are flagged within the same week, rather than discovered at month-end accounts.
  • Stocktake duration: Weekly 30-minute counts on your top 20 ingredients replace quarterly 4-hour exercises and deliver 7-day-old variance data instead of 3-month-old data.

Scaling to a Second Site and Linking to Accounting Software

Adding a second site means one additional flat fee, with all recipes, supplier data, and price alerts carrying across locations to give you a consolidated view. Recipes, supplier data, and price alerts carry across sites, giving you a clear picture of GP and variance by location.

For accounting integration, Jelly connects directly with Xero, and digitised invoices push through in one click, which reduces bookkeeping time by 90%. Sage integration is in development. Manual spreadsheets fail at scale for multi-location operators because they are prone to data-entry errors with 100+ ingredients, lack real-time updates, and cannot provide automatic alerts or reliable variance tracking. A single connected system removes that risk as you grow.

Conclusion and Next Steps for Your Café

Connecting your café POS to automatic ingredient-level inventory tracking eliminates manual stock reconciliation, delivers live GP percentages on every latte and muffin, and flags ingredient price changes before they erode your margins. The workflow is straightforward: connect your POS, map your recipes in Jelly’s Kitchen section, log waste at the point it occurs, and review your Flash Report and variance data weekly.

The admin savings, margin improvements, and supplier negotiation leverage follow directly from that discipline. Jelly is built for UK café operators at the £500k+ revenue stage who need operational clarity without complexity, at a flat £129 per month per site.

Get your first recipe mapped in a live Jelly session and start tracking your margins this week.

Frequently Asked Questions

How long does it take to set up café inventory tracking with Jelly?

Connecting your POS to Jelly takes approximately five minutes. The setup follows the same flow regardless of whether you use Square, Lightspeed, EPOS Now, or Toast: open Jelly, click Integrations, sign in to your POS, grant permissions, and select which categories to sync.

The only prerequisite is admin-level access to your POS account. Once connected, Jelly surfaces only items sold since the integration went live, so your recipe mapping list stays clean. Most café owners complete their first recipe mappings for their top five to ten items within the same session, and price alerts from scanned invoices are live within 24 hours of uploading the first invoice.

What happens to my stock data when an ingredient price changes?

Every time a supplier invoice is scanned into Jelly, whether by photo or forwarded email, Jelly reads every line item and updates the cost of any ingredient that has changed. Because your recipes are linked to those live ingredient costs, the gross profit percentage for every affected dish updates automatically.

Jelly’s Price Alert feature flags the specific ingredient, the supplier, and the exact price movement so you can act immediately, whether that means renegotiating with your supplier, requesting a credit note, or adjusting your menu price. This replaces the common scenario where a café owner discovers a margin problem weeks later through a monthly accountant’s report, by which point the loss has already accumulated.

How does Jelly calculate variance for high-volume café ingredients like milk and coffee beans?

Jelly calculates theoretical usage by multiplying your recipe quantities by the number of each item sold according to your POS data. For example, if your recipe specifies 18g of beans per flat white and you sold 200 flat whites in a week, theoretical bean usage is 3.6kg.

Actual usage is your opening stock plus any deliveries received, minus your closing physical count. The difference between actual and theoretical is your variance. Jelly presents this comparison in its Flash Report so you can see immediately whether the gap is within a healthy 1–3% range or whether it warrants investigation.

Common causes of variance in café drinks include unlogged end-of-day milk dumps, burnt espresso shots, over-pouring on syrups, and modifier mapping gaps for alt-milk options. These issues become visible and addressable once the system is running.

Does Jelly work for cafés with multiple milk types and seasonal menu changes?

Jelly supports multiple milk types and seasonal menus without extra admin overhead. Each milk type, including whole, semi-skimmed, oat, almond, and soy, is held as a separate ingredient in Jelly, each with its own live cost drawn from your invoices.

When you build a recipe for a drink that offers milk alternatives, you create a variant recipe for each option and map it to the corresponding POS modifier. This setup ensures that an oat milk flat white deducts oat milk rather than whole milk from your stock, which keeps both your theoretical usage and your ingredient-level costs accurate.

For seasonal menu changes, adding a new dish in Jelly’s Cookbook takes approximately three minutes. You click on ingredients already populated from your invoices, enter quantities, and link the recipe to the new POS item, without rebuilding your ingredient library from scratch.

Is Jelly suitable for a café that is preparing to open a second site?

Jelly is designed specifically for operators at the point of expanding beyond a single site. Each location is added at the same flat rate of £129 per month, with no additional per-user fees.

Recipes built for your first site can be replicated and adjusted for the second, and Jelly’s reporting gives you a consolidated view of GP, variance, and price alerts across both locations. The Price Alert and Flash Report features are particularly valuable at this stage because they allow an owner or operations manager to monitor kitchen financial performance across sites without being physically present, which solves the control problem that manual spreadsheets cannot handle as a business grows.

Read Next