Start with physical balance, not invoice total
A purchase order, ERP export, or project list is a starting point, not proof of what remains today. Match each listed line to a current reel, box, or cut length and add a physical reference such as a reel ID, rack position, or photo filename. Preserve the original record in its own field so the discrepancy is visible rather than overwritten.
For each line, record manufacturer or part number when available, current quantity, continuous footage where applicable, and the basis for that quantity. The seller task is to reconcile physical stock with the record, not merely explain why material once became excess.
- Keep source-record quantity separate from current balance.
- Match every physical item to a reel, box, or photo reference.
- State measured, documented, estimated, or unknown for current quantity.
Keep availability states visible
Full reels, partial reels, unopened boxes, cut lengths, reserved material, pending returns, and uncertain lines should not share one availability label. Assign a status field to every record. A line can be physically present yet not be released for sale, and that difference matters to a useful buying conversation.
Do not move reserved footage into an available total because it shares a product code. Leave the reservation visible and state the supporting note if one exists. If status is not known, record it as unknown instead of presenting all warehouse inventory as immediately releasable.
- Use a separate availability-status field.
- Distinguish full reels, partial reels, boxes, and cut lengths.
- Keep reserved and pending-return lines outside a released balance.
Document why the line is being released
State documented release reason for each line: project overrun, distributor excess, maintenance closeout, or another supported source. Add condition and available storage-date information without implying that a release reason establishes demand, condition, or a buying outcome.
Reason belongs with the physical line. A project name by itself is not a quantity or condition record. If a supporting memo is missing, leave the reason unknown or provisional and keep product and quantity facts separate from that uncertainty.
- Record release reason and supporting record when available.
- Keep condition separate from release reason.
- Mark unavailable dates and source documents unknown.
Show authority and pending approvals honestly
Record the owning department or inventory holder, business role that can confirm release, approval status, and material location. A person able to show reels may not be able to authorize their release. A specific authority status is more useful than a generic contact name.
The common mistake is offering original invoice footage as remaining inventory and calling all lines available while some are reserved or awaiting approval. Correct it by preserving current balance, evidence basis, reservation, and authority status together on each row.
- Identify owner or department and release role.
- Use pending or unknown when approval is unresolved.
- Keep location with the item record.
Compare the process to a fictional line item
Illustrative fictional inventory record—not a purchased lot: OV-LR-01 is project-overrun feeder cable with a part number on its tag. Two reels show 300 feet and 180 feet as documented continuous lengths; their condition is uninstalled, but internal release approval remains pending.
This line can be described accurately without implying it is available today. It shows the desired workflow: physical quantities, condition, release reason, and authority status are present, while the pending decision stays visible instead of disappearing in a surplus total.
- Keep physical quantity and release status in separate columns.
- Do not turn pending approval into confirmed release.
- Use record reference on every related photo.
