Your first month is free.Add code at checkout.

Team and HR

Payroll export CSV

Export absence by person for a date range, split into holiday, sick, unpaid and other. Calculations use individual working patterns and bank holidays.

By the LeaveWise teamUpdated

The payroll export produces a CSV of absence by person for a chosen date range. It separates holiday, sick, unpaid and other absence, giving you a file to use in your existing payroll process.

This is an export, not a direct payroll integration. LeaveWise does not currently connect to Xero or another payroll provider to run payroll automatically.

Choose the reporting period

As an admin, open the payroll export and select the start and end dates you need. Use the period your payroll process requires rather than assuming it is the same as the leave year.

Check the dates carefully around month ends. A leave-year report and a payroll-period report may both be correct while covering different records.

Confirm who will review the file and how it will be handled before downloading personal absence information.

Review the source records

Check that relevant absence has been recorded with the correct leave types. Sick leave entered by an admin on someone’s behalf is attributed to that admin in the history.

Review individual working patterns and bank-holiday settings where they affect the period. The export uses those inputs rather than simply counting every calendar date in a booking.

A part-time person’s absence can therefore differ from a full-time colleague’s even if the recorded date range is identical.

Download and check the CSV

Export the selected range and inspect the file in your normal review process. Check a few representative people and any bookings that cross bank holidays or involve unusual working patterns.

The categories distinguish holiday, sick, unpaid and other absence. They do not, by themselves, calculate every pay rule that your organisation or payroll system applies.

Keep any payroll-specific decisions in the appropriate payroll process. Do not describe a leave-day total as a salary forecast.

Use the right export for the question

Leave history can also be exported with working days, approver and who booked the absence. That is useful when you need the decision trail rather than a payroll summary.

Closing a leave year creates a separate CSV archive and closing balances. Use that archive for the year-end record.

If a payroll total looks wrong, inspect the source absence and calculation inputs before editing the exported file as a permanent workaround.

Payroll absence export — LeaveWise screenshot