Lightspeed Xero Export Guide for UK Hospitality 2026

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

Key Takeaways

• Accurate Lightspeed to Xero connections automate daily sales, VAT and payment data, which protects UK hospitality cash flow and reduces reconciliation backlogs.
• Correct UK-specific mapping for VAT rates, service charges, tips and account sales prevents errors in Xero and HMRC returns.
• Daily end-of-day exports with morning reconciliation checks on Z-reports, payments and VAT keep gross profit figures current and usable.
• Common export failures such as zero totals, duplicate invoices or mismatched VAT can be fixed with targeted 2026 settings and permission controls.
• When native exports fall short on real-time GP visibility or invoice automation, book a demo with Jelly to layer operational insights on top of your Lightspeed Xero setup.

Why reliable daily exports matter for hospitality cash flow

A missed or corrupted export affects more than accounting admin. It makes your Xero bank reconciliation wrong, adds risk to your VAT return and leaves your gross profit figures out of date. UK restaurant and pub operators typically run on food GP margins of 60–75%. A single week of inaccurate cost data can hide a supplier price increase that quietly erodes two or three margin points before anyone notices.

Finance managers who rely on monthly accountant reports work with data that is already four weeks old. Daily exports close that gap and give owners a current picture for pricing, staffing and purchasing decisions before problems build up.

Lightspeed Xero integration overview for UK hospitality

Before you set up daily exports, confirm which Lightspeed product you use because the Xero integration behaves differently across product lines. Lightspeed operates two distinct product lines relevant to UK hospitality. Lightspeed Restaurant (L-Series) is the table-service and quick-service POS used by most UK restaurants, pubs and hotels. Lightspeed X-Series (formerly Vend) is the retail-oriented platform more common in hotel gift shops and retail-adjacent food operations.

The Xero integration behaves differently across these two lines. L-Series pushes end-of-day account sales summaries, payment type breakdowns and tax totals. X-Series generates more granular product-level exports suited to retail inventory reconciliation. Confirm which product your site runs before configuring the integration. The account mapping screens differ and incorrect assumptions here create reconciliation issues later.

Both integrations offer a choice between exporting transactions as draft invoices or approved invoices in Xero. Draft is the safer default for new setups. It allows a finance manager to review each export before it posts to the ledger. After two to four weeks of validated mapping, switching to approved removes the manual approval step and fully automates the daily close.

Step-by-step: connecting Lightspeed to Xero

1. Log in to your Lightspeed back office with an account that holds admin permissions.
2. Go to Integrations and select Xero from the accounting section.
3. Click Connect to Xero and authenticate using your Xero organisation credentials, then grant the requested permissions.
4. Select the Xero organisation that should receive the exports. This step is critical for multi-entity operators.
5. Map each Lightspeed revenue category such as food, beverages, service charges and tips to the corresponding Xero account code. Use the mapping table below as a guide.
6. Set your preferred export schedule. Daily end-of-day is the standard recommendation.
7. Run a test export for the previous trading day and verify the figures match your Lightspeed Z-report before going live.

The most common setup failure at step one is insufficient user permissions. Lightspeed requires admin-level access to configure third-party integrations. If the Connect button appears greyed out, ask your Lightspeed account owner to elevate your permissions before you continue.

Get your setup validated — Jelly’s team can review your Lightspeed Xero configuration and confirm your mapping is correct before you go live.

UK VAT, tips and payment mapping checklist

UK hospitality operators must handle several tax and payment categories that generic Xero guides do not cover. Work through this checklist before your first live export.

• Standard-rated food and drink (20% VAT): Map to a revenue account with a 20% VAT rate applied in Xero. Confirm the tax rate is set to Tax on Sales, not Tax Exclusive, to avoid double-counting.
• Zero-rated food (0% VAT): Cold takeaway food and most grocery-style items qualify. Map these to a separate Xero account with a zero-rated tax code, not the same account as hot food.
• Reduced-rate items (5% VAT): These are rarely applicable in standard restaurant operations but matter if your venue sells certain energy products or runs accommodation with breakfast packages.
• Discretionary service charges: HMRC treats discretionary service charges as outside the scope of VAT when passed directly to staff. Map these to a separate liability account in Xero, not a revenue account, until distribution is confirmed.
• Mandatory service charges: These are VATable at the same rate as the underlying supply. Map to a revenue account with the appropriate VAT rate.
• Tips via card (operator-collected): Map to a separate nominal code. These are subject to PAYE and NIC obligations under the tipping legislation effective October 2024.
• Cash tips: These do not pass through the POS and should not appear in the Lightspeed export. Check that your mapping does not include a cash tips line.
• Account sales (house accounts): Map to a debtor control account in Xero, not a revenue account. Recognise revenue when the account is settled, not when the sale is recorded.

Where Lightspeed sales, payments and POs land in Xero

Lightspeed Data Type	Recommended Xero Account Type	Suggested Xero Code	UK VAT Treatment
Food sales (hot, eat-in)	Revenue	200	Standard rate 20%
Food sales (cold takeaway)	Revenue	201	Zero rated 0%
Beverage sales (alcohol)	Revenue	202	Standard rate 20%
Discretionary service charge	Current Liability	820	Outside scope
Mandatory service charge	Revenue	203	Standard rate 20%
Card tips (operator-collected)	Current Liability	821	Outside scope / PAYE
Account sales (house accounts)	Accounts Receivable	610	Deferred to settlement
Card payment receipts	Bank / Clearing	090	N/A
Cash payment receipts	Bank / Clearing	091	N/A
Purchase orders / supplier invoices	Accounts Payable	800	Input VAT reclaim

Xero account codes are customisable. The codes above are illustrative defaults. Align them with your existing chart of accounts before the first export to avoid duplicate nominal codes.

Daily sync timing and three key reconciliation checks

Set the Lightspeed Xero export to run automatically after your end-of-day close, typically between midnight and 02:00. This timing captures the previous day’s full trading data before your finance team starts work in the morning.

Run three reconciliation checks each morning, in this order.

1. Z-report vs Xero export total: Start by confirming the gross sales figure in Xero matches the Lightspeed Z-report to the penny. Any discrepancy indicates a mapping error or a failed line item and will affect the next checks.
2. Payment type split: Once the total is correct, check that card, cash and account sale totals in Xero match the Lightspeed payment breakdown. Mismatches here cause bank reconciliation failures even when the top-line total looks right.
3. VAT summary: Finally, cross-reference the VAT amounts in the Xero export against the Lightspeed tax report. This step is the fastest way to catch a misconfigured tax rate before it compounds across multiple days and it only works if the first two checks have passed.

Common Lightspeed Xero export failures and 2026 fixes

Failure	Likely Cause	2026 Fix
Export shows £0.00 in Xero	Lightspeed end-of-day not closed before sync runs	Manually close the trading day in Lightspeed back office, then re-trigger the export
Duplicate invoices in Xero	Manual export triggered on top of scheduled export	Disable manual export access for non-admin users, then rely solely on the scheduled sync
VAT totals do not match HMRC return	Mixed VAT rates mapped to a single Xero account	Split revenue accounts by VAT rate as shown in the mapping table above
Service charge appearing as revenue	Discretionary charge mapped to revenue account	Remap to a current liability account, then review prior exports and journal the difference
Account sales inflating daily revenue	House account sales posted to revenue on transaction date	Remap to accounts receivable so revenue posts on settlement
Purchase orders not appearing in Xero	PO module not enabled in Lightspeed or Xero bills not linked	Enable the purchasing module in Lightspeed settings, then re-authenticate the Xero connection
Multi-site exports merging into one Xero org	All sites authenticated to the same Xero organisation	Create a separate Xero organisation per legal entity, then re-map each site individually
Connection drops after Xero token expiry	OAuth token not refreshed after a long period of inactivity	Re-authenticate the Xero connection in Lightspeed Integrations and set a calendar reminder every 50 days

Need an export audit? Jelly’s team works with Lightspeed operators daily and can review your current setup in under 30 minutes.

When native export is not enough: real-time GP and invoice automation

The native Lightspeed Xero integration handles sales accounting reliably once configured correctly. It does not provide dish-level gross profit visibility, supplier price change alerts or automated invoice line-item scanning. For operators running on tight margins or managing multiple sites, those gaps are where profitability erodes.

Jelly sits alongside Lightspeed and Xero as the operational layer between the kitchen and the accounts. It connects directly to Lightspeed via a real-time API and is listed on the Lightspeed marketplace. Jelly pulls item-level sales data the moment a transaction completes. Every supplier invoice is scanned automatically, line by line, and pushed into Xero with a single click, which cuts bookkeeping time by around 90%.

The practical result is clear. A head chef sees a live GP margin for every dish on the menu, updated every time a new invoice arrives. A finance manager sees a daily Flash Report showing total GP without waiting for a monthly accountant summary. When a supplier increases the price of a key ingredient, Jelly’s Price Alert flags it immediately. The kitchen team then has the data to negotiate a credit note or switch supplier before the margin damage builds up.

Amber, a Mediterranean restaurant in East London, saves £3,000–£4,000 per month using Jelly’s invoice automation and price alerts alongside their existing POS and accounting setup. The Howard Arms reached 80% gross profit after implementing Jelly. Their owner now reacts to cost changes in real time rather than weeks later. Cairn Lodge Hotel cut food costs by 5% within a month of going live.

Jelly costs £129 per site per month, flat rate, with no per-user charges. Onboarding delivers initial value within the first week.

Frequently Asked Questions

How long does Lightspeed Xero setup take?

The initial connection between Lightspeed and Xero can be completed within minutes if you have admin access to both platforms. The more time-consuming step is configuring the account mapping correctly, especially for UK VAT rates, service charges and account sales. Allow one to two hours for a thorough first-time setup. Plan for two to four weeks of daily reconciliation checks to confirm that every line lands in the right Xero account before you switch from draft to approved exports.

Does the native export handle multi-site operations?

The native Lightspeed Xero integration is designed primarily for single-site use. Multi-site operators need to authenticate each Lightspeed location separately and, where sites operate as distinct legal entities, connect each to its own Xero organisation. Merging multiple sites into a single Xero organisation is possible but creates significant complexity at VAT return and management account level. Operators running two or more sites often find that a platform like Jelly, which aggregates GP and invoice data across all locations in a single dashboard, provides the central visibility that the native export alone cannot deliver.

Who should own the export process?

The finance manager or operations manager should own the daily export schedule, not the kitchen team. The kitchen team is responsible for completing the end-of-day close in Lightspeed accurately and on time. Finance owns the Xero mapping configuration, the morning reconciliation checks and any corrective journals. The cleanest setups assign a single named person to receive an automated alert if the export fails, so the issue is caught before the next trading day rather than discovered at month end.

What does Jelly cost per site?

Jelly charges a flat rate of £129 per location per month. There are no variable charges per user, per invoice volume or per feature. All integrations, including Lightspeed POS and Xero accounting, are included in the flat rate. Most sites recover the cost within the first month through supplier credits identified by the Price Alert feature alone.

Next step: audit your current export accuracy

The fastest way to check whether your current Lightspeed Xero export works correctly is to compare three consecutive days of Lightspeed Z-reports against the corresponding Xero invoices. Review gross sales, VAT totals and payment type splits. If any of the three columns do not match exactly, a mapping error is present and compounds daily.

If the native export works but you still spend hours each week on invoice entry, dish costing or chasing GP figures from your accountant, Jelly closes that gap without replacing Lightspeed or Xero.

See where automation fits — bring your current Lightspeed setup and Jelly’s team will show you exactly where invoice scanning and price alerts can save time and protect margin.