Why reconcile current reels before offering
Project records and original purchase invoices often show the starting quantity, not the footage that remains after site cuts, usage, transfers, and reservations. Presenting the original order as the remaining inventory causes delays and complicates release approval. This page explains a workflow to convert historical purchase lines into a reliable current-balance inventory for potential sale review in Colorado Springs.
Reconciliation reduces follow-up questions and preserves trust: each reel line should state whether footage is documented from a spool meter, measured at the time of listing, or estimated from weight or jacket markings. That per-reel clarity speeds authorization checks and reduces disputes over what is actually available.
El Paso County Public Works designs, builds and maintains roads, bridges, sidewalks and drainage systems and oversees roadway maintenance and major construction or reconstruction projects. This is local project-overrun documentation context only; it does not imply that a county project has cable available or that any stock can be released.
- Separate historical quantity (kept as context) from current-balance.
- Mark lines explicitly as documented, measured, estimated, unknown, reserved, or moved.
- Provide supporting photos, filenames and document cross-references for each reel.
Step 1 — Reconcile the physical stock
Match each inventory export or purchase record line to the reel at its storage site. For every record line note the inventory reference and manufacturer part number, and confirm the storage site and current availability status. If a reel cannot be found or the footage is unclear, mark it as unknown rather than assuming the original invoice remaining quantity.
For lines that are consumed, reserved or moved, annotate the reason and any known destination. Use the exact evidence fields: inventory reference, manufacturer and part number, storage site, and current availability status so reviewers can trace each claim back to a source.
- If a reel was moved between sites, record the new storage site and update availability.
- If a line is reserved by an internal project, mark status and reference the reservation.
- For unknown items list who last handled the reel and what follow-up is required.
Step 2 — Preserve per-reel quantities and condition
List full reels, partial reels, coils and cut lengths on separate lines. For each reel include a reel ID, continuous footage, the quantity basis (measured, documented, estimated), and reel condition. Do not roll partial and full reels together into a single aggregate line unless each reel’s continuous footage and basis are preserved.
Where footage is estimated, explain the estimation method (weight-based, jacket-print extrapolation, or visual estimate) and flag it as estimated in the quantity basis field so prospective reviewers know which lines require verification before release.
- Retain continuous footage per reel to preserve usability context.
- Record reel condition (good, damaged jacket, missing tag) and attach photo filenames showing the tag and jacket print.
- Use consistent reel IDs that match your spreadsheet and photo tags.
Step 3 — Document the release gate
Identify the owner or approver for each reel and state the release authority and approval status. Common statuses include: approval pending, approved subject to inspection, internal reservation, or owner refusal. Record the requested release date or mark it unknown. This prevents assuming that a listed reel is freely available simply because it appears on an inventory export.
If an internal project return or other commitment limits release, include that information verbatim in the release authority field so the buyer can address the correct approver without delays.
- Include owner, release authority, approval status and requested release date or unknown for every lot line.
- If release depends on sign-off from a project manager, give the manager’s title and the document filename that records that request.
- Flag lines where authority is ambiguous for follow-up.
Step 4 — Match evidence files and provide traceability
Use the same line references across your spreadsheet, photo filenames, jacket-print transcriptions and supporting purchase or project records. For each reel provide the photo filenames, document filenames and a transcription of any marking so reviewers can confirm the record-to-reel match without visiting the site initially.
Where you cannot provide a complete file set, be explicit about what is missing: a missing tag photo, absent invoice, or an unmatched serial. Mark those reels as unverified so they are not confused with fully-documented lines.
- Attach photo filenames showing tag, jacket print and overall reel condition.
- List document filenames for invoices, delivery tickets and reservation requests that reference the reel.
- Provide a clear record-to-reel match column so external reviewers can reconcile your spreadsheet with the images and documents.
Handling unknown or incomplete inventory honestly
If inventory lines have unknown or incomplete information, do not substitute an original-order quantity for the remaining footage. Instead mark current-balance as unknown or estimate and include the method used. State what follow-up action is required to verify the reel (on-site measurement, tag transcription, or staff confirmation) and who is responsible for that follow-up.
This transparent approach prevents the common mistake of presenting original purchase quantities as current inventory. Buyers and approvers can then prioritize verification efforts and decide whether to request inspection, accept estimated lines subject to adjustment, or exclude unverified reels from an offer.
- Mark current-balance explicitly as documented, measured, estimated, or unknown.
- List the exact follow-up needed for unknowns and who will perform it.
- Keep original purchase quantity only as a historical field labeled clearly as historical.
