Field reporting

Manpower report template for construction: free Excel and PDF

A construction manpower report records the people and hours assigned to a project by date, company, trade, shift and work area. A useful template separates headcount from labor hours and connects both to the activity performed. Download the free blank Excel and PDF versions below.

What a manpower report tells you, and what it does not

A manpower report helps a superintendent see how resources were distributed and helps a project manager compare planned staffing with the resources actually reported. It supports daily coordination, follow-up and a clearer record of who was working where.

Headcount alone is not productivity. Ten workers could perform different activities for different durations under different access conditions. Nor does a project attendance report establish the wages owed to each employee. Payroll, prevailing-wage and certified-payroll processes have their own requirements. Keep the manpower report focused on project resources.

Use these fields for each crew entry

FieldEntry
Date and shiftThe reporting date and shift, not the submission timestamp
Company and tradeEmployer/subcontractor and type of work
Area and activityLevel, zone and operation performed
HeadcountPeople in this crew entry, using a consistent counting rule
Regular hoursTotal regular person-hours for the entry
Overtime hoursTotal overtime person-hours, kept separate
Total hoursRegular person-hours plus overtime person-hours
Supervisor and referencePerson confirming the entry and supporting log
NotesReassignment, restricted access or missing confirmation

How the free template is organized

The Excel file includes a daily crew-entry sheet with headcount, regular person-hours, overtime person-hours and a formula for total person-hours. The PDF provides the same blank fields for printing. No worker roster is required to download or use either file.

Use one row for a company, trade, shift and work area. If a crew changes areas, agree whether you split hours across rows or use one daily row with a location note. Do not count the same people twice in a daily headcount total simply because they appear in two locations. The template records row-level headcount; unique daily attendance requires a separate reconciliation.

Headcount and hours: a worked example

Suppose six electricians each work eight regular hours in the east corridor. That crew entry has a headcount of 6 and 48 regular person-hours. If two of those people each work two additional overtime hours, enter 4 overtime person-hours. The total is 52 person-hours, not 10 hours and not 8 people.

These numbers are illustrative. The Excel template expects total person-hours in the regular and overtime columns. Do not enter eight into the regular-hours field and expect it to multiply by headcount. If your office prefers hours per person, change the fields and formulas together so the meaning stays clear.

ILLUSTRATIVE EXAMPLE
Company: Example Electrical
Trade: Electrical
Area: Level 6 east corridor
Headcount: 6
Regular person-hours: 48
Overtime person-hours: 4
Total person-hours: 52
Activity: Conduit installation
Confirmed by: Foreman at end of shift

Compare staffing to the work, not just to yesterday

A useful staffing conversation connects the report to the look-ahead plan. Which operation needed the crew? Was the area released? Were materials and inspections available? Did the actual hours support the planned activity? The report can reveal a mismatch, but it cannot determine the cause on its own.

When staffing changes, record the explanation if confirmed. A smaller crew may reflect completed work rather than a problem. A larger crew may be performing a planned recovery activity rather than generating extra cost. Keep conclusions separate from observations and investigate against the schedule and daily logs.

Collect only the worker information you need

For coordination, company, trade, count and hours may be enough. Named attendance can be appropriate for some projects, but access and retention should reflect its sensitivity. Do not put personal phone numbers, medical information or wage details into a broadly circulated manpower report.

Magra collects requested project updates; it is not a worker location-tracking tool. Tell crews what is being recorded and why. Have the designated foreman confirm attendance and hours rather than treating message timestamps as a time clock.

Collect manpower by text

A foreman can text Magra the crew count, trade, hours and work area. If the update only says “six on Level 6,” Magra can ask about the shift and hours before preparing the manpower report. Pair that entry with the day’s activity and photos so the office sees the context.

Start with your own template and counting convention. Magra prepares Excel and PDF outputs today; project-system connections are rolling out. Review the report before it becomes part of an external submission or commercial discussion.

Common questions

Are manpower hours the same as payroll hours?

Not necessarily. A manpower report is a project resource record. Payroll and certified-payroll records follow separate employer and legal requirements.

Does the template calculate total labor hours?

Yes. In Excel, total person-hours equal the regular person-hours entered plus overtime person-hours entered. It does not multiply those inputs by headcount.

Can I use it without listing worker names?

Yes. The generic template records crews by company and trade. Add a controlled named roster only when your project requires it.

Sources & editorial note

By Magra editorial. Examples are illustrative, not customer results. Not legal advice; executed documents, amendments and applicable law govern. Product availability can change.

Put the record to work.

Magra is the AI project manager for contractors, on your phone.

See reporting for general contractors · Text Magra

Keep reading