Free warehouse tool

Stock Count Variance Calculator

Enter the system quantity and the counted quantity for each item to see the differences, the variance percentage and your stock record accuracy. Paste straight from Excel, then download the result as CSV or save it as a PDF.

Count lines

Tolerance (%)Differences within this percentage still count as accurate. Use 0 for an exact match.

Paste lines from Excel

Copy four columns from Excel and paste them here: Item, System qty, Counted qty, Unit cost (optional). One item per line.

Count result

Stock record accuracy–Enter at least one item with both a system qty and a counted qty.

All counted lines

Item	System	Counted	Difference	Value

Your figures stay in this browser. Nothing is sent or saved, so download or print your result before closing the page.

How the results are worked out

Difference = counted qty − system qty. A positive figure means more stock was found than the system shows (over); a negative figure means less (short).

Difference % = difference ÷ system qty × 100. If the system shows 0 and stock is found, there is no percentage: the line is flagged as not in the system record.

Stock record accuracy = items within tolerance ÷ items counted × 100. It measures how many item records are right, not how many units. One item badly wrong and one item slightly wrong both count as one inaccurate record.

Value difference = difference × unit cost, shown only where you enter a cost. The net figure lets overs and shorts cancel out; the total value of differences does not, so it shows the real size of the error.

Worked example

Item	System	Counted	Difference	Within 0% tolerance?
A-101	240	240	0	Yes
A-102	180	176	−4 (−2.2%)	No, short
B-210	60	61	+1 (+1.7%)	No, over
C-330	25	22	−3 (−12.0%)	No, short
D-015	120	120	0	Yes

2 of 5 items match, so stock record accuracy is 40%. With a 2% tolerance, B-210 also counts as accurate and the figure becomes 60%. Press Try an example above to load these lines.

Using it during a stock count or cycle count

Freeze movements for the locations being counted, or note any receipts and issues made during the count.
Count without looking at the system quantity (a blind count), then enter the system figure afterwards.
Paste the count sheet from Excel, or type the lines in.
Recount the lines with the largest differences before posting any adjustment. Many differences come from unposted transactions, wrong units of measure or stock in the wrong location, not from real loss.
Download the CSV or save a PDF for your records and for the adjustment approval.

Tolerance is your decision. There is no universal figure. Many sites use 0% for high-value or controlled items and a small tolerance for bulk, low-value items. Set it to match your own stock policy.