# Change Order Log and Unapproved Exposure Worksheet

> Source: https://netray.co/tools/eto-change-order-log-and-exposure-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Log every change order with status, price, cost, schedule days and approved amount. Computed columns show margin and the unapproved exposure that is at risk of write-off.

## Category

industry-templates

## Industry

Engineer-to-Order Machinery

## Audience

- Project manager
- Contracts manager
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### CO number

**Key:** co

**Type:** text

#### Date raised

**Key:** date

**Type:** date

#### Description

**Key:** desc

**Type:** text

#### Status

**Key:** status

**Type:** select

**Options:**

- Draft
- Submitted
- Negotiating
- Approved
- Rejected
- Withdrawn

#### Our cost

**Key:** cost

**Type:** number

**Format:** currency

#### Quoted price

**Key:** price

**Type:** number

**Format:** currency

#### Approved amount

**Key:** approved

**Type:** number

**Format:** currency

**Help:** Signed value only. Leave 0 until the customer has authorised in writing.

#### Schedule days

**Key:** days

**Type:** number

**Unit:** days

#### Margin on quote

**Key:** margin

**Type:** number

**Expr:** price - cost

**Format:** currency

#### Margin %

**Key:** margin_pct

**Type:** number

**Expr:** if(gt(price, 0), (price - cost) / price * 100, 0)

**Format:** percent

#### Unapproved exposure

**Key:** exposure

**Type:** number

**Expr:** price - approved

**Format:** currency

**Help:** Quoted price not yet authorised. For rejected or withdrawn items, our cost may still have been incurred.

**Rows:**

**Co:** CO-001

**Date:** 2026-03-04

**Desc:** Add guarding and light curtain at infeed

**Status:** Approved

**Cost:** 18400

**Price:** 24600

**Approved:** 24600

**Days:** 6

**Co:** CO-002

**Date:** 2026-04-17

**Desc:** Change conveyor width to 900 mm

**Status:** Approved

**Cost:** 31200

**Price:** 38900

**Approved:** 36000

**Days:** 14

**Co:** CO-003

**Date:** 2026-05-22

**Desc:** Second HMI station at unload

**Status:** Submitted

**Cost:** 9800

**Price:** 13400

**Approved:** 0

**Days:** 3

**Co:** CO-004

**Date:** 2026-06-30

**Desc:** Redesign mounting frame for new PLC rack

**Status:** Negotiating

**Cost:** 22600

**Price:** 27800

**Approved:** 0

**Days:** 9

**Co:** CO-005

**Date:** 2026-07-14

**Desc:** Customer-requested documentation in two languages

**Status:** Rejected

**Cost:** 4100

**Price:** 5200

**Approved:** 0

**Days:** 0

**Totals:**

#### Total cost

**Key:** cost

**Agg:** sum

**Format:** currency

#### Total quoted

**Key:** price

**Agg:** sum

**Format:** currency

#### Total approved

**Key:** approved

**Agg:** sum

**Format:** currency

#### Total unapproved exposure

**Key:** exposure

**Agg:** sum

**Format:** currency

#### Total schedule days

**Key:** days

**Agg:** sum

**Format:** days

**Summary:**

#### Approved as share of quoted

**Key:** approval_rate

**Expr:** if(gt(sum_price, 0), sum_approved / sum_price * 100, 0)

**Format:** percent

**Primary:** true

#### Blended margin on quotes

**Key:** blended

**Expr:** if(gt(sum_price, 0), (sum_price - sum_cost) / sum_price * 100, 0)

**Format:** percent

#### Average schedule days per change

**Key:** avg_days

**Expr:** if(gt(count, 0), sum_days / count, 0)

**Format:** days

**Notes:** Exposure is quoted price minus approved amount, so it includes negotiating, submitted, rejected and withdrawn items. Filter the table by status when you review: negotiating items are a collection risk, rejected ones may be sunk cost. Keep one row per change order and never edit an approved row; add a new change order for revisions.

## Content

**Intro:** On a long ETO project, five small changes can quietly consume the margin on the whole job. A disciplined change order log is the cheapest control available: it shows what has been asked for, what has been priced, what has been signed and what is still just a verbal yes.

**Sections:**

#### How to use the log

**Body:** Add a row whenever a customer, engineer or site team raises a change, even before it is priced. Update the status as the change moves from draft to submitted, negotiating and approved. Enter your cost and quoted price, and only enter an approved amount when the customer has signed. The computed columns show margin and unapproved exposure, and the totals give approval rate, blended margin and the schedule days added. Export it to Excel for the weekly project review.

**Bullets:**

- One row per change, numbered in sequence
- Approved amount stays zero until signed
- Review the log at every project meeting

#### What the numbers mean

**Body:** Unapproved exposure is quoted price minus approved amount. A high number means you are doing or have done work you have not been paid for. Approval rate shows how your change orders land with customers: a low rate suggests either overpricing, weak justification or work done ahead of authorization. Blended margin on quotes should be compared with your base project margin; if change orders earn far less, you are pricing them at cost to keep the peace. Schedule days are cumulative, so use them in any delay discussion.

#### Process notes for ETO shops

**Body:** Most contracts require written authorization before extra work begins, and the right to payment can depend on following that notice process. Give project engineers and site leads a short rule: no work on a verbal change. Tie each change order number to a work order or project task in the ERP so cost collects against it, which makes the cost column accurate. At close-out, reconcile the log to the final invoice to catch unbilled approved amounts.

#### Common mistakes

**Body:** Teams keep the log in several spreadsheets, record verbal approvals as approved, forget to log customer-caused delays that have no price, or never reconcile approved amounts to invoices. Another is bundling several changes into one change order, which makes partial approval hard to track.

**Bullets:**

- Do not delete rejected rows, they show where cost was incurred
- Log schedule-only changes with a zero price
- Reconcile to invoices monthly

**Cta:** If your change orders sit in email threads and ERP notes, Netray can build a private agent that assembles this log and flags unapproved work against live job cost. Ask for a demo.

**Faq:**

#### What should count as a change order?

**Answer:** Any customer-directed or contractually justified change to scope, schedule or specification that affects cost or time. Log them early, including ones you may absorb, so you can see the total cost of change and decide consciously what to charge.

#### Why track rejected change orders?

**Answer:** Because the cost of the work may already have been incurred, and rejected items are evidence of scope pressure. They also help you judge which pricing and justification approach works with each customer.

#### How is unapproved exposure calculated?

**Answer:** It is the quoted price minus the approved amount for each row. Summing it shows the revenue that is quoted but not yet authorised. It includes items under negotiation and those rejected, so read it with the status column.

#### Can this feed revenue recognition?

**Answer:** It supports it, but accounting policy decides when unapproved change orders may be included in the transaction price. Share the log with your controller and follow their guidance.

## Search terms

change order log template, change order tracking spreadsheet, change order log excel, project change order register, unapproved change order exposure, change order tracker, construction change order log, manufacturing project change log

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json