Make the physical balance the starting point
A purchase order, change order, or warehouse export can help identify what was originally supplied, but it does not prove today’s remaining inventory. Walk the material that is physically present and match each reel, box, or continuous piece to a stable inventory reference. Record a discrepancy when an ordered quantity is absent, partly consumed, reassigned, or not located.
Keep the original order quantity in its own column and create a separate current-balance column. The current-balance entry should say whether it is measured, documented, or estimated. This protects the seller from presenting a historical total as if it were the amount now available for a buying review.
- Match the order or export line to a physical reel or package reference.
- Use a current-balance field separate from original ordered quantity.
- Record missing, consumed, or unmatched material as a discrepancy.
Preserve usable quantity differences
List full reels, partial reels, boxes, and cut lengths separately. A total spread across several short pieces is not the same inventory record as one continuous reel. For each line, include product designation, reel or piece count, continuous length, and the basis for that length. When a product marking is unreadable, do not use an order description alone to fill the gap.
Condition belongs beside the quantity. Note whether the line is uninstalled, has damaged packaging, has visible cable-end or jacket issues, or has an unknown storage history. Similar descriptions should not be merged simply to create a cleaner grand total. An honest list lets a reviewer see which rows are documented and which need follow-up.
- Show per-reel or per-piece continuous length.
- Separate documented footage from estimates.
- Keep product marking and condition on the same inventory row.
Separate reserved stock from released overrun
Project material may still be reserved for a different scope, awaiting a return decision, or subject to internal approval. Use a release-status field for each line: available for discussion, reserved, return review, approval pending, or unknown. Do not represent a line as offered merely because it appears in a purchasing record.
Identify the person who can confirm release, not only the person who assembled the spreadsheet. If the seller intends to offer defined groups rather than every row, mark the group boundary. This gives the buyer a clear view of what the seller is asking to discuss without assuming the rest of the project inventory is included.
- Record reservation and return status separately.
- Tie release approval to the same line or defined group.
- Keep excluded project stock visibly outside the offered scope.
Link records and photos without borrowing facts
Use the inventory reference in photo filenames, reel-tag notes, and any supporting order or product record. A photo of one well-labeled reel does not verify every similar-looking reel. Keep a field for unmatched records and unknowns so that a reviewer can request the missing item rather than mistake a related document for support.
Santa Ana’s economic-development strategic plan says many Santa Ana businesses utilize industrial space and describes industrial real estate as comparatively competitive; it also identifies manufacturing among resident employment sectors. That broad city context does not establish a particular project, leftover inventory, or buyer demand. It supports the modest point that an actual project remainder should be reconciled to the physical cable before it is described for review.
- Use one stable reference across the list, photos, and documents.
- Label a record that does not match a physical item as unmatched.
- Keep unknowns visible instead of copying a similar reel’s data.
Repair an overstated overrun list
The common overrun mistake is presenting the original invoice footage as the inventory available today, with full and partial reels collapsed into one number. A practical correction is to retain the order line for identification, then add physical reel references and a current balance for every row. Reserved or approval-pending lines stay out of the offered count until their status is confirmed.
An illustrative fictional working record might read: SA-OV-02; project-overrun feeder cable; part number on tag; two reels, 300 ft documented and 180 ft estimated; uninstalled; one reel has damaged packaging; internal approval pending. This is not a purchased lot. It demonstrates how a seller can carry an estimate and a pending decision forward without hiding either one.
- Do not use original invoice footage as the current balance without verification.
- Keep full and partial reels on distinct lines.
- Flag reserved and approval-pending material before calling it offered.
