The Google Play royalty report; downloadable in Excel XLS format, provides a summary of sales by title and the royalties earned. Google uses the ISBN as the ProductID. This ISBN should be the ISBN for the eBook edition of your title.
Sales Import Field Mappings
Close the Google Excel file before importing. If the Excel file is open dates will be imported as their numeric value.
Google has two values for the sales date; Earnings Date and Transaction Date. You can use either date in your sales import. Most clients use the earnings date.
Because the Google file does not have a column for customer enter “Google” in the “or use this value” column.
The royalty software will convert the 2 character Country of Sale code to the appropriate country name. Importing the country code is optional if your royalty rules do not have country (territory) as a criteria.
|Insert into:||From (your column headers):||or use this value:|
|Territory||Country of Sale|
Ignore when any of the following fields are blank should have a value of Earnings Date. This will cause the royalty software to ignore any rows that do not have a value in this field.