The Apple iTunes sales report; downloadable in Excel XLS format, provides a summary of royalty earnings for a selected date range. Each title is identified by an ISRC/ISBN product code and the vendor’s product code. For most vendor’s the ISRC/ISBN product code is the same as the vendor’s product code.
ISRC stands for International Standard Recording Code. This code is a unique identifier for each music. ISBN stands for International Standard Book Number. ISBN is a unique identifier for each book.
This file is a multi-currency report. During the import process the software will prompt for the exchange rates for each foreign currency in the report.
Sales Import Mappings
The Apple iTunes report is for a specific date range. The End Date field is usually used as the sale date.
|Insert into:||From (your column headers):||or use this value:|
|Territory||Country of Sale|
|SaleCurrency||Partner Share Currency|
|TotalSale||Extended Partner Share|
Ignore when any of the following fields are blank should have a value of ISBN/ISRC. This will cause the royalty software to ignore header and blank rows without sales data.
You can also import the “Customer Price” field.