Inventory reconciliation is the process of comparing the stock your records say you have with the stock you actually have, finding the reason for every difference, and correcting the records. A difference between the two is called an inventory discrepancy. Reconciling regularly keeps you from overselling, shows you where stock is being lost, and for marketplace sellers turns up units that Amazon or Walmart may owe you for.
This guide gives the reconciliation formula, a worked example, a nine-step process, and the reports to use for Amazon FBA and Walmart Fulfillment Services (WFS) inventory. The example uses made-up numbers, so swap in your own.
Why inventory records and real stock drift apart
| Cause | How it shows up | Typical fix |
|---|---|---|
| Supplier short-shipped or sent the wrong item | Received quantity in the system is higher than what arrived | Count every delivery against the purchase order before you receive it |
| Picking and packing errors | One SKU is short, a similar SKU is over | Scan items at packing; check look-alike SKUs together |
| Damage not recorded | Units on the record that nobody can sell | Move damaged units to an unsellable status with a reason |
| Returns handled wrong | Returned units added back as sellable when they are not, or never added back | Inspect returns before restocking |
| Theft or loss (shrinkage) | Small, unexplained losses that repeat | Restrict access; count high-value items more often |
| Channels out of sync | Oversold orders; a marketplace shows stock you no longer have | Keep one stock count per SKU across all channels |
| Bundles and kits | Components run out while the bundle still shows in stock | Make every bundle sale reduce its components |
| Marketplace warehouse loss | Amazon or Walmart reports fewer units than you sent | Check the marketplace reports and claim reimbursement |
| Timing | Units in transit or committed to orders counted twice or not at all | Fix a cutoff time and record what is in transit |
The inventory reconciliation formula
Expected ending stock = starting stock + units received + returns restocked − units shipped − units removed or written off ± transfers between locations
Discrepancy = counted stock − expected ending stock
Variance % = discrepancy ÷ expected ending stock × 100
A negative discrepancy means stock is missing. A positive one usually means a sale, transfer or receipt was recorded but did not happen, or units were found. Both need an explanation before you change the record.
Worked example: reconciling one SKU
A seller reconciles a 12 oz ceramic mug (SKU MUG-12) at the end of the month.
| Line | Units |
|---|---|
| Starting stock (system, 1st of the month) | 500 |
| + Received from supplier (per purchase order) | 300 |
| + Customer returns restocked | 12 |
| − Units shipped to customers | 410 |
| − Damaged units written off | 4 |
| = Expected ending stock | 398 |
| Physical count on the 30th | 381 |
| Discrepancy | −17 units (−4.3%) |
Check: 500 + 300 + 12 − 410 − 4 = 398. Discrepancy 381 − 398 = −17. Variance 17 ÷ 398 = 4.3%.
The investigation finds three causes. The supplier delivered 288 mugs, not 300, but the full purchase order was received in the system (−12): that is a credit to claim from the supplier. Three returned mugs were restocked as sellable but were chipped (−3): they move to unsellable stock. Two mugs cannot be explained (−2): they are written off as shrinkage with a reason. 12 + 3 + 2 = 17, so every unit is accounted for, and the record is corrected to 381.
How to reconcile inventory: 9 steps
- Set the scope and a cutoff. Choose which SKUs and locations you are reconciling and the exact date and time. Note units in transit and units committed to open orders at that moment.
- Pull the records. Starting stock, purchase orders and receipts, shipments, returns, transfers and every manual adjustment for the period.
- Count the stock. Either a full physical count or a cycle count of selected SKUs. See cycle counting for how to rotate counts without closing the warehouse.
- Compare per SKU and per location. Calculate expected stock and the discrepancy with the formula above.
- Investigate the biggest gaps first. Rank by value (discrepancy × unit cost), not by units, so a missing laptop gets checked before a missing pen.
- Correct the records with a reason. Damaged, theft or loss, receiving error, found. Reasons let you see patterns next month.
- Claim what you are owed. Supplier short-shipments, carrier losses, and units lost or damaged in Amazon or Walmart warehouses.
- Fix the root cause. Change the process that caused the largest discrepancy, for example counting deliveries before receiving them.
- Put it on a schedule. Fast sellers and high-value items more often, everything else less often.
How often should you reconcile inventory?
There is no single rule. A practical rhythm for most online sellers: reconcile best sellers and high-value SKUs weekly or monthly with cycle counts, reconcile marketplace warehouse stock monthly against Amazon’s and Walmart’s reports, and do a full count at least once a year, usually at year end so your accountant has a reliable closing inventory value. Reconcile immediately after anything unusual: a move, a system change, a large oversell or a big inbound shipment.
Reconciling Amazon FBA inventory
For stock in Amazon’s fulfillment centers, the source of truth is Amazon’s Inventory Ledger report (Reports > Fulfillment). For each product it shows a starting warehouse balance, every movement in the period (received, customer shipments, customer returns, vendor returns, transfers, found, lost, damaged, disposed and other events) and an ending warehouse balance. Compare it line by line with what you shipped in and what sold.
- Receipts lower than units shipped in point to an inbound shortage.
- Lost or damaged events should match a reimbursement or a replacement. Amazon reimburses eligible items lost or damaged before a customer order at your sourcing cost, up to $5,000 per unit, under its FBA inventory reimbursement policy. Enter your sourcing cost on the Manage Your Sourcing Cost page, or Amazon uses its own estimate.
- Found events can reverse an earlier reimbursement, so match them too.
- In transit between warehouses counts as stock you still own. Amazon’s own example shows the monthly beginning quantity equals the starting warehouse balance plus units in transit between warehouses at the end of the previous month (source).
Timing matters: units lost or damaged in a fulfillment center must be claimed within 60 days, inbound shipment claims within nine months of verified delivery, and customer return claims between 60 and 120 days after the refund. Our Amazon FBA reimbursement guide lists the window for each claim type.
Reconciling Walmart WFS inventory
In Walmart Seller Center, the WFS Inventory page splits each item into Available to sell, Unavailable to sell (for example units pending a review, which Walmart says typically takes 24 to 48 hours, or units moving between fulfillment centers), Reserved units for orders not yet shipped, and Inbound units not yet received. Each item also has an inventory log under Actions.
Walmart also offers a WFS Inventory Reconciliation Report through its API, with SKU-level starting and ending quantities and units sold, lost, returned and adjusted. For inbound shortages, Walmart’s investigation window opens 10 days and closes 50 days after delivery; see how to file a Walmart WFS reimbursement claim.
Reconciling stock across several sales channels
When Shopify, eBay, Walmart and Amazon FBM orders all ship from one warehouse, reconciliation has a second layer: the quantity each channel shows must match the warehouse count, minus any buffer you keep. A count can be right on the shelf and still wrong on a marketplace if a sync failed, which is how overselling starts. Check channel quantities against the warehouse after every reconciliation. If you sell on Shopify, our Shopify inventory management guide explains Shopify’s own inventory states and adjustment reasons.
Reconciliation also changes your books: written-off units raise cost of goods sold and lower the inventory value on your balance sheet. See how to calculate COGS and is inventory a current asset, and agree the treatment with your accountant.
What to look for in inventory reconciliation software
- One stock count per SKU across every sales channel and warehouse, including Amazon FBA, Walmart WFS and 3PLs.
- Adjustments that keep a reason and a history.
- Bundles and kits that reduce their components automatically.
- Low stock alerts, so a missing unit is noticed before a listing sells out.
- A way to track marketplace reimbursement cases, so losses you find become money back.
Reconcile your stock and recover what you’re owed
Crazy Vendor inventory management keeps one stock count across Amazon, Walmart, eBay, Etsy, Shopify, WooCommerce, Magento and Wix, and tracks stock at Amazon FBA, Walmart WFS, 3PLs and your own warehouse. Kits take their pieces out of stock automatically, and low stock alerts flag gaps early.
When reconciliation turns up units lost in Amazon or Walmart warehouses, reimbursements recovery prepares and tracks the FBA and WFS cases. You submit them through the marketplace portal and keep 100% of what is recovered, with no commission.
Plans start at $29/month with a 21-day free trial. See plans and start your free trial, or book a demo to see your stock and open cases in one dashboard.
Related: safety stock formula, what is real-time inventory and Amazon Buy Shipping.
Frequently asked questions
What is inventory reconciliation?
Inventory reconciliation is comparing the stock your records show with the stock you physically have, explaining every difference, and correcting the records so they match reality.
What is an inventory discrepancy?
An inventory discrepancy is the difference between the quantity your system shows and the quantity you count. Common causes are receiving errors, picking mistakes, unrecorded damage, returns, theft, and sales channels that are out of sync.
How do you calculate an inventory discrepancy?
Calculate expected stock as starting stock plus units received and returns restocked, minus units shipped and written off, plus or minus transfers. Then subtract expected stock from the counted stock. Divide by expected stock and multiply by 100 for the variance percentage.
How often should I reconcile inventory?
Many sellers reconcile fast sellers and high-value items weekly or monthly with cycle counts, reconcile marketplace warehouse stock monthly, and do a full count at least once a year, usually at year end.
How do I reconcile Amazon FBA inventory?
Use the Inventory Ledger report in Seller Central. It shows the starting balance, receipts, shipments, returns, transfers, found, lost and damaged units and the ending balance per product. Compare it with what you sent and sold, and file reimbursement claims for eligible lost or damaged units within Amazon’s claim windows.
What is the difference between inventory reconciliation and a cycle count?
A cycle count is counting a small part of your stock on a rotating schedule. Reconciliation is the whole process of comparing counts with records, finding the causes of differences and correcting them. Cycle counts are one way to get the counts reconciliation needs.
Updated November 17, 2026.









