Reconcile the export with physical stock
Start with the old purchase order, export, or project list, but match every line to a reel, box, or coil that is physically present. Record the line reference, part number, tag or photo evidence, current location, and any discrepancy. If a listed item cannot be found, keep it as a no-physical-match or pending line rather than carrying its original footage forward.
A current balance is a record of what can be shown today. It should not silently inherit quantity from a historical invoice or from another package with a similar description.
- Inventory-line or reel reference
- Part number and physical-match evidence
- Current location and discrepancy note
Keep package and length distinctions visible
Full reels, partial reels, unopened boxes, and cut lengths belong on different inventory lines. For each, show count, remaining continuous length, and whether the figure is measured, documented, or estimated. A total that combines a full reel with several cuts hides a material difference a buyer needs to see.
When footage is estimated, include the source of the estimate, such as a tag, seller record, or measurement note. Do not express an estimated partial reel as a precise current balance.
- Package or reel type
- Continuous length and count
- Measured, documented, or estimated basis
Explain availability and reserve status
State why the stock is excess, such as project overrun, discontinued inventory, distributor overage, or facility closeout. Then give reserved quantity, return status, and condition separately. Material awaiting an internal decision or return should remain a pending balance rather than being included with cleared inventory.
Name the owner and release-authority role for each group. An inventory can be well documented while authorization is still pending; the record should make that difference unmistakable.
- Reason the stock is excess
- Reserved quantity and return status
- Owner, release-authority role, and approval status
Use local context without inventing inventory
Brockton's economic-development department identifies food production, life sciences, advanced manufacturing and healthcare as established commercial clusters. This can provide truthful background when a seller describes a facility or contractor source, but it does not identify a particular stockroom, project overrun, customer, or cable lot.
The actionable evidence is still the seller's own current record: product markings, physical balance, storage location, and authorized release status for each line.
- Use source context only as background
- Keep actual product evidence on the inventory row
- Do not treat a city cluster as proof of availability
Close the approval gap deliberately
For material that is physically present but not released, list the contact role, the missing approval, the storage or access limit, and the seller's own target for confirming the fact. That lets a review distinguish an available reel from a pending one without suggesting that movement or commercial terms have been settled.
Before sending photos, check that the tag, product reference, and inventory row agree. A clear discrepancy note is more useful than a polished worksheet with an unsupported balance.
- Pending-release action owner
- Missing record or approval to obtain
- Storage and access note
Use a fictional current-balance row
Fictional example only—not a purchased lot: OV-BRK-04; project-overrun feeder cable; part number on tag; two reels; 300 ft documented and 180 ft estimated; uninstalled; sale approval pending; one reel reserved. The two quantities and the pending release remain visible rather than becoming one available total.
If a reel cannot be matched to the physical inventory, create a pending row with the old reference and the specific proof still required. Do not turn a planned reconciliation into a confirmed current balance.
- Reference: OV-BRK-04
- Quantity: 300 ft documented and 180 ft estimated
- Release: approval pending; one reel reserved
