Reconcile the physical balance before listing a project overrun
Start with the project export or purchase record, then compare it with the reels and pieces actually present. Give every physical item a reel or piece reference. Keep the original quantity as a historical field and add a separate current-balance field so consumed, transferred, or reserved material does not remain in the sale list.
For each balance, say whether it is measured, documented on a current tag, or estimated. A current estimate is more useful when it is labeled than an original invoice quantity presented as if it still describes the reel.
- Project or inventory reference
- Manufacturer and part number
- Current reel or piece ID
- Original quantity and current quantity basis
Separate full reels, partial reels, coils, and cut lengths
A single total can conceal the difference between one long usable length and several short pieces. Use a distinct line for each full reel, partial reel, coil, or cut length. Retain the continuous footage for that line and state the basis for the quantity.
Group matching part numbers only after the individual balance is visible. If two reels have different condition, footage basis, or release status, they remain different inventory lines even when their printed specification matches.
- Continuous footage for each piece
- Measured, documented, or estimated quantity basis
- Visible condition and photo filename
- Full, partial, coil, or cut-length form
Keep release status separate from material identification
Identification does not prove that a reel is available. Record whether the item is available for sale, reserved, subject to return, or waiting for an internal release. Identify the owner or controlling party and any approval that is still needed.
Do not include a return-pending reel in the available balance. A release note can be short, but it should distinguish a seller-controlled item from stock that a project, supplier, landlord, or another party still controls.
- Release status
- Owner or controlling party
- Approval still needed
- Authorized business contact
Match every record and photo to the offered reel
Use the same reference in the inventory sheet, tag photo, jacket-print photo, and overview photograph. A photo of one readable reel cannot establish the identity or current balance of another reel. Note missing labels, unreadable print, damage, and uncertain footage in the same line where they occur.
When information is incomplete, do not replace it with a nearby reel’s data. Mark the field unknown and explain whether the remaining evidence is a project record, a visible tag, a photo, or an estimate.
- Readable tag photo
- Jacket-print photo
- Elgin-area storage location
- Visible damage and unknown fields
Use local project context without treating it as inventory proof
The City of Elgin says its new commercial/industrial construction and addition application is also used for commercial/industrial tenant build-outs and projects involving multiple contractors. That limited context explains why a seller may have several contractor or tenant-build-out records to reconcile; it does not show that any particular cable is available or belongs to the seller.
Illustrative fictional record: OV-ELG-07 is a project-overrun feeder-cable line with a part number on its tag, two reels listed as 300 ft documented and 180 ft estimated, and release status noted as pending. The record is a format example, not an offered or purchased lot.
- Keep the historical order total separate from the current balance
- State unknown rather than filling a release or footage gap
