Worksheet

Stock variance investigation sheet

One printed row per item. Columns hold item code, system quantity, counted quantity, difference, value of difference, suspected cause, ledger line reference, fix applied and owner, with space for a second counter’s initials. A header records the warehouse, count date and counter, and the footer lists the four reason codes for adjustments: damaged, miscount, unposted receipt and unit error.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Why ERP stock does not match the shelf”, www.gullysystem.com/blog/why-erp-stock-does-not-match-the-shelf