Uploading Duplicate Leave Requests

Default Behaviour

By default, each leave request row in your upload file will be validated separately. If you have multiple leave request lines with the same employee, leave type, start date, and end date, only the first line will be processed and the subsequent duplicate lines will be marked as errors.

For example, if your file has the following lines, only the first leave request of each type will be uploaded:

Employee Type Start Date End Date Hours
Sarah Annual Leave 01/01/2024 03/01/2024 8
Sarah Annual Leave 01/01/2024 03/01/2024 8
Sarah Sick Leave 05/01/2024 05/01/2024 7.5
Sarah Sick Leave 05/01/2024 05/01/2024 2.5

To Allow Duplicates

Go to your user settings, select the option Sum totals for duplicate leave requests and save.

When this setting is enabled, it will add up the hours for all duplicate leave requests with the same employee, leave type, start date, and end date, and upload a single leave request in Xero with the combined total hours.

You will receive an informational message during validation to indicate the totals will be summarised. You can turn this feature on and off at any time by updating your user settings.

For example, if your file has the following lines:

Employee Type Start Date End Date Hours
Sarah Annual Leave 01/01/2024 03/01/2024 8
Sarah Annual Leave 01/01/2024 03/01/2024 8
Sarah Sick Leave 05/01/2024 05/01/2024 7.5
Sarah Sick Leave 05/01/2024 05/01/2024 2.5

Will be uploaded as follows:

Employee Type Start Date End Date Hours
Sarah Annual Leave 01/01/2024 03/01/2024 16
Sarah Sick Leave 05/01/2024 05/01/2024 10

Note: All duplicate lines in your file will be marked as uploaded and included in your billing, even though only a single combined leave request is created in Xero.