Start with the current balance, not the original order
The same capital program lists Michigan Avenue replacement work involving sanitary sewer, waterline, storm drainage and roadway infrastructure.
That documented infrastructure context can help a seller label project records, but it does not show what cable remains or who can release it. This page addresses a narrower decision: which physical reels are currently represented by a project or distributor record and which entries remain reserved, missing, returned, or pending approval.
- Match each order or export line to a reel, coil, or box at the storage site.
- Give the physical item an inventory reference and retain the source-record reference.
- Mark an unmatched line as unmatched rather than adding it to the available balance.
Reconcile footage reel by reel
For every matched item, record the reel count, continuous footage per reel and the basis for the number: measured, documented or estimated. A purchase order may help identify an original quantity, but it does not prove the balance after field use, return, transfer or partial consumption. Keep full reels, partial reels and cut lengths separate so the record describes what remains in a usable form.
If a quantity is estimated, name the basis without pretending it is a measurement. If a reel cannot be located, list the record as unresolved and exclude it from the current documented total. This correction directly addresses the common error of presenting original invoice footage as the offered balance.
- Current reel count and continuous footage.
- Measured, documented, or estimated quantity basis.
- Physical match status: matched, unmatched, or awaiting confirmation.
Separate availability from reservation and release status
Use a distinct field for project overrun, discontinued company stock, reserved-for-return material, and lines awaiting internal or owner approval. A reel can be physically present yet not be available for sale. State the reason for release, any reservation or return claim, the named owner, and the approval still needed for that individual line.
Do not convert a historical invoice into release authority. If an email, internal record or other authorization exists, link its filename or reference to the item. If it does not exist, leave the release field pending. That allows a reviewer to understand the inventory without being told that a pending line is already sellable.
- Reason for release.
- Reservation or return status.
- Owner and approval-needed field.
- Reference to any current release document.
Build a photo and document chain around the physical item
Use the inventory reference in the file names for the reel tag, readable jacket printing and overall condition view. Add a storage or packaging note when it affects what the current record can establish. Photos support identification and visible condition; they do not make an unmatched order line become a confirmed reel.
When a record conflicts with a tag or the physical count, retain the conflict in the same item line. The next useful action is to resolve the one discrepancy, not to average it into a total. This physical-record reconciliation is what distinguishes this project-overrun page from the multi-site lot page.
- Tag-photo filename and jacket-print filename.
- Overall condition and packaging or storage note.
- One inventory reference used across photos and records.
Use a fictional reconciliation record to show pending material
The following fictional record is a format example only, not a purchased lot. It shows two reels with different quantity bases and a return reservation that prevents one line from being counted as immediately available. The distinction remains visible even when both lines came from the same project record.
Apply the same approach to real inventory: document the physical balance first, preserve pending approval and return fields, and send a narrow question for each unresolved line. A transparent balance is more useful than an inflated total based on the original order.
- Inventory reference: OV-FM-03.
- Material: project-overrun feeder cable; part number on tag.
- Current balance: 300 ft documented and 180 ft estimated on separate reels.
- Status: one reel reserved pending project return; release approval pending.
