Set the release boundary first
Mark every line as physically present and available, physically present but reserved, pending return, or not found. Do not include a reel in the available balance merely because it appears on an original export. A release boundary makes the inventory useful when several teams, projects, or warehouse records have an interest in the same material.
The city says Hartford is one of Connecticut’s Enterprise Zone designations and has 10 Opportunity Zone designations. That city designation is limited redevelopment context; it does not prove that an inventory release exists or that any material is being offered.
- Inventory reference and present availability status.
- Reserve or return status with a clear pending label.
- Release approval or the role that must provide it.
Reconcile each record to the reel on hand
Match the export, purchase record, or warehouse line to a present reel ID, readable manufacturer marking, part number, current footage, and condition. Preserve full reels, partial reels, cut lengths, packaging differences, and differences in the basis of the footage. An invoice can support identification, but it cannot establish the current quantity after consumption or reservation.
When a quantity is not measured, state whether it is documented or estimated and keep the evidence basis beside the number. Keep missing or unreadable items in their own unknown line instead of using a nearby reel to complete the description.
- Manufacturer, part number, reel ID, and current footage.
- Measured, documented, or estimated quantity basis.
- Separate full reels, partial reels, and cut lengths.
Explain why the balance is surplus
State the surplus reason for each group: project overrun, distributor stock, maintenance inventory, facility closeout, or another documented reason. Include a project or warehouse reference when it actually belongs to the line. If dates are unavailable, mark them unknown rather than inventing a release history that cannot be tied to the material.
The reason material is no longer needed should not replace its product identification. A reviewer still needs the tag, jacket marking, condition, and current continuous footage before the group can be understood as wire or cable inventory.
- Surplus reason and any matching project or warehouse reference.
- Known date or an explicit unknown date field.
- Photo and supporting-record references matched to the reel.
Keep pending quantities out of the saleable balance
A reel that is reserved, awaiting return, or awaiting approval belongs on a pending line. Record the owner and release authority and describe what is known about the approval path, without presenting that pending quantity as available. This prevents a buyer conversation from being built around material that the seller cannot yet release.
Illustrative fictional record: OV-HFD-07 | project-overrun feeder cable, part number on tag | 2 reels, 300 ft and 180 ft continuous, documented | uninstalled | release pending approval. It is a fictional formatting example, not a purchased lot. The avoidable mistake is presenting original invoice footage as the available balance after reels were consumed or reserved.
- Available total separated from reserve, return, and pending lines.
- Owner and release authority for each offered group.
- Supporting record and photo references for the current balance.
