If you sell through Fulfilled by Amazon (FBA), the Inventory Ledger is the most useful report most sellers never open. It works like a bank statement for your stock: every unit that comes into, moves between, or leaves an Amazon warehouse shows up as a line. Read it well and you'll know exactly where your stock is and how fast each warehouse is selling.
Where to find it
In Seller Central go to Reports → Fulfilment → Inventory Ledger. You can view it online or download it. For day-to-day decisions use these settings:
- Type of report: Summary view (one row per day, product and warehouse)
- Aggregate by location: Fulfilment centre, not Country, so you see each warehouse
- Time period: Daily
- Format: the .txt download, because the .csv version can drop leading zeros in SKUs and FNSKUs
What each column means
| Column | In plain English |
|---|---|
| Starting / Ending Warehouse Balance | Units in that warehouse at the start and end of the day |
| Receipts | Units Amazon received from your shipments |
| Customer Shipments | Units sent to customers (shown as a negative number) |
| Customer Returns | Units customers sent back to that warehouse |
| Warehouse Transfer In/Out | Units Amazon moved between its own warehouses |
| Found / Lost / Damaged / Disposed | Adjustments: units Amazon found, lost or wrote off |
| Disposition | SELLABLE or a damaged state such as CUSTOMER_DAMAGED |
| Location | The fulfilment centre code, for example BLR8 or BOM7 |
Three things to do with it
1. Find days of stock left per warehouse
Add up Customer Shipments for the last 30 days per product and warehouse, divide by 30, and you have units sold per day there. Divide today's sellable Ending Balance by that number and you get days of stock left. A product can show 500 units overall and still be out of stock in Bengaluru, which quietly slows delivery and costs sales.
2. Decide what to send where
Decide how many days of stock each warehouse should hold, say 30. Units to send = units per day × 30 − current stock. Sort by the biggest shortfall and you have a replenishment plan.
3. Spot leaks
Watch the Lost and Damaged columns and the non-sellable dispositions. Units Amazon lost or damaged in its warehouses may be eligible for reimbursement, so keep an eye on them.
Common mistakes
- Using the Country view and missing that one region is empty.
- Counting today: the ledger runs a day or two behind, so the last day can look incomplete.
- Treating "- Mapped" SKUs separately when they are really the same product.