Start with the current reel balance
Use the purchase order or project export only as a reference. Give each physical reel, partial reel, or separate cut length an inventory line ID, then record the original quantity beside the quantity that remains today. State whether the current figure is measured, documented, or estimated; a past invoice is not a current balance.
The city describes commercial expansion involving new businesses, retail centers and dining establishments. That is limited context for possible fit-out or warehouse-overrun scenarios, not evidence that a particular project, seller, or cable lot exists.
- Assign one line ID to each reel, partial reel, or distinct cut length.
- Show original quantity separately from current continuous footage.
- Label every current quantity as measured, documented, estimated, or unknown.
Separate products before totaling them
Do not blend a full feeder reel, a partial reel, and short cut lengths into one total. For each line, transcribe the manufacturer and part number when present, conductor metal, AWG or kcmil, conductor count, voltage or jacket marking, and remaining continuous footage. Group reels only when the product designation and condition information actually match.
If the label is damaged or the balance is uncertain, leave that field as unknown and show the available photo or record. Keeping uncertainty visible is more useful than assigning a plausible specification from a neighboring reel.
- Keep copper and aluminum on separate lines.
- List continuous footage per reel rather than an aggregate across unlike items.
- Retain full reels, partial reels, and loose lengths as different conditions.
Set the release boundary for each line
State whether the item is uninstalled stock, reserved for another job, subject to a return, or available for release. Name the owner or release authority and identify the storage site. If one reel is pending approval, keep it in the list but mark its status rather than counting it as offered inventory.
This step resolves a frequent commercial-overrun error: an invoice total is presented as the remaining quantity while reserved and partial reels are silently included. A current-balance column tied to each line prevents that mismatch.
- Record unused versus removed status.
- Show reservation or return status when it affects a line.
- Identify the owner or authorized release contact for the listed stock.
Match photos and records to the same line
Use the inventory line ID in photo filenames and on any data-sheet reference. A useful set includes a reel-tag photo, readable jacket printing, an overall reel view, and a concise condition note. The file should support the actual line, not merely show a similar product elsewhere in storage.
Describe visible jacket damage, missing labels, packaging condition, and storage facts without treating a photograph as proof of electrical performance. Where a data sheet does not match the reel tag, identify the discrepancy instead of using it to fill the gap.
- Match reel-tag and jacket-printing photos to the line ID.
- Keep data-sheet references only with the product they describe.
- Record condition notes and unknown fields in the same inventory row.
Use a worked overrun record
ILLUSTRATIVE ONLY — not a purchased lot. A fictional line can show how to keep the quantity, condition, and release status together without representing that Industrial Wire Buyer has bought or seen any local inventory.
Example: line OV-BB-01; project-overrun feeder cable with the part number copied from the reel tag; two reels, one with 300 ft documented and one with 180 ft estimated; uninstalled status; release pending. The example is a format, not a statement about available cable.
- Line ID: OV-BB-01.
- Quantity basis: 300 ft documented; 180 ft estimated.
- Status: uninstalled; release pending; release authority named separately.
