🔓 Access level in Planday: Administrator

🌐 Subscription plan: Plus, Pro, Enterprise

⏱️ Reading time: 4 min.

ℹ️ Important read: How to set up salary codes in Planday

If you’re using Sage 50 Payroll to manage your company’s payroll, you can efficiently export your payroll data from Planday and create a payroll report for importing it into Sage 50 Payroll. Additionally, you can import your payslips from Sage 50 Payroll to allow employees to access them through Planday.

Activate payroll export and payslip import for Sage 50 Payroll

Log into Planday and go to the integration page via Settings > Integrations > Overview.

Find Sage 50 Payroll, click on Set up, toggle on Sage 50 Employee Payment Hours and Rates template & payslips and click on Activate.

Update salary identifiers for your employees in Planday

To update each employee in Planday with their unique salary identifier from your integration, go to People > select and edit employee > Employee Details > Payroll > Salary identifier.

Add Salary codes in Planday

Planday's Salary codes must match your Sage Payroll Elements. Update Planday with Salary codes to allow Sage to identify which Element the payment will need to go through, by matching up the codes.

Salary codes can be assigned to various components in Planday, including Employee groups, Shift types, Payroll supplements, as well as 'general' salary codes for both salary and hourly pay.

Here are the steps to set up the Salary codes in Planday:

Set the salary code for normal worked hours and monthly salary

First, enter the salary code for normal worked hours and monthly salary in Settings > Payroll > General > Salary codes.

Assign salary codes to payroll supplements (optional)

If needed, you can also assign salary codes to your existing payroll supplements in Planday. Go to Settings > Payroll > Payroll supplements and edit the payroll supplement you want to apply the salary code for.

Assign salary codes to shift types (optional)

For those using Planday to register alternate shift types, you can apply salary codes to specific shift types. Go to Settings > Schedule > Shift types and edit the shift type you want to apply the salary code for.

Assign salary codes to leave policies

Add a salary code to your leave policies so that leave is referenced correctly in the Sage50 formatted export. You can add a salary code to a leave policy under Settings > Leave & Overtime > Policies.

Note: This method works for accrued leave policies with a monetary payout option. It doesn’t work for fixed leave policies without a monetary payout option.

Go to Handling leave with Sage 50 Payroll export to learn more.

Assign salary codes to employee groups (optional)

If you wish to allocate hours among different employee groups for payroll purposes, you can apply distinct salary codes to different employee groups. Apply salary codes to employee groups in the top menu People > Employee groups > and edit the employee group to enter the salary code.

Note: The salary code for the Employee group will overwrite the salary code for normal worked hours. As a result, the hours will be recorded under the Employee group, in the CSV or Excel payroll export.

Export Sage 50 Payroll reports from Planday

Note: Before exporting the payroll export file, remember to check up on approved shifts. You can learn more about preparing payroll here.

Go to Payroll > Payroll export.
Choose date interval.
Choose between all employees or only specific employee groups or employees.
In the File Format field choose Sage 50 Payroll.
Press Prepare report.
Save the file on your desktop.

Import Planday payroll reports into Sage 50 Payroll

Log in to your Sage 50 Payroll account.
Create a new pay run and import the Sage 50 payroll report you have generated in Planday. Please verify the content in the file before you import it into Sage 50 Payroll.

Import Sage 50 Payroll payslips into Planday

Download the PDF file with payslips to your desktop. We recommend you open the file to verify it is the correct data before importing into Planday.
Log in to Planday and go to Payroll > Import payslips.
Choose start- and end date: enter the same dates as the payslip.
Existing payslips: If you have already imported payslips to a given period, you can import additional payslips to that period. You can also overwrite existing payslips to update them with new data.
Choose Payslip in Type.
Choose the Format Sage 50.
Upload the downloaded file of payslips and click import. The payslips will then be available to employees from their Planday account.

Sage 50 integration - Set up payroll export (Sage50 format)