Construction Change Order Exposure & Margin Tracker | Excel Project Control Template

A change order log tells you what changed. A project-control tool tells you where the money is exposed.

The Construction Change Order Exposure & Margin Tracker is an editable Excel workbook built for project managers, general contractors, construction managers, specialty contractors, and small construction teams that need a practical way to manage potential and approved changes without buying another software subscription.

What it tracks

• Potential changes and approved change orders
• Owner proposed and approved revenue
• Vendor proposed and approved cost
• Other approved cost
• Potential cost exposure
• Suggested sell value using your markup and tax settings
• Pending owner revenue
• Unrecovered committed cost
• Realized margin and margin percentage
• Schedule days added or recovered
• Days open and aging buckets
• Risk, priority, category, and requested-by fields

Included workbook tabs

• START HERE: quick instructions and workflow
• Setup: project information, original contract value, markup, and tax
• Change Log: 200 ready-to-use change rows with formulas and dropdowns
• Dashboard: contract value, pending exposure, cost, margin, aging, risk, and management watchlist
• CO Snapshot: clean summary view for any selected change
• Lists: editable dropdown values

Why this is different

Most change-order spreadsheets stop at “pending” and “approved.” This workbook also highlights committed vendor cost that has not been recovered from the owner, so project teams can see financial exposure before it becomes a month-end surprise.

File format

• Microsoft Excel .xlsx
• No macros
• No subscription
• Editable formulas and dropdown lists

What you receive: one Excel workbook, quick-start README, and single-business-use license.

Important: This is a project-management template, not legal or accounting advice. Contract notice and authorization requirements always control.