Written by: JJ Tan, Founder, Jelly | Last updated: 24 October 2026

Key Takeaways

  • Lightspeed POS data export starts with identifying your product line, because each version has different export paths and limits.
  • Manual exports are split by data type with row caps, so you run multiple exports and clean CSVs before importing to Xero.
  • UK VAT and MTD rules require digital links between systems, so CSV import is acceptable only when you avoid manual re-keying.
  • Lightspeed offers REST APIs for automated data access, but most operators rely on third-party integrations to avoid manual export work.
  • Jelly provides native Lightspeed integration for UK restaurants, pubs and hotels, pulling data via API and removing manual exports.

Book A Demo With Jelly

Identify Your Lightspeed Version Before Exporting

Identify your Lightspeed product line before you follow any export steps. The four main products are:

  • X-Series (Lightspeed Retail): Cloud-based retail POS with a browser back office. Login URL is secure.retail.lightspeed.app. The back office has two main categories: Reporting, which holds the sales reports, and Catalog, which holds Products. Sales history sits under the Sell menu. Hospitality operators use X-Series mainly when they also run a retail element.
  • R-Series (Lightspeed Retail, Legacy): Legacy Lightspeed Retail product, formerly Lightspeed Retail Pro. The legacy Lightspeed Restaurant product is the L-Series. The R-Series back office includes an Export Center. Many independent restaurants and pubs that joined Lightspeed several years ago still use it.
  • S-Series (Lightspeed OnSite): Desktop Mac application rather than a browser-based POS. If you open an app on a Mac to reach your POS, this is your product. S-Series appears less often in hospitality.
  • eCom (Lightspeed eCom): Separate eCom back office dashboard for online shops. It has its own Exports page under Tools > Exports for orders, products and customers. Operators use it alongside a physical POS for online ordering or retail.

Now do this: Note your product line before reading the export steps below. If you are unsure, check your login URL or the labels in your back-office menu.

How To Export Data From Lightspeed POS

The steps below cover each product line separately. Go straight to the section that matches your version.

X-Series: Sales History Export

  1. Log in to your Lightspeed Retail back office at secure.retail.lightspeed.app.
  2. Open Sell in the left-hand menu, then select Sales History.
  3. Set your date range using the date-picker fields. Keep the documented export cap in mind.
  4. Apply any filters you need, such as location, register or employee.
  5. Click Export List to download the file as CSV.
  6. Find the file in your browser’s default download folder.

What you can export: individual sale records with line-item detail, payment method and date.

Now do this: Check the row count. If it nears the documented limit, shorten the date range and run another export.

X-Series: Reporting Exports For Summaries

Reporting exports in X-Series sit separately from Sales History. Open Reporting and choose a report type. Reporting exports cover Sales, Inventory, Payment, Tax, Register closures and Lightspeed Payments. There is no “End of Day” report type, but Register closures gives a snapshot of daily activity. Each report has its own Export button and downloads as XLSX or CSV. These exports are summary-level, with pre-aggregated totals. The Sales History export is different and provides line-level records of individual sales.

What you can export: aggregated daily totals, payment breakdowns and tax summaries.

Now do this: Decide whether you need transaction-level detail or summary totals before exporting, because your accountant will use them differently.

X-Series: Product And Customer Exports

Lightspeed Retail (X-Series) exports sales, product and customer data from separate sections. There is no single “export everything” button. For products, go to Products, apply any filters, then click Export. For customers, go to Customers, filter as needed, then click Export. Customer list exports download as CSV. Product list exports download as CSV or XLSX.

What you can export: product catalogue with pricing and category data, plus customer records with contact details and purchase history flags.

Now do this: Export products and customers as separate files, then label each file clearly so you can match it to the right period.

R-Series: Export Center For Restaurant BackOffice

  1. Log in to your Lightspeed Restaurant BackOffice.
  2. Open Reports or find the Export Center in the menu.
  3. Select the data type you want to export, such as sales, products or customers.
  4. Set your date range and any location filters.
  5. Click Export to download a CSV file.

What you can export: sales reports, product lists and customer data, each as a separate CSV.

Now do this: Run one export per data type and label each file with the date range before you save it.

S-Series: Exporting From Lightspeed OnSite

  1. Open the Lightspeed OnSite application on your Mac.
  2. Use the top menu bar to open Reports.
  3. Select the report type, such as sales, inventory or customers.
  4. Choose your date range, then click Export or Print To CSV.

What you can export: sales and inventory reports, plus customer data where you collect it.

Now do this: Check your Mac’s default download location so you can find the exported file quickly.

eCom: Exporting Online Orders And Catalogues

  1. Log in to your Lightspeed eCom dashboard.
  2. Open Reports or Orders depending on the data you need.
  3. Apply date and status filters.
  4. Click Export to download a CSV of orders or product data.

What you can export: online order records, product catalogue and customer data.

Now do this: If you run eCom alongside a physical POS, export each system separately because they do not share a unified export.

Why Lightspeed Cannot Export Everything At Once

Lightspeed Retail (X-Series) exports are split by data type and product line. The back office does not provide a single “export everything” function, so each section of the store must be exported on its own. Each data category needs a separate export, and each product line follows its own route.

A complete data pull for a VAT quarter usually means several exports across multiple data types. Each export needs its own date-range selection and file download.

Now do this: List every data type you need, such as sales, products, customers and reports, then plan a separate export for each before you begin.

Limits You Face With Lightspeed Data Exports

Piecemeal exporting is only half the challenge. Lightspeed’s X-Series documentation states that the Sales History export is limited to 1,000 sales, while a separate Sales History guide mentions 10,000 sales, so the documented ceiling is inconsistent. Busy restaurants and pubs can exceed the lower limit within a week.

Date-range chunking solves this. Split the period into shorter windows, such as weekly instead of monthly, then run multiple exports and combine the CSV files before you send them to your accountant.

Some data categories do not export from the standard back office at all. Reporting exports give summary-level data, while Sales History exports give transaction-level detail. Summary reports do not replace Sales History when you need full VAT or GP analysis.

These limits reflect how manual exports work in most POS systems. Any POS struggles when you rely on manual exports as the main data pipeline for a busy multi-site group.

Now do this: When your export period covers more than a few hundred transactions, plan multiple chunked exports from the start.

Using The Lightspeed API Instead Of Manual Exports

Lightspeed publishes REST APIs across its product lines, which allow automated and real-time data access instead of manual CSV pulls. The X-Series API uses OAuth 2.0 authorisation. Scoped permissions such as sales:read, products:read and customers:read control which data types an integration can reach. Lightspeed’s APIs cover products, inventory, sales, customers, menus, tickets, payments and reporting, with capability varying by product line.

For UK hospitality operators, Jelly provides the most practical route to automated Lightspeed data. Jelly connects to Lightspeed via a real-time API and pulls item-level sales data as soon as a transaction completes. Jelly appears on the Lightspeed marketplace and runs alongside Lightspeed as a complementary tool. Setup takes about five minutes, and the full sequence appears in Jelly’s setup guide. Once connected, POS-to-dish linking surfaces items sold since the integration went live, so you avoid legacy menu clutter.

For a full walkthrough of the integration setup, see Jelly’s Lightspeed Restaurant Integration: Complete Setup Guide.

See How The Lightspeed Sync Works

How Long Lightspeed Exports Take And Where Files Go

In the Lightspeed Retail POS (S-Series) back office, quick exports download automatically once you set the date range and filters. Longer exports appear in the Export Center when ready. The real time cost comes from repeating this process across data types and date-range chunks when a record cap applies. A full quarterly pull across sales, products and customers can take several sessions before you even start cleaning the files.

In Lightspeed Restaurant (K-Series), exported files download to the computer. When you save CSV or XLSX files via Google Sheets, they also land in the default downloads folder. Lightspeed does not send these files straight to Xero or your accountant. You must retrieve, rename and process each file yourself.

Now do this: Choose a clear naming convention, such as YYYY-MM-DD_lightspeed_sales_wk1.csv, so chunked exports stay organised.

What Lightspeed Data Exports Really Cost

Standard exports from Lightspeed OnSite, Retail POS (X-Series) and eCom (C-Series) sit inside your subscription, so Lightspeed does not charge per export. Lightspeed NXT/EVO dealer API access to your own data does involve setup and monthly fees. The main cost for most operators is staff time. Teams spend hours running exports, cleaning CSVs, mapping VAT codes and reconciling duplicates before the data reaches Xero or an accountant.

Jelly offers a different approach. Its native Lightspeed integration delivers real-time sales, cost and margin data and pushes results to Xero with one click. Pricing is a flat £129 per month per location, with no extra charge per user or feature.

Using Lightspeed Exports For UK VAT, MTD And Xero

Once you have your Lightspeed CSV files, you still need to prepare them for VAT and accounting. For UK VAT, HMRC’s Making Tax Digital for VAT rules require digital records and MTD-compatible software. Acceptable digital links include CSV import and export, API transfer and automated data transfer. Manual copying or cut-and-paste between systems does not qualify.

The main cleanup steps before a Lightspeed CSV reaches Xero include:

  • Date format normalisation: Xero exports and imports follow the organisation’s regional date settings, and Excel can silently reinterpret dates. Normalise every date column to YYYY-MM-DD.
  • VAT code mapping: Incorrect tax-rate coding in Xero distorts VAT return boxes. Map each line in your Lightspeed export to the correct Xero tax rate, such as standard 20%, reduced 5% or zero-rated.
  • Duplicate row removal: Chunked exports with overlapping dates often create duplicates. Compare transaction counts and values by period before importing.
  • MTD digital link compliance: The transfer from Lightspeed CSV into Xero must use a digital link. HMRC’s VAT Notice 700/22 lists CSV import and export as acceptable, as long as you avoid manual transposition between export and import.

Every cleanup step above exists because the data arrives as a flat file. Jelly removes the file from the workflow. Its automated invoice capture digitises every supplier invoice line by line. The Flash report combines invoice costs with POS sales to show daily, weekly or monthly GP margin. The Price Alert feature highlights every ingredient price change from every supplier, so you see cost shifts before they hit your margin. A one-click push then sends those digitised invoices straight to Xero, so the manual cleanup steps above never happen.

For a detailed guide to the Xero side of this workflow, see Jelly’s Lightspeed Xero Export Guide For UK Hospitality 2026.

Talk Through Your VAT And Xero Setup

Frequently Asked Questions

Can I Export Customer Data From Lightspeed?

You can export customer data from Lightspeed, but it sits in a separate file from sales and product data. In X-Series, open the Customers section of the back office and use the Export button to download a CSV of customer records with contact details and purchase history flags. R-Series offers a similar customer export via the Export Center. Customer exports do not include transaction-level sales detail, so you still need a separate Sales History export.

Can I Schedule Lightspeed Exports?

In Lightspeed Retail POS (X-Series), exports to Excel, Open Office or Google Docs always need a user to trigger them. Reports can be scheduled by email on Advanced, Enterprise and Plus plans or with the Advanced Reporting add-on. Automated, recurring data retrieval otherwise relies on the Lightspeed API. You can build a custom integration or use a marketplace partner such as Jelly, which connects via the API and pulls item-level sales data in real time.

What Format Are Lightspeed Exports In?

Lightspeed exports are available in CSV and, for some product lines and report types, Excel format. CSV works best for importing into Xero, other accounting software or spreadsheets. Excel preserves formatting but can change dates and numbers based on regional settings. For MTD compliance, both formats count as digital links when you avoid manual re-keying between export and import.

How Do I Get Lightspeed Data Into Xero?

The manual route uses CSV. Export from Lightspeed, clean the file by normalising dates, mapping VAT codes and removing duplicates, then import it into Xero with Xero’s CSV import function. This counts as a digital link under HMRC’s MTD rules when you avoid manual re-keying. The automated route connects Lightspeed to Jelly. Jelly pulls real-time sales data via the Lightspeed API and pushes digitised invoices to Xero with one click, so you skip export, cleanup and manual import.

Conclusion: Choosing Between Manual Exports And Jelly

Lightspeed POS data export is achievable for any operator. The manual route covers identifying your product line, running chunked exports by data type, cleaning CSVs and importing into Xero. This guide walks through each step. The key question is whether that time cost still makes sense as your business grows.

For restaurants, pubs and hotels at the £500k+ stage, connecting Lightspeed to Jelly usually delivers more value. Jelly provides real-time sales, cost and margin data and a one-click push to Xero, all without manual exports. You decide which route fits your team and your growth plans.

See Jelly In Action For Your Site