Free · No signup

Construction Project Controls Templates (Free Excel Downloads)

Q: Which project controls template should I start with?

Start with the S curve and progress report if you need client-facing reporting, or the EVM calculator and cost to complete forecast if your priority is cost control. The lookahead planner and RFI register sit underneath both.

Q: Can these templates replace project controls software?

They work well for a single project or a small portfolio kept up to date by one person. They struggle once several people update different sheets, which is when most teams start looking at software that reads the same underlying records automatically.

Nine free Excel templates covering the full project controls cycle: programme, earned value, cost forecasting, changes and reporting. Built by quantity surveyors and planners, no email wall.

Project controls is the set of disciplines that keep a construction project's cost, time and scope aligned to a baseline throughout delivery, covering programme monitoring, cost and earned value reporting, change management and progress reporting so deviations are caught while they are still recoverable.

The templates in this pack

The forecasting and reporting layer, from the short interval programme through to the board pack. Every one is a direct .xlsx download.

S-curve template

Plot planned against actual progress as a classic S-curve from your programme data.

EVM calculator

Work out CPI, SPI, EAC and ETC from your cost and progress data.

Progress report template

Turn daily diary entries into a weekly progress report against programme.

Cost to complete forecast

Forecast the cost to finish from actuals to date and remaining scope.

Lookahead planner

Two, four and six week programmes with constraints and predecessors built in.

RFI and TQ register

Every query logged with response deadlines and programme impact.

Variation and change order tracker

Log and value instructed changes (NEC4) and variations (JCT) as they happen.

Compensation event log

Every CE from notification to implementation, with the eight week time bar calculated.

Construction project dashboard

One page for programme, cost and risk, ready for the weekly meeting.

What's in each template

Template	Core fields	Best for
S-curve	Planned against actual value, cumulative % complete, variance	Programme reporting, board packs
EVM calculator	PV, EV, AC, CPI, SPI, EAC, ETC	Monthly cost and schedule performance review
Progress report	Weekly activities, % complete by area, programme variance	Client-facing weekly reporting
Cost to complete	Actuals to date, remaining scope, forecast final cost	Monthly CVR and forecasting
Lookahead planner	Two, four and six week activities, constraints, predecessors	Site delivery planning meetings
RFI and TQ register	Reference, description, date raised, response due, programme impact	Design query tracking
Variation tracker	Reference, description, value, status, approval date	Instructed change and variation control
CE log	Clause 60.1 trigger, notification date, eight week time bar, quotation status	NEC4 commercial management
Project dashboard	Programme status, cost status, top risks, key actions	Weekly project team meeting

Why project controls slip on paper trackers

Most of these templates fail the same way once a project gets busy: the S-curve is only as current as the last time someone updated it by hand, the CE log only shows events someone remembered to notify, and none of them talk to each other, so the dashboard is a manual roll up built from five other spreadsheets the night before the meeting.

That's not a template problem. It's a records problem. Every one of these trackers is downstream of the same site data: diaries, allocations, instructions and correspondence. If that data is captured consistently, the templates populate themselves. If it isn't, no amount of formula work fixes the gap.

Nine trackers, one underlying record. Gather keeps them all current automatically.

Gather's AI QS reads your site diaries and correspondence as they land, keeping progress, cost and commercial position aligned to programme without a manual roll up.

See how Gather automates project controls A 30 minute call. No commitment. Bring one of your live projects.

Common questions about project controls

Which project controls template should I start with?

Start with the S-curve and progress report if you need client-facing reporting, or the EVM calculator and cost to complete forecast if your priority is cost control. The lookahead planner and RFI register sit underneath both.

Do NEC4 and JCT projects need different trackers?

The commercial mechanics differ. NEC4 projects track instructed changes through compensation events, so the CE log is the primary register. JCT projects track variations directly, so the variation tracker does the equivalent job. Both are included in this pack.

Can these templates replace project controls software?

They work well for a single project or a small portfolio that one person keeps up to date. They struggle once several people update different sheets, which is when most teams start looking at software that reads the same underlying records automatically.

Stop rebuilding these trackers by hand every week

Gather reads your site records as they come in and keeps programme, cost and commercial position aligned automatically.

Book a demo

Need the registers underneath these forecasts?

The commercial registers are in Construction Commercial Management Templates, and the daily site record is in Construction Site Records Templates. All 23 are listed on Free templates and tools.