Reconcile the order with what is present
Start with the source document, but treat it as a starting point rather than the available balance. Give every physical reel or package a temporary reference, then match it to the purchase-order line, inventory export, or project list. Record the original quantity beside the current quantity so a reviewer can see the difference without reconstructing the history.
For the current amount, state whether the footage is measured, documented by a current tag or record, or estimated. A reel shown on an old invoice is not evidence that the reel remains. If a line cannot be found, leave the current quantity unknown and keep the discrepancy visible instead of carrying forward the original number.
- Keep the original quantity and current quantity in separate columns.
- Match each row to a reel reference and photo filename.
- Mark a missing reel or unreadable label as unknown, not as zero or available.
Separate balances by present status
Make a separate line for a full reel, partial reel, cutoff, reserved stock, pending return, and material awaiting internal approval. Retain the continuous length for each reel; several short pieces should not be presented as one long length. Add condition and storage location on the same line because two matching part numbers can have different records or availability.
The likely inventory mistake is using the original project total as the remaining footage and treating every listed reel as sale-ready. The workable fix is a current-balance list that identifies the evidence basis, preserves per-reel length, and keeps reserved or pending material apart from the available balance.
- Use one current-status field: available, reserved, return pending, or release pending.
- Show the actual continuous length per partial reel.
- Keep material at another location on its own row.
Document authority without assuming release
For each group of reels, record the owner or authorizing contact, release status, ownership note, and any seller timetable that is known. A contact who can locate stock may not be the person who can authorize a sale. Where approval is unfinished, describe it as release pending and attach the record that identifies the next decision-maker if one exists.
Do not describe a balance as cleared merely because it is physically visible. If the authority is unknown, enter unknown and say whether the next useful record is a job file, warehouse record, or internal release note. That preserves a useful inquiry without creating a claim about ownership or transaction terms.
- Name the authorizing role or mark it unknown.
- Keep release-pending reels out of an available-total field.
- Attach only records that refer to the same reel or inventory line.
Build an evidence set a reviewer can follow
Match the inventory reference to a readable reel tag, jacket printing, overview photo, and any product record. Capture manufacturer, part number, complete designation, conductor metal, size, marked voltage, condition, and the quantity basis where those facts are available. Use the same reel reference in each filename so the evidence remains connected when a list contains similar products.
Lehi City describes the community as centered between Utah’s two largest urban areas, located on the I-15 Corridor, with an average annual growth rate of 8% to 10%. That is limited local context for why a seller might have project or distributor paperwork; it does not show that any named project has cable available or that a lot will be purchased.
- Photograph the tag and a legible stretch of jacket printing.
- State whether each footage figure is measured, documented, or estimated.
- Keep a product record linked only to the reel it actually identifies.
Use a clearly labeled sample row
Illustrative fictional record, not a purchased lot: reference OV-LH-01; project-overrun feeder cable with part number on tag; two reels with 300 ft documented and 180 ft estimated; uninstalled condition; release pending. The record is useful because it does not turn the invoice amount into the current amount and it leaves the approval gap visible.
If a field is incomplete, submit the known tag, photographs, and current-status note rather than filling the gap from memory. A seller can then add a measurement, clearer photo, or authorization record later without changing the identity of the reel being reviewed.
- Example purpose: show original versus current quantity.
- Example uncertainty: 180 ft is explicitly estimated.
- Example release status: pending, not assumed.
