Question 1

Payroll Setup is Incomplete

Accepted Answer

In order to use Xero Payroll, you must set it up correctly. If the setup is incomplete, UpSheets will ask you to check your payroll settings and retry.

Check your Xero User

If you have updated the Xero user who was originally used to connect UpSheets, this may be the cause. If the user has changed permissions or details it may be necessary to try and reconnect to Xero again to refresh the connection. This must be done with a Xero user with Payroll/Projects access -Click here for instructions

If Using a Xero Demo Org

The most common scenario in which this occurs is when a new demo organisation is used. Payroll setup is complete, except for the final step of viewing the overview page. Xero has made this mandatory before you can use Payroll.

To resolve it - simply navigate to the Payroll> Overview page and wait for it to load and reconnect your organisation (or login to UpSheets again).

Payroll Setup Nav

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/UXDk1oB2VQ/setup1.png (Payroll Setup Nav)

Question 2

Using Start Time and End Time instead of Hours

Accepted Answer

Most file formats require a column for Hours in order to upload data, but it is also possible to provide a Start Time and End Time column and have UpSheets calculate the hours automatically.

To do so, select the Enable Start/End Times option on the Import screen when importing your file:

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/3hKtDQmL6g/start_end.png (start_end)

On the following screen make sure you select columns for Start Time and End Time. You may optionally also select a column for Hours* which will be used if the Start Time and End Time are not set.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/AdXfkcueFe/times.png (times)

If all fields are provided, the Start Time and End Time will be used instead of Hours

Question 3

Can I upload multiple timesheets for the same employee / date / earnings rate / tracking code?

Accepted Answer

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.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/7pjhViYKvc/dupes_option.png (dupes_option)

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.

Question 4

Timesheet Date Formats

Accepted Answer

Dates can be imported to UpSheets in a number of formats. If there is an issue, you may see one of the following errors:

Invalid Date - Check your CSV file or try changing the date format checkbox on the Validate Data Page

If you see this error UpSheets has been unable to understand the provided date format. If your dates are in a US format (mm/dd/yyyy) you can select the US Date Format (m/d/y)? option on the validate screen.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/2OshXF9uFL/us_date_format.png (us_date_format)

End Date must be equal to or greater than Date

If the end_date is provided, it must be the same as or after the date field for each line. To resolve this, correct the end date in the file.

Date can not be before the employee start date

Data cannot be uploaded for a date earlier than the start date for the employee. To resolve this, either update the date in the file to be after the start date of the employee or alter the employee start date in Xero to be earlier than the date in the file.

Date must be on or after the current Draft Pay Run / Date must be on or after the Start Date of the current Pay Period

The date in your file must not be in the past, it must be after the start of the current draft pay run. If you need to load data for a prior period, this may be possible by creating an Unscheduled Pay Run in Xero. Because only one draft pay run can exist at a time for each calendar, the Unscheduled pay run will be treated as current and it will be possible to upload data for it.

The Timesheet period has not started yet

In NZ/UK data cannot be loaded until the pay period has started.

Question 5

File Formats for Timesheets, Leave and Adjustments (NZ & UK)

Accepted Answer

UpSheets allows you to upload the following transactions to Xero:

Timesheets
Leave (Approved)
Adjustments (Payslips) NZ Only - not Available in UK
- Earnings
- Reimbursements
- Deductions
- Leave Accruals

Please note Adjustments/Payslips are not available for United Kingdom Xero organisations

The file format for Timesheets, Leave and Deductions are provided below.

You may include any/all of the supported transaction types in the same file. You just need to provide correct data in appropriate columns and select them when uploading. See LINK File Formats for Combined Timesheets, Leave and Adjustments in a Single File (NZ & UK) for examples.

Selecting Options

After connecting to Xero, select the appropriate options on the Import CSV File screen:

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/Cy2IwNTK8g/9.png (9.png)

Notes on file formats

Clicking the Download Sample button on the Import screen will download a file with your Xero data in it and is the easiest way to get started.
A header row is not required, but it will save you time as UpSheets matches the headings automatically where possible and saves you from selecting them individually.
The order of the columns in your file does not matter.
Extra columns will be ignored, but it is faster if they are removed.
You can combine multiple transaction types (Timesheets/Leave/Adjustments) by including all fields in a single file.

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

Rate and Hours for Adjustment Types

The fields values that required in an upload file depend on the type of adjustment being uploaded as described in the table below.

All adjustments require the same file format and ALL fields must be included in the file, even if left blank. This enables you to upload multiple adjustment types in a single file and process them at once.

For example, the Hours column is required even when loading a deduction or reimbursement but the value should be left blank as per the table below. Likewise, Earnings still require the Calculation Type column, even though the value would be left blank.

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

You may optionally provide a Start Time and End Time column instead of the Hours column

For information on saving spreadsheets as CSV files see here

Question 6

File Formats for Projects (All Countries)

Accepted Answer

UpSheets allows you to upload the following Payroll transactions to Xero:

Tasks (Create or update existing)
Time (Create only)

Selecting Options

After connecting to Xero, select the appropriate options on the Import CSV File screen:

Projects Options

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/ME2fL6xMMW/8.png (Projects Options)

Notes on file formats

Clicking the Download Sample button on the Import screen will download a file with your Xero data in it and is the easiest way to get started.
A header row is not required, but it will save you time as UpSheets matches the headings automatically where possible and saves you from selecting them individually.
The order of the columns in your file does not matter.
Extra columns will be ignored, but it is faster if they are removed.
You can combine multiple transaction types by including all fields in a single file (Download Sample).

Task File Format

(Download Sample)

Time File Format

(Download Sample)

You can combine multiple transaction types by including all fields in a single file (Download Sample).

For information on saving spreadsheets as CSV files see here

Question 7

File Formats for Combined Timesheets, Leave and Adjustments in a single file (Australia)

Accepted Answer

UpSheets allows you to upload multiple different transaction types in a single file, so long as all of the required fields are included.

For more information on individual file formats see File Formats for Timesheets, Leave and Adjustments (Australia)

NOTE: All columns must be included in the file, even if their values are left blank. This is required to keep formats consistent and allow UpSheets to determine the type of transaction being uploaded automatically.

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

Timesheet, Leave and Adjustment file Format - Combined

(Download Sample)

Timesheet and Adjustment file Format - Combined

(Download Sample)

Timesheet and Leave file Format - Combined

(Download Sample)

Leave and Adjustment file Format - Combined

(Download Sample)

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

You may optionally provide a Start Time and End Time column instead of the Hours column

Question 8

Defaulting the Rate for Payslip Adjustments from Xero

Accepted Answer

Setup

When validating paylsip adjustments and the rate field is not provided in the file, UpSheets can try to retrieve this from Xero if it is defined on a pay template for the employee.

This feature requires each payslip to be retrieved individually and will slow down the validation of your data (the more employees you have the more noticeable this will be). For this reason, the feature must be explicitly enabled in your user settings.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/mrmWFAZt1L/Pay%20Template%20Setting.png (Pay Template Setting)

The following errors relate to this type of upload

Rate is required if Rate Per Unit not set on the Pay Item in Xero

If Use Xero Pay Template Rates for Payslip Adjustments IS NOT enabled, this error is displayed when the rate is not provided in the file and it is also not set on the pay item itself. To resolve it, simply add the rate to the pay item, or the file and revalidate.

Rate is required if Rate Per Unit not set on the Pay Item or Pay Template in Xero

If Use Xero Pay Template Rates for Payslip Adjustments IS enabled, this error is displayed when the rate is not provided in the file and not set on the employee's pay template and it is also not set on the pay item itself. To resolve it, simply add the rate to the pay item, pay template or the file and revalidate.

Revalidating

If you have updated the pay template or payslip for an employee, you must select the option to refresh payslips when revalidating the file as shown below: