What Are Identifier Columns?

Identifier Columns are columns used to store royalty matching identifiers on Works.

These identifiers allow Reprtoir to match royalty statement lines with the correct Works during royalty processing.

In most cases, you do not need to add any Identifier Columns manually. The Works Spreadsheet template already supports the standard identifier by default.

You only need to add Identifier Columns when a royalty statement provider uses non standard Work identifiers.

How to Add Identifier Columns to the Template

When additional identifiers are required, follow this process:

1. Find your royalty statement provider in the reference table below
2. Copy the exact column name shown in the table
3. Add a new column at the far right of the Spreadsheet template
4. Paste the column name exactly as written

The column name must be copied without any modification.

Do not add spaces before or after the column name.

If the column name does not match exactly, the identifier will not be recognized.

Identifier Reference Table

Default Identifier Behavior

If your royalty statement provider is not listed in the table below, Reprtoir expects the following identifier by default:

• “ISWC Code”

This column is already supported by the “Works” Spreadsheet template.

You do not need to add it manually.

Identifier Exceptions

The table below lists only the providers that require Work identifiers different from the default behavior.

Unsupported Identifiers

If your royalty statement provider requires a Work identifier that is not listed on this page, it is not supported in the “Works” template.

In that case, please contact us before importing your statement.