QuickBooks Question – Tracking Prevailing Wage Fringe Benefits
A reader wrote to ask the following question:
We were just awarded a contract with the Department of Defense and have to pay our employees “prevailing wage” and submit certified payroll reports. I called Intuit Support to ask them about prevailing wage, certified payroll, and how to track the fringe benefits; they weren’t very helpful – they just told me that QuickBooks can produce the certified payroll report…….can you help me understand all this?
Ok, let’s start with some basics:
- The Davis-Bacon Act of 1931 (a Federal Law) set wage rate requirements on government funded construction projects.
- All contractors & subcontractors who perform work on these public works projects, that have a value of $2,000.00 or more, are required to submit a certified payroll report on a weekly basis.
Prevailing Wage(s) rates are comparable to hourly wages PLUS hourly fringe benefit rates for the area in which the construction project is located in, type of construction it is, and the type of work employees are doing – carpenter, laborer, equipment operator, etc. Prevailing Wage Rates are found in the Contract Package and each employee must be classified and paid accordingly – these rates are often times higher than the hourly rate that you normally pay your employees.
A certified payroll report is a specially formatted payroll report, consisting of two pages:
- Certified Payroll Report – this contains information about who worked on the job, how much you paid them, etc.
- Statement of Compliance – this contains certain legal language and requires the original signature of a company official who is signing the document under penalty of perjury.
In your case, you will be required to file the U. S. Department of Labor Form WH-347 Certified Payroll Report, however, because this is a Department of Defense job – you will need to submit their Statement of Compliance (even though it has an expiration date of June 30, 2000).
Paying and tracking prevailing wage fringe benefits gets quite complicated, as they can be:
- paid to a Union on behalf of the employee
- paid to a bona-fide fringe benefit plan on behalf of the employee
- paid in cash to the employee
- or, a portion of the total hourly fringe benefit amount can be split between payments to a bona-fide plan with the balance in cash to the employee
Request our FREE 27 page eBook – 4 Ways Contractors Pay Prevailing Wage Fringe Benefits
Intuit was partially correct, QuickBooks does have an alternate/substitute Certified Payroll Report built into it – however, it is only available if you have an Enhanced Payroll Subscription AND you are using QuickBooks Premier (any flavor – Contractor, Accountant, etc) 2009 or 2010 OR Enterprise 9.0 and 10.0; but it is very different than the Federal WH-347 form.
What Intuit didn’t tell you – is that these prevailing wage projects require more than just the submission of a certified payroll reports, you may also be required to:
- submit EEOC/Work Utilization reports on a weekly, monthly or annually
- submit ARRA (American Recovery & Reinvestment Act) reports on a monthly basis
- generate Fringe Benefit Statements on a monthly basis (if you are paying the fringe benefits to the Union or a bona-fide plan)
- electronically file your certified payroll reports using Labor Compliance programs such as LCPtracker, TRS Consultants, Elation Systems, and others.
3 Responses to QuickBooks Question – Tracking Prevailing Wage Fringe Benefits
Leave a Reply
- The Great Debate – QuickBooks Desktop vs. QuickBooks Online
- Using Account Numbers in Your QuickBooks Chart of Accounts
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- How To Turn On and Use Manual Payroll in QuickBooks
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks Tip - Child Support Garnishments
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
- Welcome to the QuickBooks for contractors blog
- QuickBooks Tip: Important Facts About Items Left as Billable
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- QuickBooks 2015 Announced - Important System Requirements
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks 2015- The Good, Bad and Ugly, Part 1