Build a current balance, not an invoice total
Start with the purchase order, warehouse export, or project takeoff, then compare each line with the reels and packages that are physically present. The original record identifies a starting point; it does not prove today’s quantity. Give each inventory line a stable reference and show source-record quantity beside current physical quantity so a discrepancy can be reviewed instead of hidden.
For each difference, record a short reason such as consumed on the project, returned to stock, reserved for another phase, or not yet counted. If the reason is not known, leave it unknown. The task is to establish what is actually available to sell now, not to make the old purchase quantity look current.
- Record inventory line ID, manufacturer, part number, source-record quantity, and current physical quantity.
- Use a separate current-balance column rather than overwriting the original quantity.
- Mark a line unverified when the stored reel has not been physically counted.
Keep each reel and its footage traceable
List full reels, partial reels, cut lengths, and unopened packages separately. Record continuous footage for each reel and state whether that figure is measured, documented from a tag or record, or estimated. A total of several short pieces should not be described as one continuous length, and an unreadable tag should not be converted into a precise number.
Match the inventory reference to a reel ID and to the filenames for a tag photo, jacket-print photo, and overall reel photo. A reviewer should be able to move from the current-balance line to the physical item without guessing which image or product record applies.
- Keep reel ID, continuous footage, quantity basis, and full, partial, or cutoff status on the same line.
- Photograph the complete tag and a legible stretch of jacket printing where safely accessible.
- State estimated footage as estimated and retain the method or record used for the estimate.
Make release status part of the available quantity
Assign every line a release status: available, reserved, pending project return, or awaiting approval. Identify the person or business role able to authorize a sale and retain any ownership or release note that relates to the specific line. A project name is useful context, but it is not evidence that a particular reel can be released.
The city identifies Sunrise Tomorrow as a project to revitalize the 100-acre Sunrise Mall area. That local redevelopment context may help a seller describe why a project balance changed, but it does not identify any available cable or establish authority to sell it. The reel record and release status remain the deciding evidence.
- Keep reserved, pending-return, and approval-pending quantity outside the offered total.
- Name the authority role and preserve the related release note or ownership record.
- Use an explicit unknown status when authority has not been confirmed.
Correct the common balance mistake
The common mistake is presenting invoice footage as sale quantity while some reels remain reserved for project work or have already been consumed. That error can be corrected without discarding the source record: retain the invoice figure, add a physical count, and state which lines are not presently available. Do not merge an unresolved reel into the available total simply because its part number matches.
When a reel ID, footage, or approval is incomplete, include the item with the missing field marked unknown. Attach the available photograph or document reference, then isolate the uncertainty in the balance. This permits targeted follow-up without turning an unknown into a promise about the lot.
- Mistake: old invoice footage is presented as today’s releasable inventory.
- Resolution: reconcile physical reel IDs, current footage, photos, and release status before totaling availability.
- Keep incomplete lines visible but excluded from the available total until their status is established.
Use a short reconciliation record for the inquiry
A concise inventory record is more useful than a project narrative. For every offered reel, send the current-balance line, identification photos, condition notes, location, and the contact who can discuss release. Industrial Wire Buyer can review documented surplus wire and cable nationwide; trucking can be arranged only as part of the lot-specific discussion, not from the spreadsheet alone.
Illustrative fictional record—not a purchased lot: OV-CH-07; project-overrun feeder cable with exact part number on tag; two reels, 300 ft documented and 180 ft estimated; uninstalled; release approval pending. In this example, both reels remain outside the available total until the named approval is resolved.
- Match inventory line IDs to tag-photo and jacket-print filenames.
- Include the material location and any relevant access or loading limits.
- Preserve the distinction between documented and estimated footage.
