Start with the physical balance, not the invoice
Use the purchase order or inventory export as a locator, then compare it with the reels currently in storage. For each original line, note the part number, physical reel count, current storage site, and any discrepancy. A consumed, returned, reserved, or missing reel should be visible in the record rather than silently carried forward in the original footage.
Give each item an inventory reference that appears on the spreadsheet, reel photo, and supporting purchase or project record. That link is more useful than a total from an old order because it lets the seller show what is present today and what evidence supports the difference.
- Compare each order line to the actual storage position.
- Record missing, returned, consumed, and reserved items as discrepancies.
- Use the same reference in the list, photos, and supporting record.
Set a current balance for every reel
List full reels, partial reels, boxes, coils, and cut lengths separately. Record continuous footage per reel and label it measured, documented, estimated, or unknown. The current balance should describe the material that is now on that line, not what the item may have contained when it first arrived.
Where a reel is partial, keep the original tag as identification evidence but do not call its original footage a current balance. A seller can state “300 ft documented” beside one reel and “180 ft estimated” beside another. That is clearer than a combined 480-foot claim whose basis cannot be checked.
- Keep full reels, partial reels, coils, and cuts distinct.
- Give every footage claim a quantity basis.
- Do not convert an original reel label into a current balance.
Expose reservations and release gaps
State why each line is surplus: project overrun, warehouse closeout, discontinued stock, or maintenance excess. Then add its release status, owner if known, approval still needed, and storage condition. A reel set aside for another job is useful information, but it should not be counted as available while that reservation remains open.
If a sale-release signature is pending, say so. Listing the remaining approval is more actionable than calling the item ready without evidence. The buyer can then understand which stock is genuinely offered and which line requires an internal decision before a lot-specific conversation can continue.
- State the source of the surplus for each inventory line.
- Mark a reservation or return obligation rather than hiding it.
- Identify approval needed and release status independently.
Use commercial context carefully
The City of Temple says the Temple Economic Development Corporation conveys information about industrial and commercial sites and buildings, community profile and workforce information. That supports a commercial-inventory framing only; it does not show that any local business has wire or cable for sale. For a warehouse submission, pair the city context with the seller’s actual storage location, current reel count, and documented release status rather than a generalized claim about stock.
Photos should show the reel label and readable jacket printing for the same inventory reference. If an image covers only a box label or only a distant warehouse view, identify that limitation. The goal is a line-item match that explains the current balance, not a polished but untraceable inventory summary.
- Show the reel label and jacket printing for each line when available.
- Keep city context separate from actual inventory evidence.
- Identify a photo or record limitation instead of assuming a match.
Fix double-counting with a fictional record
The specific mistake is presenting original invoice footage as current availability after some reels were consumed or reserved. Fix it with a current-balance field and a short discrepancy note for every reel. The record should state what supports the number: a count, documented balance, measurement, or estimate.
A fictional example is OV-TEM-01: project overrun; release pending; part number copied from the reel tag; 300 ft documented on one partial reel and 180 ft estimated on a second reel; warehouse location known and release signer unknown. It is not a real Temple lot. It simply illustrates how useful uncertainty can remain visible.
- Add a current-balance field beside the original-order reference.
- State the evidence basis for every balance.
- Label pending release and uncertain quantity rather than assuming availability.
