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

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 2

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 3

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 4

Can I use Unscheduled Pay Runs with UpSheets?

Accepted Answer

It is possible to use UpSheets to load data relating to an Unscheduled Pay Run - but it must be created BEFORE the file is validated (or revalidated).

If you do not create the Unscheduled Pay Run in advance, you may receive a 'Date not within current Pay Period' error:

To avoid this error:

Create the Unscheduled Pay Run in Xero covering the period you wish to upload data.
Optional - Add the Employee to the Unscheduled Pay Run by opening it and clicking the Included flag (only required if you wish to load Payslip Adjustments).
Import and Validate your file (or revalidate if you have already imported it).

The validation should now pass as UpSheets can see there is a Pay Run available for the employees.