Import your Kobo Writing Life and D2D sales reports to PublishDrive Abacus

Abacus has been expanded to accept Kobo Writing Life (KWL) and D2D royalty reports for convenient royalty splitting. 

After exporting your monthly sales data, just drag-and-drop your reports into Abacus, assign royalty percentages, complete the import process, and you’re good to go! You can then calculate co-author royalties, track costs and author advances, and manage other team finances. 

Let’s see how you can do it. 

Download reports from your Kobo Writing Life account

Please use the detailed invoice data that emailed to you every month from Kobo Writing Life, or follow these steps to download them:
https://kobowritinglife.zendesk.com/hc/en-us/articles/360059386671-Where-can-I-find-my-sales-report-and-when-can-I-expect-one

Download D2D reports

Export your sales data from D2D:

1. Sign in to your account on D2D https://www.draft2digital.com/login/
2. Go My Reports https://www.draft2digital.com/reports/
3. Choose eBook Raw Sales Data https://www.draft2digital.com/reports/raw_sales_data/
4. For report period choose the period (month) you wish to import to Abacus
5. Download your results in CSV format

IMPORTANT notes: 

• D2D report may contain verified and not verified sales info as well (Column “Verified”). Abacus excludes all non-verified sales from royalty reporting!
• You need to download your report month-by-month to be imported to Abacus

Import data to PublishDrive abacus

1. Log in to PublishDrive: https://account.publishdrive.com/login
2. Start ababus with “Split Royalties” button
3. Drop your downloaded CSV file to abacus
4. Select the titles you wish to include to Abacus
5. Provide your contributors’ data
6. Review the data
7. Finish Import

Click “ADD DATA & UPDATE” button on the top of the page