Step 1 — Reconcile the export with physical reels
Begin by comparing the inventory export or purchase record against what is physically present. Do not assume the exported line item equals remaining footage. Mark every discrepancy rather than carrying the original invoice quantity forward.
Record at minimum: the inventory line identifier, the original purchase or order reference, the current physical match (yes/no/partial), and a concise discrepancy note that explains missing footage, reserved reels, or uncounted partials.
- Evidence fields to capture: inventory line, purchase/order reference, current physical match, discrepancy note.
- If a reel tag matches the order reference, record that association and the reel’s measured or documented length.
Step 2 — Preserve reel-level balances and continuity
List every full reel, partial reel, cutoff and unopened package separately. Retain continuous lengths for each reel; where measured footage is not available, annotate whether the length is estimated and how the estimate was derived (e.g., measured by meter, tagged spool length, or vendor record).
Avoid aggregating different reels into a single line quantity. Buyers and reviewers need reel-level clarity: reel ID, specification, reel count, length per reel, and the quantity basis (measured, documented, or estimated).
- Evidence fields to capture: reel ID, specification, reel count, length per reel, quantity basis.
- Label partial reels as continuous footage (e.g., 180 ft continuous) and note any cuts or joins.
Step 3 — Explain why each line is available
For each inventory line, state whether the material is a project overrun, warehouse excess, discontinued stock, or maintenance inventory. Identify any portion that is reserved for ongoing projects or listed as pending return.
Include storage condition and any known history that affects releaseability (for example: tag says project overrun, but site has a pending hold for warranty return). This explanation turns an invoice line into a usable lot description.
- Evidence fields to capture: surplus reason, reserved quantity, return status, storage condition.
- If some footage is reserved, list the reserved amount and expected resolution steps or timeline if available.
Step 4 — Confirm release authority and access limits
Name the business role that can authorize sale and physical release. Record the storage site and any access or loading limits, and do not assume that an inquiry or listing authorizes movement or pickup.
If approval is pending, mark the line as pending and do not present it as available. Provide a realistic release timetable where possible and the contact role (not personal contact details) able to clear the material for transfer.
The Heart of Illinois Regional Port District is reported to handle more than 13 million tons of cargo annually. This is regional freight context, not evidence that any offered inventory is port-linked or that movement is arranged; the seller still needs to describe the actual storage site, access limits, and release status for the specific reels.
- Evidence fields to capture: owner/release authority, storage site, access limits, release timetable.
- Note any site restrictions such as loading dock use limitations, required escorts, or staging constraints.
Handling unknown or incomplete inventory
When exact footage or reel IDs are unknown, be explicit: mark the quantity basis as estimated, note the method of estimation, and indicate what verification remains. Unknown or incomplete items should remain labeled as pending verification rather than treated as released stock.
If inventory exports lack reel-level detail, schedule a physical recount and attach the recount results as an update. Provide timestamped photos of tags and reels with a short note matching them to export lines.
- If a recount is not immediately possible, provide the best available documentary evidence and an expected date for physical verification.
- Always separate estimated balances from physically matched balances so reviewers can prioritize verifications.
Illustrative record and the required checklist
A fictional inventory record—not a purchased lot—could read: OV-POR-02; project overrun; part number on tag; two reels with 300 ft and 180 ft continuous, documented; uninstalled; release pending internal approval. That one line preserves the difference between a documented balance and a line that cannot yet be represented as released.
The common failure is carrying original invoice footage forward as if every reel were available. Use a current-balance column, a physical-match result, and a separate status such as available, reserved, pending approval, or unknown. Keep a discrepancy note beside the affected inventory line instead of hiding it in a general comment.
- Fictional record fields: export line, reel identifiers, current continuous lengths, quantity basis, condition, and release status.
- A reserved or pending line is still useful to list, but it must stay separate from current available balance.
