Match each old order line to present inventory
Start with the purchase order, warehouse export, or project list, then walk the actual inventory. For every reel, package, or cutoff that remains, create a row with the original line reference, physical tag or package ID, manufacturer part number, specification, and storage site. Split a source line when it covers different products or several physical pieces.
Johns Creek's Economic Development Department identifies healthcare, life sciences and innovation as target industries. This can provide limited context for a facility inventory example, but it does not identify material for sale, prove stock at any organization, or change the need for a physical, item-level reconciliation.
- Keep the purchase-order reference and the physical reel reference in separate fields.
- Match the listed specification to the tag or packaging before treating it as current inventory.
- Create an unknown-product row when a reel cannot be tied to the old order.
Calculate a current balance without importing old assumptions
Record each full reel, partial reel, boxed length, and cutoff as its own piece. List remaining continuous footage and mark the basis as measured, documented, or estimated. The original shipped footage may be relevant history, but it should not be carried forward as the current balance after consumption, returns, or transfers.
If several identical reels remain, retain the footage for each reel before showing an aggregate. This protects against presenting short pieces as one continuous run and allows a reviewer to see which items still have useful documentation.
- Use separate rows for full, partial, and cut lengths.
- Label every quantity as measured, documented, or estimated.
- Keep a grand total clearly separate from the reel-level breakdown.
Show release status rather than assuming availability
Add a release-status field to every line: released for sale, reserved, pending return, retained, or unknown. Record any reservation or return note, the owner, and the person or role that can authorize release. This makes it possible to distinguish an item visible on a report from one the seller can actually present for review.
If approval remains pending, leave the item in the inventory with that status instead of merging it into the available balance. A buyer can understand the evidence gap without a claim about when an internal decision will occur.
- Name the release status for each individual row.
- Keep reservation and return notes with the affected reel.
- Record release authority as unknown when it has not been confirmed.
Preserve condition and location distinctions during reconciliation
Record whether each item is uninstalled stock, previously used cable, or an unknown-history item. Note packaging, storage exposure, visible damage, material location, and seller-supplied loading constraints. Condition and location may influence what information a reviewer needs, but they do not establish acceptance or a transport arrangement.
When a tag is missing, add an unidentified row with photographs and a clear explanation of what is absent. Do not fill the gap by assigning a part number from a nearby package or by treating the order description as a physical identification.
- Link condition photos and inventory records with the same reference.
- Keep previously used cable separate from uninstalled stock.
- State location and access constraints as supplied by the seller.
Worked release-ready balance record
Illustrative inventory example—not a purchased lot: line JC-OV-02 is a project-overrun feeder cable with part number on tag; it has two reels, 300 feet and 180 feet continuous, documented; condition uninstalled; release pending. This fictional line shows why a documented quantity and a release status must coexist rather than be blended into an assumed available total.
A complete seller record can identify what evidence is still needed, such as a release approver or a better photograph, without claiming that the material is already available. Keep the balance current if a reel is reserved, returned, or relocated.
- Example line reference: JC-OV-02.
- Example balance: 300 feet and 180 feet continuous, documented.
- Example status: release pending.
