FEDERAL - WH-347/348 Premium EXCEL Payroll Workbook with 130+ autofill fields!

FEDERAL - WH-347/348 Premium EXCEL Workbook
FEDERAL - WH-347/348 Premium EXCEL Workbook
Item# WH-347-WH-348
Regular price: $99.00
Sale price: $57.00

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


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. And you have worked so hard on it, 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 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.

USDOL Wage & Hour Changes WH-347 Form and Expiration Date!

The government recently extended the expiration date for the OMB number, from 07/31/2024 to 09/30/2026. They also changed the layout of the WH-347 form (but not the actual reporting requirements).

These turbocharged Excel forms have those most recent updates by the government which means you've got a minimum of 2 1/2 years of unlimited use of these new forms before the OMB number potentially expires.

Should the government extend the expiration date before 09/30/2026 or if the reporting requirements don't change on 09/30/2026 and all they do is extend the expiration date at that time, you can continue to use these forms for even longer, through at least that next expiration date, because we've made it a simple keystroke for you to update that info yourself!

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!

    Image of WH-347 US DOL Certified Payroll Report Form Tables1 Worksheet
    (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)

    Image of WH-347 US DOL Certified Payroll Report Form Worksheet
    (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)
    Image of WH-348 US DOL Certified Payroll Report Form Worksheet
    (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

    Here's a PDF preview of the WH-347 & WH-348 US Department of Labor Certified Payroll forms.

    And here's a very short video of the WH-347 workbook in action. It's the first video I've ever made and it's rough but it's true in how quickly you'll have the WH-347 filled in. If you'd like to sample it before deciding, please send me a message here.

    The form shown in the video is the 7/2024 expiration date and layout. The expiration date and layout included in the purchased download is the 9/30/2026 version. Also, it mentions only my Etsy store but it's the same WH-347/348 workbook that's available by clicking the "Add to Cart" button above.

    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:
    • 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 WH-347 workbook will have you doing 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)

    WH-347/348 Certified Payroll Forms - Weekly Format

    WH-347 US DOL Certified Payroll Report Form WH-348 US DOL Certified Payroll Report Certification Form

    Important Notes


    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.

    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:
    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
    - OR -

    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.

    - 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 Compliance

    Back to the home page: Download Construction Forms