Excess IC Inventory Lot Reconciliation: Prepare a List Buyers Can Quote

Quick Answer

Before offering excess IC inventory for sale, reconcile the spreadsheet with the physical lots. Separate full manufacturer part numbers, packaging conditions, date or lot codes, quantities and ownership status. Keep uncertain material in clearly identified rows. A buyer can assess a documented lot more effectively than a large combined total whose contents remain unclear.

This guide is for unused component inventory from purchasing changes, cancelled builds, excess orders or discontinued programs. Used boards, recovered components and material intended for recycling should be described separately. Their identity, handling and potential sale route differ from unopened component stock.

Define What One Row Represents

Use one row for one clearly identifiable lot or container group with the same material description and condition. The manufacturer part number should include the full ordering suffix. Put an internal stock code in a different column so the buyer does not mistake your warehouse identifier for the manufacturer's code.

Do not merge rows merely because their abbreviated descriptions match. Two lots can share a basic device family but differ in package, temperature grade, shipment format or recorded history. Preserve the distinction until the supporting records establish that aggregation is appropriate for the intended transaction.

Prepare these fields:

• Full manufacturer part number and brand as recorded on the material and purchase documents.
• Physical quantity, unit of measure, container count and counting method.
• Package, shipment format, date codes and lot or trace references where present.
• Sealed, opened, partial, repacked or otherwise relevant condition.
• Storage location, available packaging records and supporting photographs.
• Ownership, existing allocation and any restrictions affecting release for sale.

The public five-column inventory feed is useful for browsing stock. A private buyback submission usually needs more lot-level detail to explain what a commercial offer would cover.

Reconcile Counts Before Combining Them

Start with the ERP balance, then identify reservations, movements awaiting posting and physical discrepancies. Count using an appropriate controlled method and record its basis. A reel label can describe the original packed quantity even after material has been removed, so retain both the label information and the verified current quantity.

Consider this illustrative example. The stock system shows 8,000 pieces of one ordering code. Physical reconciliation identifies two unopened reels recorded at 2,500 each, an opened reel counted at 1,840, and 360 pieces held for review. The physical total is 7,200 pieces, leaving an 800-piece difference from the system balance.

The starting offer list can identify 6,840 pieces as available for assessment, while the 360 held pieces remain in a separate row and the 800-piece discrepancy is investigated. These are example numbers, not SENICO inventory. “Available for assessment” does not mean that quality, ownership or purchase acceptance has already been approved.

Record movements made during reconciliation. If another team consumes 100 pieces after counting, the sale list must change too. Assign a version and preparation date so both parties know which quantity formed the basis of the discussion.

Describe Condition Without Guessing

Photograph the container, manufacturer label and packaging state. Associate each image with its row or lot identifier. Keep original labels visible and avoid replacing uncertain information with a cleaner but unsupported description. If a field cannot be established, mark it unknown and explain what evidence is missing.

Storage history deserves its own record. TI identifies moisture sensitivity, protective packaging and customer storage conditions among factors affecting shelf life. This supports checking the actual lot's history; it does not make every older device unusable or prove that every sealed bag remained within its specified conditions. TI product shelf-life guidance

Follow the relevant manufacturer's handling instructions when moving or inspecting material. Do not open protective packaging solely to improve a sales photograph. Where an inspection requires opening, counting or further treatment, agree the method and responsibility with the buyer and qualified personnel beforehand.

Separate Identity, Condition and Commercial Value

A complete ordering code answers what the component is intended to be. Trace documents help explain its supply history. Inspection evidence addresses specific questions about the received material. None of these should be replaced by a broad unsupported label such as “fully tested.” State which inspection, if any, was actually performed and retain the report.

Commercial value is a separate decision. Current buyer demand, usable quantity, documentation, lot consistency and the cost of assessment can influence an offer. The original purchase price records a past transaction; it does not establish today's resale value. Request a quotation against the identified lots instead of publishing an invented recovery percentage.

Inventory-management programs discussed by Avnet focus on matching supply to demand and reducing excess holdings. A sale list addresses the next practical question when excess already exists: which specific material can be released and assessed? The reconciliation workflow here is SENICO's proposed preparation checklist, not a description of Avnet's purchasing terms. Avnet inventory-management example

Agree the Handoff Before Shipping

Ask the prospective buyer to identify the lot rows included in the offer and any conditions that remain open. Clarify the inspection stage, treatment of quantity differences, shipping arrangements, payment terms and handling of material that does not match the description. Keep the accepted list with the transaction records.

Update internal reservations only through the appropriate inventory process. Record which lots have been offered, accepted, shipped or retained so another purchaser or production planner cannot unknowingly allocate the same quantity. An organized release record protects both the seller's remaining production needs and the accuracy of the buyer's expectation.

Frequently Asked Questions

Can I offer opened reels and partial quantities?

You can list them for review, with the current quantity and condition clearly disclosed. Acceptance and value depend on the buyer's assessment and the requirements of the material; do not group them with sealed reels without explanation.

Should I remove older date codes from the list?

No. Preserve known date and lot information. Describe storage and condition alongside it, and let the relevant technical and commercial review determine suitability.

Do I need a separate row for material under review?

Yes. Separate material awaiting investigation from lots proposed for release. Explain the hold reason and avoid presenting its quantity as already approved for sale.