Why reconcile surplus-release records
A project export or purchase record often lists original reel footage rather than the lengths that remain on each physical reel now. That mismatch leads buyers and internal teams to assume availability that may not exist. Reconciliation narrows the decision to one question: which reels and quantities are actually available today, and what evidence ties those balances to each line item.
This page focuses on marking current balances per reel, separating release and reserved states, and attaching consistent evidence. Use the steps below to produce a reviewable file that supports a sale-ready disposition request without assuming transport, payment, or acceptance terms.
Milwaukee’s Industrial Land Analysis reports about 45,000 industrial jobs, over $3.6 billion in wages and about 2,160 businesses in seven Industrial BIDs. That citywide context makes careful facility closeout records useful, but it does not show that any Milwaukee inventory is available or that Industrial Wire Buyer has a relationship with those businesses.
- Preserve per-reel lengths instead of reporting original invoice footage as remaining.
- Separate full reels, partial reels, cutoffs and material reserved for other projects.
- Attach matching references across spreadsheet line, reel-tag photo, jacket print photo and product record.
Step 1 — Reconcile the current balance
Match each exported inventory line to physical reels and mark the quantity basis for the recorded balance. For every line, provide the required evidence fields: reel/line ID, part number, reel count, continuous length per reel, and the quantity basis (measured, documented, or estimated).
If footage is estimated, state the estimation method and flag it in the evidence column. If you cannot access a reel, mark the quantity unknown and record why. Do not treat a record of original footage as proof of current sellable balance.
- Include reel/line ID that matches your export record.
- Record a continuous length per reel; do not roll multiple reels into one aggregate without per-reel detail.
- Set quantity basis to one of: measured, documented, estimated, or unknown with explanation.
Step 2 — Separate release states and reserved material
List full reels, partial reels, cutoffs and reserved or approval-pending stock on separate spreadsheet lines. For each line show condition, available-for-sale status, reserved quantity and release authority. Do not mark material as available-for-sale merely because it appears on a purchase or export file.
If a reel requires internal approval before sale, mark its status pending and record the release authority. Do not combine pending or reserved footage with the stated available balance, and do not infer approval from a purchase or export file.
- Create dedicated columns for condition (e.g., new-on-reel, uninstalled overrun, damaged jacket), available-for-sale status (available, pending, reserved), reserved quantity and release authority.
- Do not combine reserved footage with available footage in the same line; keep totals separate and explain how they sum to the exported original if relevant.
Step 3 — Tie evidence consistently to each line
Use a single reference across the spreadsheet line, reel-tag photo filename, jacket-print photo filename and any matching document. Required evidence fields here include photo filenames, manufacturer, complete designation and matching document. The same reel/line ID must appear in each supporting file name and the spreadsheet reference column.
Store or deliver photos that clearly show the reel tag, jacket print and any handwritten markings. In the spreadsheet include the exact photo filename and a short description of what the photo shows (for example: 'OV-MKE-07_reeltag.jpg — manufacturer part number legible; tag shows 300 ft').
- Photo filenames should include the reel/line ID (e.g., OV-MKE-07_reeltag.jpg).
- Attach or reference the matching document (e.g., packing list filename) and list the manufacturer and complete designation copied from the reel tag or jacket print.
- If a document's fields disagree with the physical tag, record both and flag the discrepancy.
Step 4 — Describe the handoff and logistics facts
Provide factual storage details without assuming pickup or transport terms. Required fields: storage location, access restrictions, loading resources and requested timetable. Be specific about where the reels are stored (area or dock identifier), any gate or insurance requirements to access them, whether a forklift or lift gate is available for loading, and the dates or deadline the owner requests for disposition.
If you do not know a requested timetable or loading resource, mark that field unknown and provide contact information for the site coordinator or the party who can confirm access. Do not invent availability or terms.
- List the precise storage location and any access restrictions.
- Note loading resources (forklift, dock height) or state unknown if unavailable.
- Provide a requested timetable or mark unknown and give the responsible contact for timing.
Handling incomplete or unknown inventory
When inventory is incomplete or reels cannot be accessed, be transparent: mark quantities as unknown and include why (e.g., locked facility, reel under project hold, label illegible). Provide the minimal evidence available (photo of the reel area, export line ID) and the steps needed to convert that line to measured or documented status.
Typical steps to resolve unknowns are: request access or approval from the release authority, schedule a short re-inspection to photograph reel tags, or measure continuous length. If none of those are possible before listing, keep the line in 'pending' status and do not claim sellable footage.
- If access is blocked, list the release authority and the exact barrier (e.g., locked bay, reserved for a separate project).
- For estimated footage, include an estimation note and what would be required to confirm the length.
- Retain unknown records until you can attach a photo or a documented measurement.
Illustrative reconciliation example
Use the following illustrative record as a model when preparing your submission. It is only an example — not a purchased Milwaukee lot — and shows how to present fields and the release status:
Line OV-MKE-07: designation — manufacturer part number on reel tag; exact construction recorded. Quantity — 2 reels: 300 ft documented and 180 ft estimated. Status — uninstalled overrun; second reel release approval pending.
- Include an evidence column that lists: OV-MKE-07_reeltag.jpg, OV-MKE-07_jacket.jpg, packinglist_OV-MKE-07.pdf.
- Set quantity basis to 'documented' for the first reel and 'estimated' for the second; mark second reel available-for-sale status as 'pending' and list the release authority contact.
