All Collections
Point of Sale (POS) integrations
OpenSolution POS integration – Setup guide with Planday
OpenSolution POS integration – Setup guide with Planday

Import revenue from OpenSolution POS

Anton E avatar
Written by Anton E
Updated over a week ago

Connect your OpenSolution POS to automatically import your daily revenue to Planday.

Revenue data is fetched for the set number of past days, so any updates to revenue on those those days will be shown. The revenue data in Planday is displayed per day and based on your z-reports. For the integration to import the z-reports and add the revenue to the right date, it's important that the z-reports are created daily, and do not have a start and end date across multiple days.

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

Create revenue units

If you haven't already done so, you must first create revenue units for the relevant departments in Planday.

To set up a Revenue unit in Planday, go to Reports > Revenue > Manage revenue > Revenue units.

Note: You can create several revenue units within a department.

When setting up a Revenue unit, select the option to Enter daily revenue for every unit you want to map, along with selecting Include in total revenue.

Note: For detailed steps, read Set up revenue with cost centres and budgets.

Request details from OpenSolution

Before you can setup the integration in Planday, please contact OpenSolution to request your API Key.

Activate the OpenSolution integration

Connect to OpenSolution

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

  • Find the OpenSolution integration in the POS category and select Add.

  • Enter the API key provided by OpenSolution.

  • Select Connect. If the connection fails, please check that you have entered the correct connection details.

Integration settings

Configure the settings for the integration.

  • Select the number of past days you want to fetch data for. The integration will update the revenue numbers from OpenSolution 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 any existing revenue numbers in Planday. Make sure to select this option if you manually enter your budgeted revenue in the revenue report, or if there have been changes or updates made either to the days being fetched or the revenue numbers in OpenSolution.

  • Specify the timeframe within a day, where all your z-reports are generated.

  • Select whether or not you want to include VAT in the revenue from OpenSolution.

Location matching

Now you can connect the Revenue units in Planday to their corresponding Report groups in OpenSolution, so the revenue will be imported into the correct departments in Planday and the accurate labour percentage will be calculated.

Please note that if you don't have any report groups set up, you'll need to select which revenue unit in Planday you want to have the sales without report group imported to.

  • Open Location matching by clicking on Show details.

  • Here you will see all the Revenue units created for your business in Planday. In the dropdown menu next to the name of each Revenue unit, choose the corresponding Report group.

  • Select Activate and the integration will start importing your revenue data from OpenSolution.

ℹ️ Need more help?

🔍 Search the Help Center | See videos at | Watch a webinar

💬 For personalised support

Login and contact our support team via the blue icon at the bottom if you have more questions or book a one-to-one professional training session with an expert.

Did this answer your question?