Set the boundary of what is actually offered
Begin by separating offered line items from reserved stock, pending returns and material still assigned to the project. Add the project or source label for orientation, but do not use it as proof that every item is releasable. Name the owner or role that can authorize each offered line and keep an approval that is still pending outside the offered total.
The likely mistake is carrying the original order quantity into a sale list after some material was consumed, transferred or reserved. A defined offered boundary gives the reviewer an honest starting point and keeps unresolved stock visible without representing it as available.
- Project or source label and the specific offered line items
- Separate rows for reserved material and pending returns
- Release authority or an explicit pending-approval status for each line
Reconcile the order record to physical stock
Match each inventory export or order line to a physical reel ID and current storage site. Record the original quantity, current balance and a short discrepancy note when the figures differ. The point is not to recreate every project record; it is to show what can be tied to a reel or package now.
Use the same reference on the spreadsheet, reel label photograph and jacket-print photograph. If a line cannot be found or is supported only by a historic record, mark it pending or unknown instead of converting the original footage into a current balance.
- Inventory line, reel ID and current storage site
- Original quantity, current balance and a discrepancy note
- Photo filenames and label or printing status linked to the same reference
Keep forms and lengths visible
List full reels, partial reels, unopened boxes and cut lengths as different forms of stock. For each item, retain the part number, reel count, continuous length and condition. The current balance should show actual continuous pieces rather than a total that combines short cuts with full reels.
Identify the quantity basis for each line as measured, documented or estimated. A partial reel may still be worth presenting, but the remaining continuous footage and its basis need to travel with the same line rather than with the original order record.
- Form of stock, part number and reel count
- Length per reel or continuous piece
- Condition and measured, documented or estimated quantity basis
Carry unknowns and release status forward
For a missing reel, unresolved return or incomplete approval, retain a separate pending line with its last known location and discrepancy note. Do not convert it to an offered line just because it appears on the original purchase order. This prevents the final inventory from claiming more releasable material than the evidence supports.
Add the seller’s actual deadline, available site access and known loading resources as facts for discussion. Leave any purchase, inspection, payment and transport terms to the identified lot rather than building them into the balance record.
- Pending status, last known location and next record to check
- Release deadline, site access and known loading resources
- Unresolved terms labeled separately from the inventory facts
Kennewick context and a fictional balance row
The City of Kennewick economic-development page links current development, property locating, building permits and a Three Rivers Convention Center expansion described as bringing jobs, tourism and year-round experiences. This is general commercial-project context only; it does not show that a particular project has cable available, identify an owner or establish buying demand.
A fictional row can read OV-KNW-01, project-overrun feeder cable with the part number on its tag, current balance of two reels at 300 ft and 180 ft documented, uninstalled condition and release approval pending. The example illustrates how current balance and release status can coexist without asserting that the reels are ready to transfer.
- Fictional example: OV-KNW-01; project-overrun feeder cable with tag part number
- Current balance: two reels, 300 ft and 180 ft documented
- Condition: uninstalled; release approval: pending
