wareliumtoolsCompare book quantities with counted stock, review shortages and overages, and export a variance report.
Compare expected and counted stock, SKU by SKU.
No cost column: all unit costs are 0. Use one currency.
Illustrative sample · up to 2,000 rows · processed locally
| SKU | Expected | Counted | Difference | Unit cost | Value variance | Result |
|---|
Share the tool address. Your entered values are not included.
For each SKU, difference = counted quantity − expected quantity. A negative result is a shortage; a positive result is an overage. A blank counted cell is missing information, never a zero count. Duplicate SKUs are rejected so rows are not silently merged. Consolidate locations deliberately before uploading one row per SKU.
Use the same counting unit for expected and counted values within each SKU, such as pieces for both. The shortage and overage totals sum numeric count differences across SKUs; they are not a measure of interchangeable stock. Costs must be in one currency. If no cost column is selected, every unit cost defaults to 0 and the result is not an inventory valuation.
UTF-8 CSV, TSV or pasted Excel columns, including a header, SKU, expected quantity and counted quantity. Unit cost is optional. Use non-negative decimal numbers, at most 6 decimal places, 15 significant digits and 1 trillion, without thousands separators or currency symbols. Files are limited to 1 MB, 500,000 characters and 2,000 data rows.
No. Comparison and export happen locally in your browser. Recount discrepancies and investigate receipts, movements and timing before deciding any adjustment. This tool does not connect to your ERP or write operational records.
Discrepant rows appear first, then by absolute estimated value variance. Matching rows follow. Different SKU shortages and overages remain separate even when their estimated monetary values offset. Spreadsheet-sensitive SKU text is prefixed with an apostrophe only in the exported CSV to prevent formula execution. Editing input clears the old analysis.
Illustrative inputs and outputs to help you check your own task.
Expected and counted quantities must use the same unit for that SKU. Convert cartons to pieces first if needed.
The small net value still includes two discrepant SKUs. Review the rows before deciding on any inventory adjustment.
These tools run in your browser. They do not upload your entries or store them after you leave. Downloads are created on your device. Hosting providers may process standard access logs.