Reconcile the offered reel, not the original order
An invoice, purchase order, or project export can help locate a product, but it does not prove the balance on a partly used reel. Give every reel an inventory reference, then compare the record with the physical reel. Record current footage and identify the basis as measured, documented, or estimated. Keep the original-order quantity in a separate field so it cannot be mistaken for the amount now offered.
A useful reconciliation note calls out a mismatch rather than smoothing it away. If the tag says 1,000 feet and a reel has an estimated remaining length, preserve both facts and label the estimate. Do not borrow a part number or quantity from a neighboring reel with a similar appearance.
- Inventory reference; manufacturer and part number; original-order quantity.
- Current footage per reel with a measured, documented, or estimated basis.
- Tag text, jacket designation, and photo filename tied to the same line.
Separate what is available from what is still controlled
Use a distinct line for full reels, partial reels, cut lengths, reserved material, and material awaiting release approval. State the release reason and whether an item is unused or previously installed. A release-pending reel may be described for review, but it should not be counted as presently available until the seller identifies the person who can authorize release.
This distinction is the core of a surplus reconciliation. It prevents a project closeout list from overstating what can actually be sold and gives the seller a clear list of internal questions to resolve before discussing a lot.
- Reel status and release reason on every line.
- Reserved or return status separated from available stock.
- Owner, release authority, storage site, access limits, and loading resources.
Build a proof set that follows each reel
Name image and document files with the inventory reference. For each line, include a readable tag or jacket view, an overview of the reel, and any record that actually matches that line. If the tag is missing, say so; a close-up of remaining jacket printing is more useful than an assumed product designation.
Rialto Public Works coordinates building maintenance, capital improvement projects, fleet services, infrastructure, street maintenance, traffic safety and waste management. That local context may help a seller explain a real maintenance or project source, but it does not identify a cable product or establish that any public inventory is being offered.
- Photo filenames and documents that repeat the inventory reference.
- A note for unreadable tags, estimated footage, or an unresolved discrepancy.
- A single release contact or role for the group of reels being offered.
Correct the current-balance mistake before inquiry
The common error is presenting an old invoice or project total as footage currently available for sale. Correct it by adding a current-balance field to every reel, naming the evidence basis, and flagging reserved or approval-pending material separately. This protects both the seller and reviewer from discussing material that is already allocated or not yet releasable.
The illustrative record below is fictional, not a report of an actual Rialto lot. It shows why documented and estimated balances, as well as a pending release, belong on the same specific line rather than inside one grand total.
- Illustrative line OV-RI-01: product designation remains unknown unless a reel tag supports it.
- Keep 300 documented feet and 180 estimated feet visibly distinct.
- Mark release approval pending rather than treating it as an accepted transaction.
