Reconcile the export to the physical reels
Use an invoice, purchase order, or inventory export as a starting reference, then compare it with the reels at the storage site. Record the inventory line, current reel count, storage site, and a short reconciliation note that explains the difference between the historical record and the physical count. A line that cannot be found should remain “not located,” not become available inventory by default.
This task is about changed-scope stock, discontinued inventory, or a project remainder. It is different from identifying every building-wire specification from scratch: the first question is whether the original record still matches the actual, releasable balance.
- Inventory line and current reel count
- Storage site for each physical group
- Reconciliation note and document date
- Unmatched quantities shown as unresolved
Preserve the per-reel balance
List the part number, reel ID, footage, and quantity basis for each reel. Keep full reels, partial reels, and cutoffs visible rather than reporting only a combined number. Two reels with the same part number can still have different remaining continuous lengths and different release status.
The specific mistake is presenting original invoice footage as the quantity available now. Correct it by preserving the current evidence basis for each reel. If a balance is estimated, say estimated; if the reel is reserved or subject to a return, keep that constraint on the same inventory line.
- Part number and reel ID
- Per-reel continuous footage
- Measured, documented, or estimated quantity basis
- Full, partial, or cutoff status
Make release blockers visible
A current count is not enough if part of the inventory is reserved, pending return, or awaiting an internal approval. Use separate fields for release status, reserved or return flag, and approval owner or department. If the responsible role is not known, record that as unknown rather than suggesting that possession equals authority to sell.
State the surplus origin—project overrun, distributor remainder, maintenance stock, or closeout—and connect condition photos to the affected reel IDs. This keeps a release issue from being hidden inside a generic availability note.
- Release status
- Reserved or return flag
- Approval owner or unknown status
- Surplus reason and photo references
Add location context without turning it into a logistics claim
Apex is situated between US Highway 64 and US Highway 1; NC 540 runs along the western side and NC Highway 55 bisects the town centrally. An Apex seller can use that fact only to describe the storage-area approach in the inventory note; it neither identifies a project lot nor creates a transport, timing, or acceptance commitment.
For the actual reel list, give the storage point, access limitation, and the party who can confirm release. A seller with multiple yards should keep the groups separate. The point is to make the reconciled record usable in a lot-specific discussion, not to promise an outcome for inventory that is still under approval.
- Physical storage point
- Access limitation if any
- Release contact role
- Separate grouping for each location
Use a fictional reconciliation record
Illustrative inventory example—not a purchased lot: OV-APX-01; project-overrun feeder cable, part number on tag; two reels with 300 ft and 180 ft continuous, documented; uninstalled; release pending. The example shows how a current balance and a release constraint can appear together without implying that the lot is available or purchased.
If one field is incomplete, keep the record open: write “approval owner unknown” or “footage estimated,” state the evidence that exists, and do not substitute the original order total. A well-labeled gap is more useful than a neat but unsupported total.
