Amazon report data is calculated in a number of ways. Here's the breakdown:
All amounts in our reports are estimates. There are no means to provide you with precise information due to exchange rate data, but the amounts should be within a reasonable range (~5%).
Here are more details on the exchange rates:
The exchange rate data used by KDP is not provided in any of their reports. This means that the values you see in our reports will not be 100% accurate. It will be close, but since the exchange rates vary hourly, there is no way to know the prices exchange rates at the moment KDP made their final payout.
AHS stores the exchange rate for the last day of the month for each month past. This will be used to estimage sales data on all past reports. Again, please note that it is impossible for us to match the exchange rate at the moment that KDP has made their final payout for any month.
For more recent data pulls from KDP (90 days or less), the exchange used is based on the current exchange rate. This rate is updated every two hours to ensure up-to-date information.
The historical data that you download from KDP on the Past Months' Royalty tab on the KDP Reports Dashboard has all of the financial data embedded. So we take precisely the values within to calculate your eBook sales numbers, paperback sales numbers, KENP pages read, and the amounts KDP states that they paid out to you for that month. We then multiply the values by the stored exchange rate for that month to provide you with an estimated value.
Recent data downloaded from KDP (90 days or less) has no integrated amounts for KENP page rates. This means that we must calculate your data based on two possibilities:
A fixed rate that you set in the AHS settings area for your account. When you set this amount, we will use that to calculate your KENP page amounts. You may set this to whatever you feel is reasonable. Note: You must put this amount in your selected currency.
An estimated amount based upon the average over the last three months of known data. For example, if the last three months KENP page rates for the US were $0.0047, $0.0050, and $0.0048, we would use the average of $0.0048 (rounded accordingly). Note: The system will make sure that the calculated amount will be in your selected currency.
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 ...
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 ...
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, ...
This disparity happens when a date range is selected that does not include daily KDP data. KDP only provides authors 90 days of daily data. Days 91+ going backward are all summed up in monthly totals by them. Consequently, if you choose date ranges ...
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 ...