Reconcile export lines before an offer
Begin with the warehouse export or purchase record, then match each line to the physical reel or genuinely identical reel group. Give every match an inventory reference and preserve the original quantity separately from the current balance. A reel tag, product label or photo reference should show why the physical item belongs to that export line.
If one original line now represents several partial reels, list each current reel separately. If a reel has not yet been located or photographed, mark it photo pending or not located rather than carrying it into the available total. This turns a historical list into a practical seller record.
- Export or purchase-line reference
- Physical reel reference and matching tag or photo
- Original quantity separated from current balance
Make present balance visible
State the continuous length on each reel and label it measured, documented or estimated. Keep full reels, partial reels, boxes and cutoffs distinct. A lot total may be helpful after the individual lines are clear, but it should not conceal whether the total consists of one long reel or several short pieces.
The inventory mistake to avoid is presenting the original invoice footage or an ERP total as present quantity for every reel. Correct it by recording the current balance and its basis for each line. When information is incomplete, explain the limitation and keep the affected item separate until it can be reconciled.
- Current continuous length per reel
- Measured, documented or estimated basis
- Full reels, partial reels and cutoffs on separate lines
Classify release status separately
Identify why material is available: project overrun, distributor excess, maintenance inventory or facility closeout. Then separately record reserved status, pending return, packaging condition, storage condition and internal approval status. A product can be physically present yet not available for release; that is important information, not a reason to guess.
Name the owner or release role, storage location and access constraints. If a decision is still pending, use that exact status in the line item. The buyer can then distinguish what is currently described from what may require internal authorization before a lot discussion can move forward.
- Availability reason
- Reserved or return status
- Packaging and storage condition
- Owner, release authority and approval status
Keep an audit trail
Use the same inventory reference in the spreadsheet, photos, tag scans and any packing or measurement record. Add a brief note explaining who recorded the current balance and whether the evidence is a physical count, a document or an estimate. This does not need to be elaborate; it needs to be enough to avoid confusing a historical number with present stock.
A clearly fictional example illustrates the pattern: record OV-LM-05 as a particular feeder-cable reel group, retain the tag reference, list 300 ft and 180 ft as separate documented balances, and show release pending. The example is a format only, not a representation of a local lot or a prior purchase.
- Inventory reference matched across files
- Evidence basis noted for each balance
- Reserved material kept outside the available total
Longmont context does not prove availability
The City says Longmont is centrally located in the Denver Metro Area, Northern Colorado and Boulder County. This location statement is modest context for asking a seller to state the actual storage location and access limits; it does not show that any warehouse has surplus cable or that Industrial Wire Buyer has a local operation.
The seller decision here is reconciliation of a record to physical reels and current release status. That is distinct from the industrial-cable page’s construction-and-condition task and from the airport page’s large-reel configuration and site-access task.
- City context is not inventory evidence
- Physical reconciliation determines the seller record
