FEDERAL - WH-347/348 Turbocharged EXCEL Payroll Workbook with 107 to 121 autofill fields!
NO monthly fees - each form is a one-time payment for unlimited usage!
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.
The WH-347 Payroll Report form and the WH-348 Statement of Compliance forms are designed for collecting and reporting that information.
The WH-347 and WH-348 forms are also used by many states for state-certified payroll.
Notice: Effective October 23, 2023
The Department is adding 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 is clarifying 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)
1) The WH-347/348 Federal Certified Payroll Form Turbocharged Excel Workbook contains five worksheets:
2) In-depth instructions that walk you through:
… and everything works with Apple/Mac/Macintosh and Windows/PC!
The WH-347 turbocharged Excel 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. Please click here if you'd like the supercharged PDF version instead.
If you're looking for our original Excel worksheet, without all the bells and whistles, please click here.
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.
Fill in the Tables1 worksheet (click the image for a larger view) once and this turbocharged workbook will autofill 107 to 121 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_AD and WH-347_MD 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!
Read more about the difference: Potential disparities with FICA and other percentage-based tax deductions between the paycheck and the WH-347_AD worksheet/form.
Here's a list of the fields that'll autofill on WH-348 worksheets/forms:
The time saved when using these forms is substantial!
The current OMB Number on the WH-347 form was renewed by the government in 2021 to expire on July 31, 2024. When the expiration date is renewed it’s typically set to expire again in three (3) years.
When the OMB number expires, the USDOL Wage & Hour Division may leave the current reporting requirements in place and do nothing more than extend the expiration date for another 3 (or however many) years or they may change the OMB Number and expiration date without changing the reporting requirements or they may also change the reporting requirements.
If the reporting requirements remain the same, you’ll be able to continue using this workbook because we’ve included instructions that’ll walk you through how to easily change the OMB Number and expiration date.
If the reporting requirements change requiring a change in the layout or function of the WH-347/348 Excel workbook, we will endeavor to have an updated version that meets the new requirements available for purchase as quickly as possible.
*If the reporting requirements DO change when the expiration date is updated on 8/1/2024, we'll discount your purchase of the revised and updated workbook at that time by the same amount that you paid for your purchase of the current workbook today.
I've included within the instructions some tips and tricks to make using this certified payroll workbook even easier, such as:
All of TheContractorsGroup's original works are copyrights of Diane Forster-Dennis.
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 only. Please purchase additional copies if you are working with more than one company.
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.
When using the WH-347_AD worksheet, there is a possibility that there will be disparities between the FICA and other percentage-based tax deductions deducted on the paycheck and the amounts reported on the worksheet. Unfortunately, different payroll methods can produce results that differ from week to week whereas Excel runs calculations exactly the same every time you use it.
Using FICA at the rate of 7.65% as an example:
Excel will do the calculation at exactly 7.65% (gross wage x 7.65%) every time you use the workbook, week after week after week, whereas the various methods used can produce varying results week to week to week (e.g., 7.649% and then 7.651% next week, and then 7.65% the following 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 (sometimes by mere pennies but just one cent will throw off your payroll report).
But it's SUPER EASY to get around and here are three options:
1. Override the incorrect amount(s) as follows:
2. Use the included “WH-347_MD” and “WH-348_MD” worksheets that will autofill 107 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.
- OR -
3. Provide us with the exact calculations as to how your FICA and other tax deductions are set up (e.g., $$ + % of gross wage; etc.) and we can set it up in the workbook to autofill.
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. This workbook will save you so much time over that simple 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
Who Uses The WH-347 Payroll Report form & WH-348 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.
The WH-347 Payroll Report form and the WH-348 Statement of Compliance forms are designed for collecting and reporting that information.
The WH-347 and WH-348 forms are also used by many states for state-certified payroll.
Notice: Effective October 23, 2023
New and Clarified Recordkeeping and Reporting Requirements From The USDOL Wage & Hour Division (aka Department)
New Recordkeeping Requirements
The Department is adding 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.
Clarification of Rules for Employees with Multiple Classifications
The Department is clarifying 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)
|
What's included in this WH-347/348 Turbocharged Excel Workbook
1) The WH-347/348 Federal Certified Payroll Form Turbocharged Excel Workbook contains five worksheets:
- WH-347_MD form worksheet (see below for list of fields that autofill)
- WH-348_MD form worksheet (see below for list of fields that autofill)
- WH-347_AD form worksheet (see below for list of fields that autofill)
- WH-348_AD form worksheet (see below for list of fields that autofill)
- 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 Apple/Mac/Macintosh and Windows/PC!
The WH-347 turbocharged Excel 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. Please click here if you'd like the supercharged PDF version instead.
Excel Sample, PDF Preview, and a Video
|
If you're looking for our original Excel worksheet, without all the bells and whistles, please click here.
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.
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 107 to 121 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_AD and WH-347_MD - List of Autofill Fields
Here's a list of the fields that'll automatically calculate and autofill on both the WH-347_AD and WH-347_MD 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) - Read about potential disparities
- Withholding Tax amount withheld in column 8 (7 fields) - Read about potential disparities
(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!
Read more about the difference: Potential disparities with FICA and other percentage-based tax deductions between the paycheck and the WH-347_AD worksheet/form.
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!
OMB Number and Expiration Date
The current OMB Number on the WH-347 form was renewed by the government in 2021 to expire on July 31, 2024. When the expiration date is renewed it’s typically set to expire again in three (3) years.
When the OMB number expires, the USDOL Wage & Hour Division may leave the current reporting requirements in place and do nothing more than extend the expiration date for another 3 (or however many) years or they may change the OMB Number and expiration date without changing the reporting requirements or they may also change the reporting requirements.
If the reporting requirements remain the same, you’ll be able to continue using this workbook because we’ve included instructions that’ll walk you through how to easily change the OMB Number and expiration date.
If the reporting requirements change requiring a change in the layout or function of the WH-347/348 Excel workbook, we will endeavor to have an updated version that meets the new requirements available for purchase as quickly as possible.
*If the reporting requirements DO change when the expiration date is updated on 8/1/2024, we'll discount your purchase of the revised and updated workbook at that time by the same amount that you paid for your purchase of the current workbook today.
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!
WH-347/348 Certified Payroll Forms - Weekly Format
|
Important Notes
Copyright:
All of TheContractorsGroup's original works are copyrights of Diane Forster-Dennis.
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.
Use:
All of TheContractorsGroup's products are meant to be used or filled in/submitted by one business only. Please purchase additional copies if you are working with more than one company.
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:
When using the WH-347_AD worksheet, there is a possibility that there will be disparities between the FICA and other percentage-based tax deductions deducted on the paycheck and the amounts reported on the worksheet. Unfortunately, different payroll methods can produce results that differ from week to week whereas Excel runs calculations exactly the same every time you use it.
Using FICA at the rate of 7.65% as an example:
Excel will do the calculation at exactly 7.65% (gross wage x 7.65%) every time you use the workbook, week after week after week, whereas the various methods used can produce varying results week to week to week (e.g., 7.649% and then 7.651% next week, and then 7.65% the following 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 (sometimes by mere pennies but just one cent will throw off your payroll report).
But it's SUPER EASY to get around and here are three options:
1. Override the incorrect amount(s) as follows:
- OR -a) Unprotect the WH-347_AD worksheet
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. Use the included “WH-347_MD” and “WH-348_MD” worksheets that will autofill 107 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.
- OR -
3. Provide us with the exact calculations as to how your FICA and other tax deductions are set up (e.g., $$ + % of gross wage; etc.) and we can set it up in the workbook to autofill.
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. This workbook will save you so much time over that simple 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-2023 Monk and DBug, LLC - All rights reserved.
Mastercard, Visa, Amex, Discover, PayPal, Debit, Check - all accepted
I am not an attorney. Please verify the form's fitness for your purpose and before use. I promise you a 100% refund of your purchase should the form(s) end up not being what you need.
Mastercard, Visa, Amex, Discover, PayPal, Debit, Check - all accepted
I am not an attorney. Please verify the form's fitness for your purpose and before use. I promise you a 100% refund of your purchase should the form(s) end up not being what you need.
