The Kobo royalty earnings report is a Microsoft Excel XLS file. It provides a listing a sales transactions by date and country for each ebook.
Sales Import Field Mappings
Though the Kobo file has a field for customer called Partner this field can have several values (i.e. Kobo, BordersAU, etc.). We recommend entering “Kobo” in the or use this value field for Customer.
The software will convert the 2 character Kobo country code to the appropriate country name.
|Insert into:||From (your column headers):||or use this value:|
|TotalSale||COGS in Payable Currency|
Ignore when any of the following fields are blank should have a value of Date. This will cause the royalty software to ignore any rows; including blank rows, that do not have a value in this field.