Build a physical current-balance table
Start with the purchase order, warehouse export, or project list, but treat it as history rather than proof of what remains. Give every reel, coil, or continuous cut length a stable inventory reference. At the storage location, match that reference to the physical item and record the manufacturer, part number, marked designation, and where the item is stored.
Add separate columns for original quantity, current quantity, and quantity basis. A balance may be measured, supported by a current record, or estimated; do not present those bases as interchangeable. Mark a listed item as consumed, unlocated, reserved, or returned when that is its actual status instead of carrying an old total forward.
- One reference for each physical reel, coil, or continuous cut length
- Original quantity, current quantity, and measured, documented, or estimated basis
- Manufacturer, part number, visible designation, and actual storage location
Keep partial reels and condition differences visible
A full reel, a partly used reel, a coil, and several cut pieces should not share a single balance line. Record each continuous length, reel count, and unused or removed status separately. Note damaged packaging, missing labels, fitted ends, or visible jacket issues beside the line they affect so a clean item does not stand in for the whole balance.
When footage is uncertain, state what is known without inventing precision. A useful entry can say that footage is estimated from the remaining reel, while another entry records a documented balance. The point is to let the reviewer see where additional confirmation may be useful.
- Reel ID and continuous footage for each unit
- Condition notes attached to the affected item, not the lot as a whole
- Separate unused stock from material with a different history
Show who can release each line
Availability has two parts: the material must be physically present and it must be authorized for release. Identify the owner and the person or department that can approve release for each line. Use a status such as available, reserved, return pending, or approval pending; do not place a pending line in the available balance just because it appears on the same project record.
If a decision date is not known, record it as unknown. A seller can still submit the inventory with that gap clearly identified. This keeps the purchasing conversation tied to the actual offered balance rather than an assumption about internal approval.
- Owner and release authority for each inventory line
- Reservation or return status kept separate from available stock
- Known release date, or an explicit unknown when none is confirmed
Match evidence files to disputed quantities
Use the inventory reference in every photo filename and document name. A readable reel tag, jacket printing, overview photograph, and condition photograph help explain why a current balance differs from the original order. Retain the old document as context, but identify the newer observation or record that supports the offered quantity.
Do not make a project name do the work of a cable record. The City says its economic-development programs include Enterprise Zone incentives, Tax Increment Finance Districts, development programs and capital-improvements planning and construction. That local context can help a seller describe the source of an overrun, but it does not establish that any wire or cable is available or authorized for sale.
- Photo filenames that repeat the inventory reference
- Readable tag and jacket-print images for the specific line
- A note explaining why current footage differs from historical footage
Illustrative reconciliation record
The following fictional record shows the level of distinction that makes a balance reviewable. It is not a purchased lot and does not represent material held by Industrial Wire Buyer: reference CH-OV-14; XHHW-2 feeder cable with part number recorded from the tag; two partial reels, one 310 ft measured and one 185 ft documented; uninstalled material, with damaged packaging on one reel; facilities approval pending.
If the approval or footage cannot be confirmed, leave the field pending or unknown rather than converting it to an available quantity. This worked record is a format for separating a current balance from the original inventory history.
- Reference: CH-OV-14
- Quantity: 310 ft measured and 185 ft documented on separate partial reels
- Release status: facilities approval pending
