Make the current balance the starting record
Walk the actual storage area and match each purchase-order or inventory-export line to a reel, box, coil, or cutoff that is currently present. Give the physical item a stable reference, then record the original order reference, present quantity, storage site, and whether the count or footage is measured, documented, or estimated.
An invoice can help identify a product, but it cannot prove today’s remaining balance after a project change. When a line is missing, partly consumed, repackaged, or counted remotely, state the discrepancy and evidence basis instead of carrying the original footage forward.
- Use one current physical reference per reel, box, coil, or cutoff.
- Keep a discrepancy note beside the original order reference.
- Label a visual footage estimate as estimated rather than exact.
Preserve the reel-level quantities
Record manufacturer or part number, full readable specification, reel count, and continuous length for every physical line. Keep full reels, partial reels, and cut pieces distinct even when the product designation matches. A group total can be added for orientation, but it must not replace the per-reel lengths that show what is actually available.
Pair reel-tag and jacket photographs with the same reference used in the balance. Existing purchase records are supporting documents, not substitutes for a present inventory check. If the image set is incomplete, identify which lines still need documentation.
- Capture the quantity basis with each length.
- Do not add separate cut pieces together as one continuous run.
- Tie photo filenames and reel tags to the current-balance reference.
Separate offered inventory from reserved material
For each line, state whether it is project overrun, distributor stock, reserved material, pending return, or subject to internal release approval. The decision is not simply whether a product appears on the order; it is whether that specific current item is available and authorized to be included in the inquiry.
List the owner and the authorized release contact where known. If approval is pending, write pending rather than treating the line as cleared. This protects the seller from promising inventory that another project, return process, or internal decision still controls.
- Use separate fields for availability reason and reservation or return status.
- Record release approval as confirmed, pending, or unknown.
- Keep reserved lines out of the offered group until their status changes.
Use the local project context without claiming a job
The City CIP includes sanitary sewers, storm drains, street lighting, traffic signals, recycling facilities, EV charging stations and solar array canopies. These are documented City project categories, not proof of a City contract, seller inventory, or purchasing demand. They simply explain why a contractor or facility closeout may need a disciplined overrun-balance record.
Whether a reel came from any local project category, the seller still needs its own product markings, current footage, condition notes, storage information, and release authority. The factual context does not fill those lot-specific fields.
- Use a project category only as background in the inventory notes.
- Let the current physical balance determine what is offered.
Repair the invoice-versus-stock mistake
The common mistake is presenting original invoice footage as remaining quantity and calling every leftover reel available. Repair the list by retaining the reel-level balance, flagging reserved or pending-return lines, and documenting the authority required to release each line.
Illustrative inventory example—not a purchased lot: OV-BK-01; project-overrun feeder cable with part number on tag; two reels with 300 ft and 180 ft continuous, documented; uninstalled; release pending internal approval. This fictional record is a format example, not evidence of an actual Bakersfield transaction.
- Show the evidence basis beside both reel lengths.
- Keep a pending release line visible rather than deleting it or marking it offered.
