Why Do the Sales Numbers Not Align with My Amazon Seller Central Reports?

Why Do the Sales Numbers Not Align with My Amazon Seller Central Reports?

There are several reasons you might see different numbers when comparing the Amazon Seller connector with Amazon's reports. This article will help you troubleshoot reports that show different numbers from Amazon's in-house reporting.

Minimizing Differences between Amazon UI and API Values

Amazon Seller's API reports values that differ from the values in Amazon UI, and this can be as small as a 1% difference. For example, the UI may report 3,000 orders, while the API could report 30 more or fewer orders.

This difference will be smaller and typically below 5% when using longer date ranges, but the difference may become larger for shorter ranges, such as when comparing daily figures.

Different Order Statuses

The Amazon Seller API reports all sales, including those with “Pending” order status, but their in-house reporting does not.  Selecting for different order statuses is the most common cause of misaligned reports. 

Use the optional order status filter in the connector configuration screen to remove order statuses that you do not wish to see.

Time Zone Mismatch

The API sends reports using GMT for all Regions (North America, EU, Far East). 
Amazon's in-house reports use either PST for North America (US, Canada, Mexico) or MET for Europe (UK, France, Germany, Italy, Spain, etc.)

Currency Mismatch

In the North American region, sales cannot be summed together without first being filtered by marketplace. This is because Mexican Pesos and Canadian Dollars cannot be converted and summed within Looker Studio. This is a limitation of Looker Studio.

In the connector configuration screen, you can choose any country's currency symbol. This will only affect the currency symbol displayed. It will not convert the values.

In this example, all amounts are shown with a dollar sign ($) currency symbol, but the values shown are in local currency. As displayed, it is incorrect.

To get correct results, apply a Marketplace filter.

Then edit the field to display the correct currency symbol. This will only affect the symbol and will not change the value shown.

Non-Amazon Orders Included

The API offers MCF order reports.  They will be labeled Non-Amazon. You can filter out these orders to align with Amazon's in-house reports by deselecting Non-Amazon in the Marketplace filters.

Order Date Mismatch

Most of the reports in Amazon use the "Shipped Date" as the date reported.  Our connector uses the date the order was placed. This can have a big impact on reporting because the difference between the order date and the shipped date can be several days. 
The Amazon API we use is used by shipping solutions and is focused on the order date. There are not presently APIs available to re-create the Amazon Finance reports.

API data will most closely align with the Sales Dashboard in the Business Reports section in Amazon.

API data does not align with the "Sales and Orders by Month" report.

Data Not Filtered by Marketplace

In Looker Studio, add Marketplace to the dimensions in your table.

You can also add a Marketplace filter to your report page.

In Excel or Google Sheets, add Marketplace as a dimension.

Create a Marketplace filter for your query.

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Troubleshooting Amazon

        Most errors that occur in Amazon reports can be fixed easily without the need to wait for a response from our support team. This article will help you find everything you need to troubleshoot your Amazon reports. If you have questions about regions ...
      • Incorrect Inventory Numbers from Amazon Seller

        This article will assist with the following problem: Inventory numbers in an Amazon report are bloated or incorrect. Cause The most common cause of this problem is a missing marketplace dimension or filter. Even if you configure your account to ...
      • Why do the sales numbers not align with my Shopify Sales Reports?

        This article will help you to understand some of the discrepancies you may see between Shopify Sales Reports and the reports you make with our connectors. There are many potential causes for missing or incorrect data in your Shopify report. Time ...
      • Which Amazon Seller Central Markets Are Supported? Do I Need More than One Account?

        This article will help you understand how we calculate accounts in our Amazon MWS connector and how to filter sales by Marketplace in your reports. Billing and Accounts For billing purposes, each region counts as one account under the Amazon MWS ...
      • How to Connect to Amazon Seller

        The following video and article provide instructions for connecting to Amazon Seller. Access Permissions Account administrators An administrator of the Amazon account can connect or grant access to other accounts to connect. Agencies and others Any ...