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.
QuickBooks Online Plus, Essentials, or Advanced: Initial payroll item mapping is performed during setup of the TSheets and QBO integration. Use the directions below if you want to change your previously mapped payroll items.
Check the Use QuickBooks Online for payroll box in the QuickBooks Online Integration Preferences to enable this option.
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).
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 time off codes that you have set up.
In TSheets, at the top right, click QuickBooks, and select Preferences.
Click the Payroll Item Mapping Tool button.
On the Employee Map tab, click an employee's name.
In each hour type column, select one payroll item for each. Selections are saved automatically.
(Optional) To download a spreadsheet, click Employee CSV.
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, click 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
Click 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.
After mapping payroll items by employee, in TSheets, at the top right, click the QuickBooks dropdown, and select Preferences.
Click the Payroll Item Mapping Tool button.
In the right corner of the Payroll Item Mapping Tool, click the gear icon to open the settings.
Check the Allow overrides by: box, and select Customer, Service Item, or Class.
On the Customer Map, Service Item Map, or Class Map tab, click + Add Overrides.
Click none under Select Customer/Service Item/Class (whichever displays).
Pick a Customer, Service Item, or Class and click Save.
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.
Repeat until each Customer, Service Item, or Class is mapped appropriately.
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:
In TSheets, at the top right, click QuickBooks, and select Preferences.
Click the Payroll Item Mapping Tool button.
In the right corner of the Payroll Item Mapping Tool, click the gear icon to open the settings.
