Lines counted
93%
Count accuracy
54%
Net variance value
-$67
Stock Count Sheet
Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.
SpreadsheetWarehouse ManagementFree
Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.
Shown with sample data
Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.
Cycle counting replaces the annual shutdown count with small, frequent counts weighted by value. Set how often A, B and C items are counted and the variance tolerance for each class; the schedule gives every item its next count date and flags what is due. Record each count against the system quantity and the report calculates variance in units, value and percent, judges it against tolerance and tracks inventory record accuracy, the figure auditors and finance care about.
Items are ranked by annual usage value: A items (about 20% of items, 80% of value) are counted most often, C items least. It focuses effort where errors cost most.
Here, the share of counts that are exact or within the tolerance for their class. Many warehouses target 95% or better; best-in-class sites exceed 99%.
Common starting points are 0–1% for A items, 2% for B and 5% for C, tighter for high-value or serialised stock.
Download a copy
Downloads need a free account.