Question 1

Using UpSheets to Import Data from Subway / LiveIQ

Accepted Answer

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

Using Subway Live IQ to Roster Your Staff?

UpSheets Can Upload Your Data to Xero Payroll in Just a Few Clicks

Easy to Setup and Use
Export from Live IQ + Upload to Xero
Predefined Fast Food Industry Award (FFIA)
Assign Awards to Employees
Automatic Calculations + Overtime/Allowances
No Additional Xero Setup
Multiple Locations on a Single Account
Faster, Easier and Lower Cost than Alternatives
Get Rid of Expensive 3rd Party Rostering Software
Save Time and Money
30 Day Free Trial
Excellent Support

Overview

If you are using Subway LiveIQ Labour to roster your staff, your data can be exported and uploaded to Xero using UpSheets in just a few clicks.

This guide explains the steps required to get started:

Register for an UpSheets Account
Configure settings in UpSheets
Assign awards to employees
Extract file from Subway LiveIQ Labour
Validate the file in UpSheets
Upload data to Xero

1. Register for an UpSheets Account

You can register for an UpSheets account at https://app.upsheets.com/register

No credit card is required and it is free to use for 30 days. You can either create an account using your email address, or log in using your Xero account.

After creating your account, you will be asked to connect UpSheets to Xero. This requires a Xero account with Payroll Administrator access and only needs to be done the first time you use an organisation.

We recommend using a free Xero Demo Company to try things out

https://help.upsheets.com/faqs/using-a-xero-demo-company

2. Configure Settings in UpSheets

To import the Subway LiveIQ export file without having to modify it, configure your settings as below:

Enable Smart Formulas

Navigate to your settings https://app.upsheets.com/settings

Select the Enable Smart Formulas and select Save

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

You will be shown a warning, read it and click I Agree to continue.

Set Default Start Time

A new Start Hour option will now be available. This value is used to calculate start and end times using the single hours column from the export

For example:

Set the Start Hour value for your operation and Save.

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

3. Assign awards to employees

To determine the correct earnings rate and automatic allowances, each employee must have the required smart formula assigned to them.

Please note that this assignment will create a Pay Item in Xero and update the employee pay template and ordinary earnings rate to use it.

Select Smart Formulas from the menu and select Save to accept the default settings:

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

Select Smart Formulas from the menu and then select an employee row, then click Assign.

You can then select an award and enter the base rate for the employee. Click Assign to assign the award/rate to the employee.

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

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

Automated allowances (Minimum Engagement, Laundry etc) can be endabled/disabled br following these instructions.

Repeat these steps for all employees you wish to upload data for.

4. Extract File from Subway LiveIQ Labour

The below assumes that you are using Subway Live IQ Labour as your rostering program and have made and published a roster for your stores. If you are unsure or just starting please reach out to your Business Consultant as they have User Guides to help you.

Log into Subway Live IQ Labour
Go into Payroll – Processing
Action your team members' hours as to pay by timesheet or roster etc
Once actioned and no errors showing, click Save then Finalise at the bottom of the page
Return to the Payroll Processing screen and press Process
Then go into Payroll – Breakdown
At the bottom of this page click on Accounting Software Export (CSV)
This is saved into Downloads (or choose where to save it). If you resave this file, ensure it is saved as a CSV file.

If you are unsure how to do any of the above tasks, please reach out to your Business Consultant for help.

5. Validate the file in UpSheets

From the Import screen in UpSheets, select your exported file and the Timesheets option and click Import File:

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

Make sure each column is mapped correctly and that US Date Format is on (tracking code is only required if enabled in Xero). These options will be remembered for future uploads.

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

Click Validate to check the data against Xero before uploading

The validated data is shown. If any employees or tracking codes do not match what is stored in Xero you can click Create Mapping to create an automatic mapping for future uploads. Alternatively, you can select rows and click Edit to update them. After changes, you may need to revalidate your file before uploading.

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

6. Upload Data to Xero

Once complete simply click Upload to Xero. Any required pay items will be created and the timesheet data will be uploaded to Xero.

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

Useful Links

For more information on the below topics please refer to the links below:

Assigning Smart Formulas:

https://help.upsheets.com/faqs/smart-formulas-upsheets

Automatically Calculate Start and End Times Using Hours

https://help.upsheets.com/faqs/automatically-calculate-start-and-end-times-using-hours

Mapping values between systems:

https://help.upsheets.com/faqs/create-a-mapping-for-employee-type-or-tracking-code

Editing imported data:

https://help.upsheets.com/faqs/editing-imported-files-before-uploading-to-xero

Defining public holidays:

https://help.upsheets.com/faqs/using-public-holidays-with-smart-formulas

Question 2

Managing your connection with Xero (and how to disconnect)

Accepted Answer

You can manage your connection at any time by clicking Manage next to your organisation name in the top right of the screen or selecting Organisations from the drop-down menu.

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

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

To Connect or Disconnect an organisation, click the desired button and UpSheets will connect/disconnect with Xero for you.

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

To permanently disconnect Xero form UpSheets, you must do so in Xero: Settings> Connected Apps> Disconnect App. This will remove all users from having any access to Xero and remove the ability for them to upload any files/data.

Question 3

Uploading Allowances to Payslips

Accepted Answer

This article is intended for Australian Xero users as the setup and features are specific to that region. NZ allowances can be uploaded as usual using Adjustments. UK users can not currently upload Adjustments until it is enabled by Xero (why?).

The way Allowances are uploaded using UpSheets depends on how they are set up as Pay Items in Xero.

Allowances can be uploaded to an employee payslips using the Adjustment option.

Allowances may also 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)

There is no right or wrong way - it depends what makes sense for your business/process. If your pay items are defined in a way to use Timesheets and you don't currently upload payslip Adjustments, then it is likely to be easier to upload them as timesheet.

Pay Item Setup

Below are the various ways Allowance Pay items can be set up in Xero:

Download a sample CSV file

Fixed Amount

A fixed allowance allows you to upload a fixed dollar amount to the payslip for an employee.The upload file must contain the following columns/values:

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/WcCu1A8nX7/payItem1.png (Fixed Amount Allowance Setup)

Rate per Unit

A rate per unit allowance allows you to upload a rate and a unit to the payslip for an employee.The upload file must contain the following columns/values:

Rate Per Unit Allowance Setup

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/kILL7ZuFaF/payItem2.png (Rate Per Unit Allowance Setup)

Rate per Unit (Preset)

A rate per unit allowance allows you to upload the number of units to the payslip for an employee when the rate is set against the Pay Item in Xero.The upload file must contain the following columns/values:

Rate Per Unit Preset Allowance Setup

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/qEcFmL8JA6/payItem3.png (Rate Per Unit Preset Allowance Setup)

Multiple

Multiple Allowances allow you to upload the number of units that are a multiple of the ordinary earnings rate for each employee. These must be uploaded as timesheet lines or a validation will likely occur on the payslip adjustment upload.

Multiple Preset Allowance Setup

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/HeYmhhnPpO/payItem4.png (Multiple Preset Allowance Setup)

Upload/Validation

The Adjustment option is required to upload to a payslip and the payslip must already exist

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

When validated, the above formats will appear as below:

Validated

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

Payslip

Upon upload to the payslip in Xero, the adjustments will appear as below:

Question 4

Can I upload an Excel or Google Sheets spreadsheet?

Accepted Answer

UpSheets can import CSV (Comma Separated Values) files only. Any file you can create or edit using common spreadsheet software can usually be saved in CSV format in just a few clicks.

To save a Microsoft Excel spreadsheet as CSV:

Choose File> Save As> Format: Comma Separated Values(.csv).
Enter a filename and Save the file.

To save a Google Sheets spreadsheet as CSV:

Choose File> Download as> Comma-separated Values(.csv, current sheet).
The file will be downloaded (named after file/sheet name ending in .csv).

The files can then be imported and uploaded to Xero by UpSheets.

Question 5

Update Employee Earnings Rates from CSV File

Accepted Answer

Overview

A CSV file can be used to bulk update Ordinary Earnings Rates for Employees. This is useful for situations where you may be updating the base rates for multiple employees after an annual pay review or similar.

This functionality is currently only available for :

Users with an active subscription
Users in Australia (please contact us if you need this in UK/NZ)

This function only updates the ordinary earnings rate for the employee and does not change any other settings (such as the number of hours or calculation type)

File Format

The file format required can contain any number of columns, but it must contain the following with the header row:

If the file has multiple columns for first_name, last_name they can be easily combined using a formula in Excel such as =CONCAT(A2," ",B2)

Download a sample file

Updating

The process works as follows:

Select the file and click Validate File.

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

The validation results are displayed. If there are any errors, these records will not be loaded. To resolve them, update the file and repeat step 1.

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

Once all records are validated OK, click Update Earnings Rates to update Xero.

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

Question 6

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:

Question 7

How are Leave hours allocated over multiple pay periods?

Accepted Answer

Overview

It is possible for a Leave request to span multiple pay periods, however only the total hours are provided in the file. The following article explains how these hours are distributed in this siuation.

Alternatively, UpSheets can be configured to calculate leave hours automatically to change this behaviour.

Allocation

In order to allocate the hours to multiple periods, the total number of hours are split evenly between each period (in whole hours). If there are any additional hours they are allocated to the total of the first period.

Example 1 - Single Pay Period, 10 Hours

Period one: 01-Jan-2019 to 06-Jan-2019 / 10 Hours

Example 2 - Two Pay Periods, 20 Hours

Period one: 01-Jan-2019 to 06-Jan-2019 / 10 Hours

Period two: 07-Jan-2019 to 13-Jan-2019 / 10 Hours

Example 3 - Three Pay Periods, 20 Hours

Period one: 01-Jan-2019 to 06-Jan-2019 / 8 Hours (This record has the additional 2 hours allocated)

Period two: 07-Jan-2019 to 13-Jan-2019 / 6 Hours

Period two: 14-Jan-2019 to 20-Jan-2019 / 6 Hours

Question 8

Editing Imported Files before Uploading to Xero

Accepted Answer

After importing a file to UpSheets, you have the ability to edit it to correct any errors before uploading. This saves the time of having to edit your original spreadsheet and then importing it again.

Editing/Deleting

To edit an import, select the row(s) you wish to update and click Edit. A form will be displayed to allow you to update the selected row(s).

To remove row(s) from an import, select them and then click Delete. A warning will be displayed and the rows will then be removed.

Selecting Multiple Rows

To select multiple rows that are next to each other, use Shift + Click

To select multiple rows that are NOT next to each other, use Ctl + Click (or Cmd + Click on Mac)