Change Order Log Check: The Approved Change Order That Never Reaches the Pay Application
An approved change order can clear every signature and still never be billed — not because anyone rejected it, but because it never got a line on the pay application's Schedule of Values. The approval lives on the change order log. The billing lives on the schedule. The two lists are maintained separately, and a change order that exists on only one of them is work the contract has agreed to pay for that the billing structure has no place to charge.
Of the ways a change order loses money quietly, this is the quietest. Nothing is mispriced. Nothing is missing its backup. The line the money was supposed to travel on was never built.
Why approved work never reaches the schedule
The Schedule of Values is usually built at the start of the job, from the original contract scope. Change orders arrive afterward, one approval at a time, across the life of the project.
Adding an approved change order to the billing means a second, separate act: someone has to open the schedule and give it a line. That act has no deadline of its own. The approval is signed on a Tuesday; the schedule is updated when the next pay application is prepared, from memory, or from a list of recent approvals that may or may not be complete. A change order approved between applications, or approved while the billing staffer is working from last month's file, can be signed, filed, and fully documented — and absent from the schedule entirely.
Each list looks right read alone. The log shows the approval. The schedule shows every line it has. The gap only exists between the two lists, and it is found by asking one question of every approved change order: do you have a line?
Check it by hand
The manual version of the check is a comparison, and it is worth doing once even on a small job. Take the change order log and filter it to approved change orders only. Take the Schedule of Values and list every change order it carries a line for. Any approved change order on the first list that does not appear on the second is the defect — approved work with no billing line under it.
On a job with three change orders, that comparison takes minutes. On a job with forty, across several months of approvals and schedule revisions, it is the kind of comparison that gets postponed — and every month it is postponed, the missing line bills nothing, because a pay application can only bill against lines the schedule contains.
What the EX-06 check actually tests
EX-06 is the check for this problem in the Construction Control workbook, and its mechanism is a count.
For each change-order request whose status is Approved, the workbook counts how many lines on the pay application's Schedule of Values name that request. If the count is zero — the approved request appears nowhere on the schedule — the request is flagged, and the workbook's Exception Report counts the flagged requests so they can be reviewed as a set.
Here is the shape of it, with invented COR numbers and amounts for illustration:
| COR | Status | Approved amount | Lines on the Schedule of Values | Flag |
|---|---|---|---|---|
| COR-401 | Approved | $3,600 | 2 | — |
| COR-402 | Approved | $1,250 | 0 | Flagged |
| COR-403 | Approved | $980 | 1 | — |
COR-401 has lines and is not flagged. COR-402 is the defect: approved, priced, and absent from the schedule — there is no line to bill it on, this month or any month, until someone adds one. COR-403 is the row worth pausing on: it has a line and nothing billed against it yet, and EX-06 does not flag it. Whether the billed amount on a line that exists matches the approved amount is a different question, asked by a different check. EX-06 asks only whether the line is there.
The limits, stated plainly
EX-06 tests absence. It does not compare amounts, and it does not know why a line is missing.
A change order approved this week, with its schedule line deliberately scheduled for next month's update, is flagged exactly like one forgotten for a year. The flag cannot tell those apart, and it is not trying to: it is a worklist of approved change orders with no line, for a person to sort into "not yet" and "never added." The second kind is the one that matters, and it is invisible until the two lists are compared.
Only approved change orders are tested. A pending change order with no schedule line is not flagged — it has not been approved, so there is nothing yet that the schedule is failing to carry. And the check reads the pasted billing data only: if a line exists in the billing software but was never pasted into the workbook, the workbook cannot see it. A flag means the line is missing from the data the check can read — the fix starts by confirming where the line actually lives.
How EX-06 fits the seven
EX-06 is one of seven checks in the workbook. EX-01 counts duplicate ticket IDs by exact match. EX-02 flags tickets with Date, Scope, Labor hours, or Loaded $/hr blank — exactly those four fields. EX-03 flags a ticket with no change-order reference in its link column. EX-04 flags a change-order request whose linked tickets total $0 — a test of the ticket total, not of ticket existence. EX-05 compares a pending change-order request's amount against the total of its linked tickets — an amount comparison, not a status match. EX-07 flags an approved change-order request whose billed-to-date differs from its approved amount — and it only takes up requests that appear on the schedule at least once, which is why the missing-line case belongs to EX-06 and not to it.
Each check asks one narrow question. EX-06's question comes before billing can start: is there a line for this approved work at all?
Where to go from here
This one check runs free on the Construction Control site, on sample data — the EX-06 check page shows the flag on a request with no line and clears the ones that have lines:
The free pay-application checklist — the seven checks as a list you can work through by hand — is a separate listing, here:
If you want the checks themselves, the Construction Control workbook is $39 — a macro-free Excel workbook for desktop Excel with 528 formulas, including EX-06 and the six other checks named above. Data goes in by pasting from four CSV templates; there is no importer. It is a worksheet for use alongside your AIA G702/G703 — it does not replace them. The workbook listing is here: https://payhip.com/b/rXZ62?utm_source=devto&utm_medium=article&utm_campaign=evergreen&utm_content=article-7
Disclosure: this article was drafted with AI assistance. It is from Construction Control, maker of the workbook.
Top comments (0)