Reconcile the physical balance first
Use the inventory export, purchase record, or materials list as a starting point, then match each line to the reel, box, or continuous piece that is physically present. Record a reel reference, current count, discrepancy, and evidence basis. A missing, reserved, or already-consumed item should remain visible as such rather than being counted in the offered balance.
Lewiston reports more than $840 million in public and private investment since January 2020, including about $330 million in utility infrastructure and redevelopment of historic industrial properties. That local fact makes project-overrun scenarios plausible context, but it does not identify any seller, order, or cable quantity. The current physical record—not the citywide figure—is the basis for a specific inventory line.
- Match every present item to an inventory line or create a new line for an unlisted item.
- Record current count and the basis: measured, documented, or estimated.
- Flag missing, reserved, and already-consumed quantities explicitly.
Keep forms and specifications distinct
List full reels, partial reels, unopened boxes, and cutoffs on separate lines. Within each form, group only genuinely identical manufacturer part numbers and specifications. Per-reel continuous length matters: several partial reels may add to a total, but they are not one uninterrupted length.
Photograph readable tags and note visible condition for the same line item. If a tag is missing or a length cannot be confirmed, leave that fact as unknown instead of carrying a number forward from the original invoice.
- State form, manufacturer or part number, specification, per-reel length, and condition.
- Keep each partial reel’s continuous footage visible.
- Separate undocumented cutoffs from labeled reels and unopened boxes.
Show why the inventory can be offered
For each line, record the reason for release, current owner, approval status, and available date or unknown. Project return rights, internal reserves, or pending approval can change what is actually available. A purchase order may identify the material but does not by itself prove that the seller can release it.
Use a pending or reserved status when appropriate. This preserves a workable list for discussion while preventing an unapproved item from being represented as cleared inventory.
- Name the release reason and owner or responsible entity.
- Use approval pending, reserved, or unknown where those states apply.
- Keep an available date as unknown when it cannot be documented.
Connect the photos and records to the line ID
Assign a stable line ID and use it in the spreadsheet, photo filenames, reel reference, and supporting records. Each document should state what it supports: identity, original order, current count, or release status. This linkage lets a reviewer see the difference between an original record and present inventory evidence.
When a quantity is estimated, label the estimate and note the basis used. Do not upgrade an invoice quantity to a confirmed balance just because the original document is detailed.
- Use the same line ID in files and photographs.
- Identify the supporting record and what it proves.
- Mark quantity as measured, documented, or estimated on every line.
Use a fictional balance record as a model
Illustrative fictional inventory record—not a purchased lot: OV-LW-02; project-overrun feeder cable, part number on tag; two reels with 300 ft and 180 ft continuous, documented; uninstalled; approval pending. It shows a useful entry that does not confuse a documented quantity with approved release.
If the same project also has a full reel that is reserved or a box with an unreadable label, create separate lines with those statuses. A transparent balance is more actionable than a single project total that conceals unavailable stock.
- Reference: OV-LW-02.
- Quantity remains two documented continuous lengths, not one aggregate run.
- Approval pending stays visible until release is confirmed.
