The Difference Between Sale Dates & Transaction Dates

When importing income data we will require you to store a Sale Date and Transaction Dates against the income lines. You have the liberty to interpret and use these fields as you wish, but our default take is that

• the Sale Date represents the usage date; the day the performance or reproduction happened.
• the Transaction Date represents the payment date; the day you were paid the earnings from the respective income file.

The Sale Date is the date we will use as a reference to create the Revenues Over Time graph in your analytics. Furthermore, you are also able to escalate royalty rates based on Sale Dates.

When possible, we advise to pick up the Sale Dates and Transaction Dates directly from your sales files. When creating a template, mapping this column to the respective date field will make sure Curve will automatically store the Date where possible. If you wish to use the same column as both the Sale Date and Transaction Date, you can achieve this with the use of a Copy Field. If the Date has a non-Excel format, we have a list of data formats available that can be used for Curve to read the date correctly. Pro tip; when the excel is displayed as a number in the example lines, the data is in an Excel format and the data type can simply be set to Date.

When a Sale Date & Transaction Date are not picked up from the original sales data, you will be prompted to provide these dates via the Mapping Manager. If you do pick up the dates via the template but some lines have no date specified, also then you will be prompted to provide a default date which will be used to complete the royalty lines with missing dates.