All Collections
Set up Xero Integration
Xero integration – Payroll report overview
Xero integration – Payroll report overview

Learn aspects of the Xero payroll report before synchronising your Planday data with Xero

Saad Saeed avatar
Written by Saad Saeed
Updated over a week ago

🎯 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.

Planday EN Screenshots for HC.001.png

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.

Planday EN Screenshots for HC.002.png

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.

Planday EN Screenshots for HC.003.png

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:

Did this answer your question?