Selling across Europe offers massive scale, but it comes with a massive headache: inventory visibility. If you don't know exactly where your stock is sitting—France, Germany, or Poland—you risk unexpected VAT liabilities, delayed Prime delivery promises, and inflated cross-border fulfillment fees. The Amazon Multi-Country Inventory Report is your GPS for European stock. This guide shows you how to stop guessing and start tracking. We'll cover how to automatically pull your Multi-Country Inventory report directly into Google Sheets to build a live Pan-EU stock dashboard.
How to Automatically Sync & Import the FBA MCI 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 "Multi-Country Inventory Report".
Step 4.
Select columns that you need: Country, Quantity for local fulfilment, Seller SKU, FNSKU, Condition type, and ASIN.
Step 5.
Set your schedule. Choose how often you want to export and refresh your MCI inventory—every hour, every day, or less frequent.
Step 6.
Save your data pipeline. This will export your Amazon inventory from Seller Central into spreadsheets instead of dealing with CSVs. MCI inventory records in your spreadsheets will be up to data forever.
What is the Amazon Multi-Country Inventory Report?
This report provides a near real-time snapshot of your inventory levels within Amazon’s European fulfillment network, broken down specifically by country. Unlike standard inventory reports that just show "Total Available," this report tells you exactly how many units are physically sitting in fulfillment centers in the UK, Germany, France, Italy, Spain, Poland, and the Czech Republic.
This report is critical for sellers using the Pan-European FBA program or Multi-Country Inventory (MCI) options, as it directly impacts your delivery speeds and tax obligations.
This makes it the single source of truth for answering questions like:
Do I have enough local stock in Germany to offer Next-Day Delivery to German customers?Am I unknowingly storing stock in a country where I am not VAT registered?How much inventory is stranded in "peripheral" countries like Poland or Czech Republic?Which country is depleting stock fastest, and where should my next inbound shipment go?Why am I paying EFN (European Fulfillment Network) cross-border fees instead of local fulfillment fees?
How to Analyze & Track Your FBA Multi-Country Inventory 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 "VAT Nexus" Monitor
Holding stock in a European country often triggers an immediate VAT registration obligation. You need to know instantlyif Amazon moves a unit to a new country.
How to build it:
Rows:
CountryValues:
SUM of Quantity for local fulfilmentVisualization: Create a Bar Chart.
What it shows you: A visual map of your physical nexus. If you see a bar appear for "PL" (Poland) or "FR" (France) and you aren't VAT registered there, you have an immediate compliance alert to address.
Template 2: The "Local Availability" Dashboard
Customers buy more when they see "One-Day Delivery." This requires local stock. This recipe highlights markets where you are running dry locally and forcing Amazon to ship cross-border (which is slower and costlier).
How to build it: Create a Pivot Table.
Rows:
Seller SKUorASINColumns:
CountryValues:
SUM of Quantity for local fulfilmentConditional Formatting: Highlight any cell with value
0in Red.What it shows you: If your top-selling SKU shows "0" in the
DE(Germany) column, you know you are losing the Prime advantage in your biggest market, even if you have plenty of stock in France or the UK.
Template 3: The "Pan-EU Rebalancing" Calculator
Use this to plan your replenishment.
How to build it:
Column A:
CountryColumn B:
Total Stock (Sum from Report)Column C:
Target Split %(e.g., DE=40%, UK=30%, FR=15%, IT=10%, ES=5%)Column D:
Target Stock=(Total EU Stock * Target %)Column E:
Variance=(Column B - Column D)What it shows you: This simple model tells you that you are "Overstocked" in France by 500 units and "Understocked" in Germany by 1,000 units, helping you direct your next inbound shipment to the right FC to balance the network.
Common workflows this report unlocks
EFN Fee Reduction: Identify SKUs that are fulfilling cross-border so you can send local stock and cut fulfillment fees.
VAT Compliance audit: Prove to tax authorities exactly when stock first appeared in their jurisdiction.
Inventory reconciliation: Match your European ledger balances against physical in-country counts.
Brexit planning: Clearly separate UK inventory from EU inventory to manage customs borders.
FAQ about Amazon Multi-Country Inventory
Q: What is the difference between this report and the standard "FBA Inventory" report? The standard report shows you what you have (Total Sellable). The Multi-Country Inventory report shows you where you have it (Physical Country Location). The standard report aggregates data; this report splits it by geo-location.
Q: Does this report show inventory in transit? No, this report is a snapshot of received inventory currently sitting in a fulfillment center. For inbound or transfer items, you should use the Inventory Ledger report.
Q: Why is my inventory in a country I didn't authorize? If you are enrolled in Pan-EU FBA, Amazon automatically moves your stock to meet demand. If you see stock in a country where you disabled storage, check your "Fulfillment by Amazon" settings in Seller Central immediately, as you may still be liable for VAT.
Q: How often is this data updated? The report provides a near real-time snapshot at the moment it is requested. However, Amazon's internal transfers can take days. Using Hopted to sync this daily gives you the best balance of accuracy and trend monitoring.
Q: Can I use this for tax reporting? Yes, it is commonly used by accountants to determine "End of Month" stock levels per country for VAT filings. Syncing this report to Google Sheets allows you to "freeze" a copy on the last day of every month automatically.
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.
