Is your royalty reporting telling you what you've earned, or what you actually owe?
For film distributors, television production companies and media rights holders, calculating royalties is only part of the challenge. Knowing how much is actually payable after advances, deductions and recoupable costs have been accounted for is where things become more complicated.
A royalty statement might show healthy revenue from international distribution, streaming platforms or broadcast licensing. But does that mean a payment is due?
Not necessarily.
If an advance remains outstanding or distribution costs have yet to be recovered, the amount payable could be very different from the royalties generated.
This is why accurate recoupment tracking is essential to effective royalty management. Yet for many film and TV finance teams, it's still managed through spreadsheets, manual calculations and historical records that become increasingly difficult to reconcile.
So, how can you be confident your recoupment figures are correct every reporting period?
Recoupment is the process of recovering agreed advances or eligible costs from revenue or royalties before further payments become due, according to the terms of a contract.
In the film, television and wider media industry, this might involve:
Consider a television distributor that pays a £50,000 recoupable advance to secure international distribution rights.
During the first reporting period, £20,000 becomes available for recoupment. The outstanding balance is now £30,000.
In the next period, another £35,000 becomes available. The remaining £30,000 is recovered, leaving £5,000 potentially payable, subject to other contractual deductions.
Simple enough?
For one title and one agreement, perhaps. But multiply that across hundreds of titles, territories, rights holders and reporting periods, and royalty recoupment becomes a significant financial control challenge.
Spreadsheets are familiar, flexible and relatively easy to set up. It's understandable why many royalty teams rely on them.
The problem isn't necessarily the first calculation. It's what happens after the fifth, tenth or twentieth royalty reporting cycle.
Every reporting period depends on the accuracy of the previous one.
An incorrectly carried-forward advance, an overlooked deduction or a formula referencing an outdated worksheet can affect every subsequent statement.
For film and TV distributors managing multiple licensing agreements, additional complexity comes from different currencies, territories, royalty percentages and contractual reporting schedules.
What happens when a cost is adjusted retrospectively? Or when additional revenue arrives after a statement has been issued?
Someone must identify the change, recalculate the outstanding recoupment balance and ensure the correction flows into future royalty statements.
Without a centralised system, even experienced finance teams can struggle to maintain a reliable audit trail.
And when a rights holder questions their statement, finding the answer can mean searching through months of spreadsheets.
Imagine a film distribution company preparing quarterly royalty statements for its independent producers.
One film has a £40,000 recoupable advance.
By the end of the previous quarter, £28,000 has been recovered, leaving £12,000 outstanding.
During the current quarter, the film generates another £18,000 available for recoupment.
The correct calculation is straightforward: recover the remaining £12,000 and recognise £6,000 as potentially payable.
However, the royalty team's spreadsheet accidentally carries forward an outstanding balance of £17,000.
The statement is issued showing just £1,000 payable.
The producer has effectively been underpaid by £5,000.
The mistake isn't discovered until the producer queries the figures several weeks later.
Now the finance team must investigate the original calculation, verify historical balances, correct the statement, arrange any additional payment and check whether other titles have been affected.
It's time-consuming, frustrating and potentially damaging to the relationship.
With a centralised royalty management solution such as Just-ROYALTIES, the team can manage advances, recoupment and royalty calculations within the same system.
Rather than manually transferring outstanding balances between spreadsheets, automated recoupment calculations use the recorded financial data and configured contractual rules.
In our example, the correct £12,000 outstanding balance would be available for the next calculation, helping the team identify the £6,000 potentially payable before approving the statement.
Built-in statement review and auditable calculations provide additional opportunities to identify discrepancies before distribution.
The result? Less time investigating spreadsheet errors and greater confidence in the figures being reported.
Of course, automation still depends on accurate source data and correctly configured agreements. But it removes much of the repetitive manual recalculation that creates unnecessary risk.
Developed by Creative Total Media (CTM) and built on Microsoft Dynamics 365 Business Central, Just-ROYALTIES is designed specifically for organisations managing complex media rights, revenues and royalty obligations.
It brings royalty management into one centralised platform, helping finance and distribution teams maintain visibility across titles, territories and participants.
Its capabilities include:
Instead of rebuilding recoupment calculations every quarter, teams can work from consistently maintained financial records.
This means each new royalty calculation reflects the recorded recoupment position, rather than relying on someone to update a separate spreadsheet correctly.
For finance directors, that means stronger financial oversight. For royalty managers, it means fewer manual checks. And for rights holders, it means clearer, more reliable reporting.
As film and television distribution models become more complex, royalty management needs to do more than calculate revenue.
It needs to account for what's already been paid, what's still recoverable and what's genuinely owed.
If your team is still tracking advances and recoupment manually, how confident are you that every statement reflects the correct position?
Stop relying on spreadsheets to keep track of what has and hasn't been recouped.
Ask Creative Total Media how Just-ROYALTIES handles recoupment automatically and discover how your royalty team can reduce manual calculations, improve reporting accuracy and deliver statements with confidence.