FEDERAL - WH-347/348 Premium EXCEL Payroll Workbook with 130+ autofill fields!
NO monthly fees - each form is a one-time payment for unlimited usage!
Introducing our game-changing Excel workbook designed specifically for construction contractors like you.
*** With recently extended expiration date of 09/30/2026 ***
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.
Many states also use the WH-347 and WH-348 forms for state-certified payroll.
The WH-347 Payroll Report form and the WH-348 Statement of Compliance forms are designed for collecting and reporting the required information.
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):
2) In-depth instructions that walk you through:
… 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.
Fill in the Tables1 worksheet (click the image for a larger view) once and this turbocharged workbook will autofill 110 to 130+ fields on the WH-347 and WH-348 worksheets/forms saving you a massive amount of keystrokes!
Easily make changes when you hire new employees, need to change employee information, start new projects & complete other ones, etc.
Here's a list of the fields that'll automatically calculate and autofill on both the WH-347_MD and WH-347_AD worksheets/forms:
These additional fields will automatically calculate and autofill on the WH-347_AD worksheet/form:
Working with multiple unions? Let me set up your form so that it autofills the deductions for those unions, further reducing your time spent filling in WH-347 forms.
Same goes for child support, tools, and other deductions!
Here's a list of the fields that'll autofill on WH-348 worksheets/forms:
The time saved when using these forms is substantial! Get Your Premium Workbook Now
The current OMB Number on the WH-347 form was extended by the government in late 2023 from July 31, 2024, to September 30, 2026. 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.
I've included within the instructions some tips and tricks to make using this certified payroll workbook even easier, such as:
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.
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.
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)
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.
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 supercharged PDF version instead.
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.
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.
The different payroll methods out there can produce results that differ from week to week when calculating percentage-based tax deductions whereas Excel runs calculations the same every time you enter info into the worksheet.
Using FICA at the rate of 7.65% as an example:
When filling in the Excel workbook: If you enter the FICA rate at 7.65% Excel will do the calculation at exactly 7.65%. Excel will do this every time you use the workbook, week after week after week, until and unless you change the percentage rate(s) which you can do at any time and as often as needed.
When using a payroll service/program to create paychecks: The various payroll methods used can produce varying results week to week to week (e.g., 7.649% this week, and then 7.651% next week, and then 7.65% the next week).
Because of this, dollar amounts deducted from an employee’s paycheck for FICA and Withholding may, at least at times, be different than the dollar amounts that autofill in the WH-347_AD worksheet.
If you find that your paychecks do vary with FICA and/or Withholding tax amounts (or other percentage-based deductions) it's super easy to get around. Here are three easy options:
1. If using the "AD" version, override the incorrect amount(s) as follows:
2. Easily change the FICA deduction percentage amount(s) on the Tables1 worksheet.
- OR -
3. Use the included “WH-347_MD” and “WH-348_MD” worksheets that will autofill the other 110+ fields for you and allow you to manually enter the FICA and Withholding without unprotecting the worksheet. The “MD” worksheets pull all data from the same Tables1 worksheet that the “AD” worksheets pull from which means you won’t have to re-enter employee and project data to use the “MD” worksheets.
Please note that the issue described above does NOT apply to flat-rate deductions such as tool payments, child support, $ per hour worked/paid, etc., or to percentage-based deductions that stay the same percentage week to week; it applies ONLY to percentage-based deductions where the percentage varies from pay period to pay period.
(Back to list of autofill fields)
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
Revolutionize Your State and Federal Certified Payroll Reporting with Our Automated WH-347 Excel Workbook!
|
Save Time, Ensure Accuracy, and Streamline Your Construction Projects with this Ultimate DIY Solution
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 designed specifically for construction contractors like you.
*** With recently extended expiration date of 09/30/2026 ***
- Time-Saving Automation: Our workbook is engineered to autofill 130+ 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.
|
Who Uses The WH-347 Payroll Report form and Statement of Compliance form and Why?
When contractors, subcontractors, sub-subs/etc., suppliers, etc., perform work on projects that involve federal funding, they're required to submit in-depth payroll information following Davis-Bacon and the USDOL Wage & Hour Division specific reporting requirements.Many states also use the WH-347 and WH-348 forms for state-certified payroll.
The WH-347 Payroll Report form and the WH-348 Statement of Compliance forms are designed for collecting and reporting the required information.
What's included in this WH-347/348 Premium Excel Workbook with the recently extended expiration date of 09/30/2026
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 (130+ 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, all of the employee’s information will fill in automatically as shown in the video below.
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.
Other Options
Excel and PDF Standard version
Autofill Fields Save You a Substantial Amount of Time
Fill in the Tables1 worksheet (click the image for a larger view) once and this turbocharged workbook will autofill 110 to 130+ fields on the WH-347 and WH-348 worksheets/forms saving you a massive amount of keystrokes!
(Click the image for a larger view) |
Easily make changes when you hire new employees, need to change employee information, start new projects & complete other ones, etc.
WH-347_MD and WH-347_AD - List of Autofill Fields
Here's a list of the fields that'll automatically calculate and autofill on both the WH-347_MD and WH-347_AD worksheets/forms:
- Project Name and Location (1 field)
- Project/Contract Number (1 field)
- "Day" fields in column 4 (7 fields)
- "Date" fields in column 4 (7 fields)
- Worker Name (7 fields)
- ID Number (7 fields)
- Number of Withholding Exemptions (7 fields)
- Worker Classification (7 fields)
- Total Straight-time Hours in column 5 (7 fields)
- Total Overtime Hours in column 5 (7 fields)
- Straight-time rate of pay in column 6 (7 fields)
- Overtime rate of pay in column 6 (7 fields)
- Fringe benefit hourly rate in column 6 (7 fields)
- Gross Amount Earned (top box) in column 7 (7 fields)
- "Total Deductions" field in column 8 (7 fields)
- "Net Wages Paid For Week" field in column 9 (7 fields)
WH-347_AD - Additional Autofill Fields
These additional fields will automatically calculate and autofill on the WH-347_AD worksheet/form:
- FICA amount withheld in column 8 (7 fields)
- Withholding Tax amount withheld in column 8 (7 fields)
(Click the image for a larger view) |
And we can add as many additional deductions to autofill as you'd like!
Working with multiple unions? Let me set up your form so that it autofills the deductions for those unions, further reducing your time spent filling in WH-347 forms.
Same goes for child support, tools, and other deductions!
WH-348 - List of Autofill Fields
Here's a list of the fields that'll autofill on WH-348 worksheets/forms:
- "Contractor or Subcontractor" field (1 field)
- "Building or Work" field (1 field)
- "... payroll commencing date" field (1 field)
- "... payroll ending date" field (1 field)
- "... of said employer" field (1 field)
- "Name" field (1 field)
- "Title" field (1 field)
(Click the image for a larger view) |
The time saved when using these forms is substantial! Get Your Premium Workbook Now
PDF and Video Previews
|
OMB Number and Expiration Date
The current OMB Number on the WH-347 form was extended by the government in late 2023 from July 31, 2024, to September 30, 2026. 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 WH-347 workbook will have you doing certified payroll like a pro in no time.
- 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!
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)
WH-347/348 Certified Payroll Forms - Weekly Format
|
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 supercharged 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.
Potential disparities for FICA and other percentage-based tax deductions:
The different payroll methods out there can produce results that differ from week to week when calculating percentage-based tax deductions whereas Excel runs calculations the same every time you enter info into the worksheet.
Using FICA at the rate of 7.65% as an example:
When filling in the Excel workbook: If you enter the FICA rate at 7.65% Excel will do the calculation at exactly 7.65%. Excel will do this every time you use the workbook, week after week after week, until and unless you change the percentage rate(s) which you can do at any time and as often as needed.
When using a payroll service/program to create paychecks: The various payroll methods used can produce varying results week to week to week (e.g., 7.649% this week, and then 7.651% next week, and then 7.65% the next week).
Because of this, dollar amounts deducted from an employee’s paycheck for FICA and Withholding may, at least at times, be different than the dollar amounts that autofill in the WH-347_AD worksheet.
If you find that your paychecks do vary with FICA and/or Withholding tax amounts (or other percentage-based deductions) it's super easy to get around. Here are three easy options:
1. If using the "AD" version, override the incorrect amount(s) as follows:
- OR -a) Unprotect the WH-347_AD worksheet for this pay period (don't do this to the master)
b) Override the dollar amount(s) showing in the box(es) by typing in the correct amount(s)
c) Re-protect the worksheet
d) Save
2. Easily change the FICA deduction percentage amount(s) on the Tables1 worksheet.
- OR -
3. Use the included “WH-347_MD” and “WH-348_MD” worksheets that will autofill the other 110+ fields for you and allow you to manually enter the FICA and Withholding without unprotecting the worksheet. The “MD” worksheets pull all data from the same Tables1 worksheet that the “AD” worksheets pull from which means you won’t have to re-enter employee and project data to use the “MD” worksheets.
Please note that the issue described above does NOT apply to flat-rate deductions such as tool payments, child support, $ per hour worked/paid, etc., or to percentage-based deductions that stay the same percentage week to week; it applies ONLY to percentage-based deductions where the percentage varies from pay period to pay period.
(Back to list of autofill fields)
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
Accessories
Copyright © 2000-2024 Monk and DBug, LLC - 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.
