A basic change order log is useful, but it answers only part of the question. It tells a project team what changed, when it changed, and whether the change is pending or approved. The harder question is financial: where is the project currently exposed?
What a basic change order log usually tracks
Most logs include a change number, description, requested amount, status, date submitted, and date approved. That is enough to maintain a record, but it can hide the gap between money committed to vendors and money recovered from the owner.
The exposure gap
Consider a subcontractor quote that has been approved internally so work can proceed, while the corresponding owner change is still under review. The project now has a real cost commitment without matching approved revenue. A status of “pending” does not explain the size of that exposure.
That is why a stronger change-control workbook separates owner revenue from vendor and other project costs. It should let a team see proposed revenue, approved revenue, proposed cost, approved cost, and the difference between committed cost and recovered revenue.
What to add beyond status
- Pending owner revenue: value proposed but not yet approved.
- Unrecovered committed cost: approved or committed cost not yet covered by owner approval.
- Realized margin: approved revenue less approved cost.
- Aging: how long a change has remained open.
- Schedule impact: days added, recovered, or still under discussion.
- Risk and priority: a simple way to focus management attention.
A log should help manage the project, not just document it
The best change-order process still depends on the contract, notice requirements, authorization procedures, and the project team’s judgment. A spreadsheet cannot replace those things. What it can do is make financial exposure visible before month-end reporting turns it into a surprise.
The Construction Change Order Exposure & Margin Tracker was built around that distinction, combining the traditional change log with owner revenue, vendor cost, aging, margin, schedule impact, and exposure reporting in one Excel workbook.