How to Record Full and Partial Component Reels in a Stock List

Direct answer: Put the original label QTY and the quantity currently present in separate spreadsheet fields. Record whether the material is a sealed original reel, an opened reel, a used partial reel or loose parts. For a partial reel, enter a fresh count or a clearly marked estimate and name the method used. Add the complete part number, packaging details and a reel-label photo reference so a reviewer can connect the row to the physical material.

When this checklist applies

Use this checklist when a factory or warehouse is preparing taped component stock for an initial review and the same list contains different reel states. It is especially useful when a label still shows factory QTY but a reel has already run on a placement machine. This is general practice, with no named client or claimed transaction result.

A practical five-field sequence

1. Identity: copy the complete manufacturer part number and brand from the label; keep suffixes that identify packaging.
2. Packaging: record tape type or width and reel diameter when available, plus whether the goods are sealed, opened, partial or loose.
3. Label quantity: transcribe the printed QTY as an original-pack reference.
4. Current quantity: enter the physical count or estimate actually used for the stock list.
5. Quantity source: identify label, counting machine, calibrated diameter estimate or weighing, and attach the label photo reference.

Check the rows before sending the list

Compare the spreadsheet with representative reel labels. If two reels have the same part number but different diameters or conditions, keep their separate quantities and sources visible. A manufacturer packaging specification can help check whether an original reel's QTY is plausible; a typical pack size cannot establish what remains on a used reel. If a partial reel was estimated from diameter, record the pitch and the comparable full reel used for calibration. If a counting machine was used, record that method instead.

Boundaries

An initial stock list is a record of what is known and what still needs checking. A printed label does not prove the remaining quantity after use. A diameter result depends on winding, effective tape thickness and empty leader or trailer tape. Weighing is especially uncertain for small chip resistors and capacitors. Keep unidentified or mixed material pending instead of filling a precise looking number, and use the relevant manufacturer's packaging information and a physical check for the final determination.

Next step

Export a versioned list with separate rows for the packaging states, the five fields above and representative label photos. Mark uncertain quantities as estimated or pending. That gives the next inventory review a traceable starting point without implying a fixed price, acceptance or clearance time.