Free · No signup

Construction Commercial Management Templates (Free Excel Downloads)

Seven free Excel templates covering the commercial side of a project: changes, valuations, cost forecasting, subcontractor performance, procurement and final account. Built by quantity surveyors, no email wall.

Commercial management is the discipline of protecting a contractor's entitlement to time and money throughout a project, through disciplined change control, accurate valuations, forecasting to completion and a final account that reconciles cleanly instead of becoming its own dispute.

The templates in this pack

The registers the commercial team lives in, from the first instruction through to settlement. Every one is a direct .xlsx download.

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.

Payment application and valuation

Monthly valuation with work done, retained and previously certified broken out.

Cost to complete forecast

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

Subcontractor performance scorecard

Turn diary and allocation data into a scored procurement record.

Procurement and long lead register

Track packages and long lead items against the dates the programme needs them.

Final account tracker

Reconcile every change, claim and valuation into a single final account position.

What's in each template

Template	Core fields	Best for
Variation tracker	Reference, description, value, status, approval date	JCT variation control
CE log	Clause 60.1 trigger, notification date, eight week time bar, quotation status	NEC4 compensation event management
Payment application and valuation	Work done to date, retention, previously certified, amount due	Monthly interim valuations
Cost to complete	Actuals to date, remaining scope, forecast final cost	Monthly CVR and forecasting
Subcontractor scorecard	Output, quality, safety and programme scores by package	Performance review and future procurement decisions
Procurement register	Package, lead time, order date, need-by date, status	Long lead item tracking
Final account tracker	All changes, claims and valuations reconciled to one position	Final account negotiation and close out

Why commercial trackers fall behind the project

These are the highest stakes spreadsheets on the project and the ones most likely to be one version behind reality. A CE log that misses one instruction, a valuation built from a cost report that's three weeks stale, or a final account tracker that doesn't reconcile back to every prior valuation, all cost real money at the point they matter most: negotiation.

The templates in this pack are built to the correct commercial logic. What they can't do is guarantee every underlying event actually gets logged, which is the gap that turns a well built tracker into an incomplete one.

A final account is only as strong as the weakest register that feeds it.

Gather's AI QS reviews your site records against the contract and surfaces the changes, events and claims your team hasn't logged yet, so your commercial position is complete before the negotiation, not during it.

See how the AI QS builds your commercial position A 30 minute call. No commitment. Bring one of your live contracts.

Common questions about commercial management

What is the difference between a variation and a compensation event?

They are contract-specific terms for the same underlying idea: a change to scope, time or cost. NEC4 contracts run instructed changes through compensation events under clause 60. JCT contracts run them through variations under clause 5. Use the tracker that matches your contract form, not both at once.

How often should a final account tracker be updated?

Ideally every time a change, claim or valuation is agreed, not just at the end of the project. A final account built entirely at close out is where disputes over forgotten items usually start.

Can a subcontractor scorecard affect future procurement?

Yes. A scorecard built from actual output, quality and programme data over several projects is a far stronger basis for a procurement decision than reputation alone.

Stop letting missed events cost you at final account

Gather reads your site records as they come in and keeps your commercial position complete and up to date automatically.

Book a demo

Need the records these registers rely on?

The daily site record is in Construction Site Records Templates, and the programme and cost view is in Construction Project Controls Templates. All 23 are listed on Free templates and tools.