How to Use Square for Restaurant Stock Control UK

How to Use Square for Restaurant Stock Control UK

Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026

Key Takeaways

  • Square handles transactions and sales data well but lacks native raw-ingredient tracking, recipe costing or live gross-profit calculations for UK restaurants.
  • Connecting Jelly to Square pulls real-time sales data and maps it to costed recipes, delivering live GP margins without manual spreadsheets.
  • Jelly automates invoice scanning, price alerts and variance tracking, helping operators cut food costs and recover supplier credits faster.
  • Setup takes around five minutes: link Square, map menu items and start scanning invoices to see immediate margin insights.
  • Book a demo and connect your Square account to Jelly today to protect restaurant profitability.

What You Need Before Connecting Square and Jelly

You need Square admin access, at least one set of supplier invoices, and a basic list of current menu items with core ingredients. On the Jelly side, onboarding takes approximately five minutes. Create an account, connect Square via the integrations panel, and you are live. You avoid a lengthy implementation project and do not need a consultant.

Why Square Alone Falls Short for Restaurant Stock Control UK

Square's inventory controls operate at the finished item or variation level, not at the raw-ingredient level. Enabling inventory tracking on a menu item surfaces it in Square's stock overview, counting tool and purchase orders. The system has no mechanism to deplete individual ingredients when a dish is sold. Native Square for Restaurants software allows operators to add stock levels for each finished menu item and automatically hide items when they run out, but cannot track raw ingredients or recipes. Ingredient-level tracking becomes available through integrations such as Jelly.

Square does not include native ingredient-level tracking, recipe linking, or recipe cost calculations. Many Square-using kitchens still rely on manual stocktakes and delayed margin reports. Restaurants should aim for 12-24 inventory turns annually (1–2 per month), so ingredient prices and stock levels shift constantly, far faster than a weekly spreadsheet can capture.

Jelly connects to Square via a real-time API, pulls item-level transaction data the moment a sale completes, and maps that data to costed recipes. You see live GP margins without any manual calculation. To ensure a smooth integration, you first prepare your Square environment with clean, consistent item data.

See how Jelly's real-time Square integration delivers live GP margins — book a demo today.

Square Setup Steps for Clean Item Data

Before connecting Jelly, configure Square's native inventory controls so the integration has clean item data to work with.

  1. Create or audit your items. In Square Dashboard, navigate to Items & Services. Confirm every menu item is listed with an accurate name that matches what your kitchen team recognises. Inconsistent naming is the most common cause of mapping errors later.
  2. Enable the Track Inventory toggle. Open each item, scroll to the inventory section and switch on tracking. Square prompts you to enter an opening stock count. For finished items such as bottled drinks or pre-packaged goods this is straightforward. For prepared dishes, enter a nominal count and rely on Jelly for ingredient-level depletion.
  3. Set low-stock alerts. Square allows per-item low-stock thresholds. Set these as a safety net for high-value finished goods.
  4. Run a baseline stock count. Use Square's inventory counting tool to record current levels. This creates the reference point for future variance measurement.

[Screenshot placeholder: Square Dashboard → Items & Services → Inventory tracking toggle enabled]

The Square-to-Jelly Integration Workflow

The connection process follows the same streamlined workflow used across all of Jelly's POS integrations.

  1. Log into Jelly at your account dashboard. Navigate to the Integrations panel.
  2. Select Square and authenticate. Click the Square tile, sign in with your Square admin credentials and grant the required permissions. Jelly flags upfront if the account lacks admin rights, which is the single most common friction point.
  3. Select the categories to sync. Choose which Square item categories, such as food, beverages or both, should feed into Jelly. This keeps the data clean and avoids pulling in non-food retail items.
  4. Map Square items to Jelly dishes. Jelly surfaces only items sold since the integration was connected, so the mapping list stays free of legacy menu clutter. Match each Square item to its corresponding dish in Jelly's Cookbook.
  5. Verify real-time sync. Process a test transaction in Square. Within seconds, Jelly's dashboard should reflect the sale against the mapped dish. If it does not, confirm admin permissions and category selection.

[Screenshot placeholder: Jelly Integrations panel → Square connected → item mapping screen]

Automated Invoice Scanning and Price Alerts

With Square sales flowing into Jelly, the next step is feeding in ingredient costs. Forward supplier invoices to your dedicated Jelly inbox or photograph them directly in the app. Jelly extracts every line item, including quantity, SKU, unit price and tax, without manual data entry.

The Price Alert feature then monitors every subsequent invoice against the previous price for each ingredient. When a supplier increases the cost of chicken breast, rapeseed oil or any other line item, Jelly flags it immediately. That alert gives you concrete evidence to call the supplier, negotiate a credit note or switch to an alternative. Three-way invoice validation, matching purchase order, delivery note and supplier invoice, is automated by inventory software to ensure operators only pay for goods actually received. This process catches pricing or quantity discrepancies that manual checks miss. Stuart Noble, Head Chef at Cairn Lodge Hotel, cut food costs by 5% within a month using this workflow.

Live Dish Costing from Square Sales

Inside Jelly's Cookbook, you build each dish by selecting the ingredients already populated from your scanned invoices. Jelly handles all unit conversions and wastage percentages automatically. Work that previously took an average of 28 minutes per dish in a spreadsheet now takes approximately three minutes in Jelly.

Ingredient costs update with every new invoice, so the gross profit margin for every dish stays live. A red percentage flags a dish whose margin has dropped. A green percentage confirms margin improvement. Connecting inventory management software to POS sales data and recipe costing systems enables restaurants to compare actual ingredient usage against theoretical usage calculated from menu items sold, revealing variances caused by over-portioning, waste, spoilage, theft or mispriced dishes.

Jelly's Flash Report delivers a daily, weekly or monthly view of GP margin calculated from invoice costs and Square transaction data. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue after connecting a POS to Jelly.

[Screenshot placeholder: Jelly Flash Report → daily GP margin by dish using Square sales data]

Discover your real dish margins with live Square sales data — start your free trial.

Daily Stock Counts, Waste Logging and UK VAT Reporting

Barcode-enabled stocktakes performed with inventory software can be faster than manual counts and provide the actual usage figures needed to calculate precise variances. These variances are measured against theoretical usage derived from POS recipe data. In Jelly, counts can be entered by barcode scan or manually. Waste is logged directly against the relevant recipe so the impact on GP is captured immediately.

Well-managed restaurant operations target inventory variance under 3% per ingredient category, with tighter thresholds for high-value proteins and spirits. Jelly's variance reports surface any category exceeding that threshold so action can be taken before the month-end review.

For UK VAT and accounts payable, Jelly's one-click Xero export pushes all digitised invoices, including line-item tax data, directly into your accounting software. Supplier credit notes raised following a price-alert negotiation are captured in the same flow. This keeps your VAT records accurate and cuts bookkeeping time by approximately 90%.

Common Mistakes and Troubleshooting

Missing admin rights. The Square integration requires full admin access. If the connection fails, confirm the authenticating account holds admin permissions in Square Dashboard before retrying.

Unmapped menu items. Any Square item not mapped to a Jelly dish appears in sales data but contributes no cost or margin information. Review the mapping screen after the first week of trading to catch any items added to Square after the initial setup.

Invoice upload errors. Photographs taken in poor lighting or at an angle reduce OCR accuracy. Retake the image flat and well lit, or forward the PDF directly from the supplier email to your Jelly inbox for cleaner extraction.

Stale recipes. If a dish recipe in Jelly's Cookbook references an ingredient that has since been renamed or replaced on an invoice, the cost link breaks. Audit recipes monthly and update ingredient references when suppliers change product codes.

How to Measure Success

The primary KPIs to track after connecting Square to Jelly are weekly admin hours saved and GP percentage improvement. Aim to recover 10–20 admin hours per month. Jelly customers see an average two-percentage-point GP uplift within three months. These efficiency and margin gains are driven by two operational metrics. Measure speed of supplier credit-note recovery from price alert to credit note received, and track stock variance percentage per category with a target below 3%. Tracking the turnover ratio mentioned earlier provides a clean baseline comparison before and after integration.

Advanced Tips for Multi-site and Delivery Menus

For multi-site operators, Jelly supports a separate location per site at £129 per month per location. A centralised dashboard shows GP and variance across all sites simultaneously. Delivery menu costing is handled by duplicating existing Cookbook dishes and applying a delivery commission overhead. This approach produces a separate profitable delivery menu without rebuilding recipes from scratch.

The Xero integration handles multi-site invoice consolidation. Automated par-level systems reduce average manual supplier ordering time from 8.6 hours per week to under 1 hour, freeing managers to focus on service and menu development.

Frequently Asked Questions

How often should stock counts be performed in a restaurant using Square and Jelly?

Perishable ingredients such as proteins, dairy and fresh produce should be counted daily or at minimum before each service. Dry goods and beverages suit a weekly or fortnightly count cycle. The key discipline is consistency. Counts performed at the same time each week, typically close of trading on Sunday, produce the cleanest variance data. Jelly's counting tool supports both barcode and manual entry, so the process fits into a kitchen routine without requiring dedicated office time. Waste should be logged daily against the relevant recipe so its impact on GP is captured in real time rather than discovered at month end.

What is the typical Jelly onboarding timeline?

The Square POS connection takes approximately five minutes. Invoice scanning begins generating price alerts and spending insights within 24 hours of the first invoice being photographed or forwarded by email. Building out the full Cookbook with costed recipes typically takes one to two days depending on menu size. After that, the Flash Report starts producing live GP margin data. Most operators describe meaningful, actionable insights within the first week. Unlike legacy systems that require months of configuration and consultant involvement, Jelly is designed for kitchens where the head chef or operations manager sets it up directly.

How does Jelly handle UK data security and VAT?

Jelly digitises every invoice line item including quantity, SKU, unit price and tax, and pushes that structured data to Xero via a one-click export. VAT figures are captured at the point of invoice receipt rather than reconstructed at month end, which reduces the risk of input tax errors. Supplier credit notes negotiated following a Jelly price alert are recorded in the same invoice flow, keeping the VAT position accurate. On data security, Jelly operates as a cloud platform accessible via web browser, with role-based access so management and kitchen teams see only the data relevant to their function.

Does Jelly work if my Square menu changes frequently?

Jelly works well with frequently changing menus. Jelly's POS-to-dish mapping only surfaces items sold since the integration was connected, so new Square items appear in the mapping screen as soon as they generate a transaction. Map the new item to its Jelly dish and it immediately contributes to cost and margin calculations. Seasonal menu changes, daily specials and delivery-only items are all handled through the same workflow. The only maintenance required is ensuring new dishes have a corresponding recipe in Jelly's Cookbook before they go live on Square.

Conclusion

Square provides a solid, reliable foundation for UK restaurant point-of-sale operations. Connecting Jelly to Square transforms that transaction data into something far more valuable. You gain live dish-level GP margins, automated invoice costs, real-time price alerts and clean VAT-ready exports without adding admin burden to the kitchen team. The result is the clarity, control and repeatability that growing restaurants, pubs and boutique hotels need to protect margins and make confident operational decisions every day.

Connect your Square account and see your real margins in under five minutes — get started with Jelly.