Uploading multiple timesheets for the same employee / date / earnings rate / tracking code?

Duplicate Timesheet Lines

A timesheet line is considered a duplicate if it has the same Employee, Date and Earnings Rate (and optionally Tracking Code) as another line in your upload file.

How these lines are treated when uploading depends on the option selected in your user settings.

When this setting is changed it will apply immediately to the next performed by your user.

Each option is described in detail below:

First Line Only (Default Behaviour)

Each row in your upload file should be unique between the employee, date and optionally earnings rate and tracking code if you are using them.

If you have a duplicate, the first row in the file will be uploaded, but the duplicate(s) will be marked as errors and ignored.

Individual Lines

Each line in your file will be loaded even if there is a duplicate. You will end up with multiple rows for the same Earnings/Tracking Code for the employee.

For example, if there are two lines for John Smith on 1-Jan-2018 for 1 hour and 4 hours, two lines will be created in Xero for John Smith on 1-Jan-2018 for 1 hour and 4 hours.

You will receive a warning at validation to indicate the lines will be loaded individually.

Summarise Lines

The total hours for all duplicate records will be calculated and uploaded as a single timesheet line in Xero.

For example, if there are two lines for John Smith on 1-Jan-2018 for 1 hour and 4 hours, a single line will be created in Xero for John Smith on 1-Jan-2018 for 5 hours.

You will still receive a warning to indicate the totals will be summarised.