Why reconcile project overrun quantities
Project purchase totals often do not match what a warehouse actually holds at closeout. Original invoices reflect ordered footage and can mislead buyers if they are carried forward as current balances. The reconciliation workflow shows which reels, cutoffs and boxes correspond to the purchase records, which are reserved or pending approval, and which the owner is prepared to offer now.
Use this reconciliation to reduce confusion between invoice quantities and releasable inventory, avoid listing reserved stock as available, and create a defensible current balance with supporting evidence that buyers can inspect.
The City project directory lists Raleigh stormwater drainage projects and the Atlantic Avenue Improvement Project among current project entries. This is a city-directory example only, not evidence that any offered cable came from those projects; use a project name as a source-context field beside the actual product specification and current physical balance.
- Avoid presenting original invoice footage as current available footage.
- Preserve per-reel continuity and avoid aggregating continuous reels with cutoffs.
- Make reserved or approval-pending quantities explicit rather than listed as offered.
Step 1 — Reconcile export to physical stock
Start by matching the inventory export or purchase order line to each physical reel, box or cutoff. For each export line, attach the required evidence fields: inventory reference, manufacturer/part number, current physical presence, source record, and discrepancy. If the export shows 1,000 ft but only two reels exist (e.g., 300 ft and 180 ft continuous), record that discrepancy instead of carrying the 1,000 ft forward.
If any item cannot be located, note it explicitly under 'current physical presence' as missing and list the supporting source record so buyers know the basis for the unresolved quantity.
- List matching reel identifiers or tag numbers next to the inventory reference.
- Record the physical presence as 'found', 'partial', or 'not found' with photo filenames and source record links.
Step 2 — Preserve per-reel quantities
Keep full reels, partial reels and cutoffs distinct. Grouping by identical manufacturer and part number is acceptable for summary purposes, but retain each continuous length as a separate inventory line. Required evidence fields here include reel count, per-reel footage, continuous versus cutoff, quantity basis, and condition.
This approach prevents accidental aggregation of separate continuous lengths into a single footage total and clarifies what a buyer will physically receive in any offered lot.
- Report each reel’s continuous footage and whether it is on original reel or a transfer spool.
- Indicate condition (uninstalled, tagged, damaged, etc.) and attach photos showing tag and continuity.
Step 3 — Show what is actually releasable
Separate releasable material from reserved or return-obligated stock. For every inventory line provide release status, reserved/return status, approval needed, lot grouping and owner. If a reel is reserved pending an owner approval, mark it as reserved and identify the approval authority rather than listing it as offered.
When offering material, define the groupings you will release together and the specific reels included. If an offer covers one reel only while another remains reserved, state that explicitly and include the evidence basis for the decision.
- Flag items as 'offered', 'reserved', or 'pending approval' with the approving party noted.
- Provide an explicit offered group listing the exact reel identifiers and their evidence fields.
Step 4 — Match evidence and practical access
Attach stable line references used in photos and records, and provide photo filenames, storage location, loading equipment, access restrictions and the requested timetable. Do not assume a pickup promise; supply loading equipment details and any constraints so buyers can plan logistics.
If the inventory or access details are incomplete or unknown, state what is missing and what steps are necessary to confirm (for example, inspect tags for manufacturer part numbers, confirm whether the reel is reachably stored, or obtain owner approval).
- Include photo filenames that show tag close-ups and a contextual image of the reel in storage.
- List storage area descriptions and any access constraints so a buyer can estimate effort required to retrieve offered reels.
What to do with unknown or incomplete inventory
If you cannot establish current physical presence or part numbers, be explicit: record the missing evidence fields and describe the next verification actions. Typical actions are a physical tag check, additional photos showing tag and spool ends, or a short inventory walk to confirm reel counts. Do not change the listed current balance until those actions produce verifiable evidence.
When an item is reserved by the project owner or requires an internal approval, mark it as reserved and note the approval owner and expected decision steps. Only mark a reel as offered once you have the owner’s release or a clear instruction that it is available for third-party transfer.
- Document what evidence is missing and what specific inspection will supply it.
- If a reel’s release is pending, provide the approval owner contact role (e.g., project manager) not personal details, and note the expected resolution action.
