Free tool · beta · no account needed
Physical Stock Count & Variance Report
Run a physical count against book stock: print or download a count sheet, bring the counts back as a file or type them in, and see the variance for every line, with recounts and reviewer comments.
What you need
- Book stock as .xlsx or .csv: item code and quantity; location, batch, lot, unit and unit cost help.
- Counts as a file (the filled-in count sheet works), typed on screen, or both.
- Typical preparation: export book stock at the count cut-off, print or share the count sheet, then collect the counts.
How counts are compared
| Result | When |
|---|---|
| Matches book | Final count equals book stock |
| Variance | Final count differs from book stock (variance = final count − book) |
| Counted, not on book | Counted, but the line is not in the book file; shown against zero book stock, and said so |
| Not counted | Book line with no count. Not read as zero unless you confirm that missing counts mean zero |
| Duplicate count or book lines | A line counted or listed more than once; not compared unless you choose to add them up |
| Unit differs | Book and count units differ; not compared |
The final count is the recount when you enter one. Variance value uses the book unit cost only when it is a valid number above zero. Recounts are suggested above limits you set; they are suggestions only.
What you get
- A count sheet: print view or Excel (A4), sorted by location, optionally blind (without book quantities).
- On screen: variance by line, recount, review status and comment per line.
- Excel report: Dashboard with key figures and charts, Summary, Count lines (variance formulas update when a recount is typed in Excel), To resolve, Rows not used, both sources and the method.
Beta limits
- Tested on synthetic data; reports checked in LibreOffice, not yet in Microsoft Excel.
- Recounts, review status and comments are kept only while the page is open; the downloaded report keeps them.
- It never adjusts stock or writes to your stock system or ERP.
Free to use, no account needed
Open the tool and try it with invented sample files first. Your files are read in your browser and are not uploaded. The tool is in beta and has been checked on synthetic data: compare its results with what you know. Privacy