Reconcile the physical balance, not the original order
Open the ERP export, purchase order, or project list beside the actual reels, boxes, and coils. For each inventory line, record original quantity, current reel count, current length per reel, and a reconciliation status. A line that cannot be found, has a shorter balance, or may be returned should remain visible as a discrepancy instead of inflating the offered quantity.
Keep full reels, partial reels, boxed stock, and cut pieces on their own lines. The current balance may be documented, measured, or estimated, but the basis must follow the same line it describes. A photo reference for the reel tag and overall condition makes the balance auditable without treating an old invoice as proof of present inventory.
Explain why the material is excess
Name the surplus route for each line: project overrun, distributor stock, maintenance inventory, or facility closeout. Then separately state whether it is unused, previously removed, or a mixed recovery-oriented line. The reason material is excess does not identify the product, so retain the part number, jacket printing, storage condition, and known date information with the same record.
Boulder’s Capital Improvement Program covers six years; the city’s listed 2027 projects include multimodal improvements, bridge replacement, undergrounding, treated-water pump-station upgrades and South Boulder Creek Flood Mitigation. A project name can therefore be a useful filing reference for a seller, but it does not prove the material on a reel or make it available for purchase.
Keep reservations and release approvals visible
For every offered line, show reservation status, owner, location, release approval, and requested timetable. A reel reserved for a current project or awaiting a return should not be counted in the confirmed available balance. If the owner or approving role is not known, say so and leave the line pending rather than representing it as ready to release.
This is different from a bulk-lot worksheet: the central question here is availability, not merely whether several reels can be mapped to photographs. The purpose is to give a seller a defensible current balance before a lot-specific buying conversation, without promising an offer, price, or movement date.
Correct the invoice-total mistake with one worked line
The frequent error is carrying original purchase footage into a listing after material has been consumed, reserved, returned, or moved. Correct it by retaining the original number only as a reference and presenting a current, line-level balance with its evidence basis. Unknown length, missing tags, and pending approval are useful status notes, not reasons to guess.
Illustrative inventory example—not a purchased lot: OV-BD-07, feeder cable with part number on reel tag; two reels, 300 ft documented and 180 ft estimated; one project release approval pending. That example shows why confirmed and pending quantities must stay apart.
- Original quantity and present balance shown separately
- Reel reference and photo reference retained per line
- Reservation and release status not silently folded into availability
