Replace order totals with a current physical balance
A purchase order or ERP export can identify what was ordered, but it is not proof of what remains after change orders, returns, contingency reservations, or transfers. Match every line on the project export to a physical reel, box, or cut piece. A line that cannot be located should remain not located instead of being counted as available.
Keep retained, returned, reserved, release-pending, and released material visible. This is a seller task about present availability, not a request to reconstruct the project budget. The buyer needs a current count that can be compared with the supporting paperwork without assuming the original order is still on site.
- Project reference and original part number.
- Current physical line and storage location.
- Reserved, returned, release-pending, or released status.
Split the list by actual form and current condition
List full reels, partial reels, boxed product, and cut lengths on separate lines. Record a continuous length for each reel and a piece count for cut sections. Group only truly matching products; different conductor metal, size, marked voltage, or condition deserves its own record even if the items were ordered together.
For each line, give a concise condition description such as uninstalled, removed, packaging damaged, or history incomplete. Photographs describe visible condition but do not establish performance. The goal is an honest project-closeout inventory, not an assertion that every line has the same history.
- Reel ID or inventory reference.
- Form factor, continuous length or piece count.
- Quantity basis and condition note.
Make photos auditable against the inventory
Use the inventory reference in each overview, tag, and jacket-printing file name. Attach a reel overview plus close photographs of readable tags or jacket legends. If a reel has faded printing, show what can be read and label the missing detail as unknown rather than borrowing a description from another reel.
When a group shares the same marked specification, retain a visible tag or reference for each reel. One polished photo should not stand in for a group whose lengths, flanges, or release status differ. The file set should let a reviewer move from spreadsheet row to the physical item without guessing.
- Reference-matched overview photo.
- Tag and jacket-printing photo when accessible.
- Visible differences and unreadable fields identified.
Record owner approval and handling constraints
Add the owner, authorized signer, location or ZIP, access limitations, available loading equipment, and requested release window. If an internal closeout step is unresolved, mark the affected reels as approval pending. Do not turn an inquiry into a pickup instruction or assume movement before lot-specific terms are discussed.
Where a reel is reserved for an active project, say so. A buyer can then review the documented remainder without being given an artificial all-or-nothing total. Clear release status prevents a common seller error: treating a line on a report as transferable before the person with authority has approved it.
- Owner and authorized signer.
- Site access and available loading resources.
- Release status and outstanding approval step.
Keep the local reference proportionate
The City of Fresno Capital Projects Department delivers projects for parks, public-safety facilities, sewer and water facilities, public buildings, roadways, and pedestrian/bicycle projects. It supports the possibility that sellers may need a disciplined closeout workflow for the listed project types; it does not prove that any public project has excess cable or that the City is offering material.
Illustrative inventory example—not a purchased lot: RW-12; part number recorded from tag; two reels with 300 ft and 180 ft documented; one reel reserved pending closeout; sale approval pending. The record preserves a smaller current balance rather than presenting the original order total as available.
- Do not combine reserved reels with released stock.
- Use current footage rather than invoice total.
- Email the inventory and reference-matched photos to saleselectricalbuyers@gmail.com.
