Free construction daily report template (Excel)
This free construction daily report template is an Excel workbook that records each day on site as one row per entry: weather, manpower, equipment, deliveries, inspections, visitors, delays and safety. It totals man-hours, flags entries that stopped work, and keeps the ticket, RFI or notice number that makes the record hold up later. No email, no macros.
Download the template
No sign-up, no email. 3 sheets, no macros, 17 KB. Opens in Excel or Google Sheets. The example sheet uses illustrative Texas project data; the blank sheet is ready to use.
What is in the workbook?
| Sheet | What it is for |
|---|---|
| Instructions | The steps on this page and what each column means |
| Daily report | The blank working sheet: dropdowns for entry type and work stopped, a man-hours formula per row |
| Example (Texas) | One full day on an illustrative Travis County, TX school addition |
What do the columns mean?
Each entry type answers a question someone will ask months later, in a pay application review or a delay claim.
| Column | What to enter | Why it matters |
|---|---|---|
| Date, Entry type | The day, and weather, manpower, equipment, delivery, inspection, visitor, delay, safety or photo | Filtering by type turns one sheet into a weather log, a manpower log or a delay log. |
| Company, Trade, Workers, Hours, Man-hours | Who was on site and for how long; man-hours calculate | On federally funded work, manpower supports the weekly certified payroll under the Davis-Bacon Act. |
| Location, Description | Where, and what happened, in facts and times | Work completed by location backs the percent complete you bill on the pay application. |
| Reference no. | Delivery ticket, inspection permit, RFI or notice number | Ties the entry to the document that proves it. |
| Work stopped? | Y when the entry held up work | Under AIA A201-2017 Section 15.1.3 a claim must be initiated within 21 days after the event or after the condition is first recognized; the daily report is the evidence. |
| Recorded by | Who wrote it, the same day | Records written the same day carry far more weight than reconstructed ones. |
What does the example look like?
One day, November 12, 2026, on the Example sheet. Illustrative data, not a real project.
| Entry | Company or source | Workers | Hours | Description | Reference |
|---|---|---|---|---|---|
| Weather | Site | AM 48 F clear, PM 66 F clear, wind 8 mph. No rain. | |||
| Manpower | Lone Star Steel Erectors | 6 | 9 | Erected roof joists, bays 1-4 | |
| Manpower | Capitol Electric | 4 | 8 | Rough-in, rooms 104-110 | |
| Manpower | Bluebonnet Mechanical | 5 | 8 | Duct mains, corridor 100 | |
| Manpower | Our crew | 3 | 9 | Housekeeping, layout for gym slab | |
| Equipment | Lone Star Steel Erectors | 7 | 60-ton crane, 7 hours working | ||
| Delivery | Hill Country Supply | Metal studs, 2 of 3 pallets received, 1 short | Ticket 448812 | ||
| Inspection | Travis County inspector | Underground plumbing, rooms 104-110: passed | Permit B-26-1187 | ||
| Delay or issue | Lone Star Steel Erectors | 2 | Joist bearing plates missing at grid E; crew held 2 hours | RFI-021, notice NOD-03 | |
| Safety | All trades | 18 | Toolbox talk: fall protection at roof edge. No incidents. |
Illustrative18 trade workers logged 153 man-hours. One entry stopped work: the steel crew waited 2 hours for missing bearing plates, recorded with its RFI and notice number the same day.
How do you use the template?
- Start the day with weather. Record conditions in the morning and afternoon, and whether weather stopped work.
- Log manpower by company. One manpower row per company and trade on site, with workers and hours.
- Record work completed by location. What was installed, where, and how much, in terms that match the schedule.
- Add deliveries, inspections and visitors. Supplier and ticket number, inspector and result, who visited and when.
- Write delays as facts. What held up work, who it affects, for how long, and the RFI or notice number. Mark Work stopped Y.
- Close with safety and sign off. Toolbox talk topic, observations and incidents; the superintendent reviews the day before leaving site.
For what each section should say and why it matters, read what a construction daily report should include.
When does a spreadsheet stop being enough?
A spreadsheet works when the superintendent has the time to fill it in every evening. It gets thin when crews are spread across buildings, photos live on five phones and delivery tickets ride away in trucks. Lex, BAU AI's field reporting agent, drafts the daily report from crew check-ins, voice notes, delivery tickets and photos, pulls the weather and flags entries that may need written notice; the superintendent reviews and signs. Lex is offered to the founding cohort and is not part of the published plans.
Frequently asked questions
Is the daily report template free?
Yes. Download it without an email address and adapt it for your own projects. A credit line to BAU AI sits at the bottom of each sheet.
Why one row per entry instead of a one-page form?
Rows can be filtered and totaled: by date for the day's report, by company for manpower, by Delay or issue for a claim. A form has to be retyped for each of those.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. There are no macros.
Where do injuries go?
Record the incident in the daily report, and enter recordable injuries on the OSHA 300 log within seven calendar days, as 29 CFR 1904.29 requires.
See Lex write a daily report from the field
Bring one day of photos, tickets and notes. In 15 minutes Lex drafts the report with you, every entry tied to its source.