Make the current balance the starting point
An original purchase order can identify a product, but it does not prove today’s footage or condition. Compare the inventory export with the actual reel or package. On each line, keep the original quantity as a reference, record the current balance, and state whether that balance is measured, documented, or estimated.
Do not repair a discrepancy by carrying the invoice quantity forward. A line with an unknown remaining length is still useful when it is labeled unknown and linked to a reel ID and photos. The goal is an honest current inventory, not a polished historical report.
- Inventory line and current reel ID.
- Original quantity and current balance in separate fields.
- Measured, documented, or estimated basis for the balance.
Explain availability and retain release controls
State why each item is available: project overrun, warehouse excess, maintenance stock, or closeout. Then record the owner, any reserved or pending-return status, and the person authorized to release that specific line. Physical access to a storeroom is not the same as authority to transfer material.
If sign-off is pending, keep the status visible rather than presenting the reel as available now. A release timetable can be noted if the seller knows it, but an unknown date should remain unknown. This is the decision that distinguishes a true surplus record from a general inventory export.
- Surplus reason with part number and reel-label photo.
- Owner and named release authority.
- Reserved, pending-return, or cleared status for each line.
Keep condition and continuous length intact
Full reels, partial reels, boxed lengths, and removed cable should not share one line simply because their product number is similar. Record the continuous length, reel count, package or storage condition, and any visible damage next to the current balance. A collection of short pieces is not equivalent to one longer remaining run.
A common mistake is to call all physical stock “unused” because it appears on an old closeout list. Use the actual condition category and link the line to current photos. This makes incomplete inventory useful without claiming more certainty than the record supports.
- Separate full reels, partial reels, and removed material.
- Keep continuous length distinct from aggregate footage.
- Photograph the tag, reel condition, and any packaging limitation.
Worked reconciliation format for an incomplete closeout
The fictional record below shows how to describe both a documented balance and an unresolved release step. It is not an offer, a purchased lot, or a statement that these quantities exist. Use the same compact fields in a spreadsheet so a reviewer can trace one reel back to its source documents and photographs.
Where a balance is estimated, replace “documented” with the correct basis and note what would resolve it. Keeping the release status beside the quantity prevents a pending reel from being mistaken for cleared material.
- Illustrative inventory example—not a purchased lot.
- Closeout reference: OV-POR-07.
- Material record: project-overrun feeder cable; part number on tag.
- Current balance: two reels, 300 ft documented and 180 ft documented.
- Release status: uninstalled; release approval pending.
Use local context only as context
Portsmouth Economic Development identifies transportation and logistics, maritime, offshore wind, advanced manufacturing and unmanned systems among the city’s key industries.
This supports examples such as seller-described project or warehouse inventory, not a claim that material from any Portsmouth industry is available. The relevant action remains a reel-by-reel reconciliation and release check before the list is submitted.
- Keep promised project returns and internal reservations on the worksheet.
- Provide a release contact only for material the owner has identified for review.
