WeSteel
All Posts
Operations

How to Conduct a Steel Inventory Physical Count That Actually Works

Physical inventory counts at steel service centers are dreaded, postponed, and often inaccurate. A structured approach turns this annual nightmare into a reliable process.

July 15, 20259 min read
How to Conduct a Steel Inventory Physical Count That Actually Works

The controller of a steel service center described their last physical inventory count: "We shut down for two days. Thirty people walked around with clipboards. Half of them could not read coil tags. The first count came in 12% off from the system. We recounted for another day. The second count was 8% off. We adjusted the system to match the count and moved on, knowing neither number was right."

Physical inventory counts at steel service centers are uniquely difficult. The material is heavy, large, and often stored in ways that make counting challenging (stacked coils where only the top one is visible, bundles of bar in racks where pieces in the back are hard to count). But accurate physical counts are essential for financial reporting, insurance coverage, and operational performance.

Preparation Is 80% of the Work

A successful physical count starts weeks before count day. First, organize the warehouse. Tag every location with a clear identifier (Bay, Row, Position). Ensure every piece of inventory has a visible tag with the coil or bundle ID, product description, and weight. Move damaged, held, or quarantined material to a separate area so it does not get counted as available inventory.

Print count sheets organized by location, not by product. Counters should walk a physical path through the warehouse, recording what they find in each location. Organizing by product requires counters to search the entire warehouse for a specific item, which is slow and error-prone.

Freeze all inventory movements on count day. No receiving, no shipping, no internal transfers. Every movement during the count introduces errors because material gets counted in its old location and its new location, or in neither. If you absolutely cannot shut down shipping, designate a cutoff time and ensure all shipments before that time are removed from the system before counting begins.

The Count Process

Use two-person count teams. One person identifies and reads the tag (or physically measures the material if the tag is missing or illegible). The other person records the data. This prevents the most common counting error: one person seeing what they expect to see rather than what is actually there.

Count by weight, not by pieces, for coil inventory. A coil tag may say 28,000 pounds. The actual weight may be 26,500 because someone sold material off it and did not update the tag. If you have a crane scale, weigh every coil. If not, measure the OD, ID, and width and calculate the theoretical weight. For bundles and bar stock, count pieces and multiply by the per-piece weight.

Tag each item after counting with a colored tag or sticker that indicates it has been counted. This prevents double-counting and makes it easy to spot items that were missed.

Reconciliation

After the count, compare the physical quantities to the system quantities for every item. Organize the variances by magnitude: items where the physical count is within 2% of the system are considered matched. Items with 2% to 5% variance need investigation. Items with more than 5% variance need recounting and root cause analysis.

Common root causes of variance include material shipped but not decremented from the system (paperwork lag), material received but not entered (receiving delays), scrap or remnants not recorded, internal transfers between locations not captured, and theft (rare but it happens, especially with small, high-value items like stainless bar).

Cycle Counting as an Alternative

Many service centers are moving from annual physical counts to cycle counting: counting a portion of inventory every day or week throughout the year. In a cycle counting program, you count your A items (fast movers, high-value) quarterly, B items semi-annually, and C items annually. This spreads the work across the year, catches errors closer to when they occur, and eliminates the two-day shutdown.

A cycle counting program requires discipline. Someone must count every day, regardless of how busy the warehouse is. The count results must be investigated and corrected promptly. If you let cycle counts slip for two weeks because of a rush period, you lose the cumulative accuracy benefit. But when executed consistently, cycle counting delivers 98%+ inventory accuracy without ever shutting down the operation.

physical inventorycycle countinginventory accuracywarehouse operationssteel distribution
Steel Inventory Physical Count Guide | WeSteel AI