Find answers in our knowledge base
 
Gusto
Article

How to Import from and Export to Gusto

« Go Back

Article Detail

 
Rich Text Description

These procedures assume that you have already Integrated TSheets and Gusto.

Import

  • Only employees and pay periods import from Gusto. Vendors/Contractors do not import. 
  • Any new employee that needs to track time must be added in Gusto first, and then imported into TSheets.

To import from Gusto:

  1. In TSheets, from the top right Gusto drop-down, click Import.
  2. Click OK > Done.

 

Export

  • Gusto only accepts regular hours, overtime, and paid time off. 
  • Only hourly employees' time is exported, not time associated with salaried employees or vendors/contractors.
  • Because Gusto only accepts vacation time and sick time, all other TSheets PTO codes will be combined and exported as vacation time.
  • Future timesheets can be exported to Gusto, as long as that time has been approved.
  • TSheets only exports time for completed weeks, not partial weeks.
  • As long as payroll has not been completed in Gusto, time in TSheets can be unapproved, timesheets added, reapproved, and re-exported.
  • Time exported from TSheets replaces any time for that same employee and workday that had previously been entered in Gusto, including replacing positive amounts with zero.

To export hours worked to Gusto:

  1. In TSheets, from the top right Gusto menu, click Export Time.
  2. Select a pay period, and click OK > Continue.
  3. On the approval report that displays, select Approve All or check the box(es) to the left of employees' names, and click Approve.
  4. Click Export to Gusto.

 

Troubleshooting 

If you find that Gusto is requiring you to submit partial hours worked before the end of the pay period:

  1. In Gusto, go to Company Details.
  2. Click Pay Schedule > Edit.
  3. Change the schedule, select Work Done Period, and set your Pay Date as X days (we recommend 3-4 to account for weekends and holidays) after the Work Done Period.
  4. Click Save.

When setting up an export, if the desired pay period is not displayed:

  1. If you are not your company's account manager, contact that person to make sure that it's ok to cancel a payroll period.
  2. In Gusto, go to Payroll History.
  3. Hover over the date, and click Cancel.

See also:

 

Need help? We’re here for you.
Phone
us: +1 (888) 836-2720
au: +1 (800) 989-143
uk: +44 (808) 164-0610
Email
Reply within: 1-4 hours
Have a suggestion?

Was this document helpful?

 
   

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

Characters Remaining 255