Start with the current offer boundary
An old purchase order can identify what was originally ordered, but it cannot establish what remains on a reel today. Mark every line as project overrun, warehouse excess, maintenance stock, reserved stock, pending return, or released inventory. Add the storage site and the person or team that can authorize release; a line without those facts belongs in a pending group rather than a released total.
One local context does not identify a municipal lot: The City of Warner Robins says its FY2026 budget totals $179,863,519, including $6.7 million for immediate roads, sidewalks and utilities improvements and $25.3 million reserved for future capital projects. That public budget information merely makes changed-scope examples understandable. It is not proof that any city project has cable available, and a seller should document the actual origin and release position of its own material.
- Keep reserved and approval-pending lines out of the released subtotal.
- Record the project or inventory reference that explains each line’s origin.
Reconcile records to physical reels
Create one row for each physical reel, package, or continuous piece and give it a stable reference. Match the row to an export, purchase record, reel tag, and photograph where those records exist. Transcribe the manufacturer, part number, readable jacket legend, current quantity, and whether that quantity is measured, documented, or estimated.
The recurring mistake is treating invoice footage as footage currently offered. If an export says 500 feet but the reel has a partly used balance, retain the current balance and its evidence basis. A discrepancy is useful information: leave it visible instead of silently replacing a reel-level count with a historical total.
- Use a filename such as WR-OV-07-tag.jpg that matches the row reference.
- Describe a missing tag or unreadable legend as unknown, not as a guessed specification.
Keep full reels, partial reels, and cut lengths separate
A full reel, a partial reel, a box of cut lengths, and a loose continuous run should not share one quantity cell. Record the continuous footage on each piece, condition, reel count, and cutoff status. Two short pieces may add to the same arithmetic total as one long piece, but they are not the same inventory description for a buyer.
For a partly used reel, state whether the remaining footage is measured, based on a documented count, or estimated. Include visible jacket condition, packaging condition, and accessible ends in the same row so a reviewer does not have to infer that every reel in a closeout has the same history.
- Do not combine full and partial reels under an undifferentiated “available footage” total.
- Keep different marked specifications on separate rows even when they came from one project.
Resolve unknowns and release gaps before they become assumptions
When the authorizer, reel ID, or current footage is not available, mark the specific field unknown and state what will resolve it. For example, “release status: pending controller confirmation” is more useful than presenting the line as available. Keep an approval-pending line in the list so the inventory remains complete, while distinguishing it from material that can actually be discussed as offered.
Use the quote form for the initial contact and then provide the referenced inventory and photos for the relevant lot. A submission begins a purchasing discussion; it does not turn a reservation, a warehouse export, or an incomplete record into a release decision.
- State the evidence basis next to every current quantity.
- List missing release documentation and the source that can clarify it.
Use a worked current-balance record
This is a fictional formatting example, not a purchased lot: reference WR-OV-07; material: feeder cable with part number transcribed from tag; quantity: reel A, 300 feet documented; reel B, 180 feet estimated; condition: uninstalled; release status: pending. The two reels remain separate even though they are related to the same overrun record.
The practical fix is to replace an undifferentiated invoice total with this kind of reel-level record. Attach the matching tag and condition photographs, identify the storage site, and show whether each line is released, reserved, or awaiting approval. That gives a buyer an honest starting point without guessing at the unresolved fields.
