by Sunburst Software Solutions, Inc.
Archives by Month

Automating Job Costing Overtime, an 800 pound gorilla with an attitude

Print Friendly, PDF & Email

Calculating and distributing employee overtime is a burdensome process that many business owners and payroll administrators have to deal with on a weekly basis.  Everyone has a different opinion on just “HOW” that overtime is to be calculated and distributed.  By everyone, I mean the business owner, the payroll clerk, heck even the Federal and State government.  No wonder it’s just a problematic situation!

job costing overtime - an 800 lb gorillaAt first blush this seems drop dead simple.

Overtime goes to the time worked after 40 hours, or maybe over x hours per day as well.  This seems reasonable, but would it be simpler if overtime were just distributed over all the jobs that the employee worked that week.  That seems fairer, as each job gets a share of the overtime costs for that week.

Then again, maybe the overrun that messed with scheduling to cause overtime in the first place happened at the start of the week, the jobs at the end of the week, just so happen to be all overtime hours because of that job.  So the job that really should have the overtime attributed to it, gets none or only a share of the overtime, while the innocent jobs that went as planned bear a higher, “undue” or “unfair” cost.  Heck the job that caused the delays and overruns might have happened the week before.

One should also consider costing all time at the regular rate, and then costing all overtime to the overhead job.

And now don’t forget to do weighted average overtime after the overtime is initially calculated adds another layer of … well … shall we say obfuscation.

Even on a case by case basis, there often is no clear right or wrong answer.  Maybe there is a reason Job Cost Accounting is consider such a bear by so many and why some accountants avoid it at all costs.

Automatically distributing overtime, like Crew Overtime Entry Solution can do, will either occur after the 40 hours / x hours per day, or it can average weight distribute overtime over all jobs.  Or it can leave your entered hours alone and just make an overtime adjustment to an overhead job.  But even with automation there will be basic tradeoffs that will occur.

For usually straight forward set in stone accounting, this area is decidedly gray.


2 Responses to Automating Job Costing Overtime, an 800 pound gorilla with an attitude

    About Your Host:

    Nancy Smyth, Certified QuickBooks ProAdvisor

    Nancy Smyth, Sunburst Software Solutions, Inc.
    QuickBooks Construction & Payroll Expert

    I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

    QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

    Top QuickBooks blogs to read in 2018
    We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
    Stay updated!

    Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

    Enter your email address:

    Delivered by FeedBurner

    We promise NOT to sell, rent, or otherwise distribute your name and email address!

    FREE 30-Day Trials

    Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

    Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

    Certified Payroll Training:
    Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

    certified payroll requirements webinar
    QuickBooks Training

    Frustrated with QuickBooks?

    QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

    QuickBooks Time Tracking

    Save 10%/FREE 14-day trial!

    QuickBooks Time Tracker