Created with Sketch. Visit the QuickBooks Community to find answers and meet other small business owners just like you!

Created with Sketch.

Showing results for 
Search instead for 
Did you mean: 

Export hours from TSheets to Xero

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, select 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 select 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, select Approve.
    • To approve all timesheets, select the Check all unapproved checkbox > Approve Selected Users.
  4. Select Export Approved to Xero.
  5. In the Export Time pop-up, select 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

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us