Site Diary Template: Free Excel Template and Online Builder

What a Good Site Diary Template Covers

Choose a form that your site team can complete consistently and your reviewers can understand.

The fourteen fields below cover the core record. Add project-specific fields where needed and cross-reference detailed source records.

Here's what to include in a site diary at a minimum:

The Template

Use the sections below as recording prompts. They are not a list of universal contractual requirements.

Section A: Project and Date Information

Section B: Weather Conditions

Record observations at useful intervals and whenever conditions change. Follow the project requirements. For NEC4 weather assessment, separately check the specified measurements, location and calendar-month historical comparison; three daily diary observations are not a universal NEC4 requirement.

Source of measurement and period covered: _____

Section C: Labour

Record numbers by employer and trade, relevant hours and work areas. Reference detailed allocations or timesheets rather than duplicating unnecessary personal data.

Total labour on site: _____
Subcontractor labour included? Yes / No
Any overtime worked? Yes / No (if yes, record hours and reason)

Section D: Plant and Equipment

Record each item, its location, operating or standing periods, the reason and what happened to the operator. Cost and entitlement require separate assessment; no standard hourly allowance follows from a diary entry.

Section E: Materials Delivered and Used

Any rejected deliveries? Yes / No (if yes, describe reason and impact)

Section F: Work Completed

This is the most important section commercially. Describe what was done, where, and how it relates to the Accepted Programme.

Does progress match the Accepted Programme? Yes / No
If behind programme, explain: _________________________________
Is an early warning required? Yes / No

Section G: Instructions, Variations, and Events

Keep instructions and events in an identifiable section with a source, time and follow-up reference.

Any new compensation events identified today? Yes / No
Any early warnings to raise? Yes / No
Reference numbers: _______________

Section H: Visitors, Inspections, and Meetings

Section I: Health, Safety, and Environmental

Section J: Photographs

Take photographs where they help explain progress, conditions or events, subject to site rules. Add captions and location references. The number needed depends on the work; there is no universal five-photo rule.

Section K: Summary and Sign-Off

How to Use This Template: Field-by-Field Guidance

Record during the shift where possible, then review the completed entry for dates, locations, quantities and supporting references.

Fill It In Throughout the Day

Use a format that is accessible at the work area. Record the source and timing of an instruction promptly, and keep its formal communication reference.

Be Specific, Not Descriptive

For more examples of well-written diary entries, see our dedicated guide.

Link Every Entry to a Programme Activity

Your Accepted Programme has activity references. Use them. When a commercial manager needs to demonstrate delay six months from now, they'll search by programme activity, not by "that thing we did near the river."

Flag Events for Prompt Review

Escalate potential contractual actions promptly. Record the observation and notification references, but check the applicable contract and deadlines separately.

Worked Example: A Completed Diary Entry

Project: Illustrative highways improvement project, NEC4 ECC Option C

Weather:

• 07:00: Overcast, 8C, light breeze (Beaufort 3), dry
• 12:00: Heavy rain, 10C, moderate wind (Beaufort 5), 14mm recorded
• 17:00: Clearing, 9C, light breeze (Beaufort 3), total 24hr rainfall 19mm

Labour: 14 operatives (4 steel fixers, 3 concrete finishers, 2 banksmen, 3 general operatives, 2 site engineers). Full names on allocation sheet ref DAS-2025-04-15.

Plant: 2x 30T excavators (1 idle from 11:15 due to rain, 3.75hrs standing time). 1x concrete pump on standby from 12:00 (rain delay to pour).

Work completed:

• Rebar fixing to pile cap PC-07 completed (programme ref 4.2.3). On programme.
• Concrete pour to pile cap PC-06 delayed from 13:00 to 15:30 due to heavy rain. 18m3 placed before shift end. Remaining 12m3 rescheduled to 16 April.

Instructions received:

• 10:45: PM (D. Walsh) instructed relocation of temporary haul road from chainage 120 to chainage 180 to avoid clash with utility diversion. Verbal instruction, confirmed by email 11:20 (ref PM-INS-047). Potential CE under 60.1(1): change to Scope.

Photographs: 8 taken. Refs PH-0415-001 to PH-0415-008. Include: rain conditions at 12:00, idle plant, haul road current alignment, pile cap PC-07 rebar completion.

Summary: Good progress on rebar programme despite weather disruption. Concrete pour delayed 2.5 hours. PM instruction to move haul road will require additional earthworks. Early warning to be raised re. haul road impact on programme activity 3.1.2.

Signed: S. Chen, 18:15, 15/04/2025

This is an illustrative training entry, not a customer record. It separates progress, interruption and an instruction for further review. It does not establish a compensation-event value.

Using Site Diary Records on NEC4 Projects

The following references help connect daily observations to commercial review. Check the selected contract, options, Scope and amendments for the actual requirements.

A structured diary is useful when its information can be traced to the related project records.

Common Mistakes with Site Diary Templates

1. Filling it in from memory at the end of the day

This is the most common mistake and the most damaging. By 17:30, you've forgotten the exact time of the PM's instruction, the specific rainfall at 11:00, and whether the idle plant was stood down at 11:15 or 11:45. Those details matter in a dispute.

2. Using one template for all contract types

Adapt recording prompts to the contract and work. Do not treat an example form as proof that contractual notification or record requirements have been satisfied.

3. Not linking entries to the Accepted Programme

"Worked on drainage" tells a commercial manager nothing. "Installed drainage run MH-14 to MH-15 per programme activity 5.3.1" lets them trace the entry directly to the programme, identify delay, and build a compensation event quotation. The difference is five extra words.

4. Treating photographs as optional

Take and reference photographs where they help explain the record. Preserve originals and follow project rules for photography and personal information.

5. Storing completed templates in a shared drive nobody organises

Filling in the template is half the job. Filing it where someone can find it six months later is the other half. If your completed diaries live in a folder called "Site Stuff" on someone's laptop, they're as good as lost. Use a consistent naming convention: [Project]-[Date]-[Author].pdf.

For a full walkthrough of diary best practice, see our guide on how to write a site diary.

Printable vs Digital: Which Format Works Best?

Choose a format based on the work, connectivity, review process and access needs. Project value alone does not determine whether paper, Excel or software is appropriate.

Download Options

We've created a free downloadable version of this site diary template in Excel format, pre-configured with all the NEC4 fields above.

Download the free site diary template (Excel, no email required)

The downloadable version includes:

• Pre-formatted daily entry form (A4 printable)
• Review project and contract fields before use
• Keep local observations separate from contractual weather data
• Instruction log with CE flagging column
• Use the completed example to check the level of detail

For a shared capture and review workflow, explore Gather's site diary software and AI QS.

Site Diary Template Checklist

Use this completion checklist before signing off each day's entry:

• Date, day, and shift times recorded
• Weather at three intervals with temperature and rainfall
• Every person on site listed by name and trade
• All plant recorded, including idle time and reasons
• Materials deliveries logged with supplier and condition
• Work described by location and programme activity reference
• Every instruction recorded with time, source, and CE flag
• Relevant photographs referenced and described
• Early warning assessment completed (yes/no)
• Entry signed and timed by author

Use the checklist as a practical review aid. Completing it does not certify compliance or establish entitlement.