Blog · Board and management reporting
Compare recorded royalties, composition income, licensing, merchandise and live-event revenue on consistent periods. Use supplied rights shares, reconcile statement settlements and explain the movement in a worked example.
Music business revenue analytics compares royalty, licensing, merchandise and live-event income on a common period and company-share basis. A larger payment does not necessarily mean stronger current-period trading. First reconcile what each statement represents, then measure the movement in the company's earned income.
A recording and its underlying composition are different works. The US Copyright Office explains that they are separate copyright-protected works, commonly owned and licensed separately. Keep those categories distinct in the analysis even when the song title is identical.
Preserve earned period, statement date, ledger posting period and payment date. Warner Music Group's annual report describes publishing usage reports arriving in arrears and royalties recognized using usage reports or estimates when reports are unavailable. That illustrates why receipt date alone cannot establish the underlying earning period.
Finance should supply the approved period mapping, estimates and later adjustments. Keep an as-posted ledger view and a comparable-period management view if they differ, with an explicit bridge between them. Do not silently move a late statement into a prior closed month.
Use one row per statement line or approved grouped balance. The source record needs statement ID, counterparty, artist or catalog, territory, currency, rights category and earned dates. Add these calculation columns:
| Column | Field | Instruction |
|---|---|---|
| A | Income stream | Keep recording and composition categories separate |
| B | Base before company allocation | State whether this is already company income |
| C | Approved company share | A supplied allocation, stored as a percentage |
| D | Sales credits before allocation | Use only credits applicable to this base |
| E | Company earned income | Subtract credits, then apply the share |
| F | Settlement offsets | Supplied amounts withheld from remittance |
| G | Net statement settlement | Company income less settlement offsets |
If B already contains company income, C is 100%. Do not apply the contractual percentage again. If the statement combines territories or effective dates with different shares, split the line before calculating it.
In Excel or Google Sheets, E2 and G2 are:
=(B2-D2)*C2
=E2-F2
These formulas implement the supplied reporting basis. They do not establish ownership or interpret a contract. A fixed-fee license follows its approved earning schedule; it does not acquire a usage-based recognition rule merely because another stream uses one.
Covirage is not affiliated with Microsoft or Google.
Consider a fictional US music company reporting the quarter ended June 30, 2026. Finance has supplied the following earned-period balances and shares. All amounts are USD; the bases are approved for this example, and the shares are illustrative business instructions rather than industry rates.
| Income stream | Base (USD) | Company share | Credits (USD) | Company earned income (USD) |
|---|---|---|---|---|
| Recording royalties | 160,000 | 50% | 0 | 80,000 |
| Composition royalties | 40,000 | 25% | 0 | 10,000 |
| Licensing | 60,000 | 50% | 0 | 30,000 |
| Merchandise | 50,000 | 100% | 5,000 | 45,000 |
| Live events | 90,000 | 100% | 0 | 90,000 |
| Total company income | 255,000 |
Recording income is $160,000 multiplied by 50%, or $80,000. Merchandise is $50,000 less $5,000 of returns, multiplied by 100%, or $45,000. Add the five company amounts to obtain $255,000; summing the unallocated bases would answer a different question.
For the actual export, sum E by the approved earned period, stream and catalog. Use a pivot table or a stream summary such as:
=SUMIFS($E$2:$E$6,$A$2:$A$6,"Recording royalties")
Add catalog and territory criteria when those fields are available. Unmapped categories stay visible until resolved; they should not disappear from the control total.
The same statements contain the following approved settlement offsets. In this example they are amounts applied to earlier advances, classified separately by finance; they reduce remittance without reducing the earned income shown above. Other statement deductions need their own approved treatment.
| Stream | Company income (USD) | Settlement offsets (USD) | Net settlement (USD) |
|---|---|---|---|
| Recording royalties | 80,000 | 15,000 | 65,000 |
| Composition royalties | 10,000 | 2,000 | 8,000 |
| Licensing | 30,000 | 5,000 | 25,000 |
| Merchandise | 45,000 | 0 | 45,000 |
| Live events | 90,000 | 10,000 | 80,000 |
| Total | 255,000 | 32,000 | 223,000 |
The proof is $223,000 plus $32,000 equals $255,000. Reconcile the income column to the approved revenue ledger and the offsets to the corresponding advance records. Match settlements to bank receipts by statement ID when paid; an unpaid settlement belongs on the outstanding list, not in cash collected.
This separates a commercial question from a cash question. A lower remittance after advance recoupment does not, by itself, show a decline in earned revenue. For the broader reporting choice, see revenue analytics approaches.
Compare the same quarter, company perimeter and stream definitions. Dollars below are exact; total growth is rounded to one decimal place.
| Stream | Prior income (USD) | Current income (USD) | Change (USD) |
|---|---|---|---|
| Recording royalties | 70,000 | 80,000 | 10,000 |
| Composition royalties | 8,000 | 10,000 | 2,000 |
| Licensing | 20,000 | 30,000 | 10,000 |
| Merchandise | 40,000 | 45,000 | 5,000 |
| Live events | 70,000 | 90,000 | 20,000 |
| Total | 208,000 | 255,000 | 47,000 |
The stream changes total $47,000, so $208,000 plus $47,000 equals $255,000. Growth is $47,000 divided by $208,000, or 22.6%. Live events supply the largest dollar increase; finance should ask whether event count, settlement terms or revenue per event changed before attributing it to stronger demand.
A share variation shows why the allocation basis matters. Hold the recording base at $160,000 but change the supplied share from 50% to 60%: company recording income becomes $96,000, an increase of $16,000. Total income becomes $271,000 even though the underlying base is unchanged. Report that movement as an allocation change, with its approved effective date.
Commercial operations owns source statements and catalog mapping; finance owns period treatment, allocation instructions and ledger reconciliation. Sales analytics and revenue intelligence answer adjacent commercial questions. The equivalent event-and-stream exercise is sports business revenue analysis.
Bring your royalty, licensing and sales summaries as files or a Google Sheet, including finance-approved periods and company shares; Covirage maps the columns, and its tools compute and check the comparisons. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See revenue driver analysis for the supporting approach.
Use royalty statements, approved licensing schedules, merchandise sales and returns, live-event settlement summaries and the revenue ledger. Include earned periods, payment dates, currency, rights categories and the company share supplied by finance. Preserve statement IDs so adjustments remain traceable.
Payment month is appropriate for a cash view, but it can mix earnings from different periods. For an income comparison, use the earned period approved by finance and show late reports or adjustments separately. Retain payment dates for a separate settlement reconciliation.
No. Some statements already report the company's allocated income, while others show an amount before a supplied share. Record that basis before calculating anything. Apply the share once, and use only shares confirmed for the specific rights category, territory and effective period.
No. This workflow reconciles amounts and allocation instructions already supplied by the business. Questions about ownership, conflicting shares or contract interpretation need the appropriate business owner and advisers. Keep disputed lines separate until approved instructions are available.