Start with a current balance, not the original order total
An order, ERP export, or closeout list helps locate material, but it may describe what was originally ordered rather than what remains. Create a reconciliation row that pairs the source record ID with a physical reel ID and part number. Preserve the original quantity, then add the current balance and a discrepancy field.
Photograph the tag and readable jacket marking for each physical line. If a reel cannot be matched to an export, keep it on its own line with an unknown source-record field. That approach makes discrepancies visible instead of carrying an old total into the sale discussion.
- Source record ID, physical reel ID, and part number.
- Original quantity, current balance, and a reason for any discrepancy.
- Photo references that use the same line or reel ID.
Keep full reels, partial reels, and short pieces distinct
List full reels, partial reels, boxed coils, and cut lengths separately. For every item, state continuous footage per reel and whether the figure is documented, measured, or estimated. Two partial reels do not become one uninterrupted length merely because their combined footage resembles the original purchase quantity.
Use a condition field alongside the quantity. An unopened box, an uninstalled partial reel, and cable with an exposed end should not share one generic availability line. This preserves the differences a reviewer needs without making any assumption about a later purchasing outcome.
- Form factor and reel count.
- Continuous length per reel, never only an aggregate lot number.
- Quantity basis and condition for each line.
Show why stock is available and what is still reserved
State whether the line is project overrun, distributor stock, maintenance inventory, or a closeout. Then show reservation status, return status, owner, and release approval. A reel that is held for a return or internal use can remain in the worksheet, but it should not be presented as currently available.
Pending approval is useful information, not a reason to guess. Keep the current balance and the pending quantity separate, identify the approval step if known, and let the release field remain pending until the authorized party confirms it.
- Surplus reason and reservation status.
- Return status and owner or controlling party.
- Release approval: confirmed, pending, or unknown.
Match records, location, and access to the offered line
Use stable line IDs in the inventory, photo filenames, and supporting documents. Add the storage location, known access restrictions, available loading resources, and preferred release timetable to each site group. These fields describe the seller’s situation; they do not establish a transport plan or promise that every listed line can be included.
Where one project has material at more than one location, retain the site field on each row. Do not let a well-documented reel at one site stand in for differently identified material at another location.
- Line ID and matching photo references.
- Storage location and access restrictions.
- Available loading information and desired release timetable.
Use redevelopment context carefully and keep the example fictional
The City of Dover offers limited economic-development grants and lists incentives for redevelopment of commercial and industrial buildings. That fact can provide limited context for a seller describing a commercial closeout, but it does not show that a project produced cable, identify a cable specification, or prove that stock is for sale.
Illustrative inventory example—not a purchased lot: OV-DV-02 is a fictional project-overrun feeder-cable entry with the part number on its tag, two documented continuous lengths of 300 ft and 180 ft, uninstalled condition, and release pending approval. The pending field means it remains visible without being treated as released inventory.
- Fictional reference: OV-DV-02.
- Two reels: 300 ft and 180 ft continuous, documented.
- Release status: pending approval.
