Payroll can be one of the most complex duties of any bookkeeper’s job – especially when you need to OR want to track your Worker’s Compensation costs for job costing purposes and pay your employees Vacation, Holiday and Overtime wages. Just take a look at this question, submitted by one of our blog subscribers!
—————————————————————–
Answer:
Hi Kathleen;
That’s an excellent question!
The QuickBooks payroll module is pretty darn flexible; but like the rest of the program it’s generic – so sometimes it’s a little “lacking” when it comes to some specific things like the situation above.
Even if I didn’t fall into the special situation of a reduced WC Experience Rate for Holiday and Vacation time, I would still create specific payroll items based on Work Classification/type of wage: so Carpenter-Holiday or Carpenter-Vacation would be the way I would go.
Overtime can get tricky, especially if your contractor client works on prevailing wage jobs and pays the fringe benefit portion of the prevailing wage in cash to the employee as part of the hourly gross wage, QuickBooks will need some “help” when determining the overtime rate. {This becomes complex and cannot be explained in a blog post but I plan on providing a fee-based live and pre-recorded webinar on how to set this up and make it work in QuickBooks – which will be available in January 2012}.
You will need to add an “Overtime” payroll item to your Payroll Item List using either the E-Z Setup or Custom Setup method naming them Carpenter OT, Laborer OT, etc and being sure that you select that the type of wage is an Overtime rate. If the premium OR half-time portion of overtime pay is excluded from Worker’s Compensation tracking, make sure that you have checked that option in the Workers Compensation preference; found from the Edit menu -> Preferences -> Payroll & Employees -> Workers Compensation button and checking the option to “Exclude overtime premium from Workers Comp calculation”

Make sure that your Codes in the Workers Comp List are descriptive – meaning that when you choose the WC Code in Weekly timesheets that you will understand what code is being assigned to what payroll item.
Setting things up in this manner will provide you with all the payroll numbers that you will need during an audit and clearly indicate the type of wages that are being paid.
If you feel this QuickBooks Payroll tip has been helpful, please take a moment to leave us a comment or to share it with others on your favorite Social Networking site 🙂