Turn the export into a current-release ledger
An original purchase record can identify a product, but it may not describe today’s reels, partial balances, or project reservations. Start a fresh line for each physical reel or group of truly identical full reels. Compare the export with what is present and record discrepancies instead of silently retaining the ordered footage. This task is about present availability, not a generic catalog of materials once purchased.
Inglewood’s CDBG eligible public-facility improvements include acquisition, construction or rehabilitation of infrastructure, and its economic-development activities include assistance to micro-enterprises and other businesses. That is limited local context for why a seller may be reconciling contractor or business inventory; it does not indicate City-funded stock, a customer relationship, or material for sale.
- Inventory line, manufacturer or part number, and current reel ID.
- Current balance stated as measured, documented, or estimated.
- A separate original-order field when an old record is retained for reference.
- A discrepancy note when the physical reel does not match the export.
Keep disposition states visible line by line
A full reel, a partial reel, a cut length, a reserved line, and a recovery-oriented piece are not interchangeable entries. Give each its own status. For material that is partly reserved, show the current free balance separately from the pending amount rather than reporting the whole reel as available. When an approval is needed, identify the approver or label the status pending; do not turn an internal assumption into a release statement.
Condition belongs on the same line as the balance. Note whether a reel is uninstalled, previously removed, weather-exposed, or visibly damaged, without treating a photo as a performance claim. This allows a review to begin with the actual inventory boundary rather than a broad “surplus” label.
- Full, partial, cut-length, reserved, pending, or recovery-oriented disposition.
- Continuous footage per reel or individual piece.
- Condition and storage exposure note.
- Release approval reference or an explicit pending or unknown status.
Make several storage locations auditable
If one inventory export covers more than one storage site, add a location matrix rather than using one address for every line. Each row should point to a site reference, reel reference, access limits, and the loading information the seller already knows. A site reference can be a warehouse bay or yard label; a full address can be handled through the inquiry when appropriate.
The City’s project-pipeline page organizes development information under major projects, national destinations, new hotels and new housing. Those page headings are only local development context, not proof that any listed reel is tied to a project, hotel, housing site, or commercial property. The inventory still needs its own location and release record.
- Site or location reference linked to each reel line.
- Access limits such as gate procedures, staging limits, or available equipment.
- A named or role-based release authority for that site.
- Separate rows when identical product is stored at different sites.
Match photos to the reconciled row
Use the inventory line or reel ID in every file name. Capture the product tag or jacket printing, a reel overview, and visible packaging or condition differences. A photo set should prove which physical item was counted, not merely show that similar cable exists somewhere at the facility. Where a label is unreadable, note that on the same row and preserve the visible text rather than filling the field with a guess.
For a large spreadsheet, photograph representative items only when their construction, condition, and quantity are genuinely the same; otherwise keep the differences visible. Add photo references as inventory fields so a reviewer can trace an estimated balance or a missing label to the relevant evidence.
- Photo reference tied to the inventory line or reel ID.
- Readable tag or jacket-marking image when available.
- Overview showing the physical item and any condition difference.
- Storage-exposure note for lines held outdoors or under cover.
Correct the old-invoice availability error
The common error is advertising 2,000 feet because an old invoice says 2,000 feet, without checking whether the current reels are present, partial, or reserved. Correct it by preserving the old document as background while recording current balance and basis per reel. If no count has occurred, call the balance estimated or uninspected rather than presenting it as released stock.
Illustrative inventory example—not a purchased lot: OV-01 and OV-02 are feeder-cable entries with the part number on the tag. One reel has 300 ft documented; the other has 180 ft estimated and release pending. The location is recorded as Warehouse A while exact address and loading details remain unknown. This is a transparent format, not a claim about a local lot.
- Do not replace present balance with original order footage.
- Mark unknown, uninspected, and approval-pending fields explicitly.
- Keep a pending reel separate from a released inventory line.
