Union Employees with Different Fringe Benefits by Job
Hi, I have Union employees who may work in different Locals in one payroll week. Each Local has a different set of fringe benefit rates, so I need the fringes to be based on the hours worked at each job. For example, Employee A may work 3 hours on a job belonging to Local 111 which has a Health fringe rate of 11.70/hour and may work 10 hours an another job belonging to Local 222 which has a Health fringe rate of 10.50/hour and 12 hours to another job in Local 222. Essentially, I need the 3 hours at Local 111 to have a Health rate of 11.70/hr x 3 hrs = $35.10 and the 22 hours at Local 222 to have a Health rate of 10.50/hr x 22 hrs = $231.
I have set up the different Health rates based on Local (ie Local 111 Health, Local 222 Health), and have set up Class Tracking, but how do I assign these rates to the job? When I run payroll, the "Other Payroll" items are being calculated based on the total hours worked (25) instead of Local 111 Health being calculated at 3 hours and Local 222 Health being calculated at 22 hours, both say 25 hours. How can I split the cost of the Health benefits (and others, this is just an example) by the # of hours to a certain job? The ideal would be for the system to know that Job 11, Job 12 and Job 13 are part of Local 111 and therefore Local 111 fringes should be calculated on those hours and Job 21, 22, 23 are part of Local 222 and fringes should be calculated at the Local 222 rate.
I can't see where this is possible without manually overriding the "Other Payroll Items" on the Paycheck Preview screen. Any help is appreciated.