Question 1

Is it safe to connect to Xero / Can you see my password?

Accepted Answer

UpSheets connects to Xero using OAuth, which requires you to login to your Xero account and approve the connection.

UpSheets does not see, or store your Xero login details and has no access to your Xero account after you have finished using it.

After clicking connect - You can verify that you are indeed logging into Xero by looking at the address in your browser when you are redirected to login - it will be on the xero.com domain:

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

All data transmitted between you, UpSheets and Xero is secured using industry standard HTTPS/TLS encryption.

Question 2

No Payslip found for Employee/Period

Accepted Answer

To upload payslip adjustments a payslip must already exist in Xero. UpSheets will upload the data to the draft pay run for the employees pay calendar.

To resolve this error, simply create a pay run in Xero and revalidate your file.

If using an unscheduled pay run, be sure to open the pay run and select the employees you wish to upload data for as payslips are not automatically created for employees on unscheduled pay runs.

Question 3

Uploading Smart Formulas with other Types (Earnings Rates)

Accepted Answer

Setup

The default behaviour when using smart formulas is to treat all lines as smart formulas. This is shown in the smart formla settings as Allow Types:

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/8jCYN3OMxx/allow%20types.png (allow types)

If you wish to upload nother earnings types along with this, select the option Allow All Types and Save

Types

For this feature to work, you must supply a Type column in your file to match against your Xero pay items. Any Types that match this column (or have been mapped to one) will be treated normally and not processed as a Smart Formula.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/KoSXHAVvpw/type%20selection.png (type selection)

Hours

You can optionally select an Hours column to use values from another column than the start/end times.

If a value is present in the hours column, this will be used for the non smart formula types. If no value is present, the start/end times will be used to calulate it. If they are missing an error will be given.

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

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 6

Rate Types when Uploading Earnings Lines to Timesheets

Accepted Answer

Earnings Pay Items may be uploaded as timesheets so long as they:

Have a rate type of Multiple

OR

Have a Have a **rate type **of Rate Per Unit; and
The type of units matches the value on the ordinary earnings rate set for the employee.

E.g. For an employee who has an ordinary earnings rate set to Ordinary Hours (Ttpe of unit = Hours), you can load:

Any earnings pay item with a unit of hours
Any earnings pay item with a rate type of Multiple

If you were to try and load an earnings pay item with type of unit set to Days, an error will be given.

***Timesheets: Pay Item must have a MULTIPLE Rate type OR have a unit of Hours (not Days)

Question 7

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 8

Missing Xero Smart Formulas

Accepted Answer

In order for Smart Formulas to be imported into UpSheets from Xero the pay item in Xero must:

Match the format described here;
Be assigned to the pay template of an active employee;
Be valid for timesheets; and
Do not contain extra spaces between paramaters ([EVERY][0.0~7.6][0-2] NOT [EVERY] [0.0~7.6] [0-2])

The easiest way to check if a pay item is valid for timesheets is to add a new timesheet in Xero (Payroll> Timesheets> Add Timesheet) and check that it is available in the dropdown.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/AmR1nN5Vqi/timesheet%20dropdown.png (timesheet dropdown)

If they are not visible it is usually because they are not active, or because they are set up as an allowance. Allowances may be uploaded as timesheets if they:

Have a Rate Type = Multiple; or
Have a Rate Type = Rate per unit and Type of units = hours
Have a Rate Type = Rate per unit and Type of units = The same time unit used for the Ordinary Earnings Type of the Employee (Days/Weeks etc)

See here for more information