Why reel-level reconciliation matters
Manufacturing closeouts and project overruns often leave inventory exports that no longer match what is physically stored. A common failure is treating the original order or ERP quantity as the remaining sale quantity without distinguishing reserved or released stock. That creates disputes, shipping hold-ups and wasted inspection time.
This workflow focuses on reel-level reconciliation: matching each export line to a physical reel, capturing continuous footage per reel, and documenting who can authorize release. Clear reconciliation prevents the original-quantity mistake and enables a clean, verifiable current-balance column tied to reel references.
IEDC describes advanced manufacturing as a state strength with deep talent/resources and an established supply-chain network. That is local context for a manufacturing-closeout checklist only; it does not identify a seller, available cable, buyer relationship, or demand.
- Tie export lines to physical reel IDs and storage locations
- Separate full reels, partial reels and cutoffs; retain continuous footage reporting
- Show release authority and reserved/pending status for every line
Step 1 — Reconcile the physical stock
Start by matching each inventory export or purchase record to the reels at the storage site. For every export line record the inventory reference, manufacturer/part number, storage site and the basis for the current balance (measured, documented, or estimated). If the export lists a higher quantity than reels on site, flag those lines as discrepancy items.
If location details are incomplete, record the best-known storage site name and mark the location as approximate. Do not treat an ERP line as sale-ready until a reel-level match is confirmed.
- Use the evidence fields: inventory reference; manufacturer/part number; storage site; current balance basis
- Flag discrepancies where the export quantity does not match matched reel footage
Step 2 — Preserve reel-level quantities
List full reels, partial reels and cutoffs separately. For each reel record the reel ID, continuous footage and whether that footage was measured, documented or estimated, plus the reel condition. Continuous footage must be preserved per reel so prospective reviewers can see exactly what remains on each physical item.
When footage is estimated, label it clearly and include a plan for verification. If reels were respooled or combined in storage history, document that in the storage history field to avoid double-counting.
- Required evidence: reel ID; continuous footage; measured/documented/estimated; condition
- Document any respooling or piecewise transfers in storage history
Step 3 — Confirm release status
Identify reserved stock and pending project returns separately from sale-ready lines. For each line capture ownership, the person or organization authorized to release the material, any reserved/pending status and an available date if known. Only lines explicitly authorized for release should be listed as available.
If the release authority cannot be confirmed, mark the lines as release-pending and exclude them from the sale-ready balance until the proper authorization record is provided.
- Required evidence: ownership; release authority; reserved/pending status; available date if known
- Mark release-pending lines explicitly and retain them separately from sale-ready lines
Step 4 — Match evidence files
Use consistent references across tag photos, jacket-print photos, data sheets and the inventory list. Each photo filename must reference the inventory or reel ID used in the list, and the jacket legend recorded must match the manufacturer/part number field. Where a jacket legend is partially unreadable, annotate the photo filename and provide the matching records that support the inferred part number.
Consistent cross-referencing prevents misidentification of reels and supports the current-balance column tied to physical references.
- Evidence fields to include: photo filenames; full jacket legend; matching records; storage history
- Retain a photo of each reel jacket, the reel ID tag and any export line used to match that reel
Handling unknown or incomplete inventory
If inventory exports are incomplete or storage site details are vague, be transparent: list the export line, note the missing reel-level evidence fields and mark the line as unreconciled. Offer the best available evidence basis (measured, documented, or estimated) and a clear next step for verification—either an on-site measurement or a documented confirmation of release authority.
Do not combine unreconciled lines into the sale-ready balance. Instead, present them as pending with the specific missing evidence fields identified so reviewers know what must be supplied before availability is confirmed.
- If exact storage location is unknown, include an approximate storage site and the steps planned to verify
- Keep unreconciled lines separate and list exactly which evidence fields are missing
