Asking Amazon to return your inventory is one thing; actually receiving it is another. A single removal order for 1,000 units might arrive in 50 different boxes, via 3 different carriers, over a span of 6 weeks. It’s a logistical nightmare to track. The FBA Removal Shipment Detail Report is your packing slip. It provides the carrier tracking numbers and box-level details for every unit leaving the Fulfillment Center. This guide shows you how to stop guessing where your inventory is. We'll cover how to automatically pull your Removal Shipment Detail report directly into Google Sheets to build a live "Inbound Recovery" dashboard.
How to Automatically Sync & Import the Removal Shipment Detail 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 Shipment 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: removal-date, shipment-date, order-id, sku, carrier, tracking-number, quantity-shipped, and disposition.
Step 5.
Set your schedule. Choose how often you want to export and refresh your shipment tracking data—we recommend a Daily schedule so your warehouse team always has the latest tracking numbers for incoming deliveries.
Step 6.
Save your data pipeline. This will export your removal logistics data from Seller Central into spreadsheets instead of dealing with CSVs. Your tracking dashboard will be up to date forever.
What is the Amazon Removal Shipment Detail Report?
This report is the "logistics layer" of your removal orders. While the Removal Order Detail report tells you the status of the request (e.g., "Pending"), this report tells you the status of the movement.
It links specific SKUs to specific Tracking Numbers. This is critical because Amazon rarely ships a removal order in one go. They ship from multiple Fulfillment Centers as the items become available. This report is the only way to know that "Box A" contains 5 units of SKU X and "Box B" contains 10 units of SKU Y.
This makes it the single source of truth for answering questions like:
Which carrier (UPS, FedEx, LTL) is delivering my removal order?What are the tracking numbers for the 20 boxes arriving at my warehouse tomorrow?Amazon says they shipped 100 units, but I only received 95. Which tracking number is missing?Is my removal order coming in multiple split shipments?How many units were shipped as "Sellable" vs. "Unsellable"?
How to Analyze & Track Your Removal Shipments 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 "Warehouse Receiving" Manifesto
Your warehouse team hates surprises. Give them a list of exactly what is incoming so they can plan labor and storage space.
How to build it:
Filter: Filter for rows where
shipment-dateis within the last 7 days.Columns: Display
carrier,tracking-number,sku, andquantity-shipped.What it shows you: A precise "Inbound List" for your warehouse staff. They can scan a tracking number and instantly know which SKUs are inside that specific box without opening it.
Template 2: The "Lost in Transit" Detector
If Amazon ships it, but the carrier loses it, you are owed money. You need to match "Shipped" against "Delivered."
How to build it:
Formula: Use a
GOOGLEFINANCEor external tracking API formula (or manual check) to verify the status of thetracking-number.Logic: If
shipment-dateis > 14 days ago AND carrier status is NOT "Delivered", highlight in Red.What it shows you: These are the shipments that vanished. You can now file a claim with the carrier (or Amazon, depending on the account) to get reimbursed for the lost stock.
Template 3: The "Split Shipment" Reconciler
Amazon is notorious for splitting one removal order into dozens of small shipments. This recipe groups them back together.
How to build it:
Pivot Table Rows:
order-id.Pivot Table Values:
COUNT of tracking-numberandSUM of quantity-shipped.What it shows you: You can see that
Order #12345has been split into 12 different shipments totaling 48 units. This prevents you from panicking when the first box arrives with only 4 units inside.
Common workflows this report unlocks
3PL Coordination: Automatically email a list of incoming tracking numbers to your 3PL provider so they can accept the delivery.
Carrier Claims: providing proof of shipment (Tracking ID + Contents) is required when filing a claim for lost/damaged boxes.
Inventory Receiving: Speed up the receiving process by knowing exactly which SKUs are in which tracking number before the truck arrives.
Tax Audit: Prove that inventory physically left Amazon's nexus and entered your facility on specific dates.
FAQ about Amazon Removal Shipment Details
Q: What is the difference between "Removal Order Detail" and "Removal Shipment Detail"?
Order Detail: Tracks the administrative request (Did Amazon say yes/no? Did they cancel it?).
Shipment Detail: Tracks the physical boxes (Tracking numbers, carriers, quantities shipped). Use this one for logistics.
Q: Why do I have multiple tracking numbers for one order? Amazon stores your inventory in dozens of fulfillment centers across the country. When you request a removal, each center ships its portion separately. This report aggregates all those scattered shipments into one view.
Q: Can I track LTL (Pallet) shipments here? Yes. If the carrier is an LTL provider (like ABF Freight), the tracking-numberwill usually be the PRO number or BOL number, which you can use to track the pallet.
Q: Why is the tracking-number column empty? Occasionally, Amazon uses their own internal logistics or a local courier that doesn't provide a standard tracking number immediately. It can also happen if the shipment is still in the "Packing" stage and a label hasn't been generated yet.
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.
