How to Use the AWD Inventory Ledger Report to Track Warehouse Stock Movements
Amazon's AWD Inventory Ledger report tracks all inventory events across distribution centers for up to 18 months. It offers detailed and summary views to help sellers monitor stock movements, investigate discrepancies, and support reimbursement claims.
Overview
Amazon Warehousing and Distribution (AWD) provides sellers with an Inventory Ledger report that tracks every event affecting inventory levels across distribution centers. This report covers up to 18 months of historical data, giving sellers visibility into how their stock has moved, been adjusted, or changed status over time. Whether you need to investigate a discrepancy, file a reimbursement claim, or simply understand your inventory flow, this report is an essential tool for AWD users.
Key Points / What Sellers Need to Know
- Two report versions available — The ledger comes in a Detailed View, which shows granular event-level data, and a Summary View, which aggregates inventory changes over a chosen time period at the SKU level.
- Up to 18 months of history — Sellers can pull inventory movement records going back a year and a half, making it useful for long-term trend analysis and dispute resolution.
- Multiple filter options — Reports can be filtered by MSKU, FNSKU, ASIN, event type, and date range, allowing sellers to zero in on specific products or incidents.
- Event types tracked — The report captures received, departed, lost, found, and damaged inventory events, covering the full lifecycle of stock in AWD facilities.
- Reimbursement support — The detailed view includes reference IDs and shipment IDs that can be used when submitting reimbursement claims for lost or damaged inventory.
Detailed View: Event-Level Inventory Tracking
The detailed view of the AWD Inventory Ledger report breaks down every individual event that affected your inventory in distribution centers. Each row in the report represents a specific occurrence — such as units being received into a facility, departing to an FBA fulfillment center, or being flagged as lost or damaged. The report includes key identifiers like MSKU, FNSKU, and ASIN alongside operational details such as the shipment ID, distribution center ID, number of boxes, and number of units involved. Sellers can use STAR-prefixed reference IDs for received shipments and FBA-prefixed IDs for departed shipments, while lost and found events carry their own adjustment IDs. This level of detail makes the report particularly valuable when investigating inventory discrepancies or building a case for reimbursement.
Analysis & Recommendations
Why This Matters
Sellers using AWD need accurate inventory tracking to detect losses, file reimbursement claims, and plan replenishment. This report provides the documentation required to recover costs from lost or damaged stock in distribution centers.
Key Takeaways
- The AWD Inventory Ledger has two views: a detailed event-level report and a summary SKU-level balance report
- Reports cover up to 18 months of inventory history and can be filtered by product identifiers and event types
- Shipment and adjustment IDs in the detailed view are essential for filing reimbursement claims
- The summary view uses positive and negative numbers to show how inventory balances changed over a selected period
Recommended Actions
- →Review your AWD Inventory Ledger monthly to catch discrepancies early and file reimbursement claims using the reference IDs provided
- →Use the summary view to monitor starting and ending balances at the SKU level and identify patterns in lost or damaged inventory
- →Download reports in spreadsheet format to build tracking systems for inventory movements and reimbursement documentation
Comments
Join the discussion
Log in or create an account to share your thoughts on this update.
No comments yet. Be the first to share your thoughts!