Reconcile a project record to present reels
The City of Abilene says it is investing millions of dollars in streets through the Street Maintenance Fee, DCOA funding and bonds, with projects organized by year and work-zone mapping. That public project context does not show that any cable is available; a seller still needs a reel-level record and authority to release the stated material.
Project export files and purchase orders often record the total ordered footage. That original quantity is not the same as what is physically on site after installation, partial use, or returns. We ask sellers to match each project line to the reel, box, or cutoff actually present, because a reliable sale discussion depends on the current balance, not the original order.
Reconciling reduces disputes later: list missing or consumed quantities, mark reserved or return-status reels, and show any discrepancy notes tied to evidence.
- Record project/reference number and current reel IDs for each line.
- Flag any discrepancy between original quantity and current balance and explain the basis.
How to preserve reel-by-reel quantities
Provide a separate line for every full reel, partial reel, box or cutoff. For each entry record the continuous footage and state whether that footage is measured, documented from labels/tags, or estimated. Keeping reel-level granularity lets a buyer decide whether to accept partial reels or only full units.
When footage is estimated, say how the estimate was made (visual tape measure, reel marking, or derived from weight) so the buyer can assess uncertainty.
- List full/partial/box/cutoff and length per reel or piece.
- Include quantity basis and reel count rather than rolling partials into a single sum.
Record the specification evidence clearly
Match manufacturer/part number, conductor metal and size, designation and marked voltage to photos or existing records. Keep unknowns explicit: if a tag is missing, state which fields are unknown rather than guessing. Attach photo references that show tags, reel IDs, and any printed markings.
If part numbers are stamped or printed on a tag, provide a close-up photo and transcribe the exact text; note whether conductor composition is documented or visually observed.
- Provide manufacturer/part number, designation, metal and size, marked voltage and photo reference.
- If any field is unknown, mark it as unknown and explain why (missing tag, worn print, inaccessible reel).
Confirm release and reservation status
State the owner, the authorized release contact, reservation or return status, and the approval stage required before a sale. We do not assume an item is releasable; list pending approvals and any storage location or access constraints.
If contractor approval is pending, name the responsible contact and provide any available correspondence or project documentation that shows the current approval workflow.
- Include owner, authorized release contact, reservation/return status, approval status and storage location.
- Label any quantity that is reserved or pending approval rather than marking it available.
Build a current-balance project record
First, match each project line to the reel or package present and record a current balance with a discrepancy note. Next, preserve each full reel, partial reel, box, or cutoff as a separate line with its quantity basis. Then attach the marking and photo evidence to that same line. Finally, record reservation status and the authority needed to release it; a pending line stays pending.
This is a seller workflow, not a promise to buy a project total. Its value is that an original purchase order, a physical count, a marked cable reel, and a release record remain visibly different facts.
- Keep original quantity and current balance in separate columns.
- Use one photo reference and one reel ID for each physical item.
- Mark any return obligation, reservation, or authorization gap instead of assuming availability.
What to do when inventory is unknown or incomplete
If you cannot access certain reels or tags, do not roll them into a single available quantity. Mark them as inaccessible or unknown and provide the last known record (for example, the export line number and original quantity) alongside the current reconciled reels. That transparency prevents the common mistake of presenting original order footage as current availability.
For partial reels without a measured footage, supply an estimate and the method used. Buyers can decide whether to accept estimated balances or request onsite verification.
- Label unknowns explicitly and attach the export line and any supporting documents.
- Retain each reel's length as its own entry even when quantities are estimated.
Worked example of a reconciled overrun line
Illustrative inventory example — not a purchased lot: line OV-A12 is an illustrative municipal-contractor overrun with a part number on its tag and documented conductor metal. Two reels are listed separately: 300 ft documented and 180 ft estimated. Contractor authorization is pending, so the record does not call either reel available for sale.
Use this format to keep documented footage, estimates, and release status in distinct fields. A title or project name is useful context, but it is not the cable specification or proof that the material may be released.
- Use the same evidence structure for every line so buyers can quickly compare documented reels and pending items.
