Reconcile the file with the material on hand
Begin with an export, purchase order, or closeout list, then walk the storage area and match each line to an actual reel or package. Use the same inventory reference on the reel photo, worksheet, and any release note. If a listed reel cannot be found, keep it as an unmatched line rather than silently treating the original quantity as available.
For each physical match, record current reel count, continuous length, quantity basis, packaging condition, and storage site. A full reel, partial reel, unopened box, and cutoff should not share one generic balance. The inventory should state what remains now, not merely what was ordered when the project began.
- Match every current reel or package to an inventory reference.
- List full reels, partial reels, unopened boxes, and cutoffs separately.
- Label every length measured, documented, or estimated and explain discrepancies.
Make release status visible beside the quantity
A project balance can include material reserved for return, awaiting closeout, or approved for release. Add an availability status to each line and identify the person or role that can confirm release. Do not describe a reel as surplus simply because it appears on an invoice or is physically stored at a job-related location.
Where approval is not complete, state the specific pending action and keep that reel distinct from lines already authorized for disposition. This helps a buying review focus on documented material without implying that a pending signature, transport arrangement, payment term, or acceptance is already settled.
- Record availability status, reservation, release approval, and authorizing party.
- Keep pending and approved lines separate even when the product matches.
- Attach the written release record when one exists; otherwise identify the missing approval.
Treat named city projects as context, not a source of stock
Concord’s Capital Improvement Program lists active Clayton Road and Diamond Boulevard pavement rehabilitation and Newhall Park water-quality improvement projects. Those public names can help a seller label background records, but they do not establish that a named project contains cable, that any inventory belongs to the seller, or that material is for sale.
The supporting evidence for an offered lot remains the physical reel identity, current balance, storage location, condition photographs, release status, and loading facts. Give the actual warehouse bay, yard, or other storage reference and describe access constraints without assuming who will move the material.
- Use a project name only as background on a traceable inventory line.
- Photograph the tag, full reel, and stored-location context for each line.
- State available loading equipment and access limits as documented site facts.
Repair the invoice-as-inventory error
The common mistake is presenting original invoice footage as the remaining amount and calling every line available. Correct it with a current-balance column and a release-status column for every reel. If a reel is missing, reserved, or pending approval, that is useful information and should remain visible.
Fictional inventory example—not a purchased Concord lot: OV-C-01; project-overrun feeder cable, part number on tag; two reels with 300 ft and 180 ft continuous, documented; uninstalled; release approval pending. The record makes the physical quantity clear while avoiding a claim that the lot is ready to move.
- Do not convert invoiced footage into a current availability statement.
- Preserve the reel-level specification alongside the balance and release status.
- Use an explicit pending field when an approval remains unresolved.
