Skip to main content
Solved

Overtime Project Specific Rates


iqraharrison
Captain II
Forum|alt.badge.img+8

Hi

I have a client who will be using ADP for payroll that plans on bringing in project related details using Project transactions.  The client has project specific rates for items and that works great for regular hours but occasionally they have overtime rates that need to be billed to the client.  What would be the best practice to accommodate the different billable rate? is it possible to have more than one rate on a rate table for the same item? One thought was to create a second non-stock item for each of their labor items to account for the overtime rate.  The client and I weren’t loving this option but were willing to explore.

 

i’d love to hear what the community's thoughts are and what you may have done in the past?

 

I appreciate your help in advance!

Best answer by meganfriesen37

Because there’s no way to account for the earning type when calculating project rates, there’s basically 2 options that we’ve used, depending on the customer.

  1. Set up secondary non-stock labor items for the OT items (more common)
  2. All the OT time goes to a specific set of tasks that have task specific rates (so you need to have multiple look-up rules for the rate table. 
    • i.e. sequence 100 might be Task and Inventory or Task and Employee for the Overtime specific task and then sequence 200 would be just Item and/or Employee for the default (regular) time rates.
View original
Did this topic help you find an answer to your question?

6 replies

iqraharrison
Captain II
Forum|alt.badge.img+8
  • Author
  • Captain II
  • 520 replies
  • August 29, 2023

@Heidi Dempsey @joelhoffman another topic i would love your thoughts on!

 

thank you!


meganfriesen37
Captain II
Forum|alt.badge.img+11

Because there’s no way to account for the earning type when calculating project rates, there’s basically 2 options that we’ve used, depending on the customer.

  1. Set up secondary non-stock labor items for the OT items (more common)
  2. All the OT time goes to a specific set of tasks that have task specific rates (so you need to have multiple look-up rules for the rate table. 
    • i.e. sequence 100 might be Task and Inventory or Task and Employee for the Overtime specific task and then sequence 200 would be just Item and/or Employee for the default (regular) time rates.

Forum|alt.badge.img+1
  • Semi-Pro III
  • 144 replies
  • October 25, 2023

I did something different, in the billing rule, IF transaction Earning type = Double time, Billed amount = Transaction amount x 2

 

Here 2 is a constant, but can be a variable (project or task attribute)


meganfriesen37
Captain II
Forum|alt.badge.img+11

meganfriesen37
Captain II
Forum|alt.badge.img+11

@raphrf I’ve also done something similar where we hardcode in a multiplier, but it’s not always exactly 1.5x or 2x the rate because there may be other markups included in the rate that don’t multiply (i.e. the base rate doubles, but then included in that rate is also a flat hourly markup for overhead or other allowances for tools, boots, PPE, etc. that stays constant and other items may not be included in the OT or double time rate). 


Forum|alt.badge.img+1
  • Semi-Pro III
  • 144 replies
  • June 26, 2024
meganfriesen37 wrote:

@raphrf I’ve also done something similar where we hardcode in a multiplier, but it’s not always exactly 1.5x or 2x the rate because there may be other markups included in the rate that don’t multiply (i.e. the base rate doubles, but then included in that rate is also a flat hourly markup for overhead or other allowances for tools, boots, PPE, etc. that stays constant and other items may not be included in the OT or double time rate). 

we do exactly the same! 😊


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings