Inventory reconciliation is comparing the stock your system says you have with the stock physically on the shelves, investigating every difference, and correcting the record with a reason. Done well, it also finds and fixes the cause of each discrepancy, so the same gap does not come back next month. Most inventory discrepancies come from process gaps, not theft.
- Inventory reconciliation is about units on shelves; payment reconciliation is about money in the bank. The two meet in marketplace-held stock.
- The process has eight steps, from setting a cut-off to fixing the process that caused the gap, with every adjustment carrying a reason code and approval.
- In the worked example, investigating a confirmed gap of 16 units found 12 unscanned returns, so only 4 were written off as shrinkage.
- Reconcile each warehouse on its own, track stock in transit, and reconcile marketplace-held stock against the marketplace's reports, since you cannot count it yourself.
- Reconcile every cycle count the same day, 3PL and marketplace stock at least monthly, and run a full reconciliation after a physical count, a system migration or a peak season.
- Relaxo reached 100% inventory accuracy and more than 99% bin-level accuracy on EasyEcom; Minimalist lifted cycle-count accuracy from 70% to 98.8%.
SECTION 01Inventory reconciliation in one paragraph
In brief: Inventory reconciliation is comparing the stock your system says you have with the stock physically on the shelves, investigating every difference, and correcting the record with a reason. Done well, it also finds and fixes the cause of each discrepancy, so the same gap does not come back next month.
In India it is often called stock reconciliation or physical stock verification; the job is the same. It is not the same as payment reconciliation, which matches orders and fees against marketplace payouts. Inventory reconciliation is about units on shelves; payment reconciliation is about money in the bank. The two meet in one place, marketplace-held stock, covered below.
SECTION 02The inventory reconciliation process, step by step
In brief: To do inventory reconciliation, set a cut-off, count the physical stock by bin, pull the system quantity at the same moment, calculate the variance for each SKU and location, recount large gaps, find the root cause, adjust the record with a reason code and approval, then fix the process that caused it.
- Set a cut-off. Pick the moment the count represents, and hold or log any receiving, picking and returns that happen during the count.
- Count by bin. Count the physical stock, location by location, ideally blind (without seeing the system quantity). This can be a full count or a cycle count of selected bins.
- Pull the system quantity at the same cut-off, split by status: sellable, reserved for orders, on quality hold, damaged, in transit.
- Calculate the variance for each SKU in each location, in units and in value.
- Recount large gaps with a second person before acting on them.
- Find the root cause using the table below.
- Adjust with a reason code, with approval for adjustments above an agreed value.
- Fix the cause and report the variance trend, not just the adjustment.
Variance = physical count − system quantity
Variance % = |variance| ÷ system quantity × 100
Inventory accuracy = locations (or SKUs) where system matches shelf ÷ locations counted
Worked example (illustrative figures). The system shows 500 units of a SKU in one warehouse. The count finds 482: a variance of −18 units, or 3.6%. A recount finds 484, so the confirmed gap is 16 units. Investigation finds 12 units on a returns bench, received back from customers but never scanned into stock: they are moved into the right status by scan, not written off. The remaining 4 units cannot be traced and are adjusted out with a shrinkage reason code. The fix: no return leaves the returns bench without a scan. Without the investigation, all 16 units would have been written off, and the returns gap would have opened again next month.
SECTION 03Reconciling across warehouses, 3PLs and marketplace stock
In brief: Reconcile each warehouse separately, account for stock in transit between them, compare 3PL stock reports against your own records, and reconcile marketplace-held stock, such as Amazon FBA or Flipkart FBF, against the marketplace's inventory and settlement reports, since you cannot count it yourself.
- Each location on its own. Totals across all warehouses can match while two sites are both wrong in opposite directions.
- Stock in transit. Units shipped from one warehouse but not yet received at another belong to neither shelf. Track them as in transit until the receiving scan, or they show up as a loss at one site and a gain at the other.
- 3PL warehouses. Compare the 3PL's stock report with your system on the same date, SKU by SKU, and agree in the contract how discrepancies are investigated and who bears the loss.
- Marketplace-held stock. You cannot count stock in an FBA or FBF warehouse. Instead, reconcile what you sent against what the marketplace received, and track units it reports as lost, damaged, disposed of or returned. Units lost in the marketplace's network can usually be claimed back, but only within the marketplace's time limits.
Marketplace stock is where inventory and payment reconciliation overlap: the missing units show up first in the marketplace's reports and settlements. EasyEcom's marketplace dispute workflow uses settlement reconciliation to find those units so claims can be filed in time.
SECTION 04What causes inventory discrepancies
In brief: Most inventory discrepancies come from process gaps, not theft: goods received by paperwork instead of count, returns put back without a scan, picks or putaways to the wrong bin, unrecorded kitting, unit-of-measure mix-ups and channel sync delays. Shrinkage from theft or damage is real but usually a smaller share.
| Symptom | Likely cause | Fix |
|---|---|---|
| Short right after a delivery | Received by the supplier's paperwork, not by count | Scan-based receiving against the PO and an accurate GRN |
| Extra units found near returns | Returns put back without being scanned in | No return leaves the bench without a scan and a grade |
| One SKU over, a similar SKU under | Mis-pick, mis-putaway or swapped labels | Scan to confirm at every pick and putaway; separate look-alike SKUs |
| Stock found in the wrong bin | Putaway or moves not scanned | Directed putaway with scan; record every bin-to-bin move |
| Components short, kits over | Kitting or de-kitting not recorded | Record kit builds as production in the system |
| Counts off by a multiple | Case and unit quantities mixed up | Record unit-of-measure breaks when cases are opened |
| Oversold online while stock is on the shelf | Channel sync lag or reservations not released | Real-time sync; release reservations on cancellation |
| Marketplace shows fewer units than you sent | Shortfall at the marketplace warehouse, or loss in its network | Reconcile shipments against receipts; claim within the time limit |
| Unexplained loss in high-value SKUs | Theft or damage (shrinkage) | Tighter controls; see inventory shrinkage |
Record the cause of every adjustment with a reason code. After a few months, the codes show which process is leaking, which is far more useful than the adjustment total alone.
SECTION 05Reconciliation, cycle counts and full counts
In brief: A physical inventory count counts everything at once; a cycle count counts a few locations at a time on a schedule. Both produce a count. Inventory reconciliation is what happens next: comparing that count with the system, investigating the gaps and correcting the record. Counting without reconciling leaves the causes in place.
Most eCommerce warehouses now rely on frequent cycle counts, with fast movers and high-value SKUs counted more often, and keep a full physical count for year-end or audit needs. Each count feeds the same reconciliation steps. Our guide to cycle counting covers methods and how often to count.
How often to reconcile: reconcile every cycle count the same day; reconcile 3PL and marketplace stock at least monthly; run a full reconciliation after a physical count, a system migration or a peak season. The cadence that matters most is speed: a gap investigated the day it is found is far easier to explain than one found at year-end.
SECTION 06Automating inventory reconciliation
In brief: To automate inventory reconciliation, record every stock movement by scan, keep stock in clear statuses, generate recounts automatically for bins with discrepancies, produce a reconciliation report by status, require reason codes and approvals for adjustments, and reconcile marketplace settlements to find units lost in marketplace warehouses.
Automation does not remove the count; it removes the spreadsheet work around it and makes discrepancies rarer. The biggest lever is upstream: when receiving, putaway, picking, returns and transfers are all scanned, there are far fewer unrecorded movements to find later. The rest is reporting and control: the system shows the variance by SKU, location and status, triggers a recount where needed, and keeps an audit trail of every adjustment.
SECTION 07Where EasyEcom fits
In brief: EasyEcom records every stock movement by scan, provides an Inventory Reconciliation Report with status-wise columns and an Inventory Ledger of every adjustment, and creates cycle counts automatically for bins with discrepancies. For marketplace stock, EasyReco reconciles FBA and marketplace settlements to find units lost or damaged in the network.
In EasyEcom's warehouse management system, receiving, putaway, picking and returns are all recorded by scan. The Inventory Reconciliation Report compares stock across statuses, and the Inventory Ledger keeps an audit trail of every adjustment; both are available on every plan. The Cycle Count module can create counts automatically for bins affected by a discrepancy. Relaxo reached 100% inventory accuracy and more than 99% bin-level accuracy across its warehouses on EasyEcom; Redtape runs at 99.99% bin-level accuracy with cycle counts that run themselves; Minimalist lifted cycle-count accuracy from 70% to 98.8%.
Want your system stock to match your shelves? Book a demo.
Frequently asked questions
What is inventory reconciliation?
Inventory reconciliation is the process of comparing the stock recorded in your system with the stock physically on hand, investigating every difference and correcting the record with a reason. In India it is often called stock reconciliation or physical stock verification. Its goal is an accurate record and fewer repeat discrepancies.
How do you do inventory reconciliation?
Set a cut-off, count physical stock by bin, pull the system quantity at the same moment, calculate the variance per SKU and location, recount large gaps, find the root cause, adjust the record with a reason code and approval, and fix the process that caused the gap so it does not recur.
How often should you reconcile inventory?
Reconcile every cycle count the same day it is done, reconcile 3PL and marketplace-held stock at least monthly, and run a full reconciliation after a physical count, a system migration or a peak season. Fast movers and high-value SKUs need more frequent counts and reconciliation than slow movers.
What causes inventory discrepancies?
Most inventory discrepancies come from process gaps: goods received without a proper count, returns restocked without a scan, picks or putaways to the wrong bin, unrecorded kitting, case and unit mix-ups, and delays in syncing channels. Theft and damage cause some loss, but usually less than process errors.
How do you automate inventory reconciliation?
Scan every stock movement, keep stock in clear statuses such as sellable, reserved and damaged, trigger recounts automatically for bins with discrepancies, use a reconciliation report by SKU, location and status, require reason codes and approvals for adjustments, and reconcile marketplace settlements to catch units lost in marketplace warehouses.
What is the difference between inventory reconciliation and payment reconciliation?
Inventory reconciliation matches the stock in your system to the stock on your shelves. Payment reconciliation matches orders, fees and refunds to the money marketplaces and payment providers actually pay you. They overlap for marketplace-held stock, where units lost in the marketplace's warehouse show up in its reports and settlements.