Project Commercial Control System

Know your forecast margin every month, not at final account.

Track cost, commitments, variations, claims and cash flow in one workbook, so the forecast at completion is a number you can stand behind in the monthly review.

What it fixes

• Variations done on site and never priced or claimed.
• "Cost to complete" that's really just budget minus spend.
• Close-out that starts after the crew's gone and the evidence is gone with them.

See it filled in

A complete 21-sheet worked example for a fictional contractor shows the system mid-project, from contract review through monthly forecast: A$3.38m forecast revenue, A$3.12m estimate at completion and a 7.6% forecast margin, with A$133k of variations still awaiting approval.

What's in the files

• 21-sheet Excel commercial control workbook and dashboard (30 cost codes, 250 rows on every register, 36 monthly periods)
• The same 21 sheets fully worked
• Contract and scope review, budget, commitments, cost to complete, estimate at completion and margin
• Variation and claim registers, billing and retention, project cash flow, risks, monthly review, close-out and final account
• Word guides: Start Here Guide, Method and Implementation Guide (with a 90-day rollout plan), Worked Example Walkthrough, and a Templates and Forms Pack of 7 editable forms, notices and checklists
• Print-ready PDFs of every guide and both workbooks

Who it's for

Contractors running several jobs at once. PMs and commercial managers who report margin each month. Owners who want early warning, not surprises.

Format: Microsoft Excel, Word and PDF. Use one copy per project.

Licence: One business. See terms.