Set an honest offered boundary
Start with the physical stock area rather than an old purchase order. Give every reel, coil, or distinct continuous piece an inventory reference, then mark it available, reserved, retained, or approval-pending. Record the owner, the person or role that can authorize release, and the storage area. That boundary prevents a buyer from reading a warehouse export as an offer of everything on it.
If a release contact is unknown, keep the line approval-pending. Do not solve the gap by calling it available or by dropping it into a grand total. A useful inquiry can include a pending line, provided the record states what confirmation is still needed.
- One reference per physical reel or continuous piece
- Separate available, reserved, retained, and approval-pending status
- Name the owner and release authority instead of assuming they are the same
Reconcile records to the actual reels
Match the current tag, jacket printing, and reel ID to the purchase order, inventory export, or project record. Keep the original quantity as history, but put the present quantity in its own field and label it documented, measured, or estimated. A partial part number or a record for a neighboring reel is not a substitute for the physical item.
The likely mistake is using the invoice total as the current balance. Correct it by making a row for each reel found, retaining any discrepancy, and linking the row to the photo or document that supports the balance. Unknown markings remain unknown until better evidence is available.
- Manufacturer and full designation or part number
- Reel ID matched to tag and jacket photo
- Original quantity kept separate from present balance
- Quantity basis marked documented, measured, or estimated
Keep usable lengths and release facts separate
Full reels, partial reels, and cut lengths should not become one footage number. Record each continuous length separately, along with condition and the evidence basis. Two short pieces may add to the same footage as one reel, but they do not describe the same offered inventory.
Also keep a reservation, internal return, or project hold in its own status field. A buyer can then see why a marked reel is not in the releasable balance without treating the material as unavailable forever or assuming it has been cleared.
- Continuous footage for each line
- Full reel, partial reel, and cut length distinguished
- Condition noted without making a performance claim
- Reservation or return note connected to the same reference
Build a current-balance record
A short current-balance record is more useful than a long narrative. Use the same reference in the spreadsheet, photo filename, and any export row. Attach a readable tag photo and jacket-print photo, then identify the next evidence needed for a pending line. This leaves the buyer with a checkable record instead of an unsupported total.
For example, an unknown footage figure can remain estimated with the reason stated. Do not recast it as documented because an invoice exists; the invoice may only establish what was originally received.
- Illustrative record only, not a transaction
- Inventory reference: SJ-OV-014
- Current balance: 300 ft documented; 180 ft estimated
- Status: second reel approval pending
- Evidence: photo OV-014A and warehouse export row 88
Use the city context only as context
South Jordan’s infrastructure update describes U-111 widening and realignment from South Jordan Parkway to Herriman Boulevard with two lanes in each direction and a center turn lane. That public project description does not identify a cable lot, prove a seller has material, or establish that any particular reel is releasable.
It can help a seller explain why a project-overrun record exists, but the buying review still depends on the actual labels, present footage, storage details, and release evidence for the offered inventory.
- Project background is separate from reel identification
- Physical inventory and release records control the seller task
