Start with the physical reel, not the order total
A reel tag or purchasing record may identify what was ordered, but it does not settle what remains on the reel today. Give every reel or coil a stable line ID, then record whether the material is a full reel, a partial reel, a coil, or separate cut pieces. Put the current continuous length beside the original tagged length rather than replacing one with the other.
Costa Mesa Community Development says it guides and permits new development and comprises planning, building safety, code enforcement, and housing and community development divisions. That local context is relevant only to keeping existing project paperwork with the right reel; it does not identify a Costa Mesa lot or imply that a particular job produced available wire.
- Use a line ID that also appears in photo filenames.
- Keep an original tag quantity and a current quantity as separate fields.
- Mark the current quantity as measured, documented, estimated, or unknown.
Transcribe the complete building-wire identity
Copy the readable jacket legend and reel label rather than using a color or a broad phrase such as building wire. A useful line records manufacturer, product designation, conductor metal, AWG or kcmil, insulation marking, voltage marking, color, and any part number. A single-conductor reel and a bundle of mixed short pieces should never share the same description.
If the printing is worn, say which characters cannot be read and add a clear photo reference. Do not fill a gap from a nearby reel with a similar appearance. A record that says unknown for one field is more useful than a confident but unsupported designation.
- Separate copper and aluminum lines.
- Separate different gauges, colors, and insulation markings.
- Preserve a long continuous piece as its own line.
Make the footage basis easy to audit
State how the current footage was established. A measured balance is a recorded physical measurement; a documented balance is an existing record that the seller has compared with the reel; an estimated balance is a labeled approximation. If the reel is obstructed, sealed, or cannot be checked, leave the footage unknown and explain the limitation.
Do not turn several short pieces into one continuous length. For cut pieces, list the piece count and the length of each piece or range of pieces. This distinction prevents a reviewer from reading aggregate footage as one usable run.
- Record one continuous length per reel or piece.
- Identify the quantity basis next to every footage figure.
- Note packaging damage or visible jacket issues as condition observations only.
Match evidence to the line and the release status
For each line, attach references for the tag, readable jacket area, overall reel or coil, and any visible condition difference. Keep the storage description practical: indoor, covered outdoor, exposed outdoor, or unknown. Then identify the business role that can authorize release and whether that approval is confirmed or pending.
The inventory should distinguish an available reel from one still held for a job, return, or internal review. A clear hold status avoids presenting a historical quantity as material that can actually be discussed. Storage and access facts describe the lot; they do not set transport or other commercial terms.
- Use the same line ID in photos, the inventory, and any supporting record.
- List release status as confirmed, pending, held, or unknown.
- Keep access limits with the applicable reel or storage group.
Correct a common balance error with a worked record
A common mistake is listing five different conductor sizes as one copper-wire total using an old invoice figure. The fix is to split the conductors by actual designation and gauge, report each present continuous length with its quantity basis, and leave any unresolved balance marked estimated or unknown.
Illustrative inventory example—not a purchased lot: CM-BW-17 is a partial reel labeled THHN/THWN-2, 12 AWG copper, black; the current entry is 430 ft estimated, original tag 1,000 ft, tag photo CM-BW-17-A, release status pending. The example shows the format only. It is not evidence of an actual Costa Mesa inventory.
- Resolve an unclear balance by checking the specific reel, not a combined invoice total.
- Keep the unknown field visible until the supporting record or physical review resolves it.
