Why line-by-line reconciliation matters
Large lots that combine reels from different sites often hide important differences: continuous length, spool dimensions, manufacturer marking, storage exposure, and who controls release. A single grand-total footage and one representative photo make it impossible for a reviewer to match product evidence to physical inventory without follow-up.
The goal of reconciliation is practical: let a reviewer confirm each offered line against its own evidence set so offers, inspections, and release planning can proceed without repeated requests. This conserves seller and reviewer time and reduces uncertainty about site access and authority.
The City of Allen land-development team oversees design and construction of land development, with construction inspectors working continuously with project contractors on infrastructure development. This is limited local context for retaining site and authority differences in contractor-held records; it does not identify bulk cable inventory or promise a purchase.
- Prevent mis-matches between photos and physical reels by assigning unique, stable line/reel IDs.
- Preserve per-reel length and quantity basis (measured, documented, estimated) rather than collapsing to a single total.
- Document storage site and release contact so access rules are visible up front.
Step 1 — Assign stable line and reel IDs
Create one persistent reference for each continuous piece or reel and use it across the spreadsheet, photo filenames, and any paperwork. Recommended fields to include with every ID are manufacturer, part number, and complete designation so reviewers can spot identical or genuinely different products.
Do not group reels under the same row unless the product designation, continuous length basis, and site are truly identical. When two reels share a part number but differ in documented footage or reside at different sites, give them separate line IDs.
- Evidence fields to include: line/reel ID, manufacturer, part number, complete designation.
- Photo filenames should start with the line/reel ID to make matching trivial.
Step 2 — Retain each quantity basis and length
For every reel or continuous piece, record the continuous length, whether that length is measured, documented, or estimated, and the piece count. Keep these values at the row level; do not replace them with a single grand total. If weight is estimated from footage, show the basis and calculation separately per reel.
Record condition remarks per reel (e.g., surface exposure, sun damage, core integrity) so reviewers can assess whether measured length is reliable or likely estimated.
- Evidence fields to include: per-reel length, piece count, quantity basis, condition.
- If footage is estimated, document how the estimate was made (stated by foreman, labeled on reel, measured).
Step 3 — Group and list by actual storage site
Separate reels by actual storage site (warehouse, contractor yard, project site). For each site list ZIP, site contact, ownership status, any access restrictions, and the authority who can approve release. Different sites will commonly have different release authorities and loading constraints.
Make site-level notes explicit in the spreadsheet; reviewers should not have to infer access rules from a single note or representative address.
- Evidence fields to include: storage site/ZIP, site contact, ownership, access restrictions, release authority.
- If release authority is not confirmed, mark it clearly and provide the best available contact or chain-of-custody note.
Step 4 — Add loading and handling context
List reel dimensions, gross/net/estimated weight, available loading equipment at the storage site, and any access constraints (narrow gates, unpaved yards, low clearances). These are seller-provided facts that let a reviewer understand handling needs without scheduling a move.
Do not schedule movement or assume transferability in the inquiry. Instead, provide factual constraints and requested timetable windows so subsequent inspection or transport conversations start from shared facts.
- Evidence fields to include: dimensions, gross/net/estimated weight, loading equipment, access constraints, requested timetable.
- If weights are estimated, state the method used and which reels are estimates versus measured.
Handling unknown or incomplete inventory
If you cannot confirm per-reel footage, still submit one row per reel with the best available quantity basis marked as “measured,” “documented,” or “estimated.” For unknown release authority or unclear ownership, mark the field as “unconfirmed” and include any contact names or invoices that indicate likely ownership.
A reviewer can work with incomplete entries if the spreadsheet shows which values are estimates and which are documented. Honest labeling reduces follow-up: a clear ‘estimated’ flag prevents the reviewer from assuming measured footage.
- When footage or weight is unknown, include photos showing reel markings and a visible tape measure or labeled tag where possible.
- If site contact isn’t available, provide contract references, delivery receipts, or the best-known project contact and mark the authority as unconfirmed.
Illustrative record and common mistake
Do not submit one grand-total footage and a single representative photo for reels held at different sites. The typical mistake is to combine multiple sites under one headline footage and one image, which prevents matching photos to physical reels and hides differing release rules.
The resolution is simple: use one row per reel or continuous piece, match all photos to those rows (filenames that use the line ID), and keep site and specification differences even for visually similar reels.
- Illustrative record example label: Illustrative record only — not a purchased Allen lot
- Example fields: line1 = BL-01; matching product recorded; 500 ft documented; Site A; line2 = BL-02; same product family; 90 ft estimated; Site B; photos = Each filename uses its line ID; release = Separate site authorities; not yet confirmed
