Reconcile the current balance
Start by matching each inventory-export or purchase-order line to the physical reel, coil, or package at the Tyler-area release site. For every line, record the inventory reference, manufacturer/part number, and the current reel count. Do not carry forward the original ordered quantity as the sellable balance unless you have reel-level verification.
Practically, create a worksheet row per physical reel ID and mark items as reserved, returned, or missing where applicable. Use the supplied evidence fields: inventory reference, manufacturer/part number, current reel count, storage site, and quantity basis. This reconciled worksheet is the primary document used to decide what can be released.
- Match order/export line → physical reel ID
- Mark reserved/returned/missing instead of relying on original order quantity
- Record storage site and quantity basis for each line
Preserve reel-level quantities and labeling
List full reels, partial reels, coils and cutoffs separately. For every reel, capture the reel ID and continuous length per reel and state whether the length is measured, documented, or estimated. Differentiate full/partial/coil/cutoff as a discrete field.
Where footage is estimated, label it explicitly as estimated and include the method used (visual tape, tag legend, or measured by a meter). Keep continuous-footage values with decimals or feet as appropriate; do not aggregate different reel lengths into a single lumped line that hides per-reel continuity.
- Record reel ID and continuous length per reel
- Tag full/partial/coil/cutoff status
- Mark measured, documented, or estimated quantity basis
Document product evidence and photo requirements
Photograph the complete tag and any jacket printing on every reel or coil and attach the matching part record. Record manufacturer, the full part-number legend, conductor metal, size, and marked voltage. Keep copper and aluminum constructions on separate worksheet lines.
Store photo/file references alongside the reel entry so anyone reviewing the lot can match photos directly to reel IDs. The photo should clearly show the reel tag and readable jacket legend; record the file name or reference in the photo/file reference field.
- Photograph complete tag and jacket printing
- Record manufacturer, part number/full legend, conductor metal, size, and marked voltage
- Attach photo/file reference to each reel entry
Confirm release readiness and access limitations
Identify owner/release authority and explicitly state reservation or approval status for each reel or batch. Note site access restrictions and the seller timetable so reviewers understand whether release is possible within a given window. Do not treat an inquiry or worksheet as an acceptance or transport commitment.
If approval is pending, label those reels 'pending approval' and include the authority name or role. If reels are reserved for a future job, mark them 'reserved' with reservation details. This prevents the common mistake where original invoice footage is presented as remaining sellable quantity despite reservations.
- State owner/release authority and reservation/approval status
- Record location and any access restrictions
- Include seller timetable and explicit release labels (pending approval, reserved, missing)
How to handle unknown or incomplete inventory
When reel IDs, tags, or exact locations are unknown, create a clearly labeled 'unknown/incomplete' section in your worksheet. For each unknown item, list the original order reference as background only and provide the best available evidence: photos, storage site description, and an estimated quantity basis. Do not present those entries as confirmed sellable balance.
If access to a storage site is restricted and you cannot verify reel-level footage, mark the affected reels as 'access-limited' and include the date by which verification can be completed. This honest labeling helps buyers and reviewers prioritize inspections and avoids the mistake of assuming completeness.
The Tyler Economic Development Council lists advanced manufacturing among Tyler’s key and target industries. That is limited context for organizing production or warehouse records; it does not identify a seller’s inventory, a customer, or a buying outcome.
- Create an 'unknown/incomplete' section—keep original order as background only
- Provide photo/file references or site descriptions when available
- Mark access-limited items with an estimated verification date
Illustrative reconciliation example (fictional)
Below is a fictional, illustrative record showing how to present an overrun lot. Treat the original invoice as background; the key new column is the current-balance tied to each reel and a release label.
Illustrative Tyler overrun record — fictional, not a purchased lot: reference OV-TY-01; material XHHW-2 feeder cable with exact part number shown on photographed tag; quantity: 2 partial reels—300 ft documented and 180 ft estimated; condition: Uninstalled with jacket condition visible in photos; release: Project closeout, release approval pending; location: Tyler-area warehouse, exact address unknown.
- Example shows separate lines for documented and estimated reel footage
- Release status and location are explicit, not implicit
- Original order appears only as background reference
