New ยท Business alerts check your account every day and send you a weekly email summary. see how it works
Blog/Your listings/How to Download the Amazon FBA Inventory Report
Your listingsTutorial

How to Download the Amazon FBA Inventory Report

How to download the Amazon FBA inventory report, which file answers your question, and the two ledger settings that return an empty download.

How to Download the Amazon FBA Inventory Report

18 months

of movements in the Inventory Ledger Detailed View

MONTHLY

the ledger default period, so a daily count needs it changed

Dec 27, 2024

when the Global FBA Inventory report was retired

Key takeaways

  • FBA Inventory is a near real time snapshot of active inventory. Two downloads an hour apart can differ.
  • Inventory Ledger Detailed View holds 18 months of movements and filters by event type, FNSKU or MSKU.
  • The ledger defaults to COUNTRY and MONTHLY. A date range that does not match the period can return an empty file.
  • Units of an archived SKU only appear in the archived variant of the report, which includes all inventory.
  • The Global FBA Inventory report was retired on December 27, 2024 and its data moved into the FBA Inventory report.

Before you start

  • A Professional selling account with FBA inventory in the store you want to report on.
  • A user role with access to Reports in Seller Central, set under Settings and User Permissions.
  • The right store selected in the top bar: one report covers one store at a time.
  • A spreadsheet tool that can import tab delimited text and keep SKU columns as text.

Step by step

  1. Open the Fulfillment reports pageUse the menu at the top left of Seller Central, select Reports and then Fulfillment. Amazon Fulfillment Reports opens in a new tab, with the files grouped in the left sidebar.Reports > Fulfillment
  2. Expand the Inventory section before you decideThe Inventory group shows only a few reports until you select show more. Most of the inventory files, including the ledger, are hidden behind that link, which is why the report you want looks missing.Reports > Fulfillment > Inventory
  3. Request FBA Inventory for a snapshot of todayFBA Inventory, also listed as Manage FBA Inventory, is the current state of active inventory: afn-fulfillable-quantity, afn-reserved-quantity, afn-unsellable-quantity, the three inbound columns and per-unit-volume. It took over the data of the retired Global FBA Inventory report.Reports > Fulfillment > Inventory > Manage FBA Inventory
  4. Switch to the archived version when a SKU is missingThe standard report covers active, non archived listings only. The archived variant of the same report contains all inventory including archived listings, which is where units of an archived SKU reappear.Reports > Fulfillment > Inventory > Manage FBA Inventory (archived)
  5. Open Inventory Ledger when you need a date instead of a snapshotSummary View gives Starting Warehouse Balance, Receipts, Customer Shipments, Customer Returns, Warehouse Transfer In/Out, Found, Lost, Damaged, Disposed and Ending Warehouse Balance for the range you choose.Reports > Fulfillment > Inventory > Inventory Ledger
  6. Set the two options that change the answerLocation defaults to COUNTRY: set it to FC to see each fulfillment center. The time period defaults to MONTHLY: set DAILY or WEEKLY for a shorter range. A range that does not match the period can return an empty file.Reports > Fulfillment > Inventory > Inventory Ledger
  7. Change the ledger to Detailed View to follow one unitDetailed View holds 18 months of movements and filters by event type (Adjustments, CustomerReturns, Receipts, Shipments, VendorReturns, WhseTransfers) or by one FNSKU or MSKU. Reconciled and Unreconciled Quantity tell you if a discrepancy is still open.Reports > Fulfillment > Inventory > Inventory Ledger
  8. Add Reserved and Stranded when the totals do not add upFBA Reserved Inventory splits reserved units into reserved_customerorders, reserved_fc-processing and reserved_staging. FBA Stranded Inventory gives stranded-reason, date-stranded and Date-to-take-auto-removal, the date Amazon acts on its own.Reports > Fulfillment > Inventory
  9. Pull Inventory Health for the fee sideFBA Manage Inventory Health adds sales over 7, 30, 60 and 90 days, inbound statuses, estimated storage and long term storage fees and the age buckets. It is not available in the NL, PL, SE or BE stores.Reports > Fulfillment > Inventory > Inventory Health
  10. Import the file as text, never by double clickingThese are tab delimited flat files. Import as text and set the SKU, FNSKU and ASIN columns to text first, or a SKU like 0012-A loses its leading zero. Keep the original download as evidence for a future case.

There is no single button that downloads your FBA inventory. When a seller looks for how to download the Amazon FBA inventory report, the real question is usually narrower: how many units are sellable right now, or how many were in the warehouse on a given date. Those are two different reports, and picking the wrong one is why the number never matches the one in the next tab.

Everything lives in the same place: the Fulfillment reports page in Seller Central, reached from Reports, then Fulfillment. The left sidebar groups the files by what they describe, and the Inventory section hides most of its list behind a "show more" link, which is why the report you want often looks missing. The menu path and the report names were confirmed by sellers in the Seller Forums.

Which Amazon FBA inventory report answers your question

The snapshot report is called FBA Inventory, and it is also listed as Manage FBA Inventory. In the Selling Partner API it is the report type GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA, and Amazon's own FBA report documentation describes it as the current details of active, non archived inventory, including condition, quantity and volume, updated in near real time. It is a photograph, not a ledger. Request it twice an hour apart and the two files can disagree, because units moved.

The history report is the Inventory Ledger. Amazon's documentation calls it "like a bank statement of your inventory", and the Summary View carries exactly the columns an accountant asks for: Starting Warehouse Balance, Receipts, Customer Shipments, Customer Returns, Warehouse Transfer In/Out, Found, Lost, Damaged, Disposed and Ending Warehouse Balance.

Between those two sit the reports that explain a specific gap. FBA Reserved Inventory splits reserved units into reserved_customerorders, reserved_fc-processing and reserved_staging. FBA Stranded Inventory gives you stranded-reason, date-stranded and Date-to-take-auto-removal, which is the field that tells you when Amazon will act on its own. FBA Manage Inventory Health, the report type GET_FBA_INVENTORY_PLANNING_DATA, is the fee view: sales over 7, 30, 60 and 90 days, inbound statuses, estimated storage and long term storage fees, and the inventory age buckets. That last one is not available in the NL, PL, SE or BE stores.

The two settings that decide what the ledger shows you

The Inventory Ledger has two options that quietly change the answer. The first is aggregateByLocation, which defaults to COUNTRY: your units come back as one national total unless you switch it to FC to see each fulfillment center. The second is aggregatedByTimePeriod, which defaults to MONTHLY. DAILY and WEEKLY exist, and if you ask for a date range that does not line up with the period you selected, Amazon's inventory report reference warns the report can come back empty. An empty ledger is almost never an empty warehouse. It is usually a mismatched date range.

For a count on one specific day, the Summary View set to DAILY is the file to request. For an audit of what happened to a unit, switch the report type to Detailed View, which holds 18 months of historical movements and can be filtered by eventType (Adjustments, CustomerReturns, Receipts, Shipments, VendorReturns, WhseTransfers) or by a single FNSKU or MSKU. It also carries Reconciled Quantity and Unreconciled Quantity, the two columns that tell you whether Amazon has finished investigating a discrepancy.

Which units does the report not explain?

See my inventory

Why your FBA inventory report is missing a SKU

The snapshot report covers active, non archived listings only. Archive a listing and its units stop appearing, which looks exactly like inventory that disappeared. The fix is the archived version of the same report, GET_FBA_MYI_ALL_INVENTORY_DATA, which contains all inventory including archived. If the totals still do not line up, the cause is usually one of the four listed in our guide to why the FBA inventory report does not match Manage Inventory.

Two other cases look like missing units and are not. Units sitting in Reserved FC Processing are in the warehouse but not sellable, so they show up in afn-reserved-quantity and never in afn-fulfillable-quantity. And stranded inventory is counted in the warehouse while no offer exists for it, so it is invisible in any report that starts from your active listings.

One historical note that still trips people up: the Global Fulfillment by Amazon (FBA) Inventory report was retired on December 27, 2024, and its data moved into the FBA Inventory report. Any process or spreadsheet still pointing at the old file has been broken since that date.

Open the file without breaking your SKUs

These reports download as tab delimited flat files. Double clicking one and letting a spreadsheet guess is how a SKU like 0012-A becomes a number and a leading zero vanishes for good. Import the file as text, set the SKU, FNSKU and ASIN columns to text before the import runs, and keep the original download. The file Amazon generated is your evidence if you ever open a case about a quantity.

What to check after the download

Three checks catch most bad numbers. Compare afn-fulfillable-quantity in the snapshot against the sellable figure on screen in Manage FBA Inventory; a gap of a few units is normal in a near real time report, a gap of hundreds is not. Then total the ledger: Starting Warehouse Balance plus Receipts and Customer Returns, minus Customer Shipments, Lost, Damaged and Disposed, should land on Ending Warehouse Balance. If it does not, the Detailed View filtered by eventType Adjustments shows you where the difference entered.

The last check is the one most sellers skip: run the same download next month. A single snapshot tells you what you hold. Two snapshots and a ledger tell you what is moving, which is the whole point of FBA inventory management and the only way a storage bill stops being a surprise.

โ€œThe Inventory Ledger Report is like a bank statement of your inventory.โ€

Amazon SP-API documentation

Sources

SellerKey Team

Hey! We're the SellerKey Team

Data & product at SellerKey.co

๐Ÿ“Š We build SellerKey.

The team behind SellerKey. We write about fees, margin, inventory and ads for Amazon sellers.

Keep reading

Related to Your listings

View the whole blog
Offers Not Showing for Amazon Business Customers
Your listings6 min

Offers Not Showing for Amazon Business Customers

Why your offers are not showing for Amazon Business customers: the 90% business hour delivery rule, live since September 30, 2026, and how to recover.