Inventory Ledger Summary Data

The Inventory Ledger tracks where your FBA units physically are and how they moved: receipts, customer shipments, returns, transfers between warehouses, units found, lost, damaged or disposed. Unlike FBA Inventory Summaries, which reports the stock each marketplace can sell, the ledger reports the stock stored in each location, so it is the right source when the question is "where is my stock?" or "why did it change?".

DataHawk exposes the ledger summary at two levels of location, from two versions of the same Amazon report (GET_LEDGER_SUMMARY_VIEW_DATA):

Key facts

Grain

disposition splits each SKU's stock by condition: SELLABLE, CUSTOMER_DAMAGED, WAREHOUSE_DAMAGED, CARRIER_DAMAGED, DISTRIBUTOR_DAMAGED, DEFECTIVE and EXPIRED. Sum over dispositions for all units in a location, or filter on SELLABLE for sellable units only.

How the balance works

For each row, the ending balance is the starting balance plus the day's movements:

ending_warehouse_balance = starting_warehouse_balance
                         + receipts + customer_shipments + customer_returns + vendor_returns
                         + warehouse_transfer_in_out + found + lost + damaged + disposed
                         + other_events + unknown_events

Movements that remove units from the location (shipments, transfers out, lost, disposed) are negative. in_transit_between_warehouses is reported for information and is not part of this calculation.

Columns

Identifiers

Product and location

Balances and movements

Sync

Example queries

Sellable stock by country on the latest ledger date

SELECT COUNTRY, MSKU, SUM(ENDING_WAREHOUSE_BALANCE) AS SELLABLE_UNITS
FROM SELLING_PARTNER.SELLER_INVENTORY_LEDGER_SUMMARY
WHERE DISPOSITION = 'SELLABLE'
  AND DATE = (SELECT MAX(DATE) FROM SELLING_PARTNER.SELLER_INVENTORY_LEDGER_SUMMARY)
GROUP BY COUNTRY, MSKU
ORDER BY SELLABLE_UNITS DESC;

Stock by fulfillment center for one SKU

SELECT DATE, FULFILLMENT_CENTER, DISPOSITION, ENDING_WAREHOUSE_BALANCE
FROM SELLING_PARTNER.SELLER_INVENTORY_LEDGER_SUMMARY_BY_FC
WHERE MSKU = 'YOUR_SKU'
  AND DATE >= DATEADD(day, -7, CURRENT_DATE())
ORDER BY DATE DESC, ENDING_WAREHOUSE_BALANCE DESC;

What moved my stock in a country last week?

SELECT MSKU,
       SUM(RECEIPTS) AS RECEIPTS,
       SUM(CUSTOMER_SHIPMENTS) AS CUSTOMER_SHIPMENTS,
       SUM(CUSTOMER_RETURNS) AS CUSTOMER_RETURNS,
       SUM(WAREHOUSE_TRANSFER_IN_OUT) AS TRANSFERS,
       SUM(LOST + FOUND + DAMAGED + DISPOSED) AS ADJUSTMENTS
FROM SELLING_PARTNER.SELLER_INVENTORY_LEDGER_SUMMARY
WHERE COUNTRY = 'US'
  AND DATE BETWEEN '2026-10-01' AND '2026-10-07'
GROUP BY MSKU;

For the individual events behind these totals, query SELLER_INVENTORY_LEDGER_DETAIL with the same SKU, country and dates.

FAQ