Reconcile records to what is physically present
An inventory export or purchase order is a starting point, not proof of current footage. Match each line to a physical reel, box, or package, then record the stable inventory reference, reel ID or tag, part number, and current physical status. When the export and material differ, keep both values visible and explain whether the current figure is measured, documented, estimated, or unverified.
The core mistake is carrying original invoice footage into a surplus list after a reel has been partly used, repackaged, reserved, or moved. Correct it with a physical count and a per-reel continuous-length record. Do not roll several short pieces into one continuous length just to preserve the old total.
- Inventory line and reel ID or tag.
- Part number or product designation when available.
- Current physical status: sealed, partial, cut, damaged, or unverified.
- Current footage and its measured, documented, estimated, or unknown basis.
Separate condition, surplus reason, and release status
Put full reels, partial reels, unopened boxes, cut lengths, and cable previously in service on separate lines. Then identify why each line is excess: project overrun, distributor stock, maintenance inventory, or closeout. These are different facts; a reason for availability does not identify the product and an unused appearance does not establish release authority.
Record reserved stock, pending returns, internal holds, and approval gaps plainly. If a reel is awaiting owner approval, label it pending rather than available. This protects the seller from presenting a balance that cannot yet be released and gives the buying conversation a truthful starting point.
- Condition category and per-reel continuous length.
- Surplus reason.
- Reservation or return status.
- Owner and release-approval status.
Keep site, photo, and spreadsheet references together
Use the same stable reference in the inventory, photo filenames, and any record attached to a reel. For every storage site, add access or loading constraints and identify who can authorize release. If a list spans several sites, group it by location instead of assuming one contact or one constraint covers every line.
A seller can include a desired release window, but it should be presented as the seller’s own constraint rather than a promise about a buyer’s timing. The immediate task is a clear record of material, evidence, ownership, and site facts; transaction terms are discussed only for the actual lot.
- Photo reference matched to the inventory line.
- Actual storage site and site-specific access limits.
- Owner and release authority for that site.
- Seller release window or internal deadline, if relevant.
Use city context to improve record grouping, not to imply stock
The city describes its Public Works department as responsible for traffic, signal and lighting infrastructure as well as the public right of way, survey, maps and records. That fact is limited local context and does not identify a public inventory, a customer, or available material. A seller with their own project files can use a workstream reference to find records, then must still reconcile the physical reels, their current footage, and their actual release status one line at a time.
This is especially important when one warehouse export combines several projects. Keep project reference, current physical status, length basis, and release status distinct instead of allowing the source of a record to stand in for proof that a reel is available.
- Project reference only as background.
- Physical reel match for every inventory export line.
- Current balance and release status kept separate.
Illustrative surplus record and correction
This fictional record is a documentation example, not a purchased lot. It keeps documented and estimated footage apart, records packaging condition, and shows a pending release approval rather than treating the reel as available. Use the same conservative approach for an incomplete warehouse list.
If an old inventory line lists a full reel but the material is partially used or still reserved, change the current status, preserve the original reference for traceability, and make the release condition visible. A complete list can contain unknowns as long as those unknowns are not presented as confirmed availability.
- Reference: OV-SP-04.
- Description: project-overrun feeder cable; part number on tag.
- Quantity: two reels; 300 ft documented and 180 ft estimated.
- Condition: unused; one reel has damaged packaging.
- Release: approval pending; not represented as currently released.
