Split the balance by actual wire specification
Create one inventory line for every distinct jacket or reel designation. Copy the complete printing, then add conductor metal, AWG or kcmil, insulation designation, color, manufacturer or part number, and a reel reference. A black copper 12 AWG reel and a black aluminum feeder reel are not the same listing merely because both have dark insulation.
The frequent error is presenting several gauges as one copper-wire total because they were ordered together. Keep colors as an aid to sorting, not as the sole product identifier. If a tag is missing, record the readable jacket text and label the fields that cannot be confirmed as unknown.
- Inventory reference tied to the reel or coil
- Complete jacket or tag designation copied as shown
- Conductor metal, AWG or kcmil, and color kept in separate fields
Replace order footage with the current balance
For each reel, state one continuous length and its basis: measured, documented by a current stock record, or estimated. Mark the physical form as full reel, partial reel, coil, or cut length. An old purchase order can help locate a product, but it is not evidence that the original footage remains on the reel.
If several identical reels remain, list the length for each before calculating a group total. Short pieces should remain separate from a continuous run. This makes the quantity useful without implying that several cutoffs equal one longer conductor.
- Reel ID and current continuous footage
- Measured, documented, or estimated quantity basis
- Full, partial, coil, or cut-length status
Photograph what distinguishes the reel
Take a readable image of the tag and a separate image of the jacket printing. Add an overview of the reel, accessible ends, flange damage, missing labels, and any visible storage exposure. Tie file names to the inventory reference so a photograph of one reel is not silently used for a different reel.
Describe visible jacket abrasion, sun exposure, oil, broken flanges, or open packaging in plain terms. Photographs record visible condition; they do not establish electrical fitness or an automatic purchase outcome. A clear condition note is more useful than calling a partial reel “good” without detail.
- Tag and jacket-print photo references
- Jacket and reel condition notes
- Known indoor, covered, or outdoor storage history
Keep closeout context separate from product identity
The City lists development services covering permitting, plan review, inspections, development engineering and planning, and customer support. That local context can help a contractor retain project and release records, but it does not identify the wire on a particular reel or show that the City is involved in a sale.
For a New Braunfels closeout, record the storage ZIP or address, the person or role authorized to release the wire, available loading resources, and a requested timetable. Those operational details belong beside the reel list; they do not replace the specification, current footage, or condition record.
- Storage location or ZIP
- Release authority for the offered inventory
- Loading resources and site-access constraints
Use an honest record when information is missing
When footage cannot be measured, keep the line in the list and state “estimated” with the reason, such as a partially consumed reel or an unreadable tag. Do not carry forward an original shipped length as a current balance. If the marking is incomplete, preserve the available text and photograph it instead of assigning a nearby reel’s identity.
A workable fictional line might read: BW-NB-01; THHN/THWN-2; 12 AWG copper; black; 650 ft continuous estimated; partial uninstalled reel. The record is an example only, not a purchased lot. It illustrates how a real submission separates known designation facts from an estimated length.
- Unknown fields stated rather than inferred
- Estimates paired with their basis
- One reference used in the list and photographs
