cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

Map QuickBooks payroll items

Before you can export any hours from TSheets to QuickBooks, you must use the Payroll Item Mapping Tool to assign payroll items to your hours; otherwise, QuickBooks won't accept them.

Notes:

  • Only account administrators can map payroll items.
  • If employees may be paid overtime or double time, make sure the employees are assigned the appropriate payroll items in QuickBooks. Then, in TSheets, enable overtime tracking: Company Settings > Payroll & Overtime > Overtime (or use the Pay Rate Engine for more advanced overtime options).

How to Map Payroll Items by:

By employee

If you would like a default payroll item assigned for each type of hours your employees' track, use the Payroll Item Mapping by Employee option. This means that for all regular hours tracked per employee, there will be one payroll item assigned to those hours in QuickBooks. For all overtime hours tracked per employee, there will be one payroll item assigned to those hours in QuickBooks. This can be done for regular time, overtime, double-time, and any PTO codes that you have set up.

  1. In TSheets, at the top right, select QuickBooks, then Preferences.
  2. Select the Payroll Item Mapping Tool.
  3. On the Employee Map tab, choose an employee's name.
  4. In each hour type column, select one payroll item for each. Selections are saved automatically.
  5. (Optional) To download a spreadsheet, select Employee CSV.
  6. Close the window once finished.

Note: If you use the Pay Rate Engine for more advanced overtime options, you will need to map any employee overtime payroll items within Pay Rate Engine Settings:

  • In the Payroll Item Mapping Tool, select Manage next to the Overtime rule name in the employee payroll item details. (Note: the mapped items will be visible in the Payroll Item Mapping Tool, but cannot be changed there.)
  • Any Setting that has unmapped rules, and any rule that is unmapped, is indicated by User-added image
  • Choose on a rule to map it. Any Overtime pay item from QuickBooks will appear in a dropdown next to QuickBooks pay item.

By customer/service item/class

If you prefer to assign payroll items based on specific customers, service items, or classes, you first need to set an employee default for any customer/service item/class that remains unmapped. Then set the override setting by your preferred criteria.

  1. After mapping payroll items by employee, in TSheets, at the top right, select the QuickBooks dropdown, then Preferences.
  2. Select the Payroll Item Mapping Tool.
  3. In the right corner of the Payroll Item Mapping Tool, select the Gear icon to open the settings.
  4. Select the Allow overrides by: box, and select Customer, Service Item, or Class.
  5. On the Customer Map, Service Item Map, or Class Map tab, select + Add Overrides.
  6. Select none under Select Customer/Service Item/Class (whichever displays).
  7. Choose a Customer, Service Item, or Class and select Save.
  8. Under each hour type column, select one payroll item each.
    Note: If you use the Pay Rate Engine for advanced overtime, each overtime setting and its rules will display. They can be mapped here.
  9. Repeat until each Customer, Service Item, or Class is mapped appropriately.
  10. Additions and changes are saved automatically. Close the window when the mapping is complete.

By employee selection

If you would prefer not to do any mapping and have your employees select their payroll items when they clock in and out, you can set this up on your account.

Note: Any Payroll Items selected by the employee on their timesheets will override any overtime calculation account settings. For example, even though an employee might have two hours of overtime for the week displayed in the reports and export details, it is up to the employee to select the appropriate payroll item for overtime on that timesheet in order to get paid the overtime rate.

To allow employees to select their own payroll items:

  1. In TSheets, at the top right, select QuickBooks, and select Preferences.
  2. Select the Payroll Item Mapping Tool.
  3. In the right corner of the Payroll Item Mapping Tool, select the Gear icon to open the settings.
  4. Select Let Employees choose Payroll items.
  5. Select Save.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us