Find answers in our knowledge base
 
Xero
Article

How To Integrate TSheets and Xero in Australia

« Go Back

Article Detail

 
Rich Text Description

Note: This Xero Integration article is for Australian customers and includes both Payroll and Invoicing setup instructions. If you are a customer in the US or another country, go to How to Integrate TSheets and Xero in the US and Other Countries.

Before You Begin:

  • You can only connect one TSheets account to one organisation.
  • If you have not already, in Xero, add employees, customers, contacts, and inventory items.
  • If Customers were manually added in TSheets before integrating, make sure the Customer name matches exactly between the systems before your first import.
  • If Employees were manually added in TSheets before integrating, make sure their First name, Last name, and email if applicable match exactly between the systems before your first import.
  • If you will be exporting hours worked to Xero to be included in payroll, before installing the Xero Integration in TSheets, make sure you have set up payroll in Xero.
  • If employees may be paid time and a half or double time, in Xero, set up those pay items, and assign them to the employees pay templates. Then, in TSheets, enable overtime tracking (Company Settings > Payroll & Overtime > Overtime).
    • If you use the Pay Rate Engine for more advanced overtime options, you will need to map any overtime payroll items within the Pay Rate Engine settings (See below for instructions)


Xero Integration How-To Video:


Set Up the Integration:

  1. In TSheets, go to Feature Add-ons > Manage Add-ons.
  2. Scroll down to Xero and click Install.
  3. In the Xero Integration Preferences window, choose your country.
  4. If you are planning to run payroll, make sure that Do you have Payroll enabled in Xero? is selected.
  5. Click Connect to Xero.
  6. In the Authorise Application window, select your organisation, and click Allow Access.
  7. In the Connect window, click Next.
  8. In the Import Options window, make your selections:
    • Archive: Selecting any of the archive options removes non-matching employees, customers, and/or inventory items from TSheets. If this was selected by accident, they can be retrieved by contacting TSheets Support.
    • Import customer from Xero: Select this to import your customer list for employees to track time against. Contacts that also need to be added as Customers can be imported via preferences later (see below for steps). Note: If available, the customer's address will also sync into TSheets for the Nearby Jobs functionality.
    • Assign all imported customers to all employees: Selecting this allows employees to see the full customer list. You can uncheck this and manually assign specific customers to specific employees later, if desired.
    • Import inventory items from Xero: Selecting this will allow employees to select from these items on their timesheets. These items then appear on invoices and TSheets reports. All inventory items will import into TSheets except those marked as "I track this item" in Xero.
    • Require employees to select an inventory item: When employees clock in or switch customers, they will be required to select an inventory item on that timesheet.
  9. Click Start Import.
  10. If you have set up a category in Xero labeled "Timesheet Categories", that list will automatically import as a required, selectable list on employee timesheets.
  11. Click Assign Rates if you are prompted to assign overtime rates. See below for more help.


Adding Xero Contacts as Customers in TSheets

Customers (contacts that have been invoiced) are automatically added during import, but contacts must be added this way:
  1. In TSheets, click Xero > Preferences > Manage Xero Customers.
  2. Find and select the Xero contacts you want imported in as TSheets customers.
  3. Click Add Customers.


Adding Xero Contractors/Suppliers in TSheets

Only employees are imported into TSheets from Xero. However, if you have contractors/suppliers that need to track their time against customers for your invoices, you can manually add them in TSheets:

  1. Go to Employees > Add Employee
  2. You will get a notice that this employee that you add will not show up in Xero. Click Add only in TSheets.
The new user (contractor/supplier) will track their time as normal. Their timesheets will appear on invoices for the associated customers.


Overtime Pay Item Mapping

Pay Items will be automatically mapped to the appropriate time types (Regular, Overtime, etc.). If you use more advanced overtime calculations, you will need to map the correct Pay Items to each Overtime Rule.

  1. Go to Feature Add-ons > Pay Rate Engine.
  2. Any Setting that has unmapped rules, and any rule that is unmapped, is indicated by User-added image.
  3. Click on a rule to map it. Any Overtime pay item from Xero will appear in a dropdown next to XERO PAY ITEM.


Import Employees, Customers, Contacts, and Inventory Items

If you added, edited, or deleted an employee, customer/contact, or inventory item in Xero, make sure you update it in TSheets: click Xero > Import.

See also:


Need help? We’re here for you.
Phone
Mon-Fri, 5am – 9pm MST
Sat – Sun, 8am – 5pm MST
Chat with us!
us: +1 (888) 836-2720
au: +1 (800) 989-143
uk: +44 (808) 164-0610

Was this document helpful?

 
   

Sorry this document wasn’t helpful. How can we improve it?

Characters Remaining 255