Importing rights

Import Rights (Provider, file and filter selection)

The Import rights module allows you to ingest royalty statements, sales reports, and digital performance distribution files. This data is linked directly to a specific third party or collection society to process income data across your catalog.

1. Interface Overview

The interface requires you to specify accountability links alongside your file and parsing filter selections:

• Left Section (Accountability & Files): Dropdowns to assign who sent the money/data, and the file uploader tool.

• Right Section (Filtre): The template list specifically calibrated for rights and financial data structures (e.g., LyricFind, MCPS, Maestro).

2. Step-by-Step Configuration

Step 1: Define Accountabilities (Third Party & SociétéCompany payée)paid)

Before choosing files, you must tell the system how to assign the incoming funds:

1. Third party: Click the dropdown and select the external client, publisher, or sub-publisher who provided the statement (e.g., Asia Sub Publisher).

2. Company paid(Paidpaid Society / Entity): Select your internal company node or society profile that received the payment described in the statement.

Step 2: Upload Royalty Files

1. Find the Files section below the dropdowns.

2. Click the Green Plus ($+$) icon at the bottom left to browse your computer and upload your statement files (CSV, XLS, TXT, etc.).

3. Note: Multiple files from the same provider can be added at once if they share the identical file structure. Use the Trash bin icon to clear accidental selections.

Step 3: Map the Royalty Structure (Filtre)Filter)

1. Scroll or search through the FiltreFilter column on the right side.

2. Select the filter matching the source organization or format layout (e.g., choose MCPS CRD4 if processing an MCPS statement).

3. Lightning Bolt Icons (⚡): Notice the yellow lightning bolts next to the names. These indicate active, automated script parsers optimized for handling deep financial calculations and high-volume data streams.
   

When importing the file, you must know the sender in order to indicate it in Third Party, as well as choose the appropriate filter. The filter is named after the rights provider. A Third Party may have more than one file type. This is how we have four filters for SACEM, for example, as they can send several different formats. If you do not find a filter corresponding to your rights provider, please send us the file with the name of the provider.

3. Action Buttons & Navigation

The navigation buttons at the bottom facilitate the wizard sequence:

Button	Action
Back	Returns to the previous menu dashboard (disabled during initial step).
Next	Starts parsing the financial values and advances to the preview and calculation step.
Cancel	Wipes the current setup selections and closes the Import rights module.

The rights imports allow you to integrate the statements of PROs and your sub-publishers.

Options

The rights are linked to a rights provider, called a third party in the Sage.

When importing the file, you must know the sender in order to indicate it in Third Party, as well as choose the appropriate filter. The filter is named after the rights provider. A Third Party may have more than one file type. This is how we have four filters for SACEM, for example, as they can send several different formats. If you do not find a filter corresponding to your rights provider, please send us the file with the name of the provider.

Unlike catalog imports, rights imports are done in two stages to allow you to manage the time allocated to matching:

The pre-import

1/ Indicate the Third Party 

2/Select

After selecting your filestatement (s)file, tothird importparty,

and

3/Chooseparsing filter, clicking "Next" opens the appropriateOptions filterpage. (thisThis can be preconfigured in The Sage configuration)    

Next

1/ Rights dates:screen allows you to forceconfigure afinancial datevariables, apply currency conversions, and set up metadata rules for the incoming royalty entries.

1. Setting Up Financial and Administrative Options

Configure the parameters to align with your distribution rules:

• Rights date: input the accounting/distribution period relevant to this statement (e.g., Q1 2026, H2 2025). This ensures royalties are allocated to the correct financial period.

• Currency: Defines the base currency of reception of rights on all imported lines and indicate one when the fileincoming doesn'tdocument. containBy thedefault, information. Itit is always a good ideaconfigured to indicate a date.  

  2/Currency: if nothing is entered, the currency willdefined beas the default currency indicatedone in the Settings.Stettings. Modify this code if your statement uses a different source currency (e.g., USD, GBP).

• 3/ Share to keep: ifDetermines youwhat wantpercentage of the incoming money is retained by your company before sub-distribution. By default, it is set to deduct100,00% a(meaning percentageyour oncompany allretains the linesentire ofgross rightsamount, or commission calculations will follow default contract rules).

• 4/ Counter value: this isIf the amountstatement actuallycurrency received,differs from your system's main accounting currency, enter equivalent value in your currency if the file is in a foreign currency.accurately.

• 5/ Filter on a condition: byUse indicatingthis dropdown to apply a conditionspecific youlogical canrule to the import, parsing only import the linesline of rightsitems that answermeet thata condition.custom set criteria.

• 6/ Force a rights tag: forcing a rights tag then allowsAllows you to createautomatically apply a rightsspecific conditiontag to payapply a special rule to the payout of the rights. 

Debug: Located at the bottom of the window. Exclusively for us. 

Statement Summary

Once the software finishes parsing your rights or royalty statement file, it advances to the Compte rendu screen. This stage provides a breakdown of the imported linessheets, ofdata right.volume, extracted financial sums, and parsing warnings before committing the records to your live ledger.

1. Interface & Grid Layout

NextThe main table acts as a structured tree menu. Clicking the small Minus ($-$) or Plus ($+$) square icon on the far left expands or collapses individual sheets found inside your uploaded file.

Main File Attributes

• IfFile anname: error message appears andDisplays the file analysis remains blocked, please send us a screenshot, the file being imported, as well as the namepath of the filterprocessed spreadsheet (e.g., Z:\Downloads\GRANDS DROITS V2.xlsx).

• Nb lines: The total count of data rows successfully scanned (e.g., 70 lines).

• Amount / Amount in currency: The total aggregate financial royalty sum extracted from the document (e.g., 184 214,37).

2. Reading Error Messages and Workbook Sheets

When expanding a multi-sheet spreadsheet workbook (e.g., Excel files with several tabs), Le Sage evaluates each tab independently:

• Successful Tabs (e.g., Feuil1): * Displays the subtotal financial Amount parsed specifically from that single sheet.

  • The Active zones column indicates which named script or data layout template successfully mapped the rows.

• Tabs with Errors/Warnings (e.g., Feuil2):

  • Message / Last error: Displays parsing flags such as Headers not found.

  • What this means: This alert indicates that a specific sheet inside your Excel file (like Feuil2) does not contain the expected data columns or is an empty layout tab. If the financial totals on the successful sheets match your physical statement statement balance, this warning can safely be ignored.

3. Investigating Logs & Interactive Details

💡 Pro-Tip: As noted in the subtitle instruction, you havecan selected.double-click Thedirectly fileson ofany yourrow rightsor providerssheet evolveline and we haveitem to adapttrigger thea filtersdrill-down accordingly.

window

displaying

a

detailed

row-by-row

A summaryview of the numberdata.

of

imported

lines
• as

  Logs wellButton: asClick the amount"Logs" presentbutton innext to the navigation bar to open a raw text file appears. ActiveZone isdetailing the zone used inside the filter to import theexact data ofconversion yourmetrics, file.skipped Itlines, isor importantcolumn tomapping makedetails surefor thatstructural the amount found matches the amount indicated in the PDF file sent by your rights provider. Otherwise, do not hesitate to contact us to make sure that it is not an error in the filter but an error in the file transmitted by the third party.troubleshooting.

  Next

Import completed