Treat the original order as a reference, not today’s balance
An invoice, purchase order, or warehouse export may identify the original quantity, but it does not prove that every foot is still present. Start by matching each source line to a physical reel, package, or cut piece. Record the original quantity beside the current amount and explain a discrepancy instead of carrying the original total into the sale record.
The central seller decision is whether the item physically available today is the same inventory described by the historical record and whether it can be released. This differs from a general cable-identification task because the problem is current availability and authorization, not simply naming the construction.
- Keep the original order or inventory reference on each current line.
- Record current reel or package balance separately from original quantity.
- Add a concise discrepancy note whenever the two values differ.
Preserve the physical balance at reel level
Separate full reels, partial reels, unopened packages, and cut lengths. Include the manufacturer or part number when available, reel count, footage per reel, and the basis for the current figure. Do not use a warehouse total to disguise the fact that the remaining material is split across short pieces or that some lines are estimated.
The likely mistake is calling the original order footage “surplus” without checking current stock. The resolution is a current-balance field for every line, marked measured, documented, or estimated. A pending count is better recorded as pending than silently treated as a known balance.
- Use a current-balance field per reel or package.
- State full, partial, package, or cut-length status.
- Label the balance measured, documented, estimated, or pending.
Separate availability from release authority
A reel can be physically located in a warehouse and still be reserved, pending return, or subject to internal approval. Record why the stock is being released, any project or order reference, storage condition, and reservation status. Then identify the owner or role that can authorize release and state whether that approval is complete, pending, or unknown.
This distinction prevents an inventory report from becoming a false availability claim. It also allows a seller to include useful background without asserting that every line is ready for movement or that any buying terms have been agreed.
- State project overrun, warehouse excess, closeout, or other known availability reason.
- Mark reserved or pending-return lines separately from available balance.
- List the release approver and current approval status for the line.
Document unknowns instead of rounding them away
If a tag is missing or the reel has not been measured, keep the line visible and state what is known. Add photos, the available product reference, a quantity estimate and its method, and a note about which balance still needs verification. Do not combine unidentified pieces with documented reels simply to reach a larger total.
Ada County Highway District's Capital Improvements Plan uses a twenty-year horizon for growth-related transportation projects, including major roads, intersections and bridges, and is updated every four years. That can be limited project background for a seller with a genuine transportation record; it does not establish that cable remains from a project or that any line is available for sale.
- Mark unknown or pending balance fields plainly.
- Attach the source record or photos that support the estimate.
- Keep an unavailable or unresolved line in its own status group.
Test the reconciliation with a fictional record
Illustrative fictional record—not a purchased lot: OV-B02 is project-overrun feeder cable with a part number on the tag. Its current balance reads “two reels: 300 ft documented and 180 ft estimated”; condition reads “uninstalled; packaging intact”; release reads “project closeout approval pending.” The original-order reference sits beside those current fields rather than replacing them.
That record supplies a practical fix for the invoice-versus-stock problem. It makes clear what exists, what is estimated, and what remains subject to approval without inventing a final balance or promising a purchase.
- Example balance: 300 ft documented plus 180 ft estimated on separate reels.
- Example condition: uninstalled; packaging intact.
- Example release: project closeout approval pending.
