For steel distributors, discrepancies between physical inventory and book values aren’t rare—they’re expected. But that doesn’t make them acceptable during an audit. When physical counts don’t match ERP or ledger figures, audit managers know the deviation is a symptom of something deeper: control failure, transactional timing, or incorrect costing.
Auditors don’t panic when they see these gaps—but they do investigate. And how a company responds can mean the difference between a smooth audit and a prolonged one, or worse, a qualified opinion.
Why Discrepancies Happen—And What They Mean
The steel supply chain is fast-moving, weight-based, and transformation-heavy. That’s fertile ground for inventory mismatches. Common causes include:
Incorrect receipts: Material received without proper weighbridge confirmation or posted to the wrong SKU.
Unrecorded scrap or waste: If scrap yield isn’t booked accurately during slitting or cutting, inventory gets overstated.
WIP stuck in process: Coils or billets sitting mid-job that haven’t been updated in ERP appear missing or duplicate.
In-transit inventory misclassification: Steel shipped but not received at the destination, or vice versa, can cause inventory to appear missing.
Returns and credits: Customer returns received physically but not reversed in sales ledger cause dual recognition.
Misapplied unit costs: Physical count may match, but if cost layers were misapplied, the dollar variance is still material.
No matter the trigger, audit managers see mismatches as a risk to both the income statement and the balance sheet. The priority is identifying whether the discrepancy affects valuation, revenue recognition, or operating controls.
Step-by-Step: What Audit Managers Do When There’s a Mismatch
Quantify the Gap
Auditors first calculate the variance in both units (e.g., pounds, coils) and dollars. Materiality is assessed based on financial thresholds.
If a $140,000 discrepancy is found on a $5M inventory base, that’s a 2.8% deviation—enough to warrant deeper investigation.
Trace Back to Movement Logs
They pull movement logs from ERP or WMS systems—examining receiving, job orders, transfers, and shipping transactions.
Example: A missing 12,000-lb coil might have been moved to a job bin but never recorded in the WIP account.
Test System Controls
Auditors assess whether inventory adjustments require approvals, if count variances auto-post to GL, and whether reconciliation reports are run periodically.
They also verify whether cycle count variances prompt investigations or get cleared without scrutiny.
Review High-Risk SKUs and Locations
Certain products (e.g., galvanized coil, tool steel, or high-strength plate) have higher dollar-per-ton impact. Auditors target these first.
Similarly, remote yards or overflow storage areas are common sites for physical-book mismatches due to poor scanning or delayed updates.
Interview Operations Staff
Count teams, warehouse supervisors, and inventory control clerks are interviewed. Questions center on: when was the last count, were adjustments made, are temporary workarounds common?
This helps audit teams separate clerical mistakes from systemic gaps.
Examine Adjusting Entries
Any manual journal entries booked to reconcile inventory are scrutinized. Lack of supporting documentation or inconsistent rationale raises red flags.
Test Valuation Impact
Beyond quantity, auditors examine if discrepancies relate to cost. Was the wrong cost layer applied? Was a coil downgraded but not revalued?
These insights determine whether the issue affects COGS, inventory valuation, or both.
Common Findings from These Investigations
Phantom inventory from mis-posted transfers
Overstated valuation from failure to downgrade returned stock
Duplicate inventory entries for coils split across multiple jobs
WIP inventory excluded from books for weeks
Unreconciled cycle count variances swept into suspense accounts
Each finding has different implications. Some require financial restatements; others lead to control redesign. But all require documentation and explanation.
Best Practices Audit Managers Recommend After a Discrepancy
Reconcile Immediately
Don’t delay. As soon as a physical-book mismatch is found, trace it, adjust it, and document the cause.
Enter a journal entry that explains not just the dollar value, but the operational trigger.
Segment and Age Discrepancies
Keep a running log of inventory mismatches. Segment by location, SKU, or cause. Apply aging rules to unresolved items—those older than 60 days may require write-off or impairment.
Enforce Count Closure Protocols
Cycle counts or full counts should not close until variances are reviewed, approved, and adjusted properly. Build system blocks to prevent count completion if unresolved issues exist.
Use Barcode and Location-Level Tracking
Steel inventory moves fast—and in big volumes. Barcoding each coil or bundle with job ID and heat number, and tracking its exact storage bin, reduces mismatch risk.
Train Staff on Inventory Event Awareness
Many mismatches happen because operations staff don’t realize a movement has financial consequences. A skid moved from dock to job floor must be entered, or the system will think it’s missing.
Run Reconciliation Reports Weekly
Monthly is not enough in fast-moving environments. Weekly physical vs. book reports help spot and resolve issues before they grow.
Turning Audit Pressure into Process Strength
Inventory discrepancies shouldn’t just be “cleaned up” before the audit—they should become triggers for process improvement. In steel, where each pound carries real dollar weight, aligning physical reality with ledger entries isn’t just good accounting—it’s operational discipline.
Audit managers who lead these investigations aren’t just reconciling books—they’re restoring trust between the floor and the financials. And for steel distributors competing on precision and performance, that trust is as strong as the coils they ship.
