Construction Pack: WH-347 Certified Payroll + WIP Report + Manpower Planning (Excel Template)

What's Included: 3 Workbooks Built on a Shared Project List

Construction Pack is three separate Excel files sold as one bundle: a WH-347 Certified Payroll workbook, a WIP (Work in Progress) Report, and a Manpower Planning schedule. Each one is built to be used on its own, but they share the same underlying logic - the projects you set up in the WIP Report are the same projects your crews get assigned to in Manpower Planning, so you are not re-typing job names and numbers across three different files every week.

The files open in Excel and Google Sheets. There are no macros or VBA in any of the three workbooks, so nothing gets blocked by a company's macro security policy or breaks when opened on a different Office version. Every number you see - fringe benefit totals, percent completion, over/under billing, crew hours versus budget - is a plain formula you can inspect and audit, not a black box.

This is a documentation and job-costing tool for contractors managing Davis-Bacon payroll paperwork, multi-project cost tracking, and crew scheduling in-house, without a full construction ERP. It replaces three disconnected spreadsheets (or three separate downloads from three different sources) with one consistent set of files.

WH-347 Certified Payroll Template (Davis-Bacon Compliant Layout)

The WH-347 workbook is laid out to match the U.S. Department of Labor's official certified payroll form, column for column. It starts with a Company & Project sheet (contractor name, project name, contract number, week ending date), then an Employees sheet where you record each worker's name, address (last four digits of SSN only, per DOL guidance), labor classification, base hourly rate, and their fringe benefit rates by plan - health, pension, vacation, training - each expressed as dollars per hour.

From there, a Weekly Entry sheet captures straight-time and overtime hours per employee per day. The WH-347 Form sheet pulls all of that into the same nine-column structure as the DOL form: hours worked, total hours, hourly rate, gross amount earned, deductions, and net payment, with straight time and 1.5x overtime calculated automatically from the hours you entered.

Construction WIP Report Template (Portfolio Rollup, Not Single-Project)

The WIP Report workbook handles up to 15 active projects at once. For each project you enter the contract value, costs incurred to date, and estimated total costs, and the sheet calculates percent completion using the cost-to-cost method (costs incurred divided by estimated total costs), then derives revenue recognized, amount billed, and the resulting over-billing or under-billing position for that project.

Beyond the per-project view, a portfolio rollup sheet totals costs, revenue recognized, and billing position across all 15 projects, with a chart showing over/under billing by project side by side. That rollup is the piece missing from every single-project WIP template we found in the WIP report SERPs (ServiceTitan, ProjectManager, ExcelComplete) - useful once you are running more than one job at a time and need a portfolio-level read on where cash and recognized revenue stand, not just a per-job snapshot.

Manpower Planning Template Tied to Job Costing

The Manpower Planning workbook schedules crews and employees across a 12-week window. Each person gets assigned to a project (pulled from the same project list used in the WIP Report), with hours logged per week. A per-project rollup then compares total hours assigned against that project's budgeted hours, flagging over-allocation so you can see before the fact that a crew is scheduled for more hours than the job's budget allows.

The Manpower Planning workbook keeps its own project sheet, designed to mirror the project names you use in the WIP Report, so the crew-hours view and the cost/billing view stay consistent across the pack.

Why This Is a Pack, Not Three Separate Templates

Every WH-347 template we found in a competitive scan - the DOL's own fillable PDF, Etsy auto-fill workbooks, lead-magnet blog downloads - covers certified payroll and nothing else. WIP report templates (ServiceTitan, ProjectManager, ExcelComplete) are single-project only, with no portfolio view. And templates that show up for "manpower planning" are almost all generic HR headcount/workforce-planning tools, not job-costing schedules tied to a specific project list and crew hours.

That fragmentation means a contractor doing payroll compliance, WIP reporting, and crew scheduling today is stitching together three unrelated downloads from three different sources, each with its own project-naming convention. Construction Pack keeps the three workbooks on one shared project list so the data you enter once for a job carries across the pack instead of being re-typed three times.

None of this replaces a compliance officer, a Certified Payroll Professional, or legal counsel - it is spreadsheet infrastructure that matches the DOL's form layout and automates the fringe benefit arithmetic. The judgment calls (correct wage determinations, correct classifications, whether a specific project falls under Davis-Bacon) are still yours to make or verify with someone qualified.

Who This Pack Is For

General contractors and subcontractors working on federal or federally-funded projects who need to submit weekly certified payroll under Davis-Bacon and Related Acts requirements. Also useful for any GC running multiple jobs at once who wants a WIP view across projects rather than one spreadsheet per job, and for anyone scheduling crews week-to-week against a project budget rather than an open-ended headcount plan.

It's built for contractors handling this in-house on Excel or Google Sheets - not for teams already running a construction ERP like Procore or a payroll platform that generates certified payroll automatically. If you already have that in place, this pack is redundant with what your software does.