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.