Start with today’s physical balance
A purchase order can identify what was ordered, but it does not establish what remains in the storage area now. Walk the material against the latest inventory export and assign a stable line ID to every reel, box, coil, or genuinely identical group. Record the part number from the tag or jacket, the physical count, the remaining continuous length, and whether the amount is measured, documented, or estimated.
Do not turn an original total into a current sale quantity. A full reel, a partial reel, an unopened box, and short pieces need separate lines because each has a different quantity basis. When footage is estimated, keep the estimate with the item and state why a measurement was not available.
- Use one line ID in the inventory, photo filenames, and release notes.
- Keep original ordered footage in a reference field, not the current-quantity field.
- Mark measured, documented, and estimated amounts distinctly.
Keep release states visible
The key seller decision is whether an item is actually available to offer or is still reserved, held for another scope, or awaiting internal approval. Add a release-status field to each line rather than placing every piece in one grand total. A pending item may be documented, but it should not be presented as available until the seller can identify the approval reference and the person who controls release.
For a closeout with several owners or cost centers, make the inventory boundary clear. List which rows are included in the inquiry, which rows are excluded, and which rows require another authorization. That lets the buying discussion stay focused on the actual lot instead of an outdated warehouse balance.
- Use available, reserved, pending approval, and excluded as separate status values.
- Attach an internal approval reference when one exists.
- Name the seller contact who can authorize release for the listed lines.
Match tags and photos to the right record
For each releasable or pending line, capture a readable tag or jacket legend and an overview showing the reel, box, or coil in its present condition. Use the line ID in each filename so a reviewer is not asked to guess which image belongs to which quantity. Include visible packaging damage, missing labels, and storage exposure because those details explain limitations without changing the material.
Riverside Public Utilities lists a Hunter Industrial Park make-ready project with approximately 4,983 circuit feet of new primary conductors, 22 utility poles and 23 overhead transformers. That is local project context for why an overrun record may need careful reconciliation; it does not identify stock for sale or prove that any listed material came from that project.
- Tag close-up, full-reel or box view, and visible-condition photo for each line.
- Photo filenames that begin with the same line ID as the inventory.
- Storage exposure and label-legibility notes attached to the same record.
Handle unknown quantities without inflating the lot
If a reel has no readable balance or a box count cannot be confirmed, retain the item on its own line and state the unknown. Do not infer footage from the original label after material has been consumed. A transparent estimate can still be reviewed when it identifies the basis, such as a documented prior cut report or an observed remaining wrap count.
Do not merge unidentified short pieces into the count for a marked reel. Preserve them as a separate group with their own condition and quantity limitations. This protects the useful distinction between an identified continuous length and a group that cannot support the same description.
- Use unknown rather than a guessed length.
- Give the reason and source for every estimate.
- Keep loose pieces separate from marked reels and unopened boxes.
Worked release record
A practical record can show both what is available and what still needs authorization. In the fictional example below, the two reels are not combined: one has a documented remaining length and one has an estimated balance with release pending. The status makes the scope of the inquiry clear without suggesting that the pending reel is already included.
The common mistake is sending a single invoice total with one representative photo. The workable correction is a row-by-row list, matched photo references, and a release field that separates available material from material still controlled by an internal decision.
- Reference: OV-RIV-01.
- Two reels: 300 ft documented and 180 ft estimated.
- Second reel marked approval pending rather than included in the available balance.
