Free change order log · Excel

Free Pending Change Order Log Template

Track every change from potential change order (PCO) to change order request (COR) to approved CO — with days outstanding, pending exposure, schedule days, and a summary of pending, approved, and rejected totals.

  • PCO → COR → CO lifecycle on one row per change
  • Origin tracking: RFI, owner directive, field condition, ASI, AHJ
  • ROM, submitted, and approved values side by side
  • Days outstanding (auto) with 30 / 60-day aging flags
  • Pending exposure and schedule days requested vs. approved
  • Summary: pending / approved / rejected totals + revised contract
  • Approval rate and ball-in-court counts

Pending Change Order Log

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

Change Log

One row per change: origin and reference, ROM, COR submitted value, status, CO number, approved value, schedule days, days outstanding, pending exposure, and ball in court.

02

Summary

Counts and dollars by stage, pending exposure, revised and potential contract value, approval rate, aging over 30 / 60 days, and ball in court.

03

Instructions

The PCO / COR / CO lifecycle explained, plus how to keep the log current. Not legal advice.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

What is a pending change order?

A pending change order is a change to the work that has been identified or priced but not yet approved. Contractors usually track it in stages: a potential change order (PCO) when the change is first identified, a change order request (COR) when it has been priced and submitted, and an approved change order (CO) once the owner or GC signs it.

What is the difference between a PCO, a COR, and a CO?

A PCO (potential change order) is an internal record that something changed — it may not have a price yet. A COR (change order request, sometimes called a change proposal) is the priced request you submit to the owner or GC. A CO (change order) is the signed document that changes the contract sum and/or time. This log tracks each change through all three.

How are days outstanding calculated?

From the COR submitted date (or the date identified, if it hasn't been submitted) to the decision date — or to today while it is still open. Open items turn amber over 30 days and red over 60, which is when unapproved changes start to hurt cash flow.

What is pending change order exposure?

The dollar value of changes you have identified or submitted that are not yet approved — the submitted value if you have priced it, otherwise your rough order of magnitude (ROM). It is money you have spent or will spend without a signed change order, and the number your PM, CFO, and bonding agent want to see.

Can I perform changed work before the change order is signed?

That depends on your contract. Many contracts bar payment for changed work performed without written authorization, and most require written notice of a change within a set period. Get a written directive (or a construction change directive) before you proceed, and read your changes clause. This template is not legal advice.

Every change, from first notice to signed change order

A pending change order log is the running list of every change on a project that has not yet been approved — and the ones that have. It tracks each change from the potential change order (PCO), through the priced change order request (COR), to the signed change order (CO), so nothing gets built and never billed.

This free Excel template calculates days outstanding and pending exposure for every change and summarizes pending, approved, and rejected totals, revised contract value, approval rate, and ball in court. Read your contract's changes clause for notice deadlines and pricing rules — this template is not legal advice.

When a change is approved, write it up on our change order template and add it to your schedule of values so it gets billed.

How to run a pending change order log that gets changes paid

Unapproved change orders are where contractor margin goes to die. Not the big, argued-over claims — the dozens of $1,500 to $25,000 changes that pile up quietly: the RFI answer that moved a panel, the tenant walk that added receptacles, the ASI that re-sequenced the controls. Each one is small enough that nobody chases it, and together they're 3–5% of the contract sitting unbilled while your crews have already done the work.

A pending change order log fixes that by making every change visible from the day it's identified until the day it's signed. The free template above tracks each change through the full lifecycle — PCO → COR → CO — and rolls up pending exposure, aging, schedule days, and ball in court on a summary tab. If you need the change order document itself, use our change order template; this log is how you manage all of them.

Not legal advice. Your contract's changes and claims clauses control notice deadlines, pricing rules, and whether you can be paid for work done without a signed change order. Read them first.

The change order lifecycle: PCO, COR, CO

StageWhat it meansWhat you record
PCO — potential change orderSomething changed. You may not know the price yet.Title, origin, reference document, date identified, owner notified date, ROM value.
COR — change order requestYou priced it and submitted it to the owner or GC.COR number, date submitted, submitted value, schedule days requested, ball in court.
CO — change orderThe owner or GC signed it. The contract sum and/or time changed.CO number, decision date, approved value, schedule days approved.

Terminology varies — some GCs call the COR a "change proposal," "PCO submission," or "change estimate," and owners using AIA documents may issue a construction change directive (CCD) that directs the work before the price is agreed (AIA A201-2017 §7.3). Use whatever labels your contract uses; the stages are the same.

Where changes come from

The log's Origin column tracks the source of every change, because the source tells you how to price it and who pays:

  • RFI — an answer that adds, moves, or changes work. The most common source, and the most commonly missed: the RFI gets closed and nobody opens a PCO.
  • Owner directive — the owner or tenant asks for something new. Get it in writing before you start.
  • Field condition — differing site conditions, abandoned utilities, existing conditions that don't match the drawings.
  • Design change / ASI — architect's supplemental instructions and bulletins that revise the documents after bid.
  • Code / AHJ requirement — inspector or fire marshal requirements beyond the permitted drawings.
  • Value engineering, allowance reconciliation, sub-initiated — deducts and adds that need tracking just as closely.

How to use the log

  1. Open a PCO the day the change is identified — even without a price. Enter a ROM so it shows up in exposure immediately.
  2. Notify in writing within the contract notice period and enter the Owner Notified date. The summary counts open items not yet reported to the owner — that number should always be zero.
  3. Price it with backup and submit the COR. Labor, material, equipment, subs, and markup per the contract. Enter the COR number, date, submitted value, and schedule days requested.
  4. Work the ball-in-court list every week. Items on you get priced; items on the owner or A/E go on the OAC meeting agenda.
  5. Record the decision. Approved, Rejected, or Void, the decision date, the CO number, and the approved value — which is often not the submitted value.

What the formulas calculate

  • Days Outstanding — from COR submitted (or date identified if not yet submitted) to the decision date, or to today while open. Amber over 30 days, red over 60.
  • Pending Exposure — for open items, the submitted value if priced, otherwise the ROM.
  • By stage — count, ROM, submitted, and approved dollars for PCOs, CORs, approved, rejected, and void items, with in-cell bars.
  • Contract value — original contract, approved changes, revised contract, and the potential contract value if every pending change is approved.
  • Approval rate — approved dollars divided by submitted dollars on decided CORs. If it's consistently low, your pricing backup or your markup is the problem.
  • Aging and ball in court — average days outstanding, items over 30 and 60 days, and how many open items are waiting on you, the owner, the A/E, subs, or suppliers.

Why pending change orders matter beyond the job

Pending exposure shows up in three places outside the project team:

  • Cash flow. You've paid for the labor and material on changed work. Until the CO is signed, you can't bill it.
  • The WIP schedule. Accountants are cautious about recognizing revenue on unapproved change orders, so large pending balances can make a profitable job look like it's fading. See our WIP schedule template.
  • Claims. Changes that sit unapproved for months become disputes. The log's dates — identified, notified, submitted, decided — are the timeline you'll need if they do.

Common change order mistakes

Doing the work without a written directive

"Just go ahead, we'll paper it later" is how contractors end up performing changed work for free. Many contracts bar payment for work performed without written authorization. Get an email at minimum, a signed directive or CCD ideally.

Missing the notice period

Notice of a change often has its own deadline, separate from the pricing. If a change is also delaying the work, send a notice of delay too.

Pricing without backup

A lump sum with no breakdown invites a counter-offer. Price from quantities, labor units, and quotes — and attach them. T&M tickets signed daily are the backup for work priced after the fact.

Letting approved COs sit outside the budget

An approved CO that isn't added to the budget and schedule of values doesn't get billed. Close the loop the day it's signed.

From spreadsheet to system

A log works well for one PM on one job. Once you're tracking dozens of changes across several projects, the gaps show up: RFIs closed without PCOs, approved COs never added to the budget, nobody sure which version of the log is current. Field PM links RFIs to change orders, carries approved COs straight into the job budget and schedule of values, and shows pending exposure on the PM dashboard. Start a free 30-day trial — no credit card required.

Related free templates

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice