Q: Importing CSV Files

CSV Files 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. Multiple Files Multiple files can be uploaded at once so long as they are all valid and in the same format (identical header fields and in the same order). Use Shift or CTL to select multiple files. Other tips: All files must have First Name & Last Name (or Full Name), Date and Hours columns as these are required to match employees in Xero and create timesheets. A header row is not required, but if it is not in the file, the 'File contains header row?' box should be unchecked (and vice versa). Only timesheets and leave from the next pay period, or a period with a Draft Pay Run can be uploaded. Existing timesheets in Xero can only be updated if in a Draft status. Approved/Processed timesheets must be reverted to Draft in order to upload (NZ/UK users may overwrite these by changing their settings ). All Leave is uploaded as Approved

Question 1

Projects Setup is Incomplete

Accepted Answer

In order to upload Tasks or Time using Xero Projects, you must first complete the required setup.

For detailed information on how to set up Projects check out Xero's website

If you are using the Xero demo organisation, most of the setup is done for you - however, you must manually complete the following step to complete it.

After logging into your Xero organisation, click Payroll > All Projects

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

On the next screen click, Get Started and wait for the next screen to load and you are good to go.

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

In order for UpSheets to know you have enabled Projects, either:

Log back into UpSheets
Disconnect and reconnect your organisation; or
Click the Projects button and click Reconnect to Xero

Question 2

Importing CSV Files

Accepted Answer

CSV Files

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.

Multiple Files

Multiple files can be uploaded at once so long as they are all valid and in the same format (identical header fields and in the same order). Use Shift or CTL to select multiple files.

Other tips:

All files must have First Name & Last Name (or Full Name), Date and Hours columns as these are required to match employees in Xero and create timesheets.
A header row is not required, but if it is not in the file, the 'File contains header row?' box should be unchecked (and vice versa).
Only timesheets and leave from the next pay period, or a period with a Draft Pay Run can be uploaded.
Existing timesheets in Xero can only be updated if in a Draft status.
Approved/Processed timesheets must be reverted to Draft in order to upload (NZ/UK users may overwrite these by changing their settings).
All Leave is uploaded as Approved

Question 3

Missing Type Field

Accepted Answer

Occasionally Xero may be missing some Pay Item setup that needs to be resolved to upload data.

The usual cause of this error is that there are Pay Items that do not have a Type defined. They can easily be seen as they have a warning icon next to them (Navigation: Payroll Settings> Pay Items).

The warning icon can be seen below:

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

Opening it shows the Type field:

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

The Type (and optionally the Category) must be set and the Pay Item saved:

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

THESE STEPS MUST BE COMPLETED FOR ALL PAY ITEMS THAT SHOW THE WARNING ICON

Question 4

How do I add the Pay Runs for the Timesheets I have uploaded?

Accepted Answer

After your upload is completed, you have the option to select any Pay Runs that the timesheets will be contained in and Add them.

To do so, just click the Add Pay Runs button:

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

Select the Pay Runs you wish to add and click Add Pay Runs:

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

A confirmation message will be displayed and the Pay Runs will be available in Xero.

To view them immediately - you Can click the View in Xero: Pay Run button to open Xero in a new window.

Question 5

Using Public Holidays with Smart Formulas

Accepted Answer

Background

Smart Formulas can be used to select different earnings rates on public holidays. In order to do so, they must first be configured in UpSheets (even though Xero has public holidays configured, they are not available publicly).

Basic Setup

To use public holidays, it must first be enabled:

Smart Formulas> Smart Formula Settings> Holidays

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/MXaz7Onx3j/enable%20smart%20formulas.png (enable smart formulas)

Then click Setup Holidays and then Add each holiday to the default calendar

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/jgcT0Zk7dv/add%20holiday.png (add holiday)

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/zro1FGCMN5/calendar%20setup.png (calendar setup)

Once complete click Back to Settings to exit

Default Calendar

As standard, a single Default Calendar is available and automatically assigned to all employees.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/11KhSBg2hM/default%20calendar.png (default calendar)

Using Additional Calendars

If you require more calendars, simply click Add Calendar, give it a name and click Save. You can then add holidays in the same way as usual.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/ah4ZgsVVVe/add%20calendar.png (add calendar)

NOTE: You must add all required dates for each calendar.

When multiple calendars are defined, you can optionally select a calendar for each employee. If some employees do not need a calendar, simply set up a calendar with no holidays and assign it as required.