Reconcile the physical balance first
A purchase order, invoice, or ERP export records an earlier transaction; it is not proof of the footage now available. Compare each order line to the actual reel, coil, box, or cutoff and record the current storage location and reel reference. Preserve both the original order quantity and the current quantity only when their difference is clear.
If a reel cannot be located, do not count its original footage as surplus. If an item is present but cannot yet be released, retain it as a separate pending line. This turns a project file into a current inventory rather than a historical total that could overstate what a seller can offer.
- Project or order reference beside the physical reel ID
- Original quantity and current quantity on separate fields
- Current storage site and quantity basis
Keep full reels, partial reels, and cutoffs separate
List the material format on every line: full reel, partial reel, coil, boxed length, or cutoff. Record one continuous length per item and label it documented, measured, estimated, or unknown. Several short pieces may add to a total footage figure, but they are not the same inventory as one continuous reel.
Retain the part number, jacket designation, conductor construction as marked, and visible condition with the individual line. When partial reels came from a common order, the shared order number is useful context, but it should not erase differences in remaining footage, packaging, or condition.
- Physical format and current reel count
- Continuous footage per item, not only an aggregate
- Documented, measured, estimated, or unknown quantity basis
Show why the cable is available
State whether the line is a scope-change overrun, warehouse excess, stock reserved for another job, pending return, or awaiting internal approval. Identify the role that can authorize sale and release. A current release field is more useful than a broad statement that the whole project inventory is available.
The City lists transportation work including traffic signals, roundabouts, sidewalks and complete-street reconstructions, with current projects including Eaton Street phase 2, Flynn Lane Path and Grant Creek Road & Expo Parkway. That public project context does not show that cable from any named project is available. It simply reinforces why the physical balance and release status must be documented at reel level.
- Surplus reason and reservation or return status
- Release approved, pending, or not yet determined
- Authorized contact or role for the line
Match paperwork and photos to the line
Use the same reference in the reconciliation sheet, photo filenames, and any matching paperwork. A helpful record pairs readable reel tags and jacket views with the current balance, rather than attaching an unrelated order document as if it identifies every reel. Where the physical tag is missing, show the evidence that remains and keep the identification gap visible.
Do not apply a data sheet or label from one item to a similarly colored neighboring reel. The practical goal is not a polished project summary; it is a seller record a buyer can use to see what exists now, why it is available, and what fact supports each line.
- Photo filename matched to inventory reference
- Manufacturer, part number, and jacket designation where readable
- Current condition and any missing-identification note
Correct an overstated project total
The recurring mistake is reporting the original order footage as the quantity for sale and grouping partial reels under one material total. Correct it by entering each current reel or cutoff separately, disclosing items reserved or awaiting release, and preserving the basis of every length. This makes an unknown or pending item visible without treating it as absent or sale-ready.
Illustrative inventory example—not a purchased lot: OV-MSO-02; project overrun, with the project name used only as context; part number recorded on the reel tag; two reels with 300 ft documented and 180 ft documented; uninstalled; release approval pending. The example is intentionally not an offer or a statement about an actual Missoula project.
- Do not substitute original ordered footage for current balance
- Do not merge partial reels and cutoffs into one continuous length
- Keep release-pending stock visible but distinct
