How to create Royalty Reports in IRIS
Search
- Select the IRIS.NET Royalty System tab, then select Royalty Reports.

- The report list window will open.

- Click on the Field to open the drop down and select the type of report you want to create. You can find the full list below.
- Fill in the fields, click … to find a file on your WorkSpace to add to the report.

- Once you have filled in all the necessary fields click Generate Report.

Report Descriptions
- Branch Royalties – ISP: List of intra-branch payable amounts by Major income type.
- Calculation Error: List of songs with income in the current royalty period that are not paying due to one of the following reasons: No Client setup on Song, No rates setup on the client for the specific income type, Song/Client setup would pay over 100%.
- Client Financial: List of Client opening balances, advances, payments, adjustments, income, taxes and balance due.
- Client Financial w/Bank Detail: Same as "Client Financial" (above) with additional columns containing Bank details for issuing payments.
- Client Payments Due: A list of payments due in the current period.
- Current Period to Suspense: List of unidentified income for the current period.
- Financial Transactions: List of financial transactions (Payments, Advances, adjustments, etc.).
- Held Client Financials: List of held Client opening balances, advances, payments, adjustments, income, taxes and balance due.
- Held Client Liability: List of held Client balances (simplified version of the "Held Client Financials" report).
- Income Analysis: List of income, royalty, retained and retained % broken down by company, domestic/foreign and income types.
- Income Analysis by Client: List of income, royalty, retained and retained % broken down by client or clients, domestic/foreign and income types.
- Income Analysis by Client & Song: List of income, royalty, retained and retained % broken down by client or clients and songs, domestic/foreign and income types.
- Income Analysis by Client & Song w/Payee: List of income, royalty, retained and retained % broken down by payee, client or clients and songs, domestic/foreign and income types.
- Income Analysis by Client & Source: List of income, royalty, retained and retained % broken down by client or clients, sources of income, domestic/foreign and income types.
- Income Analysis by Client & Source & Song: List of income, royalty, retained and retained % broken down by client or clients, songs, sources of income, domestic/foreign and income types.
- Income Analysis by Client & Source & Song w/Payee: List of income, royalty, retained and retained % broken down by payee, client or clients, songs, sources of income, domestic/foreign and income types.
- Income Analysis by Client & Source w/Payee: List of income, royalty, retained and retained % broken down by payee, client or clients, sources of income, domestic/foreign and income types.
- Income Analysis by Client w/Payee: List of income, royalty, retained and retained % broken down by payee, client or clients, domestic/foreign and income types.
- Income Analysis Payee: List of income, royalty, retained and retained % broken down by payee, domestic/foreign and income types.
- Payee Payments: List of payments due payees.
- Payment: List of clients that have payments due for the period. Includes opening balance, royalties, other transactions (Advances, adjustments, amount payable, taxable amount and tax rate).
- Rate Extract: List of all client pay rates (including song and source specific).
- Recipient Data File: Data file in Counterpoint file format (sent to specific clients when requested. Replaces standard Excel format sent to most clients).
- Released Statements Control: List of income statements that have been released (completed and submitted for processing in the current period).
- Royalty Run Control: List of Current period income being processed. Broken down by amount released for the current period, current and total suspense revenue (unmatched) and current and total calculation error income (revenue matched to songs that still need clients and/or rates).
- Song Client Link: List of client(s) linked to songs. (Determines how income processed to the song is paid).
- Song Earnings: List of songs earnings. Report includes breakdown by income and royalty paid by domestic/foreign and income type.
- Suspense Extract: List of unmatched works based on the definition when creating the report.
- Suspense Movements: List of previously unmatched works now linked to songs in the current period.
- Suspense Released to Error: List of previously unmatched works now linked to songs in the current period but need clients and/or rates.
- Tax Schedule: List of Clients, current period Closing Balances, Taxes due, Total Payable and Tax rate.
- Withholding Tax: List of Payee/Clients Name, Address, Withholding tax, VAT, Gross payable, Tax rate and Tax ID (US ID's restricted to last 4 digits for security purposes).