Build a present-day balance from the physical inventory
An original purchase order or ERP export explains what was ordered, not necessarily what remains. Assign an inventory reference to each physical reel, unopened box, or cut length, then compare the current item count and footage against the source record. Put discrepancies in their own field instead of adjusting them away in a narrative.
The core decision here is whether a seller can identify the current material that may be released. It is different from the industrial-closeout task, where construction and service history lead. A current-balance file can cover a small overrun without pretending that every original project line is still on hand.
- Keep an inventory reference, source record, part number, current count, current footage, and discrepancy note on each line.
- Mark a missing physical item as unresolved rather than counting its original quantity.
- Match a photo filename to the same inventory reference.
Retain the form and continuity of each remainder
Sort full reels, partial reels, unopened boxes, and cut lengths into separate rows. Then record the continuous length of each item and whether that length is measured, documented, or estimated. A file may summarize matching material later, but the underlying row should retain the physical form and continuity that a buyer needs to understand.
The common error is using an invoice total as if it were the remaining quantity, then quietly including short pieces or consumed reels. Correct it by making the current basis visible. When footage is estimated, identify the estimate rather than giving it the appearance of a measured balance.
- Use a form-factor field for full reel, partial reel, box, or cut length.
- Keep continuous footage per item separate from the aggregate project total.
- State the basis for every current quantity.
Create a release ledger before calling stock available
Next to the inventory facts, keep a release status, owner, authorizing person, and reserved or return status. A reel can be physically present while retained for another job, subject to a return, or waiting for an internal approval. Label those circumstances as they stand; they should not be counted with material that the seller can actually discuss for release.
If no release date is known, use pending rather than inventing a schedule. This simple ledger prevents a buyer from reviewing a balance that later proves unavailable and gives the seller an orderly list of the exact approvals still needed.
- Use distinct states such as released, reserved, return pending, and authorization pending.
- Record owner and authorizing person separately.
- Keep pending lines out of a release-ready subtotal.
Assemble evidence that matches the balance line
For each listed item, preserve a readable reel tag or jacket legend, a matching photo filename, the related purchase or manufacturer record when available, and a concise storage-condition note. A source record becomes more useful when its part number and reference match the physical item. If it does not match, retain the mismatch as a discrepancy rather than using it as proof.
The City of Erie identifies manufacturing and industrial projects in listed development programs and infrastructure projects including utility upgrades, water/sewer, site development and broadband connectivity. That is local context for project-overrun documentation, not evidence that any identified Erie project has surplus cable or that a particular balance will be purchased.
- Name photo files with the inventory reference.
- Record a matching purchase or data-sheet reference only when it ties to that line.
- Describe storage as observed; do not turn a photograph into a condition guarantee.
Show incomplete lines and a fictional balance example
Unknowns belong in the same balance, but they need labels. For a missing tag, unconfirmed footage, or pending release, state the missing field and keep the item outside the released total until the record is resolved. This is more actionable than deleting the line or silently carrying the original purchase quantity forward.
Illustrative fictional inventory example—not a purchased lot: OV-ERIE-02 — project-overrun feeder cable; part number on tag; two reels: 300 ft documented and 180 ft estimated; uninstalled; project return approval pending. The example remains pending because physical quantity and release authority are separate questions.
- Flag unconfirmed footage with its stated estimate basis.
- Keep a pending-release line visible for the person who must resolve it.
- Do not count the fictional example as an Erie transaction.
