My sales are off. KDP Reports shows me one number and AHS shows me another.

My sales are off. KDP Reports shows me one number and AHS shows me another. What's going on?

Before we get started in answering that question, please note AHS uses the actual data from service reports, such as KDP, to build an income picture. We use estimated exchange rates and KENP page rate amounts were applicable. It is the sole responsibility of the author to verify all income data directly from the service-source before making any business decisions.

To understand how we handle sales data, please do one test.

1. Do another AHS KDP pull with the bookmarklet.
2. Refresh the AHS page.
3. Download the KDP report xls file after doing that pull.
4. Compare the data with AHS on the “Combined Sales” tab, not the “Orders” tab.
5. Compare the data with AHS in “Net Units Sold” column.

This may be different than what you’re accustomed to focusing on. So why do we ask that you focus on Combined Sales and Net Units Sold? We have a detailed explanation on our video below, but here’s the gist of it.

(Note: If you ever notice a discrepancy in the revenue # please be sure to check to see if you had any unit sales in the UK or overseas. We use current exchange rates to estimate the final revenue.)

As authors, we got out of the habit of looking at the Amazon KDP’s report dashboard. For revenue (our primary interest) it was just too clunky. But we noticed that the KDP spreadsheet contains a treasure trove of information. Two data points that stood out were the “Net Units Sold” and the “Combined Sales”. They always showed consistent information that led to the most accurate sales numbers. We noticed the “Order” numbers were all over the place and not at all accurate in estimating revenue. Why? It probably has something to do with how Amazon handles sales across countries, refunds and other payment triggers in their system.

The bottom line is that we want to provide everyone (including our own author businesses) with accurate sales data for each day. But by showing you “Orders” data like other services do, we don’t believe we’re doing that

Here is a video to explain this in detail



There's a second reporting methodology that can lead to some confusion. When looking back a few months, the monthly data can sometimes appear out of sync with the daily data. Here's why:

When you first sign up to AHS, we can pull 90 days of daily data, and years (and years) of monthly historic data. This historic data from KDP's end does not include daily data, unfortunately. 

As you use AHS more, we continue to pull daily data as provided by KDP. If you use AHS for many months and then pull Historic data using our KDP Tool, the monthly figures from KDP's end still do not include daily data. They just include a tally of the month. This causes a conflict between the daily data you've been tracking in AHS and the reconciled "final" tally that Amazon shows (which is no longer subject to analysis on their end). We want authors to get that accurate tally of revenue so we display that in our monthly reports. However, if you then look at daily breakdown reports in AHS, you will see discrepancies because the daily data has not been updated by the Historic report data pull. 

It's for this reason that we advise our customers to use AHS as a trend tool that shows you what's working and what isn't. We display the data that KDP has in its reports, but we can't reconcile Amazon's payout with what their reports say due to factors outside our control. 

updated 2/2023


    • Related Articles

    • My Amazon sales data is completely off! What's going on?

      A few things could be happening here. Two important details to consider first. KDP's own reports are estimates. They mark their reports as estimates on their dashboard and reports pages. This is due to multiple factors such as exchange rates, ...
    • Why did my KDP revenue change all of a sudden?

      We capture adjustments that Amazon makes to their data in a couple of ways: 1. When you use the KDP Tool we go back and capture five days so we can keep your recent data current on AHS. This often has adjustments from Amazon. 2. When you use the KDP ...
    • The data seems to be different than KDP. What's going on?

      When looking back a few months, the monthly data can sometimes appear out of sync with the daily data. Here's why: When you first sign up to AHS, we can pull 90 days of daily data, and years (and years) of monthly historic data. This historic data ...
    • How do I upload ACX sales and royalties reports?

      The Author Helper Suite accepts Audible (ACX) sales reports. Note that there is no daily information because ACX does not provide daily breakdowns in their monetary reports. Therefore, all ACX sales data is saved as the last day of the month for the ...
    • How do I get all of my KDP sales data into AHS?

      Using the KDP Tool: 1. Head to KDP Bookshelf on the KDP site. 2. Activate the KDP Tool by clicking on it in your browser's bookmarks bar 3. In the pop-up window you'll see a link reading "Start importing historic KDP data". Click that. 4. Please be ...