Set the current balance before listing cable
A purchase order, job closeout list, or ERP export can identify what was originally ordered, but it is not the current inventory. Walk the material and create a row for each reel or package that is physically present. Record the manufacturer and part number, the reel reference, the current storage site, and the line in the older record that appears to relate to it. Keep an original order quantity in a historical column rather than in the available-quantity column.
For a partial reel, record one continuous remaining length and its basis: measured, documented, or estimated. Full reels, partial reels, and cut lengths do not belong in the same quantity field. This distinction is the practical decision on this page: which material is actually available now, and what evidence supports that conclusion.
- Inventory line ID tied to the older record
- Physical reel or package reference
- Current continuous footage and quantity basis
- Current storage site and visible condition
Build a reconciliation row for every reel
Use a stable reference such as OV-SAC-01 on the inventory, the reel tag photograph, the jacket-print photograph, and any supporting export. If two matching reels share one specification, preserve their individual lengths before showing a group total. A total of 480 feet made of two reels is not the same record as one continuous 480-foot reel.
Transcribe readable tag text and jacket printing instead of replacing them with a project nickname. Where a tag is missing, write unknown for the product field and attach the best available photo or record. A missing field is useful information; borrowing the description from a nearby reel hides a reconciliation gap.
- Photo filenames matched to the row reference
- Full tag text or an explicit unknown entry
- One length for each continuous piece
- Record reference that supports the current balance
Keep release status out of the available total
Create a release-status field for each row: available for discussion, reserved, pending return, or awaiting owner approval. The category is not a promise of purchase; it tells a reviewer whether the seller can actually release the material. Identify the business role that can authorize release and preserve any reservation or return note beside that row.
The City of Sacramento building page links permit services, building inspections, online building services, plan review and project-management services. That local context does not prove that a project has cable available. It is a reason to distinguish a project reference from the seller-controlled approval and current inventory record needed for a cable inquiry.
- Release status stated separately from quantity
- Approver role rather than an assumed project contact
- Reservation or return note kept with the reel row
- Seller contact who can clarify the record
Resolve incomplete balances without inventing footage
If a reel cannot be reached or its label is illegible, keep it in a separate pending-verification row. State what is known, such as a visible tag fragment or an adjacent packing-list line, and state what remains unknown. Do not convert the old invoice amount into current footage simply because a physical check is unfinished.
For a spreadsheet and photo set, send the row references in the initial inquiry and email the files to saleselectricalbuyers@gmail.com. Name each image with the same reference used in the balance sheet. That lets a reviewer see which evidence belongs to a confirmed current balance and which evidence still needs clarification.
- Estimated footage labeled with its basis
- Pending-verification rows not merged into available stock
- Unknown tag or reel fields left visible
- Photos and spreadsheet use the same row reference
Illustrative balance record—not a purchased lot
Illustrative inventory example—not a purchased lot: OV-SAC-01; feeder cable; part number transcribed from tag; two reels with 300 feet documented and 180 feet documented; original order balance retained as historical context; release status pending owner approval. The example shows a quantity supported by current records without treating pending material as released.
The common mistake is to submit the original invoice quantity as the remaining footage after material has been used, returned, or reserved. The resolution is to show the current physical balance, the evidence basis, and any pending quantity in separate fields. This is a record-building workflow, not a statement that any particular reel will be purchased.
