manage-fba-inventory

How to Automatically Pull, Sync, and Analyze Your Amazon "Manage FBA Inventory" Report in Google Sheets

Most inventory reports tell you what is on the shelf right now. But for a supply chain manager, that is only half the picture. You need to know what is on the ocean, what is at the 3PL, and what is currently being unpacked on the receiving dock. The Manage FBA Inventory Report is your complete pipeline view. It tracks the full lifecycle of your stock from the moment you create a shipping plan ("Inbound Working") to the moment it becomes buyable ("Fulfillable"). This guide shows you how to automate your supply chain visibility. We'll cover how to automatically pull your Manage FBA Inventory report directly into Google Sheets to build a live "Pipeline Dashboard."

Amazon Manage FBA Inventory

How to Automatically Sync & Import the Manage FBA Inventory Report to Google Sheets (The Hopted Way)

Using an Amazon to Google Sheets integration like Hopted, you set up the connection once, and your data flows automatically.

Step 1.

Install the Hopted browser extension and sign in using your Google Account.

Step 2.

Securely connect your Amazon Seller Central to Google Sheets using Hopted's integration wizard.

Step 3.

In Google Sheets, from the list of available Amazon Seller Central reports, select "All Orders (New or Updated)" for a specific date range. This can be as recent as the "Last 24 hours" or a custom range going as far back as 1094 days. For this example, we'll select "Include records for the last 30 days".

Step 4.

Select the critical columns for pipeline tracking: sku, product-name, afn-fulfillable-quantity, afn-inbound-working-quantity, afn-inbound-shipped-quantity, afn-inbound-receiving-quantity, afn-reserved-quantity, and afn-listing-exists.

Step 5.

Set your schedule. Choose how often you want to export and refresh your supply chain data—we recommend a Daily schedule so you can track when shipments move from "Shipped" to "Receiving."

Step 6.

Save your data pipeline. This will export your full inventory lifecycle from Seller Central into spreadsheets instead of dealing with CSVs. Your restock planning will be up to date forever.

What is the Amazon Manage FBA Inventory Report?

This report provides a near real-time view of your inventory levels, but unlike other reports, it focuses on the Fulfillment Network (AFN) status codes.

It allows you to distinguish between stock that is:

Fulfillable: Ready to sell immediately (Prime).
Inbound Working: A shipping plan is created, but not yet shipped (Labeling stage).
Inbound Shipped: Handed to the carrier (UPS/FedEx/Freight) but not yet at Amazon.
Inbound Receiving: Arrived at the Amazon dock and is being scanned.

This granular breakdown makes it the single source of truth for answering questions like:

I have 0 units available, but 500 are "Inbound." Are they on the truck (Shipped) or stuck on the dock (Receiving)?
Do I have "Ghost Inventory" where I have physical stock (afn-warehouse-quantity) but the listing is broken (afn-listing-exists = No)?
What is my "True" Days of Cover if I include the stock arriving next week?
Is my 3PL holding back stock, or is the shipment actually "Working"?

How to Analyze & Track Your Inventory Pipeline in Spreadsheets

Now that you have a live feed, you can move from data entry to data analysis. This is the real power of analyzing your Amazon Seller Central data in spreadsheets and building your Amazon excel-like template.

Here are 3 Amazon spreadsheet template ideas you can build immediately:

Template 1: The "True" Days of Coverage Calculator

Standard restock tools often ignore "Inbound" stock, leading you to over-order. This recipe counts what's coming.

Ingredients:
- Tab 1: Manage FBA Inventory Report (This report).
- Tab 2: Sales & Traffic Report (For daily sales velocity).
The Formula:
- Total Pipeline Stock = afn-fulfillable-quantity + afn-inbound-shipped-quantity + afn-inbound-receiving-quantity.
- Days of Cover = Total Pipeline Stock / [Daily Sales Velocity].
What it shows you: You might have 0 units on the shelf (Panic!), but 1,000 units in "Receiving." Your Days of Cover isn't 0; it's actually 30. You don't need to air-freight emergency stock.

Template 2: The "Listing Health" Hard Check

This report contains a specific column: afn-listing-exists. This is a binary check (Yes/No) on whether the inventory is connected to a live catalog entry.

Filter: afn-warehouse-quantity > 0 AND afn-listing-exists = "No".
What it shows you: Stranded Inventory. This is often faster and more reliable than the standard Stranded report because it looks at the raw database connection. If this flags "No," you are paying storage fees on items that technically don't exist in your catalog.

Template 3: The "Receiving" Bottleneck Detector

Amazon FBA centers can get backed up in Q4. You need to know if your stock is stuck on the dock.

Logic: Track the afn-inbound-receiving-quantity column over time.
Alert: If afn-inbound-receiving-quantity > 0 for the same SKU for more than 14 days.
What it shows you: Your shipment has arrived but Amazon isn't checking it in. This is your trigger to open a reconciliation case or investigate if the shipment was lost at the facility.

Common workflows this report unlocks

3PL Accountability: Check afn-inbound-shipped-quantity to verify that your 3PL actually handed the boxes to the carrier.
Cash Flow Management: Inbound Shipped inventory is an asset on your balance sheet that is "In Transit." Use this report to give your accountant exact end-of-month inventory values, even for stock on the water.
Removal Order Verification: Monitor afn-unsellable-quantity. If this number is growing, you need to create a Removal Order to clean up your storage limits.

FAQ about Manage FBA Inventory Report

Q: What does "AFN" stand for? AFN stands for Amazon Fulfillment Network (FBA). MFN stands for Merchant Fulfillment Network (FBM). This report uses these prefixes to differentiate stock you ship (mfn-listing-exists) from stock Amazon ships (afn-fulfillable-quantity).

Q: What is the difference between "Inbound Working" and "Inbound Shipped"?

Inbound Working: You have created the shipment in Seller Central, but (theoretically) haven't shipped it yet. It is in the "Prep" phase.
Inbound Shipped: You have marked the shipment as "Shipped" or the carrier has scanned the label. It is in transit.

Q: Why is afn-listing-exists set to "No"? This usually happens if you accidentally deleted the SKU from your "Manage Inventory" page, or if you converted the listing to "Merchant Fulfilled" while FBA stock was still in the warehouse. It results in Stranded Inventory.

Q: Does afn-total-quantity include Unsellable units? Yes. afn-total-quantity is usually the sum of Fulfillable + Unsellable + Reserved. Be careful using this number for "Sales Availability" calculations, as it includes broken items.

Q: How is Hopted different from other Amazon seller software? Most Amazon tools force you into their rigid dashboards and pre-built reports. You have to change your workflow to fit their software. With Hopted it is the opposite. It’s a flexible data automation layer that works directly inside your existing spreadsheets (like Google Sheets). Instead of forcing you to learn a new system, Hopted brings all your scattered Amazon data (sales, inventory, pipelines) right to you. You can build the fully custom supply chain models you need, not the ones a rigid tool dictates.