Most users derive the author import file from their accounting software’s vendor list. They assign a vendor type of author or royalty to royalty recipient vendors. The list is filtered to show only royalty recipients and exported to Excel. Then it is imported into Easy Royalties.
The key points about the author import file layout are:
- Each component of the address (address 1, address2, address3, city, state, postcode, country) should be in a separate field.
- Import the FullName or (FirstName and LastName) for each author. Do not import both. The software will use the full name field to derive the first name and last name field contents. This will overwrite the contents of the FirstName and LastName fields.
- Import the company name in the Organisation (British spelling) field.
Example 1: Name and Organization Fields
|1||Jason||Burne||23 Dove St||Carlton||NC|
|2||Jim Smith||55 Wall St||New York||NY|
|3||Brooks Literary LLC||555 Park Ave||New York||NY|