Reconcile the order to physical inventory
Use the order, warehouse export, or project list as a starting point, then match each line to a physical reel or package. Record the project or order reference, reel ID, manufacturer part number, and whether the item is physically present. A discrepancy belongs in the record, not in a hidden assumption.
When a line cannot be located, mark it unconfirmed. When a reel has a different part number or condition than its order entry, preserve both facts and separate it from verified stock. This creates a current, checkable balance before a selling discussion begins.
- Project or order reference
- Reel ID and physical-presence status
- Manufacturer part number and discrepancy note
Make the current quantity reel-specific
Keep full reels, partial reels, and cut lengths as different entries. For each reel, record current continuous footage and label it measured, documented, estimated, or unknown. Original invoice footage may help identify a product, but it does not prove the remaining length.
Do not turn several partial reels into one smooth total that hides their individual lengths. Retaining each reel’s balance lets the buyer understand what is actually present and which information still needs confirmation.
- Reel count
- Footage per reel
- Quantity basis
- Full, partial, or cut-length status
Show availability and release status
State whether each line is available, reserved, pending return, or pending internal release approval. Include the reason and the person or department expected to resolve a pending status. A line waiting for approval is not the same as stock already authorized for sale.
This status should be updated independently from product identification. A reel can be fully identified yet unavailable, or available while its remaining footage needs better evidence. Keeping these two questions apart prevents an overrun list from overstating what can be offered.
- Availability status
- Reservation or return status
- Approval needed and responsible role
Use the local project fact with a narrow scope
The City reports Resolute Way Phase 1 as approximately 2.1 miles of new roadway between Interstate 565 and Redstone Gateway near Gate 9. The statement is public project context only; it does not show that the project produced wire, cable, overrun inventory, or a buyer relationship.
A seller who independently holds project paperwork can use its own project reference to organize the balance. Product identity, current quantity, and release status must still come from the seller’s physical inventory and authorization records.
- Public project fact is not lot evidence
- Seller records must match physical reels
- Release status documented per line
Correct the invoice-as-balance mistake
The typical error is presenting original purchase footage as current stock and treating every line as available. Correct it by creating a per-reel current balance, carrying reservations and pending approvals forward, and naming the release authority needed for an available designation.
Illustrative inventory example—not a purchased lot: OV-HSV-06; project-overrun feeder cable; two reels; 300 ft documented and 180 ft estimated; uninstalled; release pending; loading limits to be confirmed. It demonstrates a transparent overrun record, not an offer or purchase history.
- Current balance with evidence basis
- Reserved and pending lines remain flagged
- Release authority linked to actual inventory
