Compare the physical balance with the old record
An old purchase order or inventory export can identify a product, but it may not describe the reel currently on the shelf. Build a current-balance row for every physical reel or continuous piece. Mark it present, missing, reserved, pending return, or pending release before adding any total to the inquiry.
Keep original order footage in a separate reference field. Current footage must have its own basis: measured, documented, estimated, or unknown. This preserves the useful history without allowing the original order total to be mistaken for material now available.
- Inventory reference and physical reel ID.
- Current availability: present, reserved, missing, pending return, or pending release.
- Original order quantity kept separate from current balance.
- Current footage with a named quantity basis.
Build a balance row that another person can follow
For each reel, record manufacturer, part number or readable designation, storage site, continuous footage, reel condition, and current availability. A partial reel and a cutoff are different inventory objects; list them on separate lines even if both came from the same original order.
Match label and jacket-print photos to the row ID. If the two readings differ, record both without deciding that one overrides the other. If one is unreadable, mark it unknown and note the image that was checked.
- Manufacturer, part number, and product designation.
- Continuous footage and reel condition.
- Photo filenames using the same reel ID as the balance row.
- Label match, mismatch, or unreadable status.
Keep reservations and release authority visible
A reel can be physically present and still be unavailable for sale because it is reserved for a project, subject to an internal return, or awaiting approval. Give each line a reservation status and name the owner role and release authority. A pending line should remain pending instead of being counted as available stock.
Where an approval path is incomplete, describe the missing decision or record rather than making a timing promise. The practical next step is to identify who can confirm release and what evidence they need, while keeping the physical balance intact.
- Owner role and release authority.
- Reservation or return status.
- Reason an item is pending.
- Record or decision needed to confirm release.
Use discrepancies as follow-up records
Do not erase a discrepancy just to create a clean total. If a record lists three reels and only two are found, preserve the missing line and state the source of the discrepancy. If a tag has been damaged, retain the partial reading, photo reference, and the adjacent verified facts rather than creating a replacement specification.
This approach makes unknowns actionable. The seller can request the release record, locate the missing reel, or measure a partial balance without changing the description of the confirmed inventory.
- Missing reel record with last known location or unknown status.
- Partial or unreadable label photo retained.
- Estimate method stated where footage is not documented.
- Follow-up owner or record named for each open field.
San Bernardino context and a worked balance record
The City of San Bernardino says its Economic Development team connects businesses with tools, resources and guidance for launching or expanding, including help with location and capital. That is limited context for business-held inventory records; it does not show that a business has surplus cable, that a city office is involved, or that any lot will be purchased.
Illustrative fictional record—not a purchased lot: OV-SB-03 lists two reels of one marked cable, one with 300 ft documented and one with 180 ft estimated. The first is present but reserved; the second is present with release approval pending. The original purchase order total is retained only as a reference and is not offered as the current balance.
- OV-SB-03A: 300 ft documented, present, reserved.
- OV-SB-03B: 180 ft estimated, present, release approval pending.
- Original order total: historical reference only.
- Photos: label and jacket print linked to each reel row.
