Freeze the export before correcting it
Save the inventory export with its date and treat it as a starting record. Keep the SKU or part number, project or order reference, and original quantity visible so later changes can be explained. The key error is silently carrying an old invoice figure forward after reels have been issued, moved, reserved, or partially used.
Assign each source line a physical-match status: found, moved, missing, reserved, or not yet checked. That status is more useful than deleting inconvenient lines. It creates an audit trail between the system record and the present lot without claiming that the export alone proves current inventory.
- Dated export retained as the source record
- SKU or part number linked to a physical-match status
- Found, moved, missing, and reserved lines kept distinct
Reconcile present footage reel by reel
Match every found line to a reel ID, readable tag or jacket printing, and a photo reference. Record reel count and continuous footage per reel, with measured, documented, or estimated clearly stated. A partial reel should not be represented by its original shipped length, and cutoffs should not be rolled into the footage of a full reel.
Where an export description and the physical tag disagree, preserve both in the record and flag the conflict. The product marking belongs in the seller package; the system description remains useful only as a reconciliation reference. This keeps inventory control work separate from an assumption about the cable construction.
- Reel ID and photo reference matched to each line
- Present footage, not original order footage
- Measured, documented, and estimated balances distinguished
Separate available stock from a reservation
San Joaquin County identifies Interstate 5 and Highway 99 as major regional distribution arteries and says BNSF and Union Pacific operate extensive intermodal rail facilities in the region. That regional context can help a seller identify where inventory is physically held after transfers; it does not establish the status of a particular reel or a local buying outcome.
For each line, state why it is surplus: project overrun, discontinued stock, maintenance inventory, or another documented reason. Then record whether it is available, reserved, pending return, or subject to release approval. Identify the release authority for available stock and leave a pending line pending rather than presenting it as immediately available.
- Surplus reason documented per line
- Reserved or return status kept out of available totals
- Release authority recorded for each offered group
Send a discrepancy-ready seller package
Use the same reference in the export, photos, and current-balance list. Include label images, whole-reel views, visible condition notes, and a brief reconciliation note for each discrepancy. If photos or balances are incomplete, label those rows incomplete and describe what remains unknown instead of filling the gap with an estimate presented as a fact.
The practical seller decision is whether the current package supports a conversation about the actual inventory. It does not require every field to be complete, but it does require clear boundaries around what is counted, what is reserved, and who may authorize release.
- Export line, reel ID, and photo filename use the same reference
- Discrepancies explained rather than overwritten
- Incomplete lines plainly identified
