Find answers in our knowledge base

TSheets + Xero Integration: How to Export Hours to Xero

« Go Back

Article Detail

Rich Text Description

Before exporting timesheets for payroll:

  • Payroll for Xero is only available in Australia. 
  • If employees may be paid time and a half or doubletime, in Xero, set up those pay items, and assign them to the employees pay templates. In TSheets, enable overtime tracking (Company Settings > Payroll & Overtime > Overtime).
  • The names of time off codes must match in TSheets and Xero for hours to export correctly.
  • The export only includes hourly employee timesheets, not exempt employees. Time off is exported for both hourly and exempt employees.
  • For payroll purposes, only employees who have tracked time during the selected pay period display.

How to Export Timesheets:

  1. First, do one of the following:
    • At the top right of TSheets, click Xero > Export Time.
    • Go to Reports > Approvals.
  2. In the next window, select a pay period (if a drop-down displays) and a date range, and click OK, continue. Note: If you are accessing the approvals report from the left hand menu, when selecting a pay period, make sure that the name is preceded by "By Xero."
  3. On the Approvals Report, do one of the following:
    • To approve individual timesheets, click Approve.
    • To approve all timesheets, click the Check all unapproved checkbox > Approve Selected Users.
  4. Click Export Approved to Xero.
  5. In the Export Time pop-up, click Yes, Export.

How to View the Time In Xero:

  1. Go to Payroll > Timesheets
  2. The most recent pay period's worth of time will display for each employee, as well as the status. Time exported from TSheets displays as Approved. Time for which pay run has been run will display as Processed.
  3. If time needs to be edited and re-exported, the time must be reverted from Approved to Draft in Xero: go to Payroll > Timesheets > select a timesheet > Revert to Draft. Unapprove and edit the time in TSheets as needed, reapprove, and re-export.

See also: TSheets + Xero Integration Frequently Asked Questions

Need help? We’re here for you.
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