🎯 This article is for admins with an existing Xero integration with Planday.
Set up Xero Payroll if you have not done so already.
Before synchronising your Planday payroll data with Xero, please consider reviewing the following points to ensure that the correct information is sent for your employees to be paid accurately.
Create a report preview
To create a report preview, navigate to the Xero payroll overview page by going to Payroll > Xero Payroll.
What is included in the report?
Please enter all the necessary parameters at the top of the screen, and press the Preview report button.
Remember: If you can’t select your desired Pay Run, make sure to create a Draft Pay Run in Xero first.
You will see a list of all the employees that match the criteria, set by filtering for Departments, shift status, Employee types and Employee groups.
The list will show employees by their first name and last name.
Check that you are looking at the correct Pay period and that all your employees are included in the preview.
View a summary of an employee's details
You can click on one of the employees to get complete detail of their worked hours.
Total Shifts
Here you can see an overview of how many shifts (Total shifts) this particular employee has worked and the breakdown of worked hours.
Type of shifts
Under Shift type, you will be able to see what kind of shifts this employee has worked, for instance, regular hours, paid leave or sick leave, and how many units (hours) each were scheduled for.
Please note: If you have created your own shift types, please ensure you map these to the appropriate earning rates in Xero if you need those hours synced. Learn more in our Xero integration FAQs.
Payroll supplements
Under Payroll supplement, you can see a different overview of all the overtime and penalty rates that automatically apply to an employee’s shifts.
View a detailed breakdown of all units
Click on Show details to get an even more detailed overview of the above subcategories.
Here you can see the specific date, time of day, position or job role, and the number of hours worked on any given shift.
Handing of penalties
On shifts where penalties are applied, for example, on Sundays or Public holidays, the overview will show ‘0’ hours under Quantity for that particular shift and instead allocate all of the hours to the penalty. This method of allocating the hours gives a more transparent overview while also matching the setup of the payroll reporting functionality in Xero.
Handling of breaks
Both Unpaid and Paid breaks are included in this detailed overview. However, Paid breaks are included as part of the Regular hours units, while unpaid breaks are excluded from the calculations. While both Unpaid and Paid breaks show as ‘0.5’, the Unpaid break will not be sent to Xero, but the Paid break will be included in the total units of Regular hours or overtime/penalty rates if Paid breaks are applied during this period.
Handling of Leave types
Leave type is where the leave requests made by employees and approved by admins will be shown. Any leave that requires an account will show as an instance of leave both as a Shift type and a Leave type. Planday will handle the request and schedule of leave, whereas Xero will take care of the payment and balance of leave.
Please note: Xero integration only supports leave requests counted in hours, not days.
Tip: This overview is explicitly made for Xero admins. In Planday, you can create a more generic payroll report under Payroll > Payroll export. However, the generic and Xero payroll reports should not be used to compare each other as the breakdown of hours into subcategories differs between the two reports. The total amount of hours will be identical, but the breakdown is different, so it is not recommended to compare the two in terms of the breakdown of the hours.
Need more help?
Please search for answers in the 🔍 Help Center or watch our ▶️ video tutorials.
Contact our support team via the blue icon at the bottom if you have more questions.
See related articles: