Draw the boundary around what is actually offered
Begin with availability status. Split the list into offered, retained for a project, reserved, pending return, and approval-pending lines. Within each group, identify full reels, partial reels, and cut lengths. The reason material became excess belongs beside the line, but it does not replace the cable part number or condition description.
A frequent error is describing every line on an old export as available because it once appeared on a purchase order. The inventory should instead identify the physical items now on hand and the rows that still need confirmation. That gives a buyer a realistic starting list without declaring that every historical line can be released.
- Use availability status, surplus reason, form factor, and condition as separate fields.
- Keep retained, reserved, and approval-pending material visible rather than blending it into offered stock.
Reconcile the export against individual reels
Match each inventory reference to an actual reel, coil, box, or package. Record the part number, current reel count, per-reel length, and quantity basis. When the source record shows an original purchase quantity, retain it only as background; the current balance needs its own field.
If only some reels can be found, show the discrepancy rather than allocating the missing footage across the located reels. A row can say per-reel length unknown or physical match pending. That approach keeps the next verification action clear and avoids turning an old total into an asserted current amount.
- Match reel labels and photo filenames to the inventory reference.
- Record per-reel lengths as measured, documented, estimated, or unknown.
Keep ownership and release status explicit
Record the owner or internal role that can authorize a sale, the release status, and the information still needed for a pending line. A warehouse location or an employee who can show the stock does not by itself demonstrate authority to release it. Do not hide approval-pending material in a combined total.
The city’s Business Resources page lists a City of Norwalk Business License page with application requirements, fees and renewal information for businesses operating within the city. That city information may matter to a business’s administrative records, but it does not prove cable ownership, cable identity, or approval for a specific inventory line.
- Use owner, release authority, and approval status as three distinct fields.
- Mark a line release pending when approval has not been recorded.
Package the evidence by line item
For each offered line, pair the inventory reference with tag images, jacket markings, a reel overview, and any condition detail. Store the storage location, access restrictions, and available loading resources on the same line or location group. A clean file set makes it possible to see which photos document which quantity.
Where a tag is missing or a reel is partly consumed, state the gap in the record. The useful response is a specific next action such as taking a tag photograph, measuring the remaining continuous length, or confirming the owner—not a guessed product or amount.
- Photo references should use the same identifier as the inventory line.
- Describe missing tags, unknown lengths, and unresolved approval separately.
Use a fictional release record as the format
An illustrative inventory example, not a purchased lot, is NW-OV-01: project-overrun feeder cable; part number on tag; two reels with 300 ft documented and 180 ft continuous, documented; uninstalled; release pending. Its value is that the status is visible alongside the quantity.
The correction for an old-invoice error is to preserve the length of every reel, identify reserved and pending lines, and state the evidence basis for the current balance. It is not to relabel an invoice total as current surplus.
- Illustrative record fields: inventory line, material reference, per-reel quantity, condition, and release status.
- Keep incomplete rows in the reconciliation until their missing evidence is resolved.
