Why reconcile release balances
Project exports and legacy invoices commonly report original order footage, not the footage remaining on site. That mismatch creates two problems: first, published quantities may overstate what is physically available; second, release authority for certain reels can still be pending. Proper reconciliation protects sellers from misrepresenting availability and gives buyers a clear audit trail for any lot under review.
Aurora’s Mayor’s Office of Economic Development says it works with the business community on starting, operating, expanding or relocating businesses and identifies the city’s investment in fiber-optic infrastructure as a growth strength. That commercial context may explain a facility or technology inventory record, but it does not identify cable or show that any stock is available.
This page focuses on how to convert an export or purchase record into a per-reel, evidence-backed balance listing that shows which items are full, partial, reserved or release-pending.
- Avoid presenting original invoice footage as the current available balance.
- Document per-reel continuous footage instead of aggregating across unknown cutoffs.
- Clearly mark release-pending and reserved items rather than listing them as available.
Step 1 — Reconcile the physical balance (what to provide)
Match each inventory export or purchase line to the physical reel, box or cutoff on site. For each line provide the inventory reference, manufacturer, part number, and the current footage. State the quantity basis: whether the footage is measured, documented on a tag, or estimated.
If some reels are measured and others estimated, list each reel on its own line with its evidence basis rather than combining them into a single aggregate quantity.
- Required evidence fields: inventory reference; manufacturer; part number; current footage; quantity basis (measured/documented/estimated).
- If you cannot measure footage on site, note the estimation method and which reels are estimated.
Step 2 — Separate availability states
Keep full reels, partial reels, unopened boxes and cutoffs on separate spreadsheet lines. For each line record condition, continuous length per reel, release status and reason for release. This separation prevents accidental inclusion of reserved or inaccessible material in an available balance.
If a reel is reserved for a project or part of a pending return, label it as reserved and include the reason and expected hold length if known.
- Evidence fields to capture here: condition; continuous length per reel; release status; reason for release.
Step 3 — Tie evidence to the line item
Attach photos that clearly show the complete tag, jacket printing and overall reel condition. In your spreadsheet include photo filenames and the exact tag text recorded. If there is visible damage or storage exposure affecting condition, describe it and reference the corresponding photo.
Use matching references (for example, the inventory reference) on both the spreadsheet and each photo filename so reviewers can cross-check without ambiguity.
- Evidence fields to include: photo filenames; tag text; jacket designation; visible damage/storage exposure.
Step 4 — Confirm authority and access
Name the business or owner representative who can authorize sale or release and state the storage location and any site access restrictions. Do not assume transport terms; instead, list what loading resources exist (forklift, dock access) and any specific site rules the reviewer must know to evaluate feasibility.
If the release is pending, provide the named release authority and any required documentation to complete release; if access is restricted, describe the restriction and how to request entry.
- Evidence fields to collect: release authority; storage location; access restrictions; loading resources.
Handling unknown or incomplete inventory
If you cannot fully verify footage or tag data on every reel, be explicit about which fields are unknown and provide the best available evidence. For example, mark footage as estimated and describe the basis for that estimate, include a recent photograph of the reel end or label, and note whether the reel has been moved since the original record was produced.
Initial records can be incomplete, but label those lines as estimated or unverified and keep measured reels separate so no unverified quantity is presented as available.
- Honest labeling of unknowns avoids the common mistake of listing original invoice footage as current.
- Provide measured reels first; reserve estimated or pending items on separate lines.
Illustrative example (how to present a single line)
Use the supplied illustrative record format when submitting a sample. Label the example clearly as illustrative and not a purchased lot. For each record include the exact fields shown below so reviewers can see you are following the reconciliation steps.
A clear single-line submission eliminates ambiguity and demonstrates the per-reel evidence approach required to resolve release balances.
- Example label: ILLUSTRATIVE ONLY — not a purchased lot
- Example fields (recorded exactly): reference OV-AUR-01; product part number from reel tag; quantity 2 reels: 300 ft documented and 180 ft estimated; status uninstalled; second reel release pending
