Written by: JJ Tan, Founder, Jelly | Last updated: 22 August 2026
Key Takeaways for UK Hospitality Operators
- UK hospitality operators using Shopify save 5–15 hours of weekly manual reconciliation by automating sales, fees and VAT data into Xero, while reducing HMRC compliance risk.
- The 2026 Xero Shopify integration (powered by Amaka) is free on qualifying plans, supports MTD VAT returns and needs a dedicated clearing account plus correct VAT mapping by product type.
- Stores processing over 200 orders monthly should use daily summary sync mode to keep Xero ledgers manageable and still maintain accurate payout reconciliation.
- Correct VAT mapping (20% on-premises, zero-rated takeaway cold food, exempt payment fees) and a continuous digital audit trail are essential for Making Tax Digital compliance.
- Jelly closes the supplier-cost gap the native integration cannot reach by scanning invoices, updating live dish costs and pushing accurate COGS into Xero. See real-time margin visibility in action.
Step-by-step: Connect Shopify to Xero in 2026
The seven steps below walk through the full setup using the official Xero Shopify integration.
- Install the integration. Visit the Xero App Store listing for Shopify, click Get this app, then log in to your Xero organisation when prompted.
- Authorise your Shopify store. Follow the on-screen prompts to connect your Shopify admin account. The integration supports one Shopify store per Xero organisation. Multi-site operators with separate stores need separate Xero organisations or a third-party connector.
- Create a Shopify Payments Clearing account. Before mapping any data, add a Current Asset account in your Xero chart of accounts labelled Shopify Payments Clearing. This clearing account holds sales values during the multi-day settlement delay between customer purchase and gateway deposit. It enables accurate bank matching when the payout lands.
- Build out your chart of accounts. Use dedicated accounts for Shopify Product Sales (Revenue), Shipping Income (Revenue), Discounts Given (Contra Revenue), Returns & Refunds (Contra Revenue), Shopify Payments Fees (Expense), and the clearing account created above.
- Map tax rates. Assign each Shopify tax line to the correct Xero VAT rate. Map standard-rated sales to 20% VAT on Sales, zero-rated exports to Zero Rated Income, and payment processing fees to Exempt or No VAT. Incorrect mapping here is the main cause of MTD VAT return errors.
- Choose your sync mode. Select either daily summary or per-transaction posting. This choice affects Xero ledger volume and reconciliation effort for the life of the connection.
- Import historical data. The integration allows a one-time backfill of up to 90 days of historical Shopify data. Enable this during setup if you need prior-period figures in Xero without manual journal entries.
Common reconciliation issues after setup and how to address them:
- Payout timing mismatches: Shopify Payments batches deposits over several days. The clearing account absorbs this delay, so do not attempt to match individual sales to individual bank lines.
- Refunds not appearing: Refunds processed in Shopify map to Xero as Credit Notes, which reduces gross revenue. Confirm the Returns & Refunds account is correctly assigned in the integration settings.
- Fees buried in net payouts: Recording only the net bank deposit rather than separating gross sales, fees and VAT is the primary cause of Shopify-Xero mismatches. The integration handles this separation automatically when accounts are mapped correctly.
Professional setup assistance is available directly from Amaka at help@amaka.com for operators who prefer a guided configuration session.
Choosing Daily Summary or Per-transaction Sync
The sync mode you select at step six controls how Shopify data appears in your Xero ledger. For stores processing more than a few dozen orders per day, daily summary is the recommended mode because it keeps the ledger lighter while per-order detail remains accessible in Shopify itself. The table below highlights the critical threshold: once you exceed 200 orders per month, daily summary mode becomes essential to prevent Xero ledger bloat and extra reconciliation work.
| Monthly order volume | Xero ledger load | Reconciliation effort | Recommended mode |
|---|---|---|---|
| Under 200 orders | Low | Low, individual lines traceable | Per-transaction |
| 200–1,000 orders | Medium | Medium, manageable with clearing account | Either, daily summary preferred |
| Over 1,000 orders | High without summary | High if per-transaction, low with summary | Daily summary |
| Multi-site or multi-gateway | High | High, native integration may not be sufficient | Third-party connector |
Batch settlement groups transactions into accounting-ready summaries, reducing system load and bookkeeping volume compared with per-transaction syncing. High-volume hospitality operations almost always benefit from the daily summary mode. Per-transaction mode suits cases where individual order traceability in Xero is a compliance or audit requirement.
VAT Mapping, Payouts and HMRC Rules for Hospitality
UK VAT compliance for Shopify operators rests on three pillars: correct rate mapping by product type, clean separation of payout components, and a maintained digital audit trail under Making Tax Digital.
VAT rate mapping by product type
UK hospitality operators usually sell across multiple VAT categories. Map each Shopify tax line as follows:
- Standard-rated food and drink consumed on-premises: 20% VAT on Sales
- Takeaway cold food and certain bakery items: Zero Rated Income (0%)
- Hot takeaway food: 20% VAT on Sales
- Accommodation (boutique hotels): 20% VAT on Sales
- Exports outside the UK: Zero Rated Income. Retain evidence for every zero-rated transaction.
- Payment processing fees (Shopify Payments, third-party gateways): Exempt / No VAT
Shopify Payments versus third-party gateway payouts
Shopify Payments batches net payouts that bundle gross sales, fees, refunds and VAT into a single bank deposit. Third-party gateways such as PayPal or Stripe follow the same pattern on their own settlement schedules. Marketplace payouts must be split into gross sales, VAT, fees, refunds and adjustments before posting to accounting software. Recording the net deposit as revenue overstates income and understates VAT liability.
Making Tax Digital requirements
Since 1 April 2022, all UK VAT-registered businesses except those granted exemptions must keep VAT records digitally and submit returns through HMRC-compatible MTD software. The compliant data chain for a Shopify operator runs: Shopify → Xero integration (powered by Amaka) → Xero → digital VAT return submission. Manual methods including copy-and-paste or re-keying between systems break the required digital link and are explicitly disallowed by HMRC.
Retain these records for a minimum of six years: supplier invoices, Shopify payout reports, payment processor fee statements, and any import VAT evidence such as C79 certificates.
When Xero’s Native Integration Stops at Sales
The Xero Shopify integration handles the sales-to-ledger layer reliably. It does not touch the cost side of the kitchen. The native connector does not sync stock levels, adjust inventory quantities, or track Cost of Goods Sold. For a restaurant or pub, that gap is significant. Xero shows what came in from Shopify sales, but it has no visibility of what those sales actually cost to produce.
Supplier invoices still arrive in paper or PDF form, ingredient prices shift week to week, and the only way to know whether a dish is still profitable is to rebuild a spreadsheet. This process forces managers to re-enter the same data across multiple systems, increasing human error risk and slowing decision-making.
Jelly closes this gap. Jelly automatically scans every line item of every supplier invoice, captured by photo or forwarded by email, and pushes the digitised data directly into Xero. Ingredient costs update in real time. The gross profit margin for every dish reflects the actual price paid to suppliers this week, not last month’s spreadsheet estimate.
For a boutique hotel running Shopify for online bookings and retail sales alongside a kitchen operation, Jelly connects the supplier cost layer that Xero’s native integration cannot reach. When a supplier increases the price of a key ingredient, Jelly’s Price Alert flags it immediately. The dish cost updates automatically. The GP margin in Jelly turns red if the dish drops below target. The operator can reprice, renegotiate or substitute before the margin damage compounds.
Jelly users see an average gross margin improvement of two percentage points within the first three months. One operator, Amber restaurant in East London, saves £3,000–£4,000 per month through tighter cost control enabled by Jelly’s invoice automation and live costing. Cairn Lodge Hotel’s head chef cut food costs by 5% within a month of connecting supplier invoices to live dish costings.
Jelly integrates directly with Xero, so the one-click push of digitised invoices into the accounting ledger becomes part of the same automated workflow. There is no manual re-keying, no broken digital links, and no extra MTD compliance risk.
See how Jelly feeds accurate COGS into Xero automatically.
Frequently Asked Questions
Can I connect multiple Shopify stores to a single Xero organisation?
The native Xero Shopify integration supports one Shopify store per Xero organisation. Multi-site operators running separate Shopify stores for each location need either separate Xero organisations mapped to each store, or a third-party connector that supports multi-store consolidation. If your sites share a single Shopify account with multiple locations, the integration can pull data from all locations into one Xero organisation, grouped by channel. Confirm your Shopify account structure before setup to choose the right approach.
Why does my Xero bank balance not match my Shopify payout amount?
Shopify Payments batches payouts over several business days and nets off fees, refunds and adjustments before depositing. The figure that arrives in your bank account is never equal to gross sales for the same period. The clearing account created during setup absorbs this timing difference. When the payout lands in the bank feed, Xero matches it against the clearing account balance rather than against individual sales lines. If the figures still do not reconcile, check that payment processing fees and refunds are mapped to their own accounts rather than being absorbed into the revenue line.
How does Jelly handle supplier price changes mid-month and their impact on live dish costing?
Every time a new invoice arrives from a supplier, whether by email or photo capture, Jelly scans every line item and updates the ingredient cost in real time. If a supplier increases the price of an ingredient mid-month, the dish cost for every recipe containing that ingredient updates immediately. Jelly’s Price Alert feature flags the specific price change, the supplier responsible, and the percentage movement. Chefs and operators get the data needed to renegotiate, claim a credit note, or adjust menu pricing before the margin impact accumulates. There is no need to wait for a monthly stocktake or an accountant’s report.
Does Xero automatically file my VAT return to HMRC?
Xero is an HMRC-recognised MTD-compatible platform and supports digital VAT return submission directly to HMRC for UK VAT-registered businesses. Xero does not auto-file returns without operator review and approval. You must review the VAT return figures calculated by Xero, confirm they are accurate, and then submit through the platform. The submission travels to HMRC via API, which satisfies the MTD digital link requirement. Ensure your Xero organisation has the correct VAT Registration Number and that all Shopify tax lines are mapped to the right Xero VAT rates before each filing period.
Conclusion: Use Xero Data to Protect Kitchen Margins
The path to automated, HMRC-compliant bookkeeping for UK hospitality operators using Shopify runs through a correctly configured Xero integration: clearing account in place, VAT rates mapped by product type, sync mode matched to order volume, and the digital link described earlier. The native Xero Shopify integration, powered by Amaka, handles that sales-to-ledger layer reliably and at no additional cost on qualifying Xero plans.
The remaining gap, covering supplier costs, live COGS and real menu profitability, needs a layer the native integration was never designed to provide. Jelly fills that gap by automating invoice scanning, updating dish costs in real time, and pushing accurate supplier data into Xero so operators see true margins without spreadsheets or delayed accountant reports.
Revenue keeps the lights on. Profit keeps the business alive. Accurate, automated data connects the two.
See how Jelly and Xero work together to give your kitchen real-time margin visibility.