Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Integrating stock control software with Xero UK follows five steps: choose the right app, connect via the Xero App Store, map your Chart of Accounts, configure UK VAT codes, and import opening stock before testing the sync.
- UK hospitality operators rely on invoice-level capture and recipe costing to keep Xero stock data trustworthy, because native Xero inventory lacks recipe depletion, batch tracking and multi-location support.
- Common post-connection issues include double-counting stock, AVCO versus FIFO mismatches and VAT code errors. You avoid these by disabling Xero tracked inventory, agreeing valuation methods with your accountant and auditing VAT codes before each return.
- Accurate line-item invoice capture and live recipe costing support reliable food cost percentages, gross profit tracking and supplier price alerts in restaurants, pubs and hotels.
- Jelly is the best stock control software to integrate with Xero for UK restaurants, pubs and boutique hotels because it scans every supplier invoice line by line, pushes digitised invoices into Xero in one click, and keeps dish and menu margins live from real supplier prices at a flat £129/month per location.
Before You Begin: What You Need For A Xero Stock Integration
Confirm a few basics before you connect any stock control app to Xero.
- Admin access to Xero
- Admin access to the stock control app
- A Xero Chart of Accounts with Sales, Cost of Goods Sold and Stock on Hand accounts configured
- UK VAT codes set up correctly in Xero
- Supplier invoice history available for import
- Opening stock figures agreed and ready to import
- A POS system connected (required only if you want live margin tracking)
Ownership matters because the sync spans two teams. The finance manager or owner controls the Xero side and the general ledger mapping, while the head chef or operations lead owns recipes, stock counts and supplier invoices. Because those two sets of data meet in the valuation method, the accountant must sign off on AVCO versus FIFO and journal posting frequency before go-live.
Set clear expectations. The technical OAuth connection takes minutes. Mapping accounts, importing opening stock and running a test sync usually fits into an afternoon. Reconciliation then becomes a regular habit.
Why This Process Matters For UK Hospitality Operators
Clean stock-to-Xero sync keeps food cost and gross profit visible in time to act. Without it, operators wait for the accountant’s monthly report, which arrives too late to react to supplier price changes or low-margin dishes. Before automation, some operators took three weeks to close the period for invoices, a delay that remains common without restaurant-specific systems.
Hospitality stock behaves differently from retail or wholesale inventory. Perishable, recipe-driven, invoice-heavy kitchens need accurate invoice capture and recipe costing to make the sync meaningful. In most hotel groups, food and beverage invoices are the dominant accounts payable category by document count, frequently exceeding three-quarters of all invoices received. Manual invoice and inventory work can consume 10–20 hours a week for some operators, which creates a heavy admin burden.
The margin stakes are high. A 10% rise in every ingredient cost on a dish selling at £20.00 ex-VAT cuts gross profit by approximately 2.8 percentage points, worth over £1,100 per year on 40 portions a week. A single uncorrected supplier price rise, missed because invoices are reconciled monthly rather than at delivery, compounds across every dish using that ingredient.
Restaurant inventory management software links invoices, recipes, POS systems and stock counts so that stock levels, food costs and cost of goods sold update automatically without manual data entry. This setup creates perpetual inventory instead of a once-a-week snapshot. That perpetual accuracy is what makes a Xero sync trustworthy.
How To Integrate Stock Control Software With Xero UK: Step-By-Step
The steps below follow the order you work through in practice, from choosing an app to proving the sync works.
Step 1 — Choose The Right Stock Control App For Your Model
Restaurants, pubs and boutique hotels should start with Jelly. It is built for invoice-heavy, recipe-driven kitchens, integrates directly with Xero, and costs a flat £129/month per location. Jelly automates invoice scanning via email or photo, pushes digitised invoices into Xero in one click, and keeps dish margins live from real supplier prices.
Xero’s own documentation positions multi-location stock management as a function of connected apps from the Xero App Store, not native Xero, which makes a dedicated stock control app necessary. Xero native tracked inventory uses average cost (AVCO) only, is single-location, and has no recipe costing, batch tracking or reorder capability. A multi-site restaurant or any kitchen that needs recipe-level depletion quickly hits those limits.
Other options in the market serve different use cases. Unleashed (part of The Access Group) publishes UK pricing of £269/month for Core and £499/month for Pro. It is built for wholesale workflows such as purchase orders, bills of materials and warehouse bin locations. Multi-warehouse management is a Core and Pro feature of Unleashed, so operators holding stock in more than one location must upgrade from Lite to Core rather than deploy the base plan across sites. Unleashed does not focus on recipe costing and invoice capture in a kitchen environment. Cin7 Core suits wholesale and light manufacturing at $349/month (USD), and Qoblex targets multi-warehouse distribution. inFlow is aimed at small retailers. Each is built around a different stock model, and none of those models is a recipe-driven kitchen, which is why hospitality operators look elsewhere.
Step 2 — Connect Via The Xero App Store
Open the Xero App Store, find your chosen stock control app and click Connect. The app initiates an OAuth 2.0 authorisation flow. Sign in to Xero, review the permissions requested, grant access and select the correct Xero organisation. Once authorised, the app can read and write to your Xero data within the scope you approved.
Jelly’s Xero integration pushes digitised invoices with one click and delivers a large reduction in bookkeeping time. Xero limits each organisation to two uncertified apps, so confirm your existing connections before adding a new one. Screenshot the authorisation confirmation screen for your records.
Step 3 — Map Your Chart Of Accounts For Stock In Xero
Map three account types explicitly so postings land in the right place. Sales revenue posts to your Sales account. The cost of ingredients consumed posts to a Cost of Goods Sold account. Stock held at any point in time posts to a Stock on Hand account, classified as a current asset on the balance sheet.
Every stock movement in the external app should post to these accounts and nowhere else. Xero’s inventory asset and cost of goods sold accounts are system accounts, so users cannot journal to or from them directly. The stock app must therefore post through the correct account codes rather than through manual journals.
A suggested GL mapping works as follows. Revenue from POS-linked sales should land in your Sales account, for example 200 – Sales. When stock is consumed, the ingredient cost posts to your Cost of Goods Sold account, for example 310 – Cost of Goods Sold, and the value of stock still held sits in your Stock on Hand account, for example 630 – Inventory Asset. Together these three accounts keep the profit and loss and the balance sheet in step, so confirm the codes with your accountant before activating the sync.
Xero’s multi-store guidance advises keeping the chart of accounts as lean as possible and warns that over-segmenting at the account level requires a lot of maintenance. Multi-site operators should use Xero tracking categories to tag transactions by location instead of creating separate account codes per site.
Step 4 — Configure UK VAT
The UK VAT registration threshold has been £90,000 of taxable turnover (rolling 12 months) since 1 April 2024, and Making Tax Digital for VAT has been mandatory for all VAT-registered businesses since April 2022. Every stock purchase and sale must carry the correct VAT code in Xero.
Map purchase VAT codes to reflect the actual supply. Use the standard rate of 20% for most goods, the reduced rate of 5% where applicable, and zero-rated codes for qualifying food categories. Sales VAT codes must match the VAT treatment of each dish or product sold. Automated integrations reproduce configuration errors at scale, so if product tax settings are wrong, automated postings can repeat the same VAT error hundreds of times.
The single most common cause of a wrong VAT return is not the software but a misclassified expense category quietly applying the wrong VAT rate for months at a time. Check VAT codes at transaction level and drill into Box 1, Box 4, Box 6 and Box 7 on the Xero VAT return to verify each constituent posting before filing.
Step 5 — Import Opening Stock And Run A Test Sync
When converting untracked items to tracked items in Xero, tracking starts from the day of conversion, so outstanding transactions must be entered first. Import your opening stock figures before you activate the live sync.
Run a test sync covering four transaction types before going live.
- A purchase, where a supplier invoice is received and posted
- A sale, where a dish sells via POS and stock depletes by recipe
- A credit note, where a supplier credit is applied and reconciled
- A stock adjustment, where a physical count variance is posted
After each test transaction, check a short list of results.
- Stock valuation in the app matches the Stock on Hand balance in Xero
- COGS posting appears in the correct account
- VAT codes on purchases and sales are correct
- No duplicate postings exist in either system
- The Xero balance sheet reflects the updated stock value
Screenshot each result. Reconcile the stock valuation against the Xero balance sheet before processing any live transactions. If you are still weighing whether native Xero inventory could have done this job without a third-party app, the short answer is no for hospitality, and the reasons explain why the steps above are structured the way they are.
Can Xero Do Stock Control?
Xero’s native inventory is limited to single-location tracking and the AVCO valuation method, with no recipe costing, batch tracking, stock alerts or multi-warehouse support, which is why UK hospitality operators connect third-party stock control software.
Single-site operators selling finished goods on invoices may find native Xero tracked inventory adequate. Restaurants, pubs or boutique hotels with recipe-driven stock depletion, perishable ingredients and multiple supplier invoices per week usually need more. Xero describes its accounting core as extendable with connected apps from the Xero App Store, with data flowing between Xero and the apps so stock and accounts stay in step. For multi-site operators, Xero tracking categories can produce store-level profit and loss reporting, and Xero’s own guidance frames them as a reporting and transaction-tagging tool rather than a substitute for location-aware stock control.
What Breaks After You Connect (And How To Fix It)
A completed test sync does not guarantee clean data once live transactions start flowing. The issues below appear after go-live and are the real cause of bad stock data.
Double-counting stock. When movements post through both Xero tracked inventory and the external stock app simultaneously, stock quantities and COGS are inflated. The likely cause is leaving Xero tracked inventory active after connecting the external app. Cin7 Core’s own setup guide states it does not support Xero inventory tracking and instructs users to turn off inventory tracking in Xero. The corrective action is to disable Xero tracked inventory for all items managed by the external app before you activate the sync.
AVCO versus FIFO mismatch. If the stock app uses FIFO and Xero uses AVCO, the stock valuation in the app will not reconcile to the Xero balance sheet. HMRC accepts both FIFO and AVCO for UK tax purposes, while LIFO is not permitted under UK GAAP (FRS 102 section 13). Agree the valuation method with your accountant before go-live and configure both systems to use the same method.
VAT code mapping errors. Incorrectly mapped VAT codes on purchases or sales produce an incorrect VAT return even when Xero submits it successfully to HMRC. Xero locks a VAT return once filed. Smaller errors can be corrected on the next return where the net error is below £10,000 or below 1% of Box 6, up to a £50,000 cap. Larger errors must be reported to HMRC on form VAT652. The corrective action is to audit VAT codes at transaction level before each filing period.
Unreconciled stock valuation. When the stock app’s closing valuation does not match the Stock on Hand balance on the Xero balance sheet, the ledger becomes unreliable. Xero’s multi-store guidance recommends reconciling COGS and shrinkage as part of the monthly close, matching physical stock counts to system quantities and investigating unexpected margin drops.
Before go-live, agree a few accounting rules with your accountant.
- Journal posting frequency, either daily automated journals or periodic weekly or monthly batch postings
- Stock valuation method, AVCO or FIFO, applied consistently across both systems
- Treatment of stock adjustments, including how physical count variances are posted and coded
- VAT scheme in use, whether standard accrual, cash accounting or flat rate
The Hospitality Layer: Why Invoice Capture And Recipe Costing Matter
A Xero sync only works when the data feeding it is accurate. For restaurants, pubs and boutique hotels, that means every supplier invoice line item captured correctly and every dish costed from live ingredient prices.
An invoice posted as a total can never be decomposed back into unit prices, which permanently degrades recipe costing, food cost percentage and purchase price variance analysis. Header-level capture that extracts only vendor, invoice number, date and total destroys the item price history the kitchen depends on. When inventory software syncs with the POS, every sale automatically deducts ingredients, and comparing theoretical usage with actual stock counts highlights waste, over-portioning and unrecorded comps.
Jelly acts as the invoice-to-Xero layer that makes the sync trustworthy. It captures invoices via email or photo, digitises every line item such as quantity, SKU, price and tax, and pushes them into Xero in one click. In the Kitchen section, chefs build dish recipes by clicking on ingredients already populated from scanned invoices. Tasks that previously took 28 minutes to cost in a spreadsheet take around 3 minutes in Jelly. Because ingredient costs update with every new invoice, the gross profit margin for every dish stays live.
The Price Alert feature flags every supplier price increase or decrease and gives operators the evidence needed to negotiate credits or switch suppliers. Jelly integrates natively with Square, Lightspeed, EPOS Now and Toast via real-time API, delivering item-level sales data the moment a transaction completes. The Flash Report then shows daily, weekly or monthly gross profit calculated from actual costs and actual sales. These POS systems act as complementary integration partners that Jelly works alongside.
The results are measurable. Jelly users save 10–20 hours of admin per month, cut food costs by an average of 3% in the first three months, and improve gross margins by an average of 2 percentage points in the same period. Bookkeeping time falls by around 90%. Amber restaurant in East London saves £3,000–£4,000 per month with approximately 68× ROI. As chef-owner Murat Kilic puts it: “Jelly keeps my business alive.”
Common Mistakes And Troubleshooting
Most post-go-live problems come from configuration gaps rather than the software itself. Watch for these issues and correct them early.
- Posting stock journals twice. Likely cause: Xero tracked inventory left active alongside the external app. Corrective action: disable Xero tracked inventory for all items managed externally, as outlined in the earlier double-counting section.
- Mapping purchases to the wrong COGS account. Likely cause: GL mapping configured before the Chart of Accounts was finalised. Corrective action: audit every account mapping against the agreed Chart of Accounts and repost any incorrectly coded transactions.
- Leaving opening stock unimported. Likely cause: going live before the opening stock import is complete. Corrective action: pause the live sync, import opening stock, reconcile the balance sheet, then reactivate.
- Testing with live data. Likely cause: no separate test environment. Corrective action: use a Xero demo company or a dedicated test organisation for all pre-go-live testing.
- Failing to agree journal frequency with the accountant. Likely cause: default app settings used without review. Corrective action: confirm daily versus periodic posting with the accountant before the first live sync runs.
How To Measure Success
A correctly configured Xero stock integration produces a few clear accounting outcomes.
- Stock valuation in the stock app reconciles to the Stock on Hand balance on the Xero balance sheet at period end
- COGS movements post cleanly to the correct account each period with no duplicates
- VAT returns reconcile to underlying transaction data in Box 1, Box 4, Box 6 and Box 7
- Margin reports in the stock app match gross profit figures in Xero
Directional indicators of a healthy integration include reduced bookkeeping time, fewer invoice discrepancies, faster reaction to supplier price changes and clearer gross profit tracking between periods. Mitchell Management tightened its actual-versus-theoretical inventory variance to approximately 1% and saw food cost drop 2 percentage points at a key location after adopting automated invoice and inventory workflows.
Advanced Tips And Next Steps
Scaling to multiple sites works best when you standardise supplier invoice capture across all locations before adding a second site to the sync. Inconsistent invoice capture at one location makes cross-site food cost comparison unreliable. Multi-unit restaurant groups typically count inventory differently at each location, which turns cross-location food cost comparison into a guessing game and keeps outlier locations invisible until the next audit. Jelly’s flat per-location pricing keeps multi-site rollout predictable.
Use Price Alert data in supplier negotiations to protect margins. Invoice price data used as a supplier negotiation tool allows operators to send reports on a specific item and show vendors’ price fluctuations, described by one operator as “a great negotiating tool”. Jelly’s Price Alert feature provides exactly this evidence at line-item level.
Readers evaluating custom integrations can work directly with the Xero Accounting API. It uses OAuth 2.0 authorisation and exposes Contacts, Items, Invoices, Bills and Accounts endpoints. Xero’s API allows 60 calls per minute and 5,000 calls per day per organisation, which explains why some stock apps batch or consolidate postings rather than sending every transaction individually.
For further reading on adjacent tasks, see Stock Control Software Xero Integration: A UK Guide and How To Push Stocktake Adjustments Into Xero Automatically.
Plan Your Xero Integration With Jelly
Conclusion
Integrating stock control software with Xero UK follows a clear five-step process, from choosing the right app through to importing opening stock and running a test sync. The technical connection takes minutes. The work that makes the data trustworthy, such as invoice-level capture, recipe costing and ongoing reconciliation, is what separates a reliable Xero ledger from one that misleads until month-end.
Jelly is the best stock control software to integrate with Xero for UK restaurants, pubs and boutique hotels because it automates invoice capture, pushes clean line-item data into Xero, and keeps dish and menu margins live from real supplier prices, all on a flat per-location pricing model.
Frequently Asked Questions
Can Xero Do Stock Control On Its Own?
Xero’s native tracked inventory covers basic stock quantity and value tracking for finished goods using the AVCO weighted average cost method. It is limited to a single location, has no recipe costing, no batch tracking and no stock alerts, and stock quantities update when invoices and bills are approved rather than through recipe-level depletion. Restaurants, pubs and boutique hotels therefore need a dedicated third-party stock control app connected via the Xero App Store.
What Are The Downsides Of Using Xero For Inventory?
Xero’s native inventory cannot track raw materials, work-in-progress, multiple locations, or more than 4,000 items. It also does not support FIFO costing, reorder points, bundles or recipe-level depletion. Xero Inventory Plus, which adds multi-location tracking and FIFO, is currently available only to US-based organisations. UK hospitality operators with recipe-driven, perishable stock need a connected stock control app to fill these gaps.
How Long Does It Take To Connect Stock Control Software To Xero?
The OAuth authorisation connection itself takes a few minutes. Mapping the Chart of Accounts, configuring UK VAT codes, importing opening stock and running a test sync typically takes an afternoon. Jelly onboards and generates initial value in the first week. Once suppliers send invoices to a dedicated email address, or within 24 hours of photographing invoices into Jelly, Price Alert and spending insights go live.
How Do I Avoid Double-Counting Stock Between Xero And My Stock App?
Disable Xero’s native tracked inventory for all items managed by the external stock app before you activate the sync. If both systems post stock movements simultaneously, quantities and COGS become inflated. Confirm with your accountant that journals are posting from one source only, and reconcile the Stock on Hand balance on the Xero balance sheet against the stock app’s closing valuation at the end of each period.
Does Jelly Integrate With Xero?
Yes. Jelly integrates directly with Xero and pushes digitised invoices, with every line item captured, into Xero in one click. The integration delivers around a 90% reduction in bookkeeping time mentioned earlier. Jelly also integrates natively with Square, Lightspeed, EPOS Now and Toast via real-time API for item-level sales data and live gross profit reporting.
How Does Jelly Handle VAT On Supplier Invoices?
Jelly digitises every line item of a supplier invoice, including the tax field, and pushes the invoice into Xero with the VAT codes applied. The VAT treatment of each purchase reflects the configuration set in Jelly and Xero, so confirm that VAT codes on purchases are correctly mapped before you activate the sync. Jelly’s one-click push to Xero means the same VAT coding applies consistently across every invoice, which removes many manual re-keying errors that commonly cause VAT return discrepancies.
Can Jelly Track Stock Across Multiple Sites?
Yes. Jelly is designed for operators expanding to two to five locations and charges a flat £129/month per location with no variable per-user fees. Each location has its own invoice capture, recipe costing and margin reporting, and management has direct access to insights across all sites. This setup makes cross-site food cost comparison reliable, provided supplier invoice capture is standardised across locations from the outset.
What POS Systems Does Jelly Integrate With?
Jelly integrates natively with Square, Lightspeed, EPOS Now and Toast via real-time API. Each integration delivers item-level sales data the moment a transaction completes, which Jelly uses to calculate live gross profit margins and sales mix reporting. Connecting any supported POS takes approximately five minutes and follows the same flow across all four systems. Jelly plans to add further POS partners in the future.
