Did the money match the deal?
Statements from every source in one place, against the agreements they are paying — with the commission worked out from the statement, not from a spreadsheet afterwards.
Statements stop being a quarterly archaeology project.
The deal is here. The statement is here. What is owed, what has been recouped and what commission comes off it are the same three questions every quarter, already answered.
What arrives, and from where
Statements come from your societies, your publisher, your label, your distributor and the neighboring-rights side — in different formats, on different calendars, in different currencies, none of them agreeing on what a period is. Some sources have a connector and the rest are uploaded. Either way they land in one place, against the deal they are paying.
What is in it
Set up who pays out each deal. Before a statement can be checked, somebody has to know which party is meant to send it. That is tracked per deal — needs setup, in progress, set up, income arriving — so the deals that were signed and never wired up are visible rather than assumed.
Statements against the deals they pay. A statement is linked to the agreement behind it, so the question is not "what arrived" but "what arrived against what we agreed".
A running recoupment balance. What is left against the advance, and whether the deal is still unrecouped. One number, kept current, rather than reconstructed each quarter.
Income broken down by where it came from. Performance, mechanical, sync and the rest, by period and by source, so a quarter that looks flat can be read for which line actually moved.
A calendar of when money is due. Statement periods do not arrive on your schedule. Knowing which one is late is the first half of chasing it.
Management commission calculated off the statement. Not re-derived by hand from a PDF, and marked collected when it is actually in.
Why royalties resist a spreadsheet
The statement and the agreement live in different worlds. The statement says what was paid. Only the contract says what should have been. A tool that holds one without the other can tell you the number but not whether it is right — and the whole job is whether it is right.
Every source has its own period, format and currency. Four payers, four calendars, four definitions of a quarter. Normalizing that by hand is most of the work and none of the value.
Recoupment is a moving balance, not a status. An advance is paid down across statements over years. Whoever holds that number in a spreadsheet is a single point of failure, and it is almost always one person.
Money that never arrives looks exactly like money that is late. A missing statement is silent. It shows up as an absence, and absences are what nobody notices until an audit.
Four things worth getting right
Wire up the payer when the deal is signed. The gap between executing an agreement and being registered to collect on it is where the largest quiet losses happen, and it is entirely administrative.
Keep the statement next to the contract. Filing statements by payer instead of by deal is what makes checking them a research project.
Track what has not arrived, not just what has. A list of received statements cannot show you a missing one.
Take the commission off the statement, not off a summary. Every hand-copied figure between the statement and the invoice is a place a percentage point goes missing.
Common questions
Do statements come in automatically?
Some do. Where a source has a connector it can be connected; where it does not, the statement is uploaded, and the workspace says which is which per source. Either way the statement ends up linked to the deal it pays rather than sitting in a folder.
Does it handle recoupment?
Yes. A running balance after recoupable advances is held against the deal, so whether something is still unrecouped is a current fact rather than a calculation somebody redoes each quarter.
Can it work out commission?
Yes — management commission is calculated from the statement itself and marked collected when it is in, so what you bill is not re-derived by hand from a PDF.
How is this different from a royalty dashboard?
A dashboard reports what arrived. This holds the agreement that says what should have arrived, the statement that says what did, and the commission that comes off it — which is what makes the difference between the two answerable.
Know what should have arrived. Then check that it did.
