Overview

The "Contracts to Assets" spreadsheet allows you to link contracts to assets in bulk. It supports all major asset types in a single file and is designed for large-scale operations that would be impractical to perform one by one in the interface.

👍

Good to know: For smaller operations where precision is critical, use the interface instead. It displays the calculated result of adjustments in real time. The spreadsheet does not.

Where to Find the Template

The official template is available in Reprtoir's public template library under the name:

Other - Contracts to Assets - Template (Reprtoir Public)

⚠️

Important: Copy the template to your own Google Drive before starting by opening it and selecting "File > Make a Copy". Downloading the file locally will remove dynamic helpers such as dropdown menus and data validation. Do not reuse a copy from a previous import without verifying that the column structure is still current.

Spreadsheet Structure

The template contains three tabs.

All data must be entered in the "Contracts to Assets" tab only.

Columns

The "Contracts to Assets" tab contains six mandatory columns, marked with an asterisk (*).

All six columns are required on every row. Leaving any field empty will cause an import error on that row.

Asset Types and Identifiers

Accepted Asset Types

The "Asset Type" column accepts the following values, available as a dropdown in the template: Album, Track, Work, Video, and Product.

Accepted Identifiers per Asset Type

The "Identifier" column defines which identifier type you are using to locate the asset. The accepted values depend on the asset type. "Reprtoir Identifier" is accepted for all asset types.

Enter the corresponding value in the "Identifier Value" column. Using an identifier type that is not valid for the declared asset type will cause an import error.

Asset Types and Contract Compatibility

The contract type must be compatible with the asset type declared on the same row. The "Contract Name" column must contain the exact name of an existing contract in Reprtoir.

Linking a contract of an incompatible type to an asset will cause an import error on that row.

Linking Multiple Contracts to the Same Asset

To link more than one contract to a single asset, add one row per contract. All rows for the same asset must be consecutive. Do not separate them with rows for a different asset.

All contracts on the same asset must belong to the same organization.

Example:

In this example, two contracts are linked to ISRC001 on consecutive rows before moving to the next asset.

Adjustment Rates

The "Income Adjustement Rate %" and "Expense Adjustement Rate %" columns define how royalties are distributed when the contract applies to the asset. Values must be entered as percentages (for example, enter 50 for 50%).

The system validates that the resulting splits do not exceed 100% across all split types. If they do, the import is rejected.

⚠️

Warning: The spreadsheet does not preview the result of adjustments. You are working without a live calculation. Import carefully and verify all splits in the interface after the operation is complete.

Preparing the File

1. Open the "Other - Contracts to Assets - Template (Reprtoir Public)" and select "File > Make a Copy" to save it to your own Google Drive.
2. Open the "Contracts to Assets" tab.
3. For each row, select an "Asset Type" from the dropdown.
4. Select the appropriate "Identifier" type from the dropdown.
5. Enter the corresponding "Identifier Value" that matches an existing asset in Reprtoir.
6. Enter the exact "Contract Name" as it appears in Reprtoir.
7. Verify that the contract type is compatible with the asset type on that row.
8. Enter numeric percentage values in the "Income Adjustement Rate %" and "Expense Adjustement Rate %" columns.
9. Group all rows for the same asset consecutively.
10. Verify that no contract appears more than once on the same asset.

Exporting the File

Before importing into Reprtoir, export only the "Contracts to Assets" tab as a CSV file. Importing the full Google Sheets file is not supported.

1. Open the "Contracts to Assets" tab in your Google Sheet.
2. Click "File" in the top menu.
3. Hover over "Download".
4. Select "Comma Separated Values (.csv)".

The exported file will contain only the active tab. Do not rename the file before importing.

Importing the File

1. Click "Catalog Management" in the left navigation menu.
2. Open the relevant list.
3. Click "Import" and select the exported CSV file.
4. Review any errors returned by the system before confirming.
5. After a successful import, open the affected assets in the interface and verify that adjustments are applied correctly.

Error Reference

The following errors may be returned during import. Each error identifies the row or condition that caused the rejection.

Limitations

• The spreadsheet does not display calculated adjustments before import. Use the interface to verify results after each import.
• All rows for a given asset must be adjacent. Non-grouped rows will cause an import error.
• Resulting splits must not exceed 100% across all split types. The system enforces this at import and will reject the file if the threshold is exceeded on any asset.
• The contract name must match exactly an existing contract in Reprtoir. Partial names or aliases are not accepted.
• Each contract can only appear once per asset in a single import.
• All contracts on the same asset must belong to the same organization.
• The template must be used as a Google Sheet. Exporting as Excel (.xlsx) is not officially supported and may cause compatibility issues.