All Collections
Integrations
POS (point of sale) integrations
Import revenue from Lightspeed Restaurant (L Series)
Import revenue from Lightspeed Restaurant (L Series)
Patrick Gruhn avatar
Written by Patrick Gruhn
Updated over a week ago

Connect to your Lightspeed Restaurant (L Series) POS solution to automatically import your daily revenue to Planday.

When you're done setting up, your revenue will automatically refresh every 5 minutes so you can monitor changes in real-time. Revenue data is fetched for a set number of days, so any updates to revenue on those days will be shown.

Monitor your revenue, scheduled labor costs, and labor percentage by going to Reports > Revenue in the top menu or view it inside your schedule by selecting View and toggling on Revenue in the dropdown menu.

Create revenue units

If you haven't already done so, you need to create revenue units for the relevant departments in Planday. To create your revenue units go to Settings > Reports > Revenue.

Learn more about the revenue module here.

Activate the Lightspeed Restaurant (L Series) integration

Start by activating the integration, following the steps below:

  • Log into Planday and go to Settings > Integrations > Overview.

  • Find the Lightspeed Restaurant (L Series) integration in the POS category and select Add.

  • Now click on Connect Account. You will get directed to Lightspeed, where you have to follow the steps, log in, and give grant access for the Planday integration.

  • If you have multiple sites, click on Connect Account again and follow the same steps but for the other Lightspeed Restaurant (L Series) account.

  • Your account will now be connected to Planday. Now it’s time to configure the revenue import.

Integration settings

Configure the settings for the integration.

  1. Select the number of past days you want to fetch data for. The integration will update the revenue numbers from Lightspeed Restaurant (L Series) for the number of prior days chosen, so any changes to the revenue data will also appear in Planday.

    Select Overwrite existing data if the integration should overwrite the existing figures in Planday. This should be selected if the budgeted revenue is entered manually in the revenue report, or if the days being fetched have had any changes or updates made to the revenue figures in Lightspeed Restaurant (L Series).

  2. Choose if you want to import revenue based on Product prices or Payments.
    Please note that this option is only available in the US.

  3. Choose if you want the revenue to be imported based on Day (12 am-12 am) or defined by your Business hours in Lightspeed. (Business hours is useful if your restaurant is closing after midnight)
    Please note that this option is only available in the US.

  4. Choose if you want the revenue to be displayed including or excluding taxes.

  5. Choose if you want the revenue to be displayed including or excluding a service charge (your option is not going to affect the numbers if you don´t use a service charge)

  6. Open Location matching by clicking on Show details.

Location matching

Now, you can connect the Revenue units in Planday to their corresponding Floors in Lightspeed Restaurant (L Series), so the revenue will be imported into the correct departments in Planday and an accurate labor percentage will be calculated.

If you have some of your tables set up to “delivery” and/or “takeaway” you also need to specify to which revenue unit these types should be imported to.

Please note that revenue from “Takeaway Simple” will be calculated as a part of the floor and only revenue from the table types “takeaway” or “delivery” will go into the separate delivery and takeaway mapping.

  • Here you will see all of the Revenue units created for your business in Planday. In the dropdown menu next to the name of each Revenue unit, choose the corresponding Floor from Lightspeed Restaurant (L Series).

  • Select the revenue unit you want to import the revenue from Delivery to. Do the same for revenue from Takeaway. It is possible to leave this blank or select revenue units that are already mapped. In this case, the revenue from all selections will be imported to the same revenue unit.

  • Select Activate. Now the integration will start importing your revenue data from Lightspeed Restaurant (L Series).
    Allow it 5 minutes for it to show up in the schedule.


FAQ and troubleshooting

If the integration seems to be enabled but no revenue is coming in.

  • If configured correctly, the revenue will be visible at the bottom of the schedule. Make sure that “Revenue” is enabled under Planday > Schedule > View.

  • Make sure there are existing shifts on the week or the day you ́re looking at, otherwise the revenue might not show. Allow 5 minutes for the revenue to update if you make any changes to the schedule.

  • Are you looking at the correct department/location? In the top left corner of Planday you can switch between departments/locations:

Revenue is coming in, but the numbers are incorrect:

  • Review the steps under “Integration settings”
    *If you make any changes, allow 5 minutes for the integration to update.

Did this answer your question?