K7

How to get the data:

  • Royalty reports are emailed every month
  • Open the statement link in your email, click the "Export Details To Excel" button under your catalog information on the statement, and a .xlsx file will be delivered to you

Importing into IC:

  • In IC, navigate to Royalties -> Data Imports
  • Select the K7 importer from the dropdown menu
  • This importer requires the Timestamp and Paid Timestamp to be entered manually
  • For Timestamp, use a date in the middle of the month of the reporting Period. For example, a statement with a Reporting Period of 2023-09-01 - 2023-09-30 would have a Timestamp of 9/15/2023.
  • For Paid Timestamp, as K7 data is on a two month payment lag (i.e. payment for a September royalty statement is remitted in November), use a date in the middle of the month two months from the statement's reporting period. For example, a statement with a Reporting Period of 2023-09-01 - 2023-09-30 would have a Paid Timestamp of 11/15/2023.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us