Start with the physical reel, not the purchase order
An invoice or inventory export can identify an original shipment, but it may not describe what is still on a reel. Begin by walking the stock and matching every exported line to a physical reel, partial reel, or cut length. Give the physical item a stable reel ID even when the original tag is incomplete.
Keep the old order footage in a historical column. In a separate current-balance column, state the footage actually measured, a documented balance, or an estimate. This distinction is the point of this page: a buyer can see both the product history and the quantity that is presently available without treating one as proof of the other.
- Record: inventory-row reference, reel ID, manufacturer or part number, and storage location.
- Use one row for each physical reel or continuous cut; do not turn several short pieces into one continuous length.
- Label the current-balance basis as measured, documented, estimated, or unknown.
Reconcile a current balance before grouping reels
Compare the reel, its label, and the row in the export before grouping anything. Full reels, partly used reels, and cut lengths may share a part number yet have different current quantities and conditions. If identical items are grouped for convenience, retain a count and a current balance for each reel inside that group.
When a tag is missing, photograph the reel, visible jacket printing, and any internal asset label. Give it a temporary reel ID and identify its balance as unknown or estimated until the item can be reconciled. A temporary ID is more useful than silently applying the quantity from a neighboring reel.
- Keep a reel-condition field separate from the footage field.
- Note whether a partial balance comes from a meter, a stock record, or an estimate of remaining layers.
- Flag an export row as unmatched when no physical reel can be located.
Treat release status as a separate decision
A current balance does not establish that a reel can be offered. Add reservation status, an available-for-sale flag, the releasing role or department, and a short note for every line. A reel reserved for a return, an internal project, or another disposition should remain visible but separate from lines with a completed release decision.
If the approver is not known, write release authority unknown rather than filling in a name from the warehouse list. Keep the inventory evidence and the release evidence tied to the same reel ID. This lets the seller resolve a release gap without changing the reported physical quantity.
- Use distinct values for available now, release pending, and release authority unknown.
- Record the reservation or hold that affects a particular reel, not only a lot-wide note.
- Keep the release note with the same line that carries the current footage.
Use local context without treating it as inventory evidence
Wyoming’s Community & Economic Development Department covers comprehensive planning, development review and incentives while balancing residential, commercial, industrial, recreational and institutional land.
That planning context does not identify a cable lot or suggest that any local organization is selling cable. It only makes a project or facility balance worksheet a proportionate local example. The actual buying record still needs the offered reel’s own tag, current quantity, storage location, and release status.
- Capture one readable tag image and one jacket-marking image per reel when available.
- Use the reel ID in the spreadsheet row and in each photo filename.
- Keep project names as background only; product markings and physical balance identify the material.
Correct the original-footage mistake and show unknowns
The common mistake is using original invoice footage as though it were the current balance on every reel. Correct it by checking each reel against physical stock, retaining the original quantity only as history, and labeling any unresolved balance unknown or estimated. Do not roll an unmatched export line into a total that appears confirmed.
A clearly fictional example is: reel OV-WY-EXAMPLE-01; product Example feeder cable, part number on tag; current quantity 300 ft documented; second reel 180 ft estimated; release status pending. It is not a purchased lot. The example shows why a documented balance and an estimate must remain separate, even when both came from one historical order.
- For an unreadable tag, state tag unreadable and attach the best available photo.
- For a missing balance, state current footage unknown rather than copying the invoice figure.
- For a pending release, leave the reel on its own line until the authorizing role is confirmed.
