SRD
How to get the data:
- Multi-tab monthly statements are emailed to labels from SRD in Excel format with the naming convention CATALOG NAME - CATALOG NUMBER - YYYY - MM.xls
Importing into IC:
- In IC, navigate to Royalties -> Data Imports
- Select the SRD importer from the dropdown menu
- This importer requires the Timestamp and Paid Timestamp to be entered manually
- For Timestamp, enter the reporting month and a date in the middle of that month. For example, a 2024 - 11 report would have a Timestamp of 11/15/2024.
- For Paid Timestamp, enter a date two months after the reporting month, and a date in the middle of that month. For example, a 2024 - 11 report would have a Timestamp of 1/15/2025.
SRD remits payment for reporting on 60 day EOM payment terms, meaning that there is a two-month remittance lag between the reporting month and the payment for that report. For example, the payment for a January report with the date 2024 - 01 is remitted in March. As such, IC uses the Paid Timestamp (i.e. remittance date) for each report for royalty accounting purposes, in order to determine in which Period those royalty transactions are accounted for.