Start with today’s physical balance
A purchase order, invoice, or inventory export is a useful starting point, but it may not show what is physically present today. Walk the inventory and create a current line for every reel, coil, box, or continuous piece. Retain the project or order reference, manufacturer, part number, printed designation, original quantity, current quantity, and the evidence basis for the current figure.
The central reconciliation question is not what the project originally ordered. It is which pieces are now present and can be documented without inflating their current balance. When a figure comes from a reel label, inventory record, measurement, or estimate, label that basis directly. An estimate remains useful when it is disclosed as an estimate.
- Put original quantity and current quantity in separate columns.
- Assign a physical reel or piece ID to every current-balance line.
- Record the source of the balance: measured, documented, or estimated.
Do not merge different package forms
A full reel, partial reel, boxed stock, and loose continuous piece do not present the same quantity or condition question. Keep them on separate lines even when they share a manufacturer or a project reference. Record package type, reel or piece ID, continuous length, reel count, packaging or seal condition, exposed ends, and visible damage for the particular item.
That detail prevents a common mistake: reporting the original project footage as the sale quantity while mixed package forms are hidden in one aggregate row. If two partial reels add to a numerical total, preserve their individual continuous lengths instead of presenting the sum as one uninterrupted piece.
- Use a separate row for each full reel, partial reel, box, or loose length.
- Keep continuous length separate from an aggregate footage total.
- Photograph labels, jacket legends, reel flanges, ends, and condition differences by item ID.
Separate available stock from release questions
A cable line may be physically present while reserved for a future project, subject to a customer return, or waiting for internal approval. Give every line a release status and ownership status, identify the role that can authorize release, and keep a return or retention note with that same row. A seller should not include a pending line in an available balance merely because it appears in an old order record.
If the seller knows an anticipated review date, it may be recorded as a seller-requested date, but it is not a promise about purchase or movement. Moving approval-pending lines into a separate pending section is the workable resolution: it protects the accuracy of the offered balance and makes the remaining questions visible.
- Use clear statuses such as available, reserved, return-pending, or approval-pending.
- Identify the release-authority role and any ownership or consignment limitation.
- Keep pending items visible but outside the currently offered balance.
Make photos and records reconcile to the same line
A clear evidence packet uses the same item ID in the spreadsheet and photo names. For each current-balance line, show readable label text, jacket legend, reel flange, accessible end, and relevant condition detail. Transcribe conductor metal, AWG or kcmil, voltage marking, and shield, armor, or jacket notation only when those facts are readable. Keep fields unknown when the available image or record does not establish them.
This page is about correcting the physical balance against the project record, not about repeating a generic cable description. A current line that says “quantity unknown, label unreadable, release pending” is more reliable than a line that copies a similar reel’s data. Send the reconciled inventory and photos to saleselectricalbuyers@gmail.com or call +1 (614) 715-3047 for a discussion of the documented lot.
- Match photo names to the inventory ID rather than the original purchase-order line alone.
- Keep electrical markings as transcribed facts, not inferred classifications.
- State missing seals, exposed ends, and unreadable fields in the condition record.
Keep the San Francisco context proportionate
San Francisco's Southern Waterfront combines cargo shipping and heavy industrial maritime operations with production, distribution and repair uses. That local context can make it sensible to keep project, warehouse, and facility records separate, but it does not establish that any particular cable is available or that Industrial Wire Buyer has handled a local lot.
Illustrative inventory example—not a purchased lot: project line SF-OV-17 shows an original order of 1,000 feet. The current physical balance has two partial reels: 300 feet documented on one reel and 180 feet estimated on the other. The first line is available for discussion; the second has a pending release entry and stays outside the current available total. The missing seal on the first reel is recorded as condition information, not ignored.
- Example line SF-OV-17A: 300 feet documented, partial reel, release recorded as available for discussion.
- Example line SF-OV-17B: 180 feet estimated, partial reel, release pending and excluded from the available balance.
- A local industrial context is not proof of stock, demand, a customer relationship, or purchase history.
