Q: Default end date and description for leave

Selecting the Default end date and description for leave option in your user settings will cause UpSheets to automatically set the following values on import: The result of this setting being enabled is that you do not need to provide the end_date or description in your file.

Question 1

Overwrite Approved Timesheets

Accepted Answer

****This functionality is only available for users in NZ/UK*

You can allow approved timesheets to be overwritten by selecting the option Allow approved timesheets to be overwritten (NZ/UK Only) in your user settings.

A warning message will then be displayed instead of an error and you can then upload the timesheet.

Question 2

How do I view uploaded Timesheets, Leave, Adjustments or Projects in Xero?

Accepted Answer

After validating or uploading your file, you can open the transaction is Xero by clicking the appropriate button under 'View in Xero'

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/JPgwI43sQH/Screen%20Shot%202020-08-24%20at%2010.30.39%20pm.png (Screen Shot 2020-08-24 at 10.30.39 pm.png)

For NZ and UK organisations, most transactions can be viewed in Xero by clicking on the link in the transaction type column when viewing the upload data.

If you need to make changes in Xero, you can then retry the validation on the current file by clicking 3 : Validate Data in the top of the screen or in the Revalidate button.

Question 3

Can I upload Draft Timesheets or Approve them after upload?

Accepted Answer

Yes.

The default option for uploading timesheets to Xero is a status of Draft. If you would like to upload timesheets with a status of Approved, just select the appropriate radio button when importing your file to UpSheets.

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

Alternatively, you may select the Approve All button after uploading your file to Xero and UpSheets will approve all eligible timesheets for you.

Question 4

Multiple Adjustment Types/Earnings Rates in Xero with the same name

Accepted Answer

This error is shown if you have more than one Pay Item set up in Xero with the same name.

To resolve this, update the pay items (under Payroll Settings> Pay Items> Earnings) to either:

have a different name; or
make the duplicate items inactive so there is only a single active one that matches the file

Once your changes are saved in Xero, you can click Revalidate in UpSheets to validate your file and the error should no longer appear.

Question 5

Default end date and description for leave

Accepted Answer

Selecting the Default end date and description for leave option in your user settings will cause UpSheets to automatically set the following values on import:

The result of this setting being enabled is that you do not need to provide the end_date or description in your file.

Question 6

How can I load Earnings Adjustments as Timesheets in the same file

Accepted Answer

When loading Timesheets and Earnings Adjustments in the same file, UpSheets will assume the Earnings lines are meant to be treated as Earnings Adjustments, not timesheets. If you wish the opposite to happen, you can either load the file without the Adjustment option selected as below:

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

Or alternatively, choose Setting from the top-right menu and select Prefer timesheets not adjustments. When any lines are loaded, they will now be treated as Timesheets and not Adjustments.

Question 7

Can I upload timesheets that are after the current pay period for the employee?

Accepted Answer

Unfortunately not, this is a limitation of Xero.

You can only create/update timesheets for the employee's next pay run or for the period of an existing Draft Pay Run.

In order to add timesheets for the next period, you must first create the current pay run.

Question 8

Calculate Leave Hours Automatically

Accepted Answer

Overview

Enabling this function will let UpSheets calculate leave hours using the employee setup in Xero and the working days in the given period. The hours column becomes optional and if included will override the calculated value.

Setup

To enable this function, select the Leave Hours option in your user settings and save.

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

Note: In order for this function to work, the Pay Item for Annual Leave must be named Annual Leave. If you have modified this value, please contact us.

Defaulting Leave Hours

When importing a file that includes Leave, the Hours column will display as Hours* and be optional.

If a value is provided in this field for any lines in a file, UpSheets will use this value. For all lines that do not have a value, UpSheets will calculate the hours automatically.

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

When the file is validated, the number of hours is calculated automatically.

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

The calculation is made using the employee setup in Xero and uses the number of working days between the date and end_date of the imported line.