Written by: JJ Tan, Founder, Jelly | Last updated: 23 June 2026
Key Results You Can Expect
- The Lightspeed OpenTable integration removes manual reservation entry, so UK operators see same-day gross profit in Jelly.
- Seven clear steps, from enabling the integration in Lightspeed to validating live data in Jelly’s Flash Report, take under an hour.
- Accurate table-number alignment and real-time status sync between OpenTable and Lightspeed prevent reporting delays and margin erosion.
- Operators typically recover 2–5 hours of weekly admin time and see GP improvements of 2–7 percentage points within the first 12 weeks.
- Book a demo with Jelly to connect your Lightspeed OpenTable integration and start tracking live gross profit today.
What You Need Before You Start
You need a few pieces in place before you begin the integration.
- An active Lightspeed Restaurant account with admin-level credentials (K-Series, O-Series or U-Series, see compatibility matrix below)
- An active OpenTable for Restaurants account with manager or owner access
- An active Jelly account (£129/month per location, flat rate)
- Table numbers in Lightspeed that match the floor plan configured in OpenTable
- Menu items published and live in Lightspeed so they are available for dish mapping in Jelly
- UK VAT settings confirmed in Lightspeed before syncing, so Jelly’s GP calculations use the correct net figures
2026 Lightspeed–OpenTable–Jelly Compatibility Matrix
| Lightspeed Series | OpenTable Integration Supported | Jelly POS Integration Supported | Notes |
|---|---|---|---|
| K-Series | Yes | Yes | Primary UK-deployed series |
| O-Series | Yes | Yes | Confirm firmware is on the current 2026 release before connecting |
| U-Series | Limited | Yes | Ensure table numbers match across platforms |
Once all prerequisites are confirmed, you are ready to begin the integration. First, review why this process delivers measurable financial impact within days of completion.
Why Lightspeed, OpenTable and Jelly Together Matter
Manual reservation entry into a POS creates a lag of minutes to hours between a table being seated and the kitchen having accurate cover counts. That lag compounds into margin erosion, as price changes on ingredients go unnoticed and dish costs drift. By the time a finance manager sees a report, the damage has already happened.
The Lightspeed OpenTable integration removes this lag by syncing reservation status directly to your POS, so Jelly receives real-time sales data and calculates GP as transactions close. This automation turns every seated reservation into immediate, accurate revenue and cost data.
Jelly customers who connect a POS consistently recover several hours of weekly admin and see meaningful GP improvements. One operator moved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Populu lifted GP from 68% to 72% across 16 locations using the same data pipeline.
Step-by-Step Process
Step 1: Enable OpenTable in Lightspeed Back Office
Log in to the Lightspeed Restaurant Back Office with admin credentials. Navigate to Settings → Integrations → OpenTable and toggle the integration to active. Lightspeed then prompts for your OpenTable Restaurant ID to establish the connection between the two platforms. You can find this ID in the OpenTable for Restaurants portal under Account → Restaurant Details. Enter the ID and save to complete the authorisation.
Success criterion: Lightspeed Back Office shows a green “Connected” status next to OpenTable. Next action: Proceed to Step 2.
Step 2: Confirm Matching Table Numbers in Both Systems
Now verify the table-number alignment flagged in the prerequisites. In Lightspeed Back Office, open Floor Plans and note every table number. In the OpenTable portal, open Table Management → Floor Plan and confirm each table number is identical to Lightspeed. Any mismatch prevents reservation status from updating at the correct POS table.
Success criterion: Every OpenTable table number has an exact match in Lightspeed. Next action: Proceed to Step 3.
Step 3: Set Up Guest Status Sync from OpenTable
In the OpenTable portal, navigate to Settings → POS Integration and select Lightspeed as the connected POS. Enable Automatic Status Updates so that when a reservation is marked “Seated” in OpenTable, the corresponding table opens automatically in Lightspeed. Set the sync interval to real-time, not batched, to minimise delay between front-of-house actions and POS activity.
Success criterion: A test reservation moved to “Seated” in OpenTable opens the correct table in Lightspeed within 60 seconds. Next action: Proceed to Step 4.
Step 4: Publish and Clean Your Menu in Lightspeed
In Lightspeed Back Office, confirm all current menu items are published and assigned to the correct revenue categories, such as Food and Beverages. Items that remain unpublished never appear in Jelly’s dish-mapping interface. Remove any legacy or inactive items so the mapping list stays focused on live dishes.
Success criterion: The Lightspeed menu reflects only live, saleable items. Next action: Proceed to Step 5.
Step 5: Connect Lightspeed to Jelly
Log in to Jelly and navigate to Integrations. Select Lightspeed Restaurant and click Connect. Jelly redirects to a Lightspeed authorisation screen, where you sign in with admin credentials and grant the requested permissions. Return to Jelly and select which Lightspeed revenue categories, such as Food and Beverages, you want to sync. This connection step usually takes around five minutes.
Success criterion: Jelly’s Integrations page shows Lightspeed as “Active” with a timestamp of the most recent data pull. Next action: Proceed to Step 6.
Step 6: Map Lightspeed Menu Items to Jelly Dishes
In Jelly, open Kitchen → Sales Mix. Jelly surfaces only items sold since the integration was connected, which keeps the list free of legacy menu clutter. Match each Lightspeed menu item to the corresponding Jelly dish recipe so Jelly can calculate real-time cost of goods sold against every sale.
Success criterion: Every active menu item has a mapped Jelly dish with a live GP percentage displayed. Next action: Proceed to Step 7.
Step 7: Check Live GP in Jelly’s Flash Report
Run a test transaction in Lightspeed by seating a table via OpenTable, adding items and closing the bill. In Jelly, open the Flash Report and confirm the sale appears with the correct revenue, cost and GP margin. Check that the cover count from OpenTable matches the transaction in Lightspeed, so both systems stay aligned.
Success criterion: The Flash Report reflects the test transaction within minutes, with accurate GP data. Next action: The integration is live, so you can move on to measuring success.
Common Mistakes and Quick Fixes
| Issue | Likely Cause | Resolution | Prevention |
|---|---|---|---|
| Reservation does not open table in Lightspeed | Table number mismatch between OpenTable and Lightspeed floor plan | Reconcile table numbers in both platforms (Step 2) | Audit floor plans before enabling sync |
| Status sync delay exceeding 5 minutes | Sync interval set to batched rather than real-time in OpenTable POS settings | Change sync interval to real-time in OpenTable → Settings → POS Integration | Confirm real-time setting during Step 3 |
| Lightspeed not visible in Jelly Integrations | User does not have admin access to Lightspeed account | Request admin credentials from the account owner, as Jelly flags this requirement at the connection screen | Confirm admin access before starting Step 5 |
| Menu items missing from Jelly dish-mapping screen | Items not published in Lightspeed, or sold before integration was connected | Publish all active items in Lightspeed Back Office, because only items sold post-connection appear in Jelly | Complete Step 4 before connecting Jelly |
How to Measure Success in the First Weeks
Three metrics show whether the integration delivers value within the first week, and each one covers a different area of efficiency. The most immediate metric is admin hours, where reservation-to-POS manual entry should drop to zero and recover 2–5 hours of weekly work. That time saving supports faster responses to cost changes, because Jelly’s Price Alert feature surfaces ingredient price changes in the same week they occur rather than in a monthly report, which is how Amber restaurant saves £3,000–£4,000 per month through quicker reactions to supplier price movements.
The combined effect of reduced admin and faster cost control appears in GP margin. Jelly’s Flash Report provides a daily view of gross profit calculated from live Lightspeed sales data and invoice costs. Operators should establish a baseline GP in week one and track weekly movement. The 2–7 percentage point improvement cited earlier typically becomes visible within the first three months.
Advanced Jelly Features to Extend the Integration
Once the Lightspeed OpenTable integration runs smoothly, several Jelly features extend its value. The Price Alert feature flags every ingredient price change from supplier invoices, giving chefs clear data to negotiate credits or switch suppliers before margin erosion builds. The daily Flash Report email can be scheduled so the operations manager receives a GP summary each morning without opening a spreadsheet.
The Sales Mix report combines Lightspeed item-level sales with Jelly dish costs to highlight which menu items are both popular and profitable. That combination guides menu engineering decisions and supports confident price changes. For multi-site operators, each location connects independently at £129/month per site, and all site-level Flash Reports remain accessible from a single Jelly account.
FAQ
Does the Lightspeed OpenTable integration cost extra to use with Jelly?
Jelly charges a flat rate of £129 per month per location. There are no additional charges for connecting Lightspeed or for the number of users accessing the platform. Lightspeed and OpenTable each have their own subscription costs, which are separate from Jelly’s pricing. The integration itself is enabled within each platform’s settings at no additional fee.
Which Lightspeed series work with OpenTable and Jelly in 2026?
K-Series and O-Series both support OpenTable integration, but Jelly connects to Lightspeed via daily sales sync rather than a confirmed real-time API for these series. U-Series has limited OpenTable integration. Operators on U-Series should audit their floor plan configuration in both platforms before enabling the sync.
Can I roll this integration out across multiple sites at once?
Each site connects independently, which keeps access control and reporting clean. The process, which takes around five minutes per location, is identical across all sites. Open Jelly, click Integrations, sign in to Lightspeed with admin credentials for that location, grant permissions and select revenue categories. Jelly’s Flash Report then aggregates data across all connected locations, so a finance manager or operations director can view GP across the estate from a single dashboard without switching between accounts.
How does this setup handle reservation and sales data under UK data rules?
Jelly processes sales and cost data, not personal guest data. Reservation guest details, such as names and contact information, remain within OpenTable’s platform and are not transmitted to Jelly. The data that flows from Lightspeed into Jelly is transactional, including item sold, quantity, revenue and timestamp. Operators should confirm their OpenTable and Lightspeed data-sharing settings comply with their own UK GDPR obligations, particularly for guest profile data stored within those platforms.
Conclusion: From Reservation to Same-Day Margin Control
The Lightspeed OpenTable integration removes the manual step between a reservation being seated and the kitchen having accurate sales data. Connected to Jelly, that data pipeline delivers live gross profit visibility through the Flash Report, Price Alert and Sales Mix on the same day the integration goes live. The seven steps above take under an hour to complete, and the financial impact becomes visible within the first week.
UK operators at restaurants, pubs and boutique hotels running Lightspeed Restaurant POS have a direct route from setup to same-day margin control. Talk to Jelly’s team to connect your Lightspeed OpenTable integration and start seeing live gross profit.