Find answers in our knowledge base
 
QuickBooks
Article

How to Map QuickBooks Payroll Items

« Go Back

Article Detail

 
Rich Text Description
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 > Advanced > Time Options > 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, click QuickBooks, and select Preferences.
    2. Click the Payroll Item Mapping Tool button.
    3. On the Employee Map tab, click 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, click 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:manage overtime button

    • 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 User-added image
    • 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.

    1. After mapping payroll items by employee, in TSheets, at the top right, click the QuickBooks dropdown, and select Preferences.
    2. Click the Payroll Item Mapping Tool button.
    3. In the right corner of the Payroll Item Mapping Tool, click the gear icon to open the settings.
    4. Check the Allow overrides by: box, and select Customer, Service Item, or Class.
    5. On the Customer Map, Service Item Map, or Class Map tab, click + Add Overrides.
    6. Click none under Select Customer/Service Item/Class (whichever displays).
    7. Pick a Customer, Service Item, or Class and click 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, click QuickBooks, and select Preferences.
    2. Click the Payroll Item Mapping Tool button.
    3. In the right corner of the Payroll Item Mapping Tool, click the gear icon to open the settings.
    4. Select Let Employees choose Payroll items.
    5. Click Save.
     

    Need help? We’re here for you.
    Phone
    us: +1 (888) 836-2720
    au: +1 (800) 989-143
    uk: +44 (808) 164-0610
    Email
    Reply within: 1-4 hours
    Have a suggestion?

    Was this document helpful?

     
       

    Sorry this document wasn’t helpful. How can we improve it?

    Characters Remaining 255