FEDERAL - WH-347/348 Premium EXCEL Payroll Workbook with 167 Autofill Fields!
 "Pin It")
|
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!
|
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 167 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 for instant access to our Excel workbook and instantly eliminate the hassle of federal certified payroll reporting.
167 Fields that Auto Calculate and Auto Fill
|
Here's a list of those fields on the WH-347:
And here's a list of the fields on the certification form (aka WH-348):
- Project Name field
- Project No. or Contract No. field
- Project Location field
- "Day" fields in column 4
- "Date" fields in column 4
And for each employee:
- 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
These auto calculating and auto filling fields not only free up your time but they also cut down on keying errors!
- 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 (for each employee)
Additional Deductions and Fringe Benefit Plans
Got child support, or tool loans, or other deductions and/or fringe benefits that you need to report?You can easily manually enter that information into the "Other" column on the form or if you'd prefer, I also offer an optional customization service to set up your workbook so it automatically fills in those deductions, saving you even more time. Just shoot me an email with what you need, and I'll be happy to provide the details.
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 WH-347 Premium Excel Workbook Package
The latest release from the USDOL Wage & Hour Division has a brown & orangish color theme with shaded fields. When printing the forms, the shading will also print. This package has a workbook with the same colors. In addition, for those who wish to use less ink, I've also included the same workbook in simple black & white with no shading in the fields. It is not a requirement to use the USDOL's form, or any WH-347 for that matter, so please feel free to use the black & white workbook if you wish.1) Two workbooks as explained above, and each workbook contains the following:
2) In-depth instructions that walk you through:
- WH-347_AD form worksheet:
This worksheet autofills 153 fields including "Tax Withholdings" and "FICA"
- WH-348_AD form worksheet (accompanies the WH-347_AD worksheet):
This worksheet autofills 14 fields
- WH-347_MD form worksheet:
This worksheet autofills 137 fields - "Tax Withholdings" and "FICA" are manual-fill fields
- WH-348_MD form worksheet (accompanies the WH-347_MD worksheet):
This worksheet autofills 14 fields
- Tables1 worksheet
The Tables1 worksheet is what allows the magic of this workbook to happen. Enter your employees ONE time on this worksheet and then every time you use the workbook you'll be able to select employees from the dropdown list on the WH-347 worksheets and all of the employee’s information across the form will fill in automatically. As changes happen with your employees (new hires, raises, etc.) you'll be able to easily edit the Tables1 worksheet to reflect those changes.
- 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
-
3) FREE BONUS: The workbook that expires 09-30-2026 is included at no extra charge!
- The 2026 WH-347 workbook functions the same as the new 2028 workbook above and is black & white.
- 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!
Compatibility
The WH-347 Premium Excel workbook is compatible with Excel 2008 through Excel 365 (desktop and laptop versions) 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: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.
|
Back to top of this page: USDOL WH-347 / WH-348 Federal Certified Payroll Form and Statement of Compliance
Back to the home page: Download Construction Forms
Copyright © 1999-current Diane Forster-Dennis - All rights reserved.
Mastercard, Visa, Amex, Discover, PayPal, Debit, Check - all accepted
Mastercard, Visa, Amex, Discover, PayPal, Debit, Check - all accepted
GUARANTEE
We guarantee you that our form templates will meet your needs. If, through our error, any document purchased from us is not accepted by your customer, relevant court, or other entity, we will correct the form for you, at no charge, or issue you a full refund, whichever you prefer.
TERMS AND CONDITIONS
All of TheContractorsGroup's original products are copyrights of TheContractorsGroup and are to be used or filled in/submitted by one business only. Please purchase additional copies if you are working with more than one company.
We are not attorneys and nothing in this listing or 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.
Purchase and/or use of any file from TheContractorsGroup and/or its associates indicates acceptance of these terms and conditions. Please verify the form's fitness for your purpose and before use. I promise you a 100% refund of your purchase, or I can revise the form for you, should it end up not being what you need.
We are not attorneys and nothing in this listing or 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.
Purchase and/or use of any file from TheContractorsGroup and/or its associates indicates acceptance of these terms and conditions. Please verify the form's fitness for your purpose and before use. I promise you a 100% refund of your purchase, or I can revise the form for you, should it end up not being what you need.
