Reconcile the physical inventory before offering it
Start with the original purchase order, warehouse export, or project list, but treat it as a reference rather than the current balance. Assign a stable inventory line and reel ID, then match that line to a reel, box, or continuous piece at the storage site. Record confirmed present, present with an estimated balance, reserved, pending return, or not located instead of allowing one old total to stand for every item.
A reel shown on an invoice may have been consumed, moved, or allocated to another project. Keep those differences visible. If a physical item cannot be matched to the record, do not use a similar product or a neighboring reel to fill the gap; keep the item unconfirmed until its markings and status are documented.
- Use one stable line reference for the inventory row, reel, and photo filenames.
- Record current storage site and reconciliation status.
- Flag missing, reserved, or pending-return items separately.
Show the current quantity, not only ordered footage
List full reels, partial reels, boxes, and cut lengths on separate lines. For each, record manufacturer and part number when available, reel count, footage per reel, and whether the remaining amount is measured, documented, or estimated. An original tag may describe starting footage, while the balance requires its own evidence basis.
When a balance is estimated, say how it was estimated and leave the label intact for later comparison. Do not combine separate short pieces into one continuous length. That distinction lets the buyer understand what has actually remained after the project changed or closed out.
- Keep original tag footage and current balance in separate fields.
- Identify the measurement basis beside each remaining length.
- Separate partial reels, boxes, and cut pieces.
Keep release state separate from material identity
Describe why each item is available: project overrun, changed-scope stock, warehouse excess, or another known reason. Then list condition, ownership record, and release approval status on that same line. An item awaiting internal approval can be documented for review, but it should remain release pending rather than represented as ready to transfer.
Use the actual owner or authorized department in the record. If the person who can approve release is not known, state that uncertainty and identify the follow-up record needed. This keeps a quantity question from being confused with a release-authority question.
- Use a release reason that applies to the actual item.
- Record ownership and approval status independently.
- Label pending or reserved quantities rather than including them as available.
Attach photos that resolve a specific inventory line
Name each photo with the inventory line or reel ID and capture readable tags, jacket printing, packaging, and visible condition. Include a storage-context image when it clarifies whether the material is indoors, covered, or exposed. A wide warehouse image alone does not show which line item it supports.
The airport reports a $72 million renovation and expansion adding more than 86,000 square feet of facilities and amenities. This is a local example of project activity as context for keeping changed-scope records accurate; it does not say that the airport has cable available or that it is connected to a seller inquiry.
- Match the photo filename to the inventory line and reel ID.
- Photograph readable tags and visible packaging or damage.
- State storage exposure rather than assuming a photo proves it.
Correct the invoice-versus-balance mistake
The common error is treating original invoice footage as the remaining quantity and describing every listed reel as available. Correct the record by showing the current balance and its evidence, separating reserved or pending amounts, and retaining the owner release field. This is a seller workflow, not an offer or an assumption that any item will be purchased.
Illustrative inventory example—not a purchased lot: reference OV-MEL-EXAMPLE-01; material: project-overrun feeder cable with part number on tag; quantity: two reels, 300 ft documented and 180 ft estimated; condition: uninstalled; release: pending. The second balance and the release field remain visibly uncertain until supporting records are supplied.
- Do not replace a current balance with an order total.
- Leave estimated footage and release-pending status visible.
- State the record needed to close each gap.
