Separate exposure from approval and cash.
A single status or “change order total” hides where action is stuck. This workbook keeps the forecast, authorization, billing, and payment stages separate.
Every total stays traceable to a row.
The fictional examples below are included only to show the calculation path. Delete them before operational use.
| CO ID | Status | Forecast | Approved | Billed | Unapproved exposure | Unbilled approved | Exception |
|---|---|---|---|---|---|---|---|
| PCO-001 | Submitted | $9,200 | — | — | $9,200 | $0 | Decision overdue |
| PCO-002 | Approved | $4,800 | $4,600 | $3,000 | $0 | $1,600 | Unbilled; unpaid |
| PCO-004 | Negotiating | $17,200 | — | — | $17,200 | $0 | Overdue; high exposure |
Synthetic dashboard totals after Microsoft Excel recalculation: US$26,400 open unapproved exposure, US$1,600 approved-not-billed, US$3,000 billed-not-paid, and US$43,750 expected final impact.
The workbook already exists.
Version 1.0 was generated, reopened, fully recalculated in Microsoft Excel, and checked against all five synthetic examples before this page was published.
Artifact SHA-256: 8753af524204201d5d3bfc3e161ecda6459d02983b3035b4c5b4308f0ad3a0a1
An operating aid, not the contract or ledger.
Request the ready-to-deliver tracker.
The order request is public and asks only about your role, spreadsheet application, and intended use. Do not include project names, contracts, customer or employee data, financial records, payment information, attachments, or an email address.
Availability and private payment and delivery instructions are confirmed before payment is due. Delivery begins only after cleared payment. The workbook may not be redistributed, resold, sublicensed, or published.
Built from recurring public workflow requests for separate pending, approved, and unapproved change logs, projected final cost, status, and aging—not from any private project data.