Purpose and when to use this workflow
This reconciliation workflow is for sellers who have an inventory export, purchase order, or project order that does not match the physical reels on site. Public projects and airports often show original order quantities; the goal here is to determine which reels and lengths are actually available for sale now and to document that availability with clear evidence.
Use this process when release authority, storage location, or access restrictions are unclear, or when original order footage may mix reserved, installed, or returned stock with sale-ready inventory.
Local context: TLH’s international facility includes a 40,000-square-foot terminal expansion and is designed for international passenger and cargo inspection; the city says construction is underway. This construction context does not identify a supplier, an available cable lot, or a purchasing transaction. It gives the local relevance for a project-overrun example; the seller still needs to reconcile physical reels and authorized release independently.
- Focus on per-reel reconciliation rather than carrying forward the original total.
- Separate full reels, partial reels/coils, and cut lengths on different lines.
- Include photos that match the reel tag and jacket printing to the inventory entry.
Step 1 — Build the current balance
Start with the inventory export or project purchase record and match every line to a physical reel or coil. For each reel line record the inventory reference, manufacturer and part number, reel count, and current footage per reel. If a reel is missing from the site, flag it as missing; if it is reserved or return-pending, mark that explicitly.
When footage is estimated, mark the balance basis (measured, documented, or estimated) and record who made the measurement and when.
- Required evidence fields: inventory reference; manufacturer and part number; reel count; current footage per reel; balance basis.
- If any field is unknown, state which evidence is missing and whether the item is still being reconciled.
Step 2 — Keep continuous lengths and conditions separate
List full reels, partial reels, coils, and cut lengths on separate lines and retain each continuous length value. For partial reels, record continuous footage remaining on the reel rather than combining with other partials.
Also record whether the material is unused, installed then removed, or otherwise altered; include a concise condition note such as 'factory jacket intact' or 'jacket abraded at 3 ft' so condition is tied to a specific reel line.
- Required evidence fields: continuous footage; measured/documented/estimated; unused or removed status; condition.
- Avoid aggregating different physical pieces under a single footage total unless they are a documented continuous length.
Step 3 — Tie records to photographs
Photographs are essential. For every inventory line, include at least one photo of the reel tag or label and one photo showing the jacket printing. Use the same inventory reference text in the file name or caption to link photos to the line item.
If a manufacturer packing list, delivery ticket, or vendor tag exists, attach a matching excerpt and reference the document number in the inventory line so reviewers can confirm part numbers and original order ties.
- Required evidence fields: photo reference; tag text; jacket designation; matching document.
- If photos are incomplete, clearly state which photos are missing and whether they can be provided later.
Step 4 — Confirm sale release and access
Identify the owner or authorized releaser for each lot and state the exact storage location and any access limits. If internal approval is pending, mark the release status as 'pending approval' and identify who must sign the release.
Do not treat 'original order' or 'reel label' footage as sale-ready unless release authority and physical footage have been confirmed. Mark unavailable or pending lines explicitly instead of carrying forward the original total.
- Required evidence fields: owner/releaser; exact location; access limits; release status.
- If a lot requires on-site escort, permit, or restricted access, document that restriction and provide the contact who can authorize access.
Handling unknown or incomplete inventory
When footage, tag data, or location information is unknown, be explicit: create a placeholder line with the inventory reference and list which required evidence fields are missing. State whether missing evidence can be produced and an estimated timeframe.
If a reel's footage is estimated, provide the estimation method (tape measure, reel counter, or extrapolated from label) and flag the line as 'estimated' so buyers understand the basis for the balance.
- If complete reconciliation cannot be provided, submit what you have with clear notes and indicate which lines remain to be verified.
- Do not represent estimated or unresolved lines as confirmed available stock.
Illustrative reconciliation record (example)
Use a concise per-lot record like the following illustrative example so reviewers can see the format. This example is illustrative only and not a purchased lot.
Provide the same fields when you submit actual lots so the evaluation team can confirm availability without repeated back-and-forth.
- Reference: OV-TLH-07
- Specification: manufacturer and part number recorded from tag
- Quantity: 2 reels; 300 ft documented and 180 ft estimated
- Status: uninstalled; second reel release pending
