Showing results for 
Search instead for 
Did you mean: 
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
6 helpful votes

Error exporting hours between TSheets and QuickBooks

Learn how to fix a payroll mapping error.

TSheets makes it easy to track employees hours and export them to QuickBooks Online for payroll.

Before you export payroll hours, you need to add the type of pay for each employee. If this hasn’t been done for all your employees, you’ll see this error:

Error exporting hours, the user doesn’t have any payroll items assigned. Use the Payroll Item Mapping Tool to assign payroll items to this user and then re-export the time.

To fix this, you’ll use the Payroll Item Mapping Tool in TSheets. This lets you sync payroll items like:

  • Regular time
  • Overtime
  • Double-time
  • Paid Time Off
  • Sick time

Step 1: Assign payroll items in TSheets

  1. Select QuickBooks, then select Preferences.
  2. Select Payroll Item Mapping Tool.
  3. Select the pay type for each employee.
  4. Close the window when you’re finished.

If you need to enter a different type of pay, but you don’t see it in TSheets, go to QuickBooks Online and add it there first.

Step 2: Add a pay type in QuickBooks Online

  1. From QuickBooks Online, select Workers.
  2. Select the employee.
  3. Select + Add additional pay types (like overtime, sick, and vacation pay).
  4. Select the additional pay types you need and add the required info.
  5. Select Done.

After adding the additional pay types, go to TSheets and rerun the Payroll Item Mapping Tool.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us