Why reconciliation matters
Project invoices and ERP exports often show the original footage ordered, not the current balance. That difference creates risk for both seller and buyer if every listed reel is treated as available. Our process focuses on documenting the current, releasable inventory so offers and line items reflect what is actually on site and approved for sale.
Use reconciliation to record missing reels, reserved material, pending returns or partial cutoffs. Treat the original record as a source, not as the final statement of availability.
Anaheim lists business assistance for opening, remodeling or expanding an existing business, including coordination among city departments and outside agencies. That commercial-development fact may be background for a project record, but it neither proves that an overrun exists nor identifies a seller’s cable, quantity, or authority to release it.
- Record the inventory reference and the source record alongside each physical match.
- Note discrepancies rather than preserving stale quantities from older exports.
- Identify any items reserved by project stakeholders or subject to return.
Step 1 — Match records to physical stock
Compare the ERP export, purchase order or project list to each reel, box or package present. For each line, create these evidence fields: inventory reference, source record, physical match and discrepancy note. If a reel listed by part number cannot be found, record it as a missing item with the source citation and the date of the physical check.
If a line in the source record covers multiple reels, break it into single-reel entries unless every reel is verified with identical part number, length and condition.
- Inventory reference: tie the physical tag to the original line.
- Source record: include export filename, PO number or project sheet.
- Physical match: note reel tag numbers, visible part numbers and measured lengths where possible.
- Discrepancy note: explain why counts differ (cutoffs, returns, reserved).
Step 2 — Retain per-reel quantities and condition
Separate full reels, partial reels, unopened boxes and cutoffs. Group only reels with genuinely matching specifications, and keep every reel's length visible as the primary quantity basis. Evidence fields here include part number, reel count, length per reel, continuous versus cutoff and the quantity basis.
When continuous length is documented, state whether footage is continuous or measured from a cutoff. For partials, report the measured remaining footage on the reel rather than attributing the original invoice footage to the line.
- Part number and reel count must be recorded on the same line as length per reel.
- Mark continuous reels versus cutoffs so buyers understand whether multiple pieces are joined.
- Document condition: unopened, uninstalled, used, or damaged — with photo references.
Step 3 — Explain and document release status
State whether material is project overrun, discontinued stock, warehouse excess or maintenance inventory. Identify reserved stock, pending returns and whether a release approval is required. Use evidence fields: surplus reason, condition, reserved stock, pending return and release approval.
If a reel is pending approval, mark its status clearly and do not represent it as available for sale until the required approval is obtained and recorded.
- Surplus reason: brief cause such as project overrun or discontinued part.
- Reserved stock: explicitly name the stakeholder or approval step that holds the item.
- Pending return: include expected return date where known, or state unknown.
Step 4 — Send evidence with lot location and access details
Match photos to each line reference and provide storage location, access limits, loading resources and a seller timetable. Attach photo references for each reel and note any special handling or loading constraints. Evidence fields include photo references, storage location, access limits, loading resources and seller timetable.
If inventory details are unknown or incomplete, mark which evidence fields are missing and give a clear plan and deadline for completing them. Honesty about unknowns prevents misrepresentation and speeds approval when the missing evidence is produced.
- Photo references: tag photos with inventory reference and reel tag.
- Storage location and access limits: note warehouse aisle, pallet, or rack and any access permits.
- Loading resources: state whether forklift, reel cradle or manual handling is required, and whether those resources are on site.
Handling unknown or incomplete inventory
When records are incomplete, follow the steps above but flag missing items explicitly. For any unknowns — such as untagged reels, undocumented returns or unclear approval status — record a discrepancy note and a next-action (for example: schedule inventory recheck, request release approval, or produce missing photos).
Do not represent unknown or pending items as available. Instead, publish the reconciled balance with the evidence basis and an explicit list of unresolved items and the seller timetable for resolution.
- If some reels lack length measurements, measure and update the line before listing as available.
- If release approval is required but not yet granted, mark the line pending approval and include the approval owner and expected timeline.
- If source footage exceeds reconciled balance, publish the reconciled balance and attach the discrepancy note.
