How to Automatically Sync & Import the FBA Removal Order Details 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 "FBA Removal Order Detail" for a specific date range. This can be as recent as the "Last 24 hours" or a custom range going as far back as 35 months. For this example, we'll select "Include records for the last 30 days".

Step 4.

Select columns that you need: request-date, order-id, order-type (Return, Disposal, or Liquidation), sku, disposition (Sellable vs Unsellable), requested-quantity, shipped-quantity, cancelled-quantity, and order-status.

Step 5.

Set your schedule. Choose how often you want to export and refresh your removal status—a Weekly schedule is usually sufficient as removal operations are slower than sales.

Step 6.

Save your data pipeline. This will export your removal history from Seller Central into spreadsheets instead of dealing with CSVs. Your unfulfillable inventory tracking will be up to date forever.

What is the Amazon FBA Removal Order Details Report?

This report provides the line-item status of every removal order you have placed. Whether you asked Amazon to Returnthe items to your warehouse, Dispose of them, or Liquidate them via FBA Liquidations, this report tracks the progress of that request.

Unlike the "Removal Shipment Detail" report (which tracks the boxes/tracking numbers), this report tracks the fulfillment of the request itself. It answers the critical question: "Did Amazon actually honor my request to remove these 50 units?"

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

• Why am I still paying storage fees on items I asked to remove 2 months ago?

• Did Amazon cancel my removal order because the bin couldn't be located?

• How many units of "Unsellable" stock are currently in limbo (In-Process)?

• Are my "FBA Liquidations" orders actually completing, or are they being cancelled?

• What is the discrepancy between what I requested and what was actually shipped?

How to Analyze & Track Your Removal Orders 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 "Silent Cancellation" Trap

Amazon often cancels removal orders if they are too busy or cannot find the stock. When they cancel, the stock goes back into your active inventory, and storage fees resume immediately. You need to catch this.

How to build it:

• Filter: Filter for rows where cancelled-quantity is greater than 0.

• Action: Highlight these rows in Red.

• What it shows you: These are units you thought were leaving but are still accruing fees. You must immediately re-submit a removal order for these items.

Template 2: The "Limbo" Dashboard

Removals can take 14 to 30 days (or longer in peak season). This dashboard tells you how much stock is currently "In Process."

How to build it:

• Formula: Create a column Remaining to Ship = requested-quantity - (shipped-quantity + disposed-quantity + cancelled-quantity).

• Pivot Table: Rows = order-id. Values = SUM of Remaining to Ship. Filter for values > 0.

• What it shows you: A list of open orders that haven't fully cleared. If an order has been "In Process" for more than 45 days, you should open a Seller Support case to investigate lost inventory.

Template 3: The "Unsellable" Audit

Are you throwing away money? Tracking your "Disposals" vs "Returns" helps you decide if you should fix your returns settings.

How to build it:

• Pivot Table Rows: sku or product-name.

• Pivot Table Columns: order-type (Return, Disposal, Liquidate).

• Pivot Table Values: SUM of requested-quantity.

• What it shows you: If you see you are "Disposing" of hundreds of units of a high-value item, it might be more profitable to change your settings to "Return" them to your warehouse, refurbish them, and resell them on another channel.

Common workflows this report unlocks

• Storage Fee Auditing: Prove to Amazon that you requested removal on Date X, so you shouldn't be charged storage fees for the months the items were stuck in "Pending."

• Liquidation Reconciliation: Track exactly which units entered the liquidation program to verify against your payment reports later.

• Inventory Reconciliation: If cancelled-quantity is high due to "Inventory not found," this is your trigger to file a "Lost Inventory" claim for reimbursement.

• Tax Write-offs: Use the "Disposal" records as proof of destroyed inventory for tax deduction purposes.

FAQ about Amazon FBA Removal Orders

Q: Why did Amazon cancel my removal order? Common reasons include: the inventory was in a trans-shipping status between fulfillment centers, the inventory could not be found (ghost inventory), or the fulfillment center was too busy (peak season restrictions) to process removals.

Q: How long do removal orders take? Amazon officially states it can take 14 business days for standard removals and 30 business days or more during peak periods (Prime Day, Q4). However, "In Process" status can sometimes last months without automation to track it.

Q: What is the difference between "Removal Order Detail" and "Removal Shipment Detail"?

• Removal Order Detail: Tracks the status of your request (Pending, Cancelled, Complete) and quantities. Use this to manage inventory levels.

• Removal Shipment Detail: Tracks the logistics (Carrier, Tracking Number, Number of boxes). Use that one to track the UPS truck coming to your warehouse.

Q: Do I pay for cancelled removal orders? No, you are not charged the removal fee if the order is cancelled. However, you are charged monthly storage fees for that inventory because it remains in the fulfillment center. This is why tracking cancellations is critical.

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, orders, etc.) right to you. You can build the fully custom reports and automations you need, not the ones a rigid tool dictates.