Inventory Count Reconciliation
Compare what the system says you hold against what the count actually found — with the variance valued, by SKU.
Nothing you paste leaves this page. Parsing and matching happen in your browser.
How it works
A stock count produces two numbers per line and one question: what is the difference worth? Valuing the variance is what turns a count sheet into something a finance team can act on, because a hundred missing low-value items usually matters far less than three missing high-value ones.
Shortages and overages both matter, and for different reasons. Shortages are shrinkage — theft, damage, miscounting or unrecorded issues. Overages usually mean goods were received without being booked in, which means the payable is missing too. SKUs appearing in only one of the two lists are a third category, and normally point at a master-data problem rather than a physical one.
Variance = counted − system · Value = variance × unit cost
- Shrinkage — counted less than the system says — value lost
- Overage — counted more than the system says — usually unbooked receipts
- Net variance — shrinkage and overage combined
Worked example
8 SKUs counted against system quantities
Inputs
Results
A net 14,005 shortfall on just over a million of stock — about 1.4%. Most of it is five missing units of one high-value SKU, which is why valuing the variance matters more than counting it.
Frequently asked questions
What format should the two lists use?
System stock as SKU, quantity, unit cost — one line each. The physical count as SKU, quantity. A header row is optional and is skipped automatically.
What shrinkage rate is normal?
It varies widely by sector — retail commonly runs 1–2% of stock value, while a controlled warehouse should be well under 1%. What matters more than the level is the trend and whether the same SKUs recur.
Why would I count more than the system says?
Usually goods received but not booked in, returns processed physically but not in the system, or an earlier count that was wrong. All three mean the accounting records are behind the warehouse.
Is my ledger data uploaded anywhere?
No. Every line you paste is parsed and matched inside your browser. Nothing is transmitted to us, nothing is stored, and closing the tab discards it. That is the whole reason this tool exists in this form.
More in Reconciliation
Two-List Matcher
Paste any two lists of transactions and find what does not line up — matched pairs, exceptions on each side, and duplicates within either.
ReconciliationBank Reconciliation
Match your cash book against the bank statement and produce a proper reconciliation — outstanding items, unrecorded charges and adjusted balances on both sides.
ReconciliationInvoice vs Payment Reconciliation
Match payments received against invoices raised, and find the short payments, overpayments and unallocated cash sitting in your receivables.
ReconciliationPayment Gateway Payout Reconciliation
Reconcile what the gateway actually paid you against what your orders say it should have — with fees, refunds and missing settlements itemised.
ReconciliationGST / VAT Return Reconciliation
Match your purchase register against what your suppliers actually filed, and find the input tax credit you are about to lose.
ReconciliationDuplicate Payment Detector
Scan a payment run or a full year of ledger for payments made twice — the same supplier, the same amount, days apart.