What is a Royalty Statement Income?

A Royalty Statement Income is a file-based Income used to report music sales or rights revenues received by the Organization from a Company such as a Distributor, an Aggregator, a Platform, a Publisher, or a CMO.

To learn more about Incomes, visit the Incomes page.

📘

Where to find Royalty Statement Incomes

Royalty Statement Incomes are displayed in the Income list. To access them, go to the navigation menu on the left, click the “Royalty Accounting” icon, open the “Transactions” section, and click the “Incomes” list.

Ingesting a Royalty Statement (05:09)

We strongly advise you to start by watching the video below to get up and running quickly.

Royalty Statement Income Step-by-Step

Follow the process below to add and process a Royalty Statement Income:

1. Adding a Royalty Statement Income
2. Uploading a Royalty Statement File
3. Mapping the Data
4. Handling Amount Errors
5. Handling Data Errors
6. Review
7. Summary

◼ 1. Adding a Royalty Statement Income

To add a Royalty Statement Income, go to the navigation menu at the left of the Workspace, click on the "Royalty Accounting" icon, browse to the "Transactions" section, and click on the "Incomes" list.

At the top right of the list, click the orange "New Income" button and select "Import from Statement File".

A pop-up window will open to enter the necessary data for the new Royalty Statement Income:

Details Tab

Processing a Royalty Statement with a Different Currency (02:57)

If your statement currency differs from your bank account currency or your Organization accounting currency, we strongly recommend watching the video below before proceeding.

Tags Tab

Reprtoir will automatically create a new Tag or link to existing Tags during import.

Once filled in, to save the new Royalty Statement Income, click the orange "Save" button at the bottom right of the pop-up window. The new Income will be opened in a new panel and displayed in the "Incomes" list.

To cancel, click the “Cancel” button.

◼ 2. Uploading a Royalty Statement File

To upload a Royalty Statement File, go to the Royalty Statement Income panel, and drag and drop a Royalty Statement File from your computer desktop to the "Upload Statement" box at the bottom of the Panel.

The following File formats are supported:

At this step, the system performs technical checks (file type, encoding, structure) to validate the file. If an abnormality is detected, the file is rejected.

When the upload is accepted, the system proceeds automatically to the next step.

◼ 3. Mapping Data

📘

In some cases, the system maps the data automatically and proceeds to the next step.

This step maps the uploaded statement file to the Reprtoir standard format so the system can process it consistently.

In most cases, the system maps the file automatically, but manual adjustments may be required.

At this step, the system displays:

• A “Statement Preview” table showing the first five rows in the provider format
• A “Data Mapping” table showing the first five rows in the “Reprtoir Standard Format”

The goal is to map as many columns as possible before continuing.

Please follow these instructions carefully:

You can use column statuses to track progress:

📘

The final data used to produce Royalty Statements and Analytics is imported at this step. It is not possible to modify these data after confirmation.

When finished, click the orange "Confirm Mapping" button at the page's top right.

To restart the action, click the white "Restart Process" button next to it.

Royalty matching prerequisites

Royalty statements rarely contain reliable descriptive metadata. Providers primarily reference assets using technical identifier codes present in the statement file.

To process a statement accurately, these identifiers must exist on the corresponding items in your catalog. If a line cannot be matched using identifiers, it remains unmatched and cannot be processed automatically.

◼ 4. Handling Amount Errors

📘

If no amount errors are detected, the system skips this step automatically.

This step allows manual correction when the system detects inconsistencies between the statement totals and the amounts entered in the Income metadata.

If it's an entry error, click the white "Edit Income Amount" button at the top right of the page, edit the Net Amount, and save. If it's a Royalty Statement file error, verify that you have mapped the correct column, and if so, contact the Royalty Statement provider.

◼ 5. Handling Data Errors

📘

If no data errors are detected, the system skips this step automatically.

If required data is missing or unknown, this step allows you to correct and standardize values into the Reprtoir standard format.

If a correction cannot be completed immediately, it can be quarantined and processed later.

Statuses:

Correcting and formatting data

❗️

The final data used to produce Royalty Statements and Analytics is imported at this step. It is not possible to modify these data after confirmation.

When mandatory data is missing or unknown, the system allows manual correction and automatically create Rules.

To filter errors by type, (click an error type) in the left sidebar.

To correct a Data error, right-click on the error to correct it in the list (or, when hovering over the Error, click on the three dots on the right side), and then click on the "Make Correction" action in the opened contextual menu.

This will open a pop-up window at the right of the Workspace to edit the Error.

Make corrections using the following instructions:

Typical correction cases

Typical formatting cases

To save, click the orange "Save" button at the bottom right of the pop-up window.

Click the grey "Cancel" button to cancel the action.

👍

During the calculation step, the system records these corrections in the Rules list to support future processing.

Put in Quarantine

“Quarantine” excludes specific errors that cannot be resolved immediately, without blocking the workflow.

To learn how to manage quarantines, go to the dedicated page “Quarantine”.

When done

🚧

Good to know

All errors must be in “Corrected” or “Quarantined” status to proceed.

When done, go to the next step by clicking the orange button "Confirm Errors" at the bottom right of the page.

To restart the process, click the white "Restart Process" button next to it.

Do not assume you are done after the first pass. Validating errors may reveal additional issues that only become detectable once earlier corrections are applied.

◼ 6. Review

This step indicates the details of the treatment that will be carried out:

• Total Amount
• Total Lines
• Quarantined Lines

If this meets your expectations, click the orange button "Confirm" at the bottom right of the page. To return to the previous step, click the white "Back" button next to it.

This step may seem long as the System calculates and shares the Royalties. Please be patient. You can do something else while the system is running.

◼ 7. Summary

It's done! The System has finished calculating and returns a digest of what it did:

If there are any Quarantined Errors that you want to process, click the white "Edit Quarantined Errors" button at the bottom right of the page.

The System will then return to step 4 to correct processing errors.

Editing a Royalty Statement Income

To edit a Royalty Statement Income, go to the navigation menu at the left of the Workspace, click on the "Royalty Accounting" icon, browse to the "Transactions" section, and click on the "Incomes" list.

Find the Royalty Statement Income to edit in the list and click on its name. This will open the Royalty Statement Income panel.

Click on the "Edit" button at the top right of the list. This will open a pop-up window at the right of the Workspace to edit the Royalty Statement Income metadata.

To save, click the orange "Save" button at the bottom right of the pop-up window.

Click the grey "Cancel" button to cancel the action.

📘

Only Name, Payment Date, and Notes can be edited on Royalty Statement Incomes. At this stage, if an error is detected, the Income must be deleted or reprocessed, depending on the use case.

Editing Royalty Statement Incomes in bulk

To edit Royalty Statement Incomes in bulk, go to the navigation menu at the left of the Workspace, click on the "Royalty Accounting" icon, browse to the "Transactions" section, and click on the "Incomes" list.

Select one or more Royalty Statement Incomes in the list, right-click (or, when hovering over the Royalty Statements, click on the three dots on the right side), and then click on the "Edit" action in the opened contextual menu.

This will open a pop-up window at the right of the Workspace to mass edit the selected Royalty Statements' metadata. Please visit the Mass Edit article to learn more about this feature.

To save, click the orange "Save" button at the bottom right of the pop-up window.

Click the grey "Cancel" button to cancel the action.

📘

Only Name, Payment Date, and Notes can be edited on Royalty Statement Incomes. At this stage, if an error is detected, the Income must be deleted or reprocessed, depending on the use case.

Deleting a Royalty Statement Income

To delete a Royalty Statement Income, go to the navigation menu at the left of the Workspace, click on the "Royalty Accounting" icon, browse to the "Transactions" section, and click on the "Incomes" list.

Find the Royalty Statement Income to delete from the list and click on its name. This will open the Royalty Statement Income panel.

Click on the arrow icon behind the "Edit" button at the top right of the list and click on "Delete".

This will open a pop-up browser alert at the top of the Workspace.

To stop the action, click the "Cancel" button.

Click on the "OK" button to confirm the deletion.

Deleting Royalty Statement Incomes in bulk

To delete Royalty Statement Incomes in bulk, go to the navigation menu at the left of the Workspace, click on the "Royalty Accounting" icon, browse to the "Transactions" section, and click on the "Incomes" list.

Select one or more Royalty Statement Incomes in the list, right-click (or, when hovering over the Royalty Statements, click on the three dots on the right side), and then click on the "Delete" action in the opened contextual menu.

This will open a pop-up browser alert at the top of the Workspace.

To stop the action, click the "Cancel" button.

Click on the "OK" button to confirm the deletion.