🔓 Access level in Planday: Administrator

🌐 Subscription plan: Plus, Pro, Enterprise

⏱️ Reading time: 4 min.

ℹ️ Important read: How to modify the employee form

✅ Required steps: How to export employee details to Sage 50 templates - Step 1

You want to know how to export payroll data to Sage 50 and import Payslips from Sage 50? Go to Set up Sage 50 Payroll (formatted export).

Step 1: Initial setup	Step 2: Final setup
◎	◉
⏱ 10 minutes	⏱ 10 minutes

Create your own report

You can create your own report(s) based on the Sage 50 template. You can also name them as you prefer and apply different filters to them. To do so:

Go to People > Employees > Tools > Export data.

Under Integration templates, find the templates with the Sage 50 logo and select Create report (1.).
Give your report a name, and select which Departments and Employee types you want to include (2.).
Under Filter, you can select to include only newly created, updated, deactivated, or hired employees. The filters are optional (3.).
Click on Create (4.)
Repeat the process if needed.

Your employee report(s) will appear under Your employee reports.

Download your report(s)

When you are ready to download your Sage 50 employee reports based on the templates, simply follow these steps:

Go to People > Employees > Tools > Export data.
Find the report you want to download under Your employee reports.
To make sure the report is in the correct format, you should check for the Sage 50 logo in the top right corner, next to the name of the report, as shown in the screenshot below.
If you are using filters ( e.g. Changed employees), click on Edit (1.) and then you'll need to add Start and End dates (2.). This will define the date range for which user creations, changes, hire dates, or deactivations to be included in your report download.
Select Download when ready (3.).
Your file will start the download to your local machine.

Now that the report is saved, you can revisit it anytime and download it again if necessary. Prior to downloading it again, please ensure that the Start and End dates are correct.

Import the file in Sage 50

Note: The import file must not be in use when attempting to upload it into Sage 50.

In Sage 50, go to File, then Advanced Data Import.
Make a backup of your data by clicking Backup, then follow the on-screen instructions.
Select the data template you want to import (e.g. Employee Information), then click Next.
Browse to find the file your want to import and continue.
Browse to the file that you want to import again and click Next.
Select the required worksheet from the Worksheet drop-down list and proceed.
In Import Field, select the data field that corresponds with the information in the Payroll Field.
If you’ve previously saved a payroll import map, click Load Map, then browse to and double click the required map.
Click Save Map: find the location, add a file name, and save the map.
Then Finish and Print.
When you're done click Ok, then Close.

FAQs

Will new employees created in Planday, automatically be created in Sage 50?

No, you will need to do pull a new report and import the new employees into Sage 50. The integration only works in one direction, so the new information from Planday will need to be imported into Sage each time.

What will happen if I update an employee’s data in Planday?

You will have to update the two systems independently of one another once an initial import has been done.

What will happen if I deactivate an employee in Planday?

You will also need to deactivate the employee in Sage 50.

See related articles:

ℹ️ Need more help?

🔍 Search the Help Center | See videos at Tutorials.Planday.com | 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.