How to Set Up Xero Integration for Restaurant Finances

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

Key Takeaways

• Map daily POS sales to clearing accounts, post supplier invoices line by line into the correct nominal codes, then reconcile card and delivery settlements daily for real-time gross-profit visibility.
• A hospitality-specific chart of accounts in Xero, combined with automated POS mapping, keeps VAT returns accurate and HMRC Making Tax Digital compliant without manual corrections.
• Automating supplier invoice entry via Jelly eliminates 10–20 hours of weekly bookkeeping and updates dish-level margins in real time as prices change.
• Correct reconciliation of card fees and delivery commissions prevents understated revenue and overstated margins on both the P&L and VAT returns.
• Track daily GP reports and admin hours saved to measure success, then book a demo with Jelly to automate your own Xero workflow.

Why Your Xero Setup Needs Automation

Many UK restaurants, pubs and boutique hotels lose hours each week to manual invoice entry, POS exports and bank reconciliation in Xero. By the time a monthly management report lands, the margin data is already three weeks old, which is too late to react to a supplier price increase or a delivery platform commission change.

The solution lies in automating the data flow at every stage, from the moment a sale is recorded to the point where supplier costs hit your books. This guide walks through the exact Xero setup that removes that lag: a hospitality-specific chart of accounts, daily POS summary mapping, automated supplier invoice sync via Jelly, and card and delivery reconciliation that keeps you HMRC Making Tax Digital compliant in 2026.

What You Need Before Setup

You need a few basics in place before you start:

• An active Xero account on a plan that includes bank feeds and VAT returns
• UK VAT registration, either standard or flat-rate scheme
• A POS system capable of exporting daily sales summaries, such as Square, ePOS Now or Lightspeed
• Supplier invoices arriving by email or captured by photo
• Basic bookkeeping familiarity, as this guide assumes you understand debits, credits and nominal codes

Why This Process Matters for MTD and Margins

VAT-registered UK businesses are already inside HMRC’s Making Tax Digital framework for VAT and must use compatible software such as Xero for digital record-keeping and return submission. From April 2026, MTD for Income Tax extends further, which makes a clean, automated Xero setup non-negotiable rather than optional.

Beyond compliance, the operational case is straightforward: correct nominal-code mapping means your gross profit report reflects today’s costs, not last month’s. This real-time accuracy depends on separating standard-rated food and drink sales, at 20% VAT, from zero-rated food sales at the point of POS mapping, because mixing them forces manual correction on every VAT return. Getting the structure right once removes that recurring error and keeps both your margin data and VAT position reliable.

Step-by-Step Process

Step 1: Build a Hospitality Chart of Accounts in Xero

Start in Accounting → Chart of Accounts in Xero and create or rename the following accounts. Use the exact names below so that automated tools, including Jelly, can map to them without custom configuration.

Account Name	Type	VAT Rate	Notes
Food Sales	Revenue	20% (SR) / 0% (ZR)	Split standard-rated (hot/prepared) from zero-rated (cold/grocery) at POS level
Beverage Sales	Revenue	20% SR	Includes all alcoholic and soft drinks
Food Purchases	Direct Costs (COGS)	20% SR / 0% ZR	All food supplier invoices; VAT rate follows supplier invoice
Beverage Purchases	Direct Costs (COGS)	20% SR	All drink supplier invoices
Card Processing Fees	Overhead / Expense	20% SR	Acquirer fees (Stripe, Square, Worldpay), reconcile against monthly statement
Delivery Commission	Overhead / Expense	20% SR	Uber Eats, Deliveroo, Just Eat net settlement deductions
POS Clearing Account	Current Asset	No VAT	Temporary holding account, clears to zero on bank reconciliation

[Screenshot placeholder: Xero Chart of Accounts screen with hospitality accounts highlighted]

Step 2: Map POS Daily Summaries to a Clearing Account

POS accounting integrations such as Lightspeed create a single summary invoice each day, with sales by item category mapped to corresponding income accounts in Xero. Apply the same logic regardless of your POS system:

1. Export or auto-sync your end-of-day Z-report from the POS into Xero.
2. Post total food sales to Food Sales and total beverage sales to Beverage Sales, splitting VAT rates at source.
3. Post the gross cash and card takings to the POS Clearing Account.
4. When the bank feed shows the card settlement, typically T+1 to T+3 for most UK acquirers in 2026, match it against the clearing account and post the acquirer fee to Card Processing Fees.

If you follow these steps correctly, the clearing account balance returns to zero after each reconciliation cycle. A persistent balance signals a missed settlement or a POS export error and acts as an early warning that the daily workflow needs attention.

Step 3: Automate Supplier Invoice Sync into Xero with Jelly

Manual invoice entry consumes most of those weekly hours. Jelly removes that work entirely. When a supplier invoice arrives by email or photo, Jelly scans every line item, including quantity, SKU, unit price and VAT, and pushes each line to the correct nominal code in Xero, such as food lines to Food Purchases and beverage lines to Beverage Purchases.

Because Jelly updates ingredient costs with every new invoice, dish-level gross profit margins in the Jelly Kitchen section update in real time. A red margin indicator flags any dish that has slipped below target, and the team can react without opening a spreadsheet.

See how Jelly automates your invoice-to-Xero workflow and watch line-item mapping happen live during the demo.

Step 4: Reconcile Card Fees and Delivery Platform Batches

Delivery platforms such as Uber Eats, Deliveroo and Just Eat pay out in weekly or fortnightly batches that net off commission before transfer. This pattern creates a common reconciliation problem, because the bank receipt is smaller than the gross sales figure posted from the POS, and the difference must be coded to Delivery Commission.

The correct reconciliation flow separates what you sold from what you received, so both figures land in the right place:

1. Post gross delivery sales from the POS daily summary to Food Sales or Beverage Sales as normal, which captures the full revenue you earned.
2. When the platform settlement arrives in the bank feed, match the net amount to the clearing account, which records the cash you actually received.
3. Post the commission shortfall to Delivery Commission using the platform’s remittance statement as the source document, which explains the difference between gross sales and net cash.
4. Reconcile card acquirer fees from the monthly statement against Card Processing Fees to complete the picture of all transaction costs.

[Screenshot placeholder: Xero bank reconciliation screen showing delivery batch split]

Step 5: Run VAT Checks Before Making Tax Digital Submission

Before submitting each return using Xero’s MTD-compliant filing, run a short set of checks:

• Confirm that zero-rated food sales are coded separately from standard-rated sales in the POS mapping.
• Verify that all supplier invoices in Xero carry the VAT rate shown on the original document.
• Check the VAT reconciliation report in Xero against your POS Z-report totals.
• UK VAT returns are usually due one calendar month and seven days after the end of each VAT accounting period for online submissions, so set a Xero reminder to avoid late-filing penalties.

Common Mistakes and How to Fix Them

Delivery platform batching: Posting the net settlement as revenue rather than splitting gross sales and commission is the single most common error. It understates revenue and overstates margin at the same time, which corrupts both the P&L and the VAT return.

Card-fee mis-mapping: Acquirer fees coded to a revenue account rather than an expense account inflate COGS and distort gross profit. Always post these costs to Card Processing Fees under overheads.

Missing price alerts: Without automated price monitoring, a supplier quietly increasing a line-item price goes undetected until the monthly report. Jelly’s Price Alert feature flags every price movement on every invoice line the day it arrives, which gives operators the data to request credit notes or switch suppliers before margin damage builds up.

How to Measure Success of Your Xero Workflow

Once the setup is live, track three metrics weekly:

• Daily GP report: Jelly’s Flash Report compares invoice costs against POS sales to produce a gross profit percentage every day. The target for most UK restaurants sits between 65% and 72% GP on food.
• Admin hours saved: Operators using Jelly’s automated invoice-to-Xero sync report the time savings mentioned earlier, with hours previously spent on manual data entry and reconciliation freed up for operations.
• VAT return accuracy: A clean Xero setup with correct nominal-code mapping means VAT returns require no manual adjustment before submission.

Request a live Flash Report built from your own data and see your actual GP margins during the demo.

Advanced Tips and Next Steps for Operators

Multi-site rollout: Jelly charges a flat £129 per location per month with no per-user fees. Each site gets its own invoice inbox and Xero push, while the operations manager sees consolidated GP across all locations in a single dashboard.

Live price alerts across suppliers: Once all suppliers send invoices to Jelly, the Price Alert feature surfaces every price movement, up or down, with the supplier name, SKU and percentage change. Cromlix, a 5-star Scottish hotel, processes 100–150 supplier invoices weekly through an automated Xero-connected workflow, which shows that high invoice volumes stay manageable when the right automation is in place.

POS integration for Sales Mix reporting: Connecting your POS to Jelly unlocks the Sales Mix report, which shows which dishes are most popular and most profitable at the same time and supports data-driven menu engineering.

FAQ

Is Xero recognised by HMRC for Making Tax Digital VAT filing?

Yes. Xero is compatible with Making Tax Digital for VAT filing and digital record-keeping. UK VAT-registered businesses, including restaurants, pubs and hotels, must use MTD-compatible software to maintain digital VAT records and submit returns. Xero handles both requirements, and from April 2026 MTD for Income Tax applies to self-employed individuals and landlords with income over £50,000, which makes a properly configured Xero account increasingly important for owner-operators.

Can my accountant access Jelly and Xero simultaneously?

Yes. Xero supports multiple user roles, so your accountant or bookkeeper can be invited as an advisor with read or edit access without sharing your login credentials. Jelly’s management dashboard is also accessible to anyone you grant access to, so your accountant can review invoice data, GP margins and price alerts directly rather than waiting for a manual export. This removes the bottleneck of monthly reporting and allows your accountant to flag issues in real time.

Is there a limit on how many invoices Jelly can push into Xero?

No practical limit exists for typical hospitality volumes. Jelly processes invoices as they arrive, by email or photo. Each invoice is scanned line by line, with quantity, SKU, unit price and VAT extracted automatically before being pushed to the correct nominal code in Xero. Whether your site receives 20 invoices a week or 150, the workflow stays identical and the Xero push happens without manual intervention.

How does Jelly handle zero-rated versus standard-rated food purchases in Xero?

Jelly reads the VAT rate shown on each supplier invoice line and applies the corresponding rate when pushing to Xero. A delivery of raw vegetables coded at 0% VAT by the supplier posts to Food Purchases at 0%, while a delivery of prepared or hot food coded at 20% posts at 20%. This approach preserves the integrity of your VAT return without requiring manual review of each line item.

Conclusion: Turn Xero into a Daily Margin Tool

A correctly structured Xero setup with a hospitality chart of accounts, daily POS clearing, automated invoice sync and delivery-batch reconciliation converts weeks-old margin data into a daily gross-profit figure you can act on. The admin time saved runs to 10–20 hours every month, and HMRC Making Tax Digital compliance sits in place from day one.

Jelly acts as the automation layer that connects supplier invoices to Xero without manual entry, keeps dish costs live as prices change, and surfaces margin problems before they compound. At £129 per location per month, the return on investment is measurable within the first week.

Watch your invoice data flow into Xero automatically and schedule a demo to see the automation in action.