Skip to main content
C
caseyjtaylor
May 11, 2021
Solved

Assign a different pay rate by project by employee

  • May 11, 2021
  • 1 reply
  • 0 views

I have a particular project set up in QBO where employees working on this project will be earning a different wage than regular (prevailing wage).  I have created the additional pay rate for each applicable employee within their profile.  Now, I need to be able to assign this pay rate to the project in QuickBooks Time so that when the hours are exported back to QBO, the correct pay is assigned for just the applicable hours and is tied back to the project expenses.  Generally, an employee is not spending an entire pay period working on this one project, so I can't just map the Prevailing Wage rate that I created to the Regular time field of the Payroll Item Mapping Tool.

Best answer by K_Siman

Good afternoon, @caseyjtaylor! Welcome to the Community and thank you for bringing your question here. I'd love to help you out with this!

 

What I believe you're describing is something in the Payroll Mapping window called Map Overrides. What this means is your employees are paid at their regular pay rate unless they choose one of the designated customers/projects. Then, they'll get paid at the rate you mapped for that customer. Here's how to set this up:

  1. After you've mapped payroll items by employee in QuickBooks Time, in the top right, select the QuickBooks dropdown, then Preferences.
  2. Select the Payroll Item Mapping Tool.
  3. In the right corner select the Gear icon to open the settings.
  4. Select the Allow overrides by: box, and select Customer.
  5. On the Customer Map, select + Add Overrides.
  6. Click on none under Select Customer.
  7. Choose a Customer and then Save.
  8. Under each hour type column, select one payroll item each.
  9. Choices are saved automatically. Close the window when the mapping is done.

I'm also attaching this video to walk you through those steps as well: Payroll Item Mapping: By Customer/Services/Classes.

 

If you have any questions or need clarification, please reply to this post. I'm happy to help!

1 reply

K_Siman
K_SimanAnswer
May 11, 2021

Good afternoon, @caseyjtaylor! Welcome to the Community and thank you for bringing your question here. I'd love to help you out with this!

 

What I believe you're describing is something in the Payroll Mapping window called Map Overrides. What this means is your employees are paid at their regular pay rate unless they choose one of the designated customers/projects. Then, they'll get paid at the rate you mapped for that customer. Here's how to set this up:

  1. After you've mapped payroll items by employee in QuickBooks Time, in the top right, select the QuickBooks dropdown, then Preferences.
  2. Select the Payroll Item Mapping Tool.
  3. In the right corner select the Gear icon to open the settings.
  4. Select the Allow overrides by: box, and select Customer.
  5. On the Customer Map, select + Add Overrides.
  6. Click on none under Select Customer.
  7. Choose a Customer and then Save.
  8. Under each hour type column, select one payroll item each.
  9. Choices are saved automatically. Close the window when the mapping is done.

I'm also attaching this video to walk you through those steps as well: Payroll Item Mapping: By Customer/Services/Classes.

 

If you have any questions or need clarification, please reply to this post. I'm happy to help!

    C
    caseyjtaylorAuthor
    May 11, 2021

    @K_Siman thank you for the information!  I was able to work through that process and add the override, but now I am not sure how to get that associated with my employee's time entries for the applicable project.

    K_Siman
    K_Siman
    May 12, 2021

    Good morning, @caseyjtaylor! Thanks for coming back here. I'm happy to explain how to do this.

     

    Moving forward, your users will choose those Projects you set up on their timesheets when they clock in. This way, their time is tracked toward that project and the rate that you mapped once it exports. Any timesheets that have already been created, you can edit if needed. Here's an article on how to edit timesheets : Edit or delete your timesheet in QuickBooks Time Web.

     

     

    Let me know if I answered your question, or if I need to clarify anything at all!

    Terms & ConditionsAccessibility statement