Reconcile the original record to what remains
An old purchase order or inventory export can identify a product, but it is not a current balance by itself. Start with each source line and match it to the reel, box, or cutoff that is physically present. Mark the result as current, reserved, missing, or pending approval, with a short discrepancy note where the physical count differs from the record.
This task is not a technical classification exercise. The seller decision is whether a listed item is actually available for a buying discussion now. A clear reconciliation prevents original ordered footage from being mistaken for material that remains on hand.
- Inventory-line ID and part number
- Physical reel or package reference
- Current status and discrepancy note
Preserve reel-level balance and continuity
Keep full reels, partial reels, boxed stock, and cut lengths as distinct entries. Record footage per reel and whether the number is measured, documented, or estimated. A total spread across several short pieces does not communicate the same inventory as one continuous reel, even if the aggregate footage matches.
The common error is to present invoice footage as remaining quantity while reserved reels and partial balances are treated as available. Correct it by giving every reel its own current quantity basis and by leaving unavailable material visibly unavailable in the list.
- Reel count and footage per reel
- Full, partial, boxed, or cutoff status
- Measured, documented, or estimated basis
Match photos and records to the same line
Use the inventory-line ID or reel reference in image filenames, then capture a readable label, jacket printing, and an overview for that same item. If a data sheet exists, note exactly which line it supports. A photo of a similar product should not be used to fill a missing tag on another reel.
When documentation is incomplete, leave the affected field unknown and keep the item on a separate line. That lets a buyer understand both the confirmed product record and the gap instead of assuming a match that the seller cannot demonstrate.
- Photo filename linked to inventory line
- Reel-label and jacket-marking image
- Matching data-sheet reference or explicit unknown
Record release status and actual access facts
Choose Columbus says Columbus has direct access to U.S. Highway 80 and I-185, Norfolk Southern and CSX rail, Columbus Airport and Hartsfield–Jackson Atlanta International Airport, with intermodal connections to the Port of Savannah. This is local logistics context only; it does not set transport terms for a particular cable list.
For the offered balance, name the owner or role able to discuss release, identify any reservation or approval still pending, and state the material location and known site constraints. Those facts keep a current inventory list from implying that every physical item is already cleared for disposition.
- Ownership or release-contact role
- Approved, reserved, or pending status
- Location and known access constraint
Illustrative balance: show the uncertainty
Illustrative inventory example—not a purchased lot: line OV-COL-07 identifies a project-overrun feeder cable by its tag. It shows two reels: 300 feet documented and 180 feet estimated. The condition is uninstalled; the second reel is marked internal approval pending rather than listed as available.
That fictional line demonstrates the resolution. It does not turn a pending item into an offerable balance, and it does not manufacture an exact number for the estimated reel. Apply the same discipline to missing labels, reserved packages, and quantities that still need confirmation.
- Keep pending reels out of the available balance
- State the basis for every current quantity
