Map QuickBooks payroll items in QuickBooks Time
by Intuit• Updated 8 months ago
Before you can export any hours from QuickBooks Time 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
Initial payroll item mapping is performed during setup of the QuickBooks Time and QuickBooks Online integration. Use the directions below if you want to change your previously mapped payroll items.
Select the Use QuickBooks Online for payroll box in the QuickBooks Online Integration Preferences to enable this option.
QuickBooks Desktop
First, set up the QuickBooks Time and QuickBooks Desktop integration, then map payroll items.
Important: Before performing a sync, be sure you are logged in to QuickBooks Desktop as the administrator and in single-user mode.
In this article, you'll learn how to map payroll items:
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 QuickBooks Time, enable overtime tracking: Company Settings > Payroll & Overtime > Overtime (or use the Pay Rate Engine for more advanced overtime options).
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.
- In QuickBooks Time, at the top right, select QuickBooks, then Preferences.
- Select the Payroll Item Mapping Tool.
- On the Employee Map tab, choose an employee's name.
- In each hour type column, select one payroll item for each. Selections are saved automatically.
- (Optional) To download a spreadsheet, select 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, 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
- Choose 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 QuickBooks Time, at the top right, select the QuickBooks dropdown, then Preferences.
- Select the Payroll Item Mapping Tool.
- In the right corner of the Payroll Item Mapping Tool, select the Gear icon to open the settings.
- Select the Allow overrides by: box, and select Customer, Service Item, or Class.
- On the Customer Map, Service Item Map, or Class Map tab, select + Add Overrides.
- Select none under Select Customer/Service Item/Class (whichever displays).
- Choose a Customer, Service Item, or Class and select 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 QuickBooks Time, at the top right, select QuickBooks, and select Preferences.
- Select the Payroll Item Mapping Tool.
- In the right corner of the Payroll Item Mapping Tool, select the Gear icon to open the settings.
- Select Let Employees choose Payroll items.
- Select Save.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- About QuickBooks integration preferences in QuickBooks Timeby QuickBooks•Updated May 20, 2024
- Set up QuickBooks Time in QuickBooks Online or QuickBooks Online Payrollby QuickBooks•9•Updated March 15, 2024
- Fix an error when exporting hours between QuickBooks Time and QuickBooksby QuickBooks•Updated January 08, 2024
- Run payroll reportsby QuickBooks•12•Updated 1 month ago