Skip to main content
All CollectionsIntegrationsXero payroll integration
Export timesheets from Planday to Xero
Export timesheets from Planday to Xero

Learn to export hours and leave date ranges from Planday to Xero.

Maud avatar
Written by Maud
Updated this week

🔓 Access level in Planday: Administrator

🌐 Subscription plan: Plus, Pro, Enterprise

⏱️ Reading time: 5 min.

  • Watch a webinar to get help with setting up the integration and understanding what the integration syncs.


Tip: Before you export your timesheets to Xero,

To preview and export approved timesheets from Planday to Xero, go to Payroll > Xero payroll.

Using the filters, you can specify the output and preview the hours that will be synced to Xero. Click the Create report preview button to see an overview of which employees have hours in the chosen period and select individual employees to see their hours.

  • Xero Organisation – Choose the name of the Xero organisation you are syncing.

  • Date range - Choose the date range you want to run the payroll for. By default the range will display a period of 3 months back from today’s date (though a period of up to 1 year in the past can be selected if needed).

  • Pay run – Select the appropriate pay run in the drop-down. You need to have a draft pay run in Xero before you can sync. Read more about processing a pay run at Xero Central.

  • Department: Select the departments that you want to sync the hours from.

  • Click Create report preview in the top right of your screen

Then, click on Filters and choose the following:

  • Employee type: Choose which employee types should be included.

  • Employee group: Choose which employee groups should be included. Note that you can select and deselect the individual employees by clicking the tiny arrow on the right-hand side of Employee type and Employee group.

  • Shifts: Select whether approved, non-approved, or all shifts should be included.

Note: all shifts synced will be created as approved timesheets in Xero.

Click on an employee’s name to see a detailed breakdown of the hours.

To sync the hours to Xero, click on Sync payroll in the top right corner. Once the sync is complete, head over to Xero to process your pay run.

For the syncing of holiday data:

  • Ensure you have mapped the holiday shift types in Planday to your Xero Leave types. Learn more in Map your Planday holiday shift types to your Xero Leave types.

  • Planday will only send the date range of holidays taken to Xero, as we cannot currently send the hours or days of holidays or their monetary value. Therefore, any payment or balances will be handled within Xero.

Note: If you have timesheet export errors when syncing your hours to Xero, check Resolve payroll export errors.


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.

Did this answer your question?