Reconcile the export with physical stock
Begin with the purchase order, warehouse export, or project list, then match every line to a reel, box, or package that can be located. Record the original line ID, the physical reference, part number, current balance, and any discrepancy. The order quantity is useful history, but it is not proof that the same footage is still present.
When a record cannot be matched, mark it unmatched rather than treating it as available. Put a short reason beside the discrepancy: partial use, missing package, stock reserved elsewhere, or confirmation pending. That lets the buyer see the boundary between verified physical stock and an open inventory question.
- Inventory line and physical reel/package reference.
- Part number exactly as marked.
- Current balance with measured, documented, or estimated basis.
Keep each quantity form visible
List full reels, partial reels, unopened boxes, and cut pieces on separate lines. For cable, record the continuous length of each piece; several short cutoffs should not become one long usable length on the inventory. State whether footage comes from a measurement, an existing job record, or an estimate and preserve the individual reel count.
Condition form belongs in the same row. “Uninstalled,” “opened box,” and “removed material” describe different inventory situations. If a reel has visible damage or a missing label, state it rather than allowing the original purchase description to hide the current condition.
- Condition form.
- Reel or package count.
- Continuous length per reel or piece.
- Quantity basis for every footage figure.
Separate available stock from pending stock
For each line, state why the material is being released and whether it is reserved, a project return, subject to internal approval, or otherwise restricted. Identify the owner or role responsible for the item. A line awaiting release approval can remain on the working inventory, but it should be marked pending instead of being described as offered stock.
The common error is reporting invoice footage as remaining quantity and calling every listed reel available. The practical correction is a current-balance field with evidence, plus a separate release-status field. This avoids mixing an honest prospect list with a confirmed release list.
- Availability reason.
- Reserved or return status.
- Release approval or explicit pending status.
- Owner or responsible role.
Tie photos and unknowns to the balance
Name photo files with the inventory or reel reference and show readable jacket printing, reel tags, and any relevant packaging condition. Add the storage address or site area and known access restrictions. A warehouse overview can help with context, but it does not replace photos that identify the listed item.
If footage, ownership, or physical access is incomplete, say exactly what is unknown and what record could settle it. For example, an estimated partial reel can remain an estimated line while the seller seeks a measurement; it should not be converted to a precise balance merely to complete the form.
- Photo reference and matching jacket or tag image.
- Storage location and access limits.
- Known discrepancy and action needed to resolve it.
Illustrative balance record and city context
Illustrative only—not a purchased lot: OV-SL-02 is project-overrun feeder cable with its part number on the tag. The record has two reels, one with 300 ft documented and one with 180 ft estimated. Condition is uninstalled, while release approval is pending, so the line is not represented as available.
San Leandro’s CIP examples include street improvements, sewer replacements, municipal building enhancements, and marina-area and park improvements; the City maintains a 10-year plan of funded and unfunded projects. That public-plan context does not establish that a seller’s project material is City-owned, available, or suitable for purchase. It only reinforces why a project-related cable list should be reconciled to the actual stock and its release authority.
- Show documented and estimated footage separately.
- Keep approval-pending stock out of the available column.
- Use project context only after the material record is established.
