Developer Console

Reporting FAQ

The following are frequently asked questions (FAQ) about reporting.

Q:  What is the time zone for Sales reports?
All of the estimated sales dates are based on marketplace time zone. This is to ensure that sales reports use the same time zones as the earnings reports.

The following table captures the timezone utilized for each marketplace:

Marketplace Time Zone
AU Sydney
BR Sao Paulo
DE Paris
ES Paris
FR Paris
GB London
IN Kolkatta
IT Paris
JP Tokyo
US Los Angeles
Q:  How often are sales report updated?
Sales report are updated every 6 hours. The latest data in a report may be up to 12 hours old.
Q:  How are the sales categorized for Appstore?
Appstore Sales categories include: Apps, In-app purchases and In-App Subscriptions.
Q:  How are the sales categorized for Twitch?
In the Sales report, Twitch sales are categorized under three broad categories - Game, In-Game, and Extension. The mapping is as follows:
  1. Fuel Game -> Game
  2. Fuel Entitlement -> In-Game
  3. Fuel VirtualCurrency -> In-Game
  4. Fuel Consumable -> In-Game
  5. Fuel Game, Extension –>Extension
  6. Fuel Entitlement, Extension -> Extension
  7. Fuel Consumable, Extension -> Extension

Based on the type of Twitch goods that you sell, you will either see one category or all categories in your sales reports.

Q:  What is gross units sold?
Total number of units sold in all sales categories. This number excludes refunds.
Q:  What is net units sold?
Total number of units sold in all sales categories, and with refunds included.
Q:  Can the units and amount reported within sales records change?
Because the sales report numbers are estimated, the number may change if we apply adjustment transactions at a later time.
Q: Will a transactional sales report CSV file exactly match with the summary sales data in the Developer Console?
There could be minor differences between these two reports. Transactional sales reports are generated based on the invoice date. The summary sales information displayed on the Developer Console is based on the actual date of transaction. An invoice for a given month may remain open for the first few days of the following month. Transactions from early in the next month are mapped to that open invoice until it is closed. However, the summary data in the Developer Console does not include the transactions that occur in the next month.
Q: What is the purpose of the adjustment column in the Sales CSV file in the Download Center?
Adjustments can apply to a charge or a refund transaction:
  • Charge Adjustments: If the adjustment status is yes and the transaction type is charge, the adjustment applies to a transaction that was a charge to the customer. This adjustment results in lowering your previously-reported sales revenue.
  • Refund Adjustments: If the adjustment status is yes and the transaction type is Refund, the adjustment applies to a refund. In this case, Amazon had taken out money to refund the customer, but the refund didn’t go through for some reason. This adjustment results in increasing your previously-reported sales revenue.
Q: When the adjustment is yes, why do we show both positive and negative transactions with the same transaction ID and time?
This is provided to support partial adjustments. The report shows the original transaction and the adjusted transaction. In case of partial adjustments, the earnings amount will differ between the original transaction and the adjusted transaction.
Q: How can I calculate sales (units and revenue) for a given product or all the products in a given month using the Sales CSV file in Download Center?
To calculate revenue for all product, remove all transactions with Adjustments = Yes, and sum the Units column for units and the Sales Price column for revenue. To calculate the sales for a specific product, filter first by SKU, then remove all transactions that have adjustments, and then sum the Units column for units and the Sales Price column for revenue.
Q: Are there changes in how the Developer Console presents 2018 and later sales summary information?
There are two minor changes:
  • Display of sales data now takes Day Light Savings Time into account.
  • An adjustment or a refund is reported in the month in which the adjustment is made or refund is issued.
Q:  How soon do Earnings and Payments reports become available?
Earnings and Payments reports are updated once a month. Earnings reports are updated the month after the sale occurred, at the end of the month. Payments are issued the month after the sale occurred, at the end of the month, and Payment reports are updated between three and five days after the payment is issued. For example, for sales in January, Earnings reports are updated by the end of February, and Payment reports are updated between March 3 and March 5.
Q:  Do earnings for a given earnings period always match with sales data for the same period?
Sales reports are provided for your convenience only and are not binding. Please note that earnings in sales reports are only approximate and may not exactly match with the earnings reports.
Q:  Will all earnings lead to payment in same period as the earnings?
Earnings from multiple periods may be combined and paid as one payment. For example, if the payment method is check or wire transfer, minimum payment thresholds must be met before payment is issued. If Amazon does not make a payment, you will see a comment Not issued for the respective earnings period. When the payment is issued, the status is updated to Payment issued.
Q:  Will the payment amount exactly match the earnings?
Earnings may not reflect the actual disbursement amount. For example, if royalties are subject to tax withholding.
Q: I see multiple invoice line items with the same payment amount. Why is that?
Since one payment can include multiple invoices, the same payment amount is shown for each of those invoices.
Q: How do I calculate the estimated the payment amount?
The following formula should give you estimated payment amount. If there is any payment cost associated with these earnings, you need to subtract these costs as well:

Estimated payment amount = (Earnings pretax and adjustments – tax withheld – adjustment) *FX Rate

Q:  Will I get one payment for all transactions in all marketplaces?
For information about payments, refer to Understanding Payments.
Q:  What is Invoice Group ID and why do I use it?
Invoice Group ID maps to a unique earnings record. Refer to it when you need to troubleshoot earnings-related issues with Amazon.
Q:  What is Payment Id and why do I use it?
Payment Id maps to a unique payment record. Use it to troubleshoot payment-related issues with your bank or with Amazon.
Q:  How many years of historical data is available?
The last 3 calendar years of your financial data is available.
Q: I would like to understand country sales data. Where can I get this information?
The downloadable sales files in the Download center provide the country sales data. You can download these files to perform the required analysis.
Q: I would like to understand earnings by SKU or ASIN. How can I get this information?
For 2018 and later reports, ASIN-level earnings can be derived from the downloadable sales reports in the download center. For 2017 and earlier years, you can derive the ASIN earnings by downloading the sales reports and applying the appropriate royalty terms for those ASINs.

Last updated: Dec 13, 2023