Question 1

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; and
Be valid for timesheets.

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

Question 2

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:

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.

Missing Xero Smart Formulas

Uploading Smart Formulas with other Types (Earnings Rates)

Not many results?