SKU Reconciliation Variance Breakdown

Variance exposure across reason codes, categories, channels, warehouses, and the highest-impact invoice-SKU lines.

Lines analyzed
Distinct invoice-SKU records checked across the reconciliation extract.
Monetary variance lines
Rows where the variance amount is non-zero and contributes to financial exposure.
Absolute variance exposure
Total of absolute variances, regardless of whether the line is positive or negative.
Zero-amount price flags
Unit-price inconsistency rows dominate count, but carry no variance amount in this file.
Variance interpretation

Returns share
Negative qty share
Positive variance balance
Control hotspots
  • Loading hotspot summary…
  • Loading hotspot summary…
  • Loading hotspot summary…
  • Loading hotspot summary…
Reason mix: issue volume versus monetary impact
Bars compare flagged line counts and monetary-variance lines; the line shows absolute variance impact.
Absolute variance by category and reason
Dollar exposure is spread fairly evenly by category, with returns leading and negative quantities acting as the secondary driver.
Warehouse heatmap of variance exposure
The unspecified warehouse bucket is the clearest location hotspot and is materially above named warehouses in every category.
Composition snapshot
Side-by-side donut views show how exposure splits by reason and by positive versus negative variance direction.
Top SKUs by absolute variance
The highest-exposure SKUs each accumulate roughly $16K–$18K of absolute variance across many invoice lines.
Highest-impact invoice-SKU lines
Invoice SKU Reason Category Channel Warehouse Qty Variance Expected Value Direction