Why reconcile original records to physical balance
Original project orders and ERP extracts commonly show invoice footage or ordered quantities rather than the present physical balance. That leads to overstated availability when records are carried forward without verification. Our approach treats the original record as the starting document, not the final inventory statement.
Reconciling records avoids the frequent mistake where every line is listed as available before reservations, removals, or partial use are identified.
Kansas City Public Works lists 93 capital projects and includes projects at addresses such as 11th and 12th Streets, Bannister Road, and 75th and Wornall. A project reference can explain why material is being released, but it does not replace current reel labels, physical quantities, or authority to release the offered cable.
- Use the original source record as provenance, not as the confirmed remaining quantity.
- Record per-reel or per-package identifiers to preserve traceability from the original tag to the current item.
- Separate items that are unopened, partial, reserved, removed, or pending approval so visibility is clear to buyers.
Step 1 — Reconcile the physical balance
Match the ERP export, purchase order or original tag to each physical reel or package and record discrepancies. For each line, collect the required evidence fields: source record, current reel/package ID, original quantity and current quantity. Do not replace the original quantity with an assumption; instead, record both numbers and note how the current quantity was determined.
If footage on a reel is estimated because the reel lacks a legible tag or measuring label, document the method used to estimate length (visual estimate, scale, or measured sample) and mark the line as 'estimated' rather than 'confirmed.'
- Evidence to capture: source record, current reel/package ID, original quantity, current quantity.
- Mark estimated lengths clearly and include the estimation method in the record.
Step 2 — Split availability states
List full reels, partial reels, unopened boxes, cutoffs, reserved stock and any removed material on distinct lines. Each line should include form factor, continuous length (where measurable), unused/removed status, and reserved or pending status. This prevents bundling dissimilar availability into a single ambiguous quantity.
When items are reserved by a project owner or held for returns, note the approval status and any requested timetable. If release authority is unclear, capture who is listed as the owner and where the approval request is pending.
- Evidence to capture: form factor, continuous length, unused/removed status, reserved or pending status.
- Create a separate entry for every reel or boxed unit when practical; bundle only when units share identical evidence and release authority.
Step 3 — Explain the surplus reason and storage condition
State whether each line is a project overrun, distributor stock, maintenance inventory or a closeout lot without guessing missing dates. Record the surplus reason, manufacturer/part number, storage condition and known date or clearly mark date as unknown.
Accurate reason codes let buyers understand if material is unused, returned, or part of a project change order. If storage condition is unknown, mark it as unknown rather than making assumptions about exposure or handling.
- Evidence to capture: surplus reason, manufacturer/part number, storage condition, known date or unknown.
- If tags show manufacturer or part numbers, transcribe them exactly; where a tag is missing, document the absence and any observed markings.
Step 4 — Confirm release authority and approvals
Identify who can approve sale and release and whether a project owner, returns department, or internal approval remains pending. Include owner, release authority, approval status, and requested timetable in the record. Buyers must see whether the material is genuinely releasable or requires sign-off before transfer.
When release authority is pending, annotate each affected line with the pending approver and the date the approval was requested. Do not list items as available until the record shows release has been given.
- Evidence to capture: owner, release authority, approval status, requested timetable.
- If the approver is unknown, include the person or department to contact for approval and note that the line is 'release pending'.
Handling unknown or incomplete inventory
When inventory items are missing tags, partially labeled, or recorded only by legacy invoices, be explicit about uncertainty. Record what is known and what is unknown; for example, list the original invoice footage alongside a measured or estimated current quantity and tag the entry as 'estimated' when measurement is incomplete.
If a full reconciliation cannot be completed before listing, present lines as conditional: show the evidence you have, flag missing evidence fields, and state the steps needed to complete verification. This lets buyers weigh risk and decide whether to inspect, request measurement, or require approval contingencies.
- Do not present estimated or unknown items as fully available—label them clearly and provide the missing evidence fields required to confirm availability.
- Provide a short plan of action for each unknown item: onsite measurement, tag reattachment, or owner confirmation.
