Why reconcile before you submit
Project invoices, purchase-order exports, and warehouse closeout lists commonly record original ordered footage rather than the footage still on physical reels. That mismatch leads to offers based on quantities that don't exist, disputes over reserved lines, and delays while managers track down release approvals. Reconciling creates a reliable present-balance picture tied to identifiable reel and tag data so a reviewer can assess genuine availability without assuming historical numbers are still valid.
This section focuses on practical reconciliation: compare records to what is physically present, preserve continuous lengths at reel-level, and clearly mark any release limitations. Don't treat a pending return or reservation as available—document it instead.
- Start with the ERP export or warehouse export as a record, not a source of truth.
- Physically identify reel IDs, tag text, and photo evidence for every line.
- Separate full, partial, and cut reels into distinct entries with measured or estimated footage.
Step 1 — Reconcile the source records
Follow the brief step: compare the ERP export, purchase order, or project balance with a walkthrough of the Aurora storage site. For each inventory line, mark discrepancies between recorded and observed quantity rather than carrying forward the original quantity into the offered lot.
Record the required evidence fields for each line so that a reviewer can match source records to physical stock without ambiguity.
- Record inventory line ID and the recorded versus observed quantity.
- Copy manufacturer and part number from the product tag, not from memory.
- Log storage location and current reel ID for each physical item.
Step 2 — Preserve reel-level quantity and status
List full reels, partial reels, boxes, coils, and cut lengths as separate entries. Retain continuous length—measured or documented—or clearly mark an entry as estimated when measurement is not possible. This preserves the unit-of-sale integrity: continuous footage on a single reel cannot be split in description without explicit measurement and re-labelling.
When a reel is partially used, show the continuous footage, the quantity basis (feet/meters), and whether the value is measured, documented, or estimated.
- Use the evidenceFields: reel reference, continuous footage or meterage, quantity basis, full/partial/cut status.
- If footage is estimated, record how the estimate was made (visual, scaled photo, tag annotation).
Step 3 — Document release status and approvals
For every inventory line state whether it is reserved, subject to a return, or awaiting an owner or manager sale-release approval. The brief emphasizes: do not treat a pending balance as available. Include the release authority and approval status in your submission so the reviewer knows which lines are genuinely offered and which are pending.
Separate pending or reserved lines from offered lines in your worksheet; include a note describing the approval required to change status.
- Capture release authority, approval status, reservation or return note, and offered quantity.
- If a manager's signature or documented email is required to release a line, include that reference (photo filename or document reference).
Step 4 — Match evidence to inventory lines
Before submitting the lot for review, match stable inventory line IDs to reel photographs, tag images, and product records. Use consistent filenames and tag references so a reviewer can trace each line from the ERP export to the physical reel and to the release authority.
This keeps each line tied to its supporting record for review.
- Attach photo filenames, tag/jacket-print references, and matching document references to each inventory line.
- If any evidence is estimated or incomplete, mark it clearly and describe what additional verification is needed.
Handling unknown or incomplete inventory
If a reel or line cannot be visually located, do not invent a quantity. Add an 'unverified' status with the supporting note (last-known location, who performed the search, date/time). State whether footage is estimated and the method used for estimation. This honest flagging enables reviewers to decide whether to request an on-site verification or accept the estimate for preliminary review.
When physical reconciliation is impractical before submitting an export, submit the file with clear flags: which lines are verified, which are estimated, and which are pending release. That transparency preserves the seller's credibility and prevents the mistake described in this brief.
- Add 'unverified' or 'estimated' tags rather than representing those lines as offered.
- Describe the next action needed to verify: measurement, manager sign-off, or owner release documentation.
Aurora planning context, limited to record keeping
The task force says infrastructure priorities will consider urgency, impact, feasibility and alignment with city strategic goals, with phased short-, mid- and long-term planning.
This planning fact does not show that any Aurora project has surplus cable or that the buyer has a relationship with a project. It simply makes a careful release record relevant: the seller still needs current reel IDs, observed quantities, reservation notes, and release authority.
