This course covers how to import data into the EasyRoyalties royalty software.
- Manual: Importing
How to import authors, products, sales and more into EasyRoyalties.
How to import royalty recipients into EasyRoyalties.
How to import titles (properties) and editions (products).
How to import sales transactions into EasyRoyalties.
- Sales Import Field Mappings
Sample sales import field mappings for sales import files.
- Amazon KDP Royalties Report (New Format)
- Amazon KDP Royalties (Old Format)
Importing the Kindle KDP Prior Month's Royalties report
- Amazon Vendor Report
Amazon has two sales reports. The Amazon Vendor Report and the Kindle KDP Royalties Report. This lesson covers how to import sales from the Amazon Vendor Report.
- Audible Royalty Report
- Google Play
- Inktera (PageFoundry)
- LSI – Lightning Source POD
- OverDrive – Max Access Plan
Barnes & Nobles Nook sales import field mappings.
- Wheelers Books
- Royalty Contracts
How to create royalty contracts via a file import.
- Excel Tips
How to use Excel to format and manipulate data in your sales import file.
- Text To Columns
- TRIM & CLEAN
- LibreOffice XLSX Format
- Remove Scientific Notation
- Negative to Postive
How to change a negative number to a positive number in Excel.
- Extract a Product Code
- Convert UTC Text to Excel Date
- Assign Sales Record: Entry Type
Excel formula to automatically assign an entry type of "R" to sales records for returns.