Stock Reconciliation & Variance Analyzer
Compare two stock reports line by line — the system against the warehouse, one site against another, or the same report on two dates — and see which lines agree, which differ, and why.
What you need
- Two stock reports, each .xlsx (any sheet) or .csv, up to 50 MB and 300,000 rows. Column names and order may differ between them.
- In both: item code and quantity. Description, location, batch, lot, unit and unit cost help.
- Typical preparation: export the two reports and check they cover the same date and stores. The tool suggests the columns; you confirm them.
How lines are matched
A line is the item code plus the location, batch or lot you choose to match on. Rows that share a line are never added together unless you choose to; different batches or locations are never combined.
| Result | When | Difference |
|---|---|---|
| Matched | Both reports, same quantity | 0 |
| Quantity differs | Both reports, different quantity (a tolerance can be set) | B − A |
| Missing from one report | The line is only in A or only in B | − A or + B |
| Ambiguous match | Several rows share the line in a report, so the line cannot be compared as it is | Not compared |
| Duplicate key | Several rows share the line in one report and the line is not in the other | Not compared |
| Unit differs | Both reports state a unit and the units differ | Not compared |
Item codes are compared without case and outer spaces; ignoring leading zeros or separators is an option you switch on. Rows with no item code or a quantity that is not a number are listed with their row numbers, never read as zero. A difference shows that two reports disagree; it is not a finding of loss, theft or error.
What you get
- On screen: summary figures, a hint when looser code rules would match more lines, rows not used, and a filterable table with the reason for every line.
- Excel report: Dashboard with key figures and charts, Summary (formulas), Results with Resolved? and Reviewer comment columns, Rows not used, both sources row by row with their match key, and the matching rules.
Beta limits
- Tested on synthetic data; reports checked in LibreOffice, not yet in Microsoft Excel.
- Your column choices and review notes are not saved between visits; the downloaded report keeps them.
- It reads files only: it never changes your stock system.
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