The new WH-347-348 Federal Certified Payroll forms are here! The USDOL has changed the layout of their form and this is the latest version, expiring 01/31/2028.
| |
NO monthly fees - each form is a one-time payment for unlimited usage!
Revolutionize Your State and Federal Certified Payroll Reporting with Our Automated WH-347 Excel Workbook!
Happy Customers
"Diane-
I just did two weeks of certified payrolls and the new forms worked like a charm. I buzzed right through them. Only thing there was a new job site I had to enter and a new guy on the payroll that I had to add, but so easy.
I am thrilled with the form, I really appreciate it."
Debbie - HK Concrete
Instant Download
Unlimited Usage
Unlimited Free Replacement
Unlimited Free Support
100% Satisfaction Guaranteed |
|
Save Time, Ensure Accuracy, and Streamline Your Construction Projects
Are you tired of drowning in paperwork every time you tackle certified payroll reporting for your construction projects? Imagine a solution that not only slashes the time spent on filling out forms but also helps with accuracy and compliance in every field.
Introducing Our Game-Changing Excel Workbook
With recently extended expiration date of 01/31/2028 AND revised layout!
- Time-Saving Automation: Our workbook is engineered to autofill 164+ fields, transforming what was once a laborious task into a breeze. Spend less time on paperwork and more time focusing on what matters – growing your business.
- Precision and Compliance: Say goodbye to the anxiety of compliance issues. Our workbook helps you to ensure that every field is accurate, meeting federal and state regulations effortlessly. No more sleepless nights worrying about errors or audits.
- Effortless Implementation: You don't need to be an Excel expert to harness the power of our workbook. With a user-friendly interface and clear instructions, you'll be up and running in no time, saving you the headache of complex software installations.
- Cost-Effective Solution: Why break the bank on expensive payroll software when you can achieve the same results with our cost-effective workbook? Maximize your budget and experience the same level of efficiency without compromising on quality.
Transform your certified payroll process today! Click the "Add to Cart" button above to gain instant access to our Excel workbook and take the first step towards a future where paperwork is no longer a roadblock to your success.
160+ Fields that Auto Calculate and Auto Fill
This workbook has so many fields that automatically calculate and automatically fill for you that it practically fills in itself!
Here's a list of those fields on the WH-347:
- Project Name field
- Project No. or Contract No. field
- Project Location field
- "Day" fields in column 4
- "Date" fields in column 4
- Worker Last Name fields
- Worker First Name fields
- Worker Middle Initial fields
- Worker ID Number fields
- Journeyworker or Registered Apprentice fields
- Labor Classification fields
- Total Straight-time Hours fields
- Total Overtime Hours fields
- Straight-time rate of pay fields
- Overtime rate of pay fields
- Total Fringe Benefit Credit fields
- Payment in Lieu of Fringe Benefits fields
- Gross Amount Earned fields
- FICA
- Tax Withholdings
- Total Deductions fields
- Net Pay to Worker for ALL Work fields
And here's a list of the fields on the certification form (aka WH-348):
- Project Name field
- Project No. or Contract No. field
- Payroll No. field
- Prime Contractor's/Subcontractor's Business Name field
- Project Location field
- Week Ending Date field
- Total Hourly Credit fields
These auto calculating and auto filling fields not only free up your time but they also cut down on keying errors!
Additional Deductions and Fringe Benefit Plans
Got child support, or tool loans, or other deductions and/or fringe benefits that you need to report?
Let me set up your form so that it autofills those deductions for you, freeing up even more time for you. Shoot me an email telling me what you need and I'll get you taken care of.
Your Satisfaction is Guaranteed
I guarantee that these forms will be accepted on your Federal certified payroll project (and/or state if these forms are used by your state). If you are for any reason dissatisfied please let me know and I'll refund your purchase 100%.
What's Included in Your New WH-347/348 Premium Excel Workbook Package
1) The WH-347/348 Federal Certified Payroll Form Premium Excel Workbook contains five worksheets (see below for a list of the fields that autofill):
- WH-347_MD form worksheet (110+ autofill fields inc. WH-348 fields)
- WH-348_MD form worksheet
- WH-347_AD form worksheet (164+ autofill fields inc. WH-348 fields)
- WH-348_AD form worksheet
- Tables1 worksheet
The Tables1 worksheet is what allows the magic of this workbook to happen. You’ll enter each employee and their information ONE time on this worksheet and then when you select the employee from the dropdown list on the WH-347_AD or WH-347_MD worksheets, the employee’s information will fill in automatically.
I've included two "versions", one has the brown/orange coloring and the other is simply black and white. It is not a requirement to use the USDOL's form so please feel free to use the black and white version if you'd like to cut down on ink usage.
2) In-depth instructions that walk you through:
How-to easily set up and customize this WH-347/348 workbook to your company's needs
How-to report payroll for employees who work under multiple classifications on a project
How to save time when submitting payroll reports on multi-week jobs
… and everything works with PC/Windows and Apple/Mac/Macintosh computers running Excel!The WH-347 Premium Excel workbook is compatible with Excel 2008 through Excel 365 only (desktop and laptop versions only) on PC/Windows and Apple/Mac/Macintosh computers. It is not compatible with Google Sheets or any other program.OMB Number and Expiration Date
The current OMB Number on the WH-347 form was extended to January 31, 2028. When it expires, the USDOL Wage & Hour Division may leave the current reporting requirements in place and do nothing more than extend the expiration date or they may change the OMB Number and reporting requirements and assign a new expiration date.
If the reporting requirements don't change you'll be able to easily edit the OMB number expiration date in this workbook and continue using it through at least the next expiration date.
If the reporting requirements do change, we will strive to offer a new workbook that meets the new requirements before the current expiration date. Please contact us to purchase an updated package.
Tips and Tricks
I've included within the instructions some tips and tricks to make using this certified payroll workbook even easier, such as:
- How to customize the forms to your company to even further reduce the time you spend filling in payroll reports (plus fewer keystrokes means less chance for typos).
- How to even further reduce time spent when reporting your certified payroll on multi-week jobs.
- How to report payroll for employees who work under multiple classifications on a project.
- How to add additional WH-347 sheets to accommodate as many employee rows as you need.
- You can easily unprotect the workbook and worksheets (no password required) to make your own upgrades if you'd like!
This workbook will have you doing federal Davis-Bacon certified payroll like a pro in no time.
After You've Completed Your Purchase
Your receipt page, and the instant receipt/confirmation email that you'll receive, each have download buttons.
When you click either of those download buttons the zipped form package will download to your computer and automatically unzip itself, presenting you with the forms and instructions that you'll be able to use immediately.
USDOL Wage & Hour Division (aka Department) Institutes New Recordkeeping Requirements
The Department recently added two new recordkeeping requirements for contractors to the collection under 1235–0008 (telephone # and email address; social security number and mailing address were already required). However, like the social security # and mailing address, they don’t want this information added to the “certified payrolls” submission (such as the WH–347 instrument); rather, this information must be maintained in-house and then provided to DOL and other agencies on request.
This workbook has columns on the Tables1 worksheet for each employee’s SS#, mailing address, telephone number, and email address!These columns are provided for your convenience and the information entered here does not appear on the WH-347 or WH-348 forms. By using these columns you'll be able to keep all the information in one place while still staying in line with the rule that it not be included in your "certified payrolls" report/submission.
USDOL Wage & Hour Division (aka Department) Clarifies Rules for Employees with Multiple Classifications
The Department clarified reporting requirements that have to do with employees who work under more than one classification on a project.
Contractors and subcontractors are required to include on their certified payroll submissions (and keep records of) hours worked by an employee broken down by each separate classification of work performed by that employee. If the employee works under two or more classifications on a project, there must be a separate entry for each classification that shows the hours worked and monies earned under each classification.
If a contractor or subcontractor fails to report the breakdown accurately and/or maintain such records of actual daily and weekly hours worked and the correct classifications for those hours worked, then it must pay workers the rates of the classification of work performed with the highest prevailing wage and fringe benefits due.
This workbook and the in-depth instructions make entering, tracking, and reporting multiple-classification employees very easy and simple!The instructions walk through step-by-step how to enter multiple-classification employees on the WH-347 worksheet to meet the Department’s requirements. And anytime you might have questions, I'm here to help get you up and running. :o)
Important Notes
Copyright:
All of TheContractorsGroup's original works are copyrights of Diane Forster-Dennis. The WH-347 (and '348') basic form layout is the property of the USDOL Wage & Hour Division.
Compatibility:
The WH-347 workbook is compatible with Excel 2008 through Excel 365 only (desktop and laptop versions only) on Windows and Apple/Mac/Macintosh). It is not compatible with Google Sheets or any other program.
The instructions are written based on Office 365 for Windows and may vary with other versions.
Please click here if you'd like the turbocharged PDF version instead.License for Use:
All of TheContractorsGroup's products are meant to be used or filled in/submitted by one business/employer only. If you are working with more than one business/employer, please purchase an individual copy for each of those entities.
Legal Advice:
Nothing in this listing or in the downloads themselves should be construed as legal advice. It is the user’s responsibility to ensure that the product suits the purpose intended, both from a practical and legal standpoint.
These do-it-yourself forms and instructions are not a substitute for the advice of an attorney, and no attorney-client relationship is created by the purchase of this kit. If you have a legal question, you should seek advice from an attorney in the relevant jurisdiction.
By purchasing and/or using any file from TheContractorsGroup and/or associates you accept these terms and conditions.
We are not accountants, lawyers, licensed finance professionals, etc., and we are not liable for any errors, hardships, etc., resulting from using this workbook. It is the user’s responsibility to ensure that this workbook suits the purpose intended, both from a practical and legal standpoint. Your purchase and/or use of any file from us signifies your agreement with this.
Submission of federal certified payroll:
While completion of Form WH-347 is optional, it is mandatory for covered contractors and subcontractors performing work on Federally financed or assisted construction contracts to respond to the information collection contained in 29 C.F.R. §§ 3.3, 5.5(a). The Copeland Act (40 U.S.C. § 3145) requires contractors and subcontractors performing work on Federally financed or assisted construction contracts to "furnish weekly a statement with respect to the wages paid each employee during the preceding week." U.S. Department of Labor (DOL) Regulations at 29 C.F.R. § 5.5(a)(3)(ii) require contractors to submit weekly a copy of all payrolls to the Federal agency contracting for or financing the construction project, accompanied by a signed "Statement of Compliance" indicating that the payrolls are correct and complete and that each laborer or mechanic has been paid not less than the proper Davis-Bacon prevailing wage rate for the work performed. DOL and federal contracting agencies receiving this information review the information to determine that employees have received legally required wages and fringe benefits.
Please note that there is a simple PDF form available through the federal government website that you can download and use for free. The USDOL estimates it’ll take you 55 minutes to fill out their version but in our experience, it can easily take double or triple that time, and even more if you have a large field crew. The premium Excel workbook, available here, with multiple auto-calculating and autofill fields, will save you so much time over that simpler PDF document.
- Federal Certified Payrolls Must Be Paid and Reported Weekly -
The USDOL Wage & Hour Division has stated that federal certified payroll MUST be paid no less than once per week, and MUST be reported weekly per Davis-Bacon.
Do not pay your federal payroll less often than once per week and do not submit your federal payroll on a biweekly form. |
|
|
Back to top of this page:
USDOL WH-347 / WH-348 Federal Certified Payroll Form and Statement of ComplianceBack to the home page:
Download Construction Forms