Reconcile the order before describing a surplus balance
Treat a purchase order, takeoff, invoice, or warehouse export as a starting record, not proof of remaining inventory. For each candidate line, write the source document, part number, original quantity, current balance, and a short discrepancy note. A quantity used on a project, returned to stock, reserved, or missing belongs in the discrepancy note rather than in an assumed available total.
Milpitas Design & Construction says its five-year Capital Improvement Program funds and prioritizes streets, water, sewer, storm-drain utilities, parks and community infrastructure. This only supports a local infrastructure-project context; it does not establish a particular project, cable type, or available lot.
- Retain the original document reference with the current balance.
- Explain each difference between original and current quantity.
Count physical reels and boxes on their own terms
Create separate lines for full reels, partial reels, boxes, and cut lengths. Record a reel reference, continuous footage, packaging, reel count, and whether the quantity is measured, documented, or estimated. Group only matching product designations and matching continuous lengths; otherwise the total hides the material a buyer would actually review.
Use the same reference in the photo filename and the inventory. A reel photograph without an inventory line is context, not a current balance.
- Keep a 300 ft partial reel distinct from a 180 ft partial reel.
- Do not turn multiple separated cuts into one continuous length.
Tie product evidence to the reconciled line
For every line, attach a readable tag or jacket-marking photograph and note the manufacturer, part number, jacket designation, and visible condition. If a tag is missing, show the available printing and record the exact uncertainty. Do not use a nearby package or an old invoice to supply an unverified current specification.
A compact filename convention such as OV-MP-01-tag and OV-MP-01-overview keeps the physical reel and its records connected through the reconciliation.
- Photograph readable labels and representative visible condition.
- Mark unreadable markings unknown rather than calling them a match.
Separate release status from the inventory count
A reel can be physically counted while release is still pending. State who owns the item, who may authorize release, whether a project return or reservation applies, the storage location, and site-access limits. This avoids the seller mistake of reporting every item on an order as immediately available.
Do not let a short timetable convert a pending line into an approved release. The current balance and the internal approval are separate facts that should travel together in the inquiry.
- Use offered, reserved, or pending as distinct release labels.
- Keep storage and access notes with the reel reference.
Show unknowns in a current-balance example
Illustrative inventory example—not a purchased lot: OV-MP-01; project-overrun feeder cable; part number on tag; two reels, 300 ft and 180 ft continuous, documented; uninstalled; release pending approval. It shows a verified physical balance without claiming the pending line can be released.
The recurring mistake is presenting original invoice footage as current availability. Correct it by retaining the source record, showing the current per-reel count, and identifying the missing approval or unknown footage directly.
- Example release status: pending approval.
- Example quantity basis: documented continuous footage.
