Draw the physical inventory boundary first
Match each original order line to the reels, coils, boxes, or continuous pieces that can be found now. Create a row for each physical item with its inventory reference, manufacturer or part number, original quantity, current quantity, and a simple status. An absent reel is a discrepancy to note, not a quantity to carry forward.
Keep full reels, partial reels, and cut lengths distinguishable. They may share a product designation, yet their current balances and usable continuous lengths can differ. The balance should follow the physical item rather than the order-line total.
- Original quantity remains a reference field.
- Current quantity is tied to the physical reel.
- Full, partial, and absent lines remain separate.
Separate offered cable from reserved or pending cable
Mark each row as offered now, reserved, pending return, pending internal approval, or not located. Record the owner and release authority with that status. This makes it clear which footage belongs in a submission and which is background awaiting an internal decision.
Do not use a project invoice to imply that all historical material is available. A seller can still show pending lines, but should keep them outside the offered-current total until the release authority confirms their disposition.
- Offered group identified for each row.
- Reserved and pending status remain visible.
- Owner and release authority are separate fields.
Tie the balance to proof a reviewer can follow
Use the inventory reference in photo filenames, then attach readable tag or jacket images to that same row. Record per-reel length and whether it is measured, documented, or estimated. Add the storage location so a reviewer does not have to infer where the current balance was observed.
When records and physical inventory disagree, describe the difference without forcing a reconciliation. A tagged 300 ft reel and an untagged partial reel should remain two records even if they originated from one order line.
- Photo reference matches inventory reference.
- Per-reel length has a stated basis.
- Storage location is tied to the actual item.
Replace invoice footage with a current balance
The common mistake is presenting original invoice footage as the remaining quantity available for sale. Correct it with a current-balance column that totals only physical, offered items. Leave reserved, missing, returned, or pending lines visible with their reasons rather than hiding them inside the total.
This does not require a perfect inventory before an inquiry. It requires a truthful one: unknown quantities stay unknown, estimated quantities identify their basis, and release gaps are visible to the person reviewing the cable.
- Current balance does not inherit original footage automatically.
- Reasons for a discrepancy are written beside the row.
- Pending lines are excluded from offered-current totals.
Use Downtown context only as context
The City says the Central Vista Business Improvement District Grant Program funds activities in Downtown Vista, with grants and micro-grants from $1,000 to $10,000 and annual district assessments totaling approximately $50,000.
That municipal program does not prove that a Downtown project produced cable or that any material can be sold. If a seller has project records, the practical evidence is still the physical reel, its current quantity, and the authority that can release it.
- Do not treat project context as material identification.
- Use the actual release status for the seller decision.
Illustrative current-balance record
Illustrative inventory example — fictional, not a purchased lot: OV-V-01 is project-overrun feeder cable with a fictional part number. It has two documented reels, one at 300 ft and one at 180 ft; the release status is pending. The record therefore does not count either reel as offered-current until authorization is recorded.
A real balance sheet can include a short reason for each difference between original and current quantity. The point is to make the available inventory reviewable without silently substituting historical order data for present evidence.
- Reference: OV-V-01.
- Quantity: two reels, 300 ft and 180 ft documented.
- Release: pending; fictional example.
- Original and current balance shown on separate fields.
