Reconcile the export to physical stock
Start with an inventory reference or part number, then match it to the physical reel or package. Record the reel ID, observed current balance and any discrepancy between the old export and present stock. An original invoice can document a purchase history, but it is not proof that all listed footage remains available.
If a reel cannot be matched, mark the line unverified and attach the best available tag photo, receiving reference or other record. Do not carry an unverified balance forward simply because it is present in a spreadsheet.
- Inventory reference or part number
- Physical reel ID
- Current balance with basis
- Discrepancy between export and observed stock
Preserve reel-level availability
Use each full reel, partial reel or cut length as an individual record even where product specifications match. State per-reel footage, its measured/documented/estimated basis and condition. A summary may group matching items for readability, but it should not erase the individual quantities that make up the summary.
For an estimated partial reel, state how the estimate was formed. That is more actionable than treating its footage as a released balance or merging it into a total with documented reels.
- Specification and part number
- Reel count and per-reel footage
- Measured, documented or estimated basis
- Condition and physical-item reference
Separate inventory evidence from release status
For every reel, show whether it is released, release pending, reserved, return-pending or unknown. Identify the approver or authorization reference when one is available. A reel may be physically present and still be unavailable for disposition; the inventory state and release state are different fields.
The likely mistake is treating the invoice quantity as today's balance and every listed reel as available. The correction is a current balance with its evidence basis plus an explicit reservation or approval gap. Do not represent a pending line as released.
- Release status
- Reservation detail
- Return status
- Approver or authorization reference
Connect photos and access to the physical reel
Name photos with the same inventory or reel reference used in the spreadsheet. Show the tag, an overall reel view and visible condition. Add storage ZIP or location, access notes and known loading limitations. If a tag cannot be photographed clearly, say why and attach the alternate record used for identification.
Alhambra's Economic Development Division lists business recruitment, retention and expansion, development-project coordination, and marketing to targeted industries and commercial tenants among its responsibilities. That is limited commercial context only; it does not establish that a particular tenant, distributor or contractor has surplus cable available.
- Photo filename linked to inventory reference
- Storage site or ZIP
- Access and site limitation note
- Clear explanation where evidence is incomplete
Illustrative surplus-reel record
Illustrative fictional record—not a purchased lot: ALH-OV-01; project-overrun feeder cable; part number on tag; two reels—300 ft documented and 180 ft estimated; uninstalled; release pending. The two footage bases and pending availability status remain visible rather than becoming a single confirmed total.
If the estimated reel is later reserved for a return, update its release field without changing the documented reel's line. The value of the format is that a changing availability decision does not distort the material record.
- Reference: ALH-OV-01
- Two reels: 300 ft documented; 180 ft estimated
- Condition: uninstalled
- Availability: release pending
