When Spreadsheets Stop Working: 7 Signs You Need a Better Royalty Operations Process
Spreadsheets are often the first royalty system a growing music business uses—and for good reason.
They are accessible, flexible, and familiar. A carefully managed spreadsheet may be perfectly adequate for a small catalog with straightforward agreements and only a few revenue sources.
But music businesses rarely remain simple.
The catalog grows. New artists and partners are added. Agreements contain different royalty rates, deductions, reserves, recoupable expenses, and reporting schedules. Statements begin arriving from multiple sources in multiple formats.
Eventually, the process that helped the business get started may no longer provide the structure, control, or visibility it needs.
The problem is not necessarily the spreadsheet. The real problem is relying on a process that has outgrown its original design.
Here are seven signs that your music company may need a more reliable royalty operations process.
1. Royalty statements take longer every period
Royalty reporting should become more efficient as a team gains experience. If every reporting cycle takes longer than the previous one, complexity may be growing faster than the process supporting it.
Common causes include:
More releases and tracks
Additional revenue sources
Inconsistent statement formats
Manual data cleanup
New contract terms
Increasing numbers of participants
Adjustments carried forward from prior periods
A process that once required a few hours may gradually consume several days or weeks. If reporting deadlines are routinely stressful, the workflow should be reviewed before the next growth stage.
2. Critical information lives in different places
One spreadsheet contains contract terms. Another contains ownership data. A shared drive holds statements. Payment instructions are stored in email, while someone’s personal notes explain how the calculations work.
When information is scattered, even a simple royalty question can become difficult to answer.
A strong process should make it possible to determine:
Who owns each right
Which agreement applies
How royalties are calculated
Which expenses are recoupable
What has already been paid
What remains outstanding
Where the underlying source data is stored
If answering those questions depends on searching through messages or asking one specific employee, the business has an operational risk.
3. One person understands the entire process
Growing companies often depend on one person who knows how every report, formula, exception, and workaround functions.
That knowledge is valuable—but it should not exist only in one person’s memory.
Ask what would happen if that person became unavailable during a reporting cycle. Could another team member locate the correct files, understand the contract terms, reproduce the calculations, and explain the final statement?
If not, the company has a single point of failure.
Written procedures, centralized documentation, consistent file structures, and clearly assigned responsibilities protect both the business and the person carrying the process.
4. Formulas are being copied and adjusted manually
Manual calculations are not automatically inaccurate. However, risk increases when formulas must be copied, modified, or rebuilt for every statement.
A small change to a cell reference can affect multiple payments. A new revenue category may be treated differently across recipients. An old formula may be carried into a new reporting period without reflecting an updated agreement.
Warning signs include:
Hard-coded percentages
Repeated copying and pasting
Calculations that cannot be easily traced
Multiple versions of the same workbook
Formulas that only one person understands
Manual currency or territory adjustments
No documented review before payment
Reliable royalty operations require controls that make unexpected changes visible before statements are issued.
5. Contract terms are difficult to translate into calculations
Royalty calculations should reflect the governing agreement, but contract language does not always map neatly into a spreadsheet.
Different agreements may define:
Royalty rates
Revenue bases
Distribution fees
Reserves
Recoupable costs
Advances
Cross-collateralization
Territory restrictions
Accounting periods
Payment thresholds
If the team must reinterpret the agreement during every reporting cycle, the calculation rules have not been operationalized clearly enough.
Each relevant contract term should be documented in a structured form that explains how it affects data, calculations, statements, and payments. Questions should be resolved with the appropriate business or legal stakeholders before reporting begins.
6. Partners regularly question their statements
Questions from artists and partners are normal. Repeated questions about the same issues may indicate that the statements or supporting process are not clear enough.
Common questions include:
Which revenue was included?
Which period does the statement cover?
How was the royalty rate applied?
Why was a particular deduction taken?
Which expenses are still unrecouped?
Was a prior-period adjustment included?
When will payment be issued?
A transparent statement should allow the recipient to understand how the payment was calculated. Internally, the company should be able to trace every amount back to its source data, applicable agreement, and calculation.
Clear reporting builds trust. Unexplained numbers—even when they are correct—can damage it.
7. Corrections are becoming routine
Every royalty operation will occasionally require an adjustment. But repeated corrections, regenerated statements, and supplemental payments suggest a larger process issue.
Track both the correction and its cause.
Was the error created by:
Missing source data?
Incorrect ownership information?
A contract term entered incorrectly?
A formula problem?
A catalog mapping issue?
Duplicate data?
An incomplete review?
A change that was not communicated?
Fixing the immediate payment is important. Fixing the underlying workflow prevents the same issue from affecting the next reporting cycle.
What does a stronger royalty process look like?
Improvement does not always mean purchasing an expensive royalty platform immediately.
A growing company may first need better operational foundations:
A centralized source of catalog and ownership information
Structured documentation of contract terms
Consistent procedures for importing and validating statements
Clear rules for calculations and exceptions
Defined reporting and payment responsibilities
Version control and approval checkpoints
Reconciliation between source revenue, statements, and payments
A documented process for corrections
Secure retention of source files and final reports
Technology can support these controls, but it cannot replace decisions about ownership, responsibilities, calculation rules, and data quality.
The right solution depends on the catalog, agreement structure, reporting volume, available resources, and growth plans of the business.
How to improve without disrupting the business
A royalty operations review can begin with a single reporting cycle.
Start by mapping the process from beginning to end:
Identify every source of royalty or revenue data.
Document where files are received and stored.
List the manual transformations being performed.
Connect each calculation to the applicable agreement.
Identify who prepares, reviews, approves, and pays each statement.
Record recurring questions, corrections, and delays.
Prioritize the areas with the greatest financial or operational risk.
This provides a practical picture of the current process before new technology or major changes are introduced.
The goal is not to eliminate every spreadsheet. It is to create a royalty operation that is accurate, traceable, repeatable, and appropriate for the size of the business.
Build the process before the pressure builds
Royalty operations often remain invisible when everything is working. They become highly visible when a payment is late, a statement is unclear, or a partner challenges the calculation.
Putting the right structure in place early helps a growing music company protect its relationships, reduce repetitive work, and prepare for additional scale.
If your royalty process depends on increasingly complicated spreadsheets, undocumented workarounds, or knowledge held by one person, it may be time to examine what happens behind the numbers.
Tsila Rights helps music companies review and improve rights, royalty, reporting, and compliance workflows. If your catalog is growing faster than your current process, contact us at hello@tsilarights.com.
Comments