Map QuickBooks payroll items in QuickBooks Time
by Intuit•11• Updated 8 months ago
Map payroll items to make sure your team is paid correctly for the hours they work. If your employees are paid different rates based on the type of work they do, use overrides to assign pay rates to customers, service items, or classes.
Before you map payroll items:
- You must have an active payroll subscription to use the payroll item mapping tool:
- QuickBooks Online Payroll Premium and Elite: 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.
- For QuickBooks Desktop Payroll: first, set up the QuickBooks Time and QuickBooks Desktop integration, then map payroll items.
- Only account administrators can map payroll items.
- Make sure your employees are set up with payroll items in QuickBooks Online or QuickBooks Desktop.
- If you track overtime, make sure that is set up in your account.
- Vendors and 1099 contractors don’t need mapped payroll items.
How to Map Payroll Items by:
By employee
This is the default setting. For each type of hour your employee tracks, there will be one payroll item assigned to those hours in QuickBooks. Map regular hours, overtime, and time off.
- In QuickBooks Time, select the QuickBooks dropdown, then Preferences.
- Select Payroll Item Mapping Tool.
- On Map Employees, select an employee's name.
- In each hour type column, select one payroll item for each. Selections are saved automatically.
If you use advanced overtime options, you’ll 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.
- In the Pay Rate Engine, look for any setting and rule labeled Unassigned rates.
- 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 your employees are paid differently based on specific customers, service items, or classes, set up the override setting. This applies to hourly employees only. You can only choose one item to assign pay rates to. If an item doesn't have a pay rate assigned to it, time tracked will be the employee’s default pay rates.
- After mapping payroll items by employee, in the Payroll Item Mapping Tool, select Settings ⚙.
- Select the Allow overrides by: box, and select Customer, Service Item, or Class.
- Select Save.
- On the Map Customers, Map Service Items, or Map Classes tab, select + Add Override.
- Choose a customer, service item, or class (whichever displays), then expand the new override option.
- Under each hour type column (e.g., regular and overtime), select a payroll item.
- 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 choice
Have your employees select their payroll items when they clock in and out. Before choosing this option, set up defaults by employee first, so time off is mapped correctly.
Important: Any payroll items selected by the employee on their timesheets will override any overtime calculation account settings. E.g., if an employee has two overtime hours, it’s up to them to select the appropriate payroll item for that overtime timesheet.
To let employees to select their own payroll items:
- In QuickBooks Time, select the QuickBooks dropdown, and select Preferences.
- Select the Payroll Item Mapping Tool, then Settings ⚙.
- Select Let Employees choose Payroll items, then 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•47•Updated May 20, 2024
- Set up QuickBooks Time in QuickBooks Online or QuickBooks Online Payrollby QuickBooks•495•Updated March 15, 2024
- Fix an error when syncing hours between QuickBooks Time and QuickBooks Onlineby QuickBooks•79•Updated January 08, 2024
- Working with time data imported from LMNby QuickBooks•Updated June 26, 2024