How do I indicate historical sales so my first royalty statements use the correct rates?

Historical Sales for Escalating Royalties

If you have royalty agreements with escalating royalties (e.g. x% for the first 5,000 copies, y% for the next 5,000 copies, z% thereafter...), you will need to set starting counters when implementing EasyRoyalties in order for the first royalty statements to use the correct rates. This is done by entering 'historical sales'.

Historical sales are simply sales entries with an entry type specified as "Historical". Historical sales balances determine the starting escalator levels for pre-existing products, and they also allow the royalty statements to display the life-to-data sales quantities. Royalties are not calculated on historical sales records.

Historical sales records can be entered manually, or imported from an Excel file.

The minimum information required for historical sales is:

• the ISBN
  
• the quantity sold
  
• a sale date (this can be set to any date prior to the start of the first royalty period to be managed by EasyRoyalties; for example, if the first EasyRoyalties period is 1 Jan 2017 - 30 June 2017, the historical sales should be recorded with a date of 31 December 2016 or earlier)
  

Important: Your royalty rules may require additional fields to be included on historical sales entries.

Examples:

• If royalty rules are based on sales type (e.g. domestic vs export, with different escalators for each type), then the historical sales must also specify which sale type is involved. You may need to enter multiple historical sales entries for each ISBN, to account for historical sales for each sale type (there is no limit to the number of historical sales entries you can enter for each ISBN).
  
• If royalty rules are based on discount, then you must specify the Quantity, RetailPrice and TotalNetReceipts. This allows the software to calculate the discount that was provided when the sale occurred.
  
• If royalty rules are based on customer, then you must specify the Customer.
  

etc.

For more information, see section 5.4 in the EasyRoyalties Implementation Guide (available through the Help menu in EasyRoyalties).

• Related Articles

• How do I change the appearance of my royalty statements in a royalty run?

  To change the appearance of the formatted royalty statements, do the following: 1. Go to Data & functions > Royalty statements. Select a royalty statement to use as an example (you can select any statement, preferably one which provides a ...

• How can I make mass changes to reserve rules?

  You can modify reserve rules across multiple royalty contracts using the technique shown below. This feature is available in release 4.10.21 and later. 1. In the Royalty Contracts view, select the royalty contracts containing the reserve rules you ...

• Can I get a report showing the royalty rules used in all my royalty contracts?

  To extract the details on royalty rules used in the royalty contracts, including rates, applies-to criteria, etc.: 1. Go to the Royalty Contracts view 2. Select one or more royalty contracts 3. Click the Documents command Two documents/reports are ...

• How do I account for licensing revenues in my royalty calculations?

  Go to the 'Royalty contracts' view and select the royalty contract for which you have licensing revenues to include in the royalty calculations. Go to 'Royalty rules' (under the tab 'More') and at 'Royalty rules for' (top of the form) select ...

• The author's share from licensing revenues does not show on the royalty statement.

  Check the following: Is there a royalty rule for licensing revenues on your author's contract? Have you received payment from your licensees and marked it as paid? Have you set up your royalty statement printing options to show 'Royalties from ...