Reconcile the report with the reels
Treat an ERP export, purchase order, or project closeout list as a starting point. Walk the offered stock and mark whether each referenced reel or package is physically present. Create a current-balance field for the footage or quantity that remains, rather than assuming the original order amount is still available.
Use a stable inventory reference on the list, reel tag, and photo filename. When a line cannot yet be checked, keep it as pending verification instead of presenting it as available. This makes an inventory change visible without overstating what the seller can release.
- Inventory reference.
- Physical reel present or pending verification.
- Manufacturer part number or readable designation.
- Current balance.
Preserve usable lengths and packaging status
Record full reels, partial reels, coils, and cut pieces separately. For each item, state the continuous length and whether the quantity is measured, documented, or estimated. A total of several pieces is not a single continuous length, and a tag showing the original fill does not automatically show the balance now on the reel.
Add clear photos of labels, packaging, flanges, and visible condition. If a reel has damaged wrapping, exposed ends, or a missing label, state that next to the line item. This allows the inventory record to remain accurate even when the condition record is incomplete.
- Reel count and full, partial, coil, or cut status.
- Continuous length per item.
- Measured, documented, or estimated quantity basis.
Explain the availability without inventing a deadline
State why the material is excess: project overrun, distributor inventory, maintenance stock, or closeout. Then distinguish items that are released from those reserved for a project, pending return, or awaiting an internal decision. Include the ownership and release-authority fields that a seller can actually confirm.
The City of Yuma describes the city as part of a tri-state corridor, connected via I-8 and SR-195, with logistics and transportation among its target sectors. That is context for possible warehouse or distributor records in the area; it is not evidence that any inventory is available or that transport has been arranged.
- Surplus reason.
- Reserved or pending status.
- Owner and release-authority role.
- Storage site and access limits.
Use one current-balance column
The common mistake is submitting the original invoice footage or one warehouse total as the remaining quantity while partial reels and reservations are left out. Resolve it with a current-balance column tied to a physical reel ID, one line for each continuous piece, and a note for every estimate or approval gap.
If stock is inaccessible for a count, say so and give the storage location, available record, and person who can confirm access. A transparent pending field is more useful than a confident total that cannot be linked to the actual material.
- Photo filenames matching the inventory reference.
- Condition and packaging note.
- Loading facts and access limits.
- Release contact or explicit unknown.
Illustrative surplus record
Illustrative inventory example—not a purchased lot: OV-YU-01; project-overrun feeder cable; part number on tag; two reels with 300 ft and 180 ft continuous, documented; uninstalled; release approval pending. It demonstrates a current balance and a release status, not a promise that the material is ready to move.
Use the same format for each offered line: identify the cable, state the present quantity and its basis, give a condition note, and state whether a reservation or approval affects release. Replace any fictional field with a documented field or an explicit unknown in an actual submission.
- Fictional record only.
- Separate the two reel balances.
- Keep release status visible.
