A quarterly routine, not a year-end scramble
Left unattended, royalty reconciliation drifts into a year-end scramble — a label pulling twelve months of distributor, PRO and sub-publisher statements at once, trying to match tracks from memory of a busy release year. That approach works until it doesn't, usually right when a genuine metadata gap needs to be found among a pile of ordinary reporting-lag statements.
This guide describes eight steps to do instead, on a quarterly cadence, so each period's reconciliation stays small enough to actually finish.
Why this drifts without a routine
A single quarter's reconciliation is a manageable task, even across several royalty sources. A full year stacked together is four times the volume with none of the context — by the time someone gets to it, the specific release or metadata quirk behind a mismatched line may be long forgotten, and the original statement has to speak for itself.
A fixed quarterly cadence keeps the volume small and the context fresh, which is most of what makes this reconciliation fast rather than dreaded.
Two decisions before the first statement
First: who owns this quarterly, by name — not “whoever has time,” which quietly becomes nobody the first busy release cycle. Second: what counts as a discrepancy worth escalating versus a reporting lag that resolves itself once a slower source's statement actually arrives.
Both decisions take five minutes to make and prevent the two most common ways this routine falls apart — nobody doing it, and every ordinary reporting delay being treated as a crisis.
Picking a cycle and sticking to it
The specific week matters less than the consistency of picking one. Six to eight weeks after each calendar quarter closes tends to work well — enough time for the fastest sources, usually distributors, to have issued their statements, without waiting so long that the reconciliation itself gets pushed into the next quarter's busy period.
What matters more than the exact timing is protecting it. A reconciliation that gets bumped “just this once” because a release deadline came up tends to get bumped again the following quarter, and the routine quietly slides from quarterly to annual without anyone deciding that on purpose.
The eight steps
Pull every statement for the period
Every distributor, PRO, sub-publisher and mechanical statement issued for the quarter — exported directly from each source's own portal rather than retyped from a summary email, since a summary email is one more place a transcription error can creep in.
Include adjustment or correction statements if a source issues them separately; those lines matter later when reconciling against a prior period's figures.
Read each statement's per-track lines
Title, ISRC, ISWC, units or performances, gross and net amounts, currency and territory, for every line on every statement — not just the summary total each statement prints on its cover page, which hides exactly the per-track detail a reconciliation needs.
A statement covering dozens or hundreds of tracks makes this step the slowest part of the whole routine done by hand, and the first one worth automating.
Match every track across statements
Use ISRC where every source reports it — it's the strongest available signal for a specific recording. Where a statement keys to ISWC instead, or carries no code at all, match by composition identifier or by title and artist, flagging the weaker match for a quick confirm.
Keep a running note of which tracks remain unmatched after this step — that list is the input to step six.
Sum matched income per recording or composition
Roll every matched source's figures into one total per track, while keeping each source's individual contribution visible — a track's distributor income, mechanical income and performance income are each worth seeing on their own, not just as a single blended number.
Check the total against deposits and recoupment
Confirm the summed royalty income for the period lines up with what actually landed in the bank — accounting for any recoupment balance still being worked off against an advance, which can mean a real, fully earned royalty produces a net payable of zero.
Investigate any unmatched or missing statement
Before treating a missing statement as a problem, confirm it's actually due for this period — some PROs and sub-publishers report semi-annually or annually rather than quarterly, and a statement that isn't late at all shouldn't be chased as if it were.
Document the exception
A short note on what caused a gap and how it was resolved — a metadata correction filed with a society, a confirmed reporting lag with an expected arrival date — attached to that period's reconciliation sheet.
Close the period
Export the reconciled catalog income, with every line traceable back to its source statement, ready to feed songwriter payments, recoupment tracking or a label's own financial reporting.
Handling discrepancies with method
Not every unmatched item is a real discrepancy — most resolve within a source's usual reporting lag once given another quarter or two. What separates a genuine discrepancy from a lag is whether it's still unexplained well after that window has passed.
Sharing a specific, concrete gap with a distributor, PRO or sub-publisher — the exact ISRC or ISWC, the exact period, the exact figure expected — tends to get a faster, more useful response than a general inquiry about “missing royalties,” and often surfaces a metadata fix on both sides.
Keep a short running log of confirmed discrepancies and their resolutions, even the small ones. Over a year or two, that log becomes its own useful reference — a metadata gap that repeats across releases is worth fixing at the registration source; a one-off correction from a year ago is worth remembering the next time something similar shows up.
A quarter, worked through
A small label's catalog, eighteen active tracks, one distributor and one domestic PRO. Sixteen tracks match cleanly across both statements by ISRC and ISWC within twenty minutes. The remaining two show up unmatched on the PRO statement at first glance.
Step six resolves it: both tracks were released only four months earlier, and the PRO's reporting lag for newly registered compositions runs closer to two quarters than one — not a discrepancy, just a registration still working its way through the pipeline.
Common mistakes
Treating the distributor statement's total as the full quarter's income without waiting on slower sources.
Paying out recoupment or songwriter shares before the royalty total has actually been reconciled.
Letting two or three quarters pile up before reconciling any of them.
Escalating a reporting lag to a PRO or sub-publisher before its normal window has passed.
Skipping the documentation step on a resolved metadata gap.
Best practices
Reconcile on the same cycle every quarter, so it never competes with a release deadline's priorities.
Keep the unmatched list visible until every item resolves, rather than letting it fall off the sheet.
Register ISRC and ISWC for every new release before its first statement is even due.
Review a full year of reconciliation sheets together once a year to spot slow-forming black-box patterns.
None of these four are complicated on their own — together, they're what separates a reconciliation routine that survives a busy release year or a staff handoff from one that quietly stops happening the first time the usual person is unavailable.
Turning it into a routine, not a chore
The eight steps stay the same every quarter; what changes is how much time each takes once the historical backlog is cleared and a document reader handles steps one through four automatically. A routine that used to take several hours settles into thirty or forty minutes once it has nothing but the current quarter to process.
The annual check
Beyond the quarterly routine, an annual review comparing total royalty income against total streaming or sales volume catches a slow rate drift or a persistent black-box pattern that a single quarter's reconciliation, focused on matching rather than trend analysis, would never surface on its own.
A recording that consistently under-reports on one specific PRO or sub-publisher relative to its streaming volume, quarter after quarter, rarely shows up as a single dramatic discrepancy — it shows up as a pattern only an annual comparison across a full year of reconciliations makes visible.
The annual check is also the right moment to reconcile the reconciliation sheet itself against the catalog's master registration list — confirming every active release still has a current, correctly spelled entry with its ISRC and ISWC, rather than assuming a registration made years ago is still accurate. Distributors occasionally re-issue a catalog's metadata during a platform migration, and a stale registration is one of the quieter ways a previously well-matched track starts drifting into the medium-confidence tail described earlier.
What you actually need
None of this requires specialized royalty accounting software to start. A spreadsheet works fine for the reconciliation sheet. What's genuinely slow by hand is reading each statement's per-track lines consistently enough, quarter after quarter, to keep that sheet current.
A document reader that extracts track titles, identifiers and amounts the same way every time, whether the source is a clean CSV export or a scanned PDF, removes exactly that bottleneck — see ISRC and UPC matching across statements for how that reading feeds directly into the matching step.
Running this across every royalty source
For a catalog earning through a distributor, a domestic PRO, a foreign sub-publisher and a mechanical collection society at once, the same eight steps apply per source, run in parallel once the routine is established — not sequentially, which would turn a forty-minute quarterly task into a full day.
A shared reconciliation sheet format across every source makes it possible to spot a pattern that repeats on one source but not the others — often the first sign of a metadata or registration issue worth investigating. See distributor and PRO statements to Excelfor how those two source types' formats differ in practice.
See finance for independent labels and publishersfor how this routine changes shape once it's running across a full catalog and multiple writers rather than a single release.
| Source | Typical reporting lag |
|---|---|
| Distributor | Weeks after the streaming or sales activity, on a monthly cycle |
| Domestic PRO | One to two quarters after the performance period |
| Foreign sub-publisher | Six months to over a year, after domestic collection abroad |
| Mechanical collection society | One to two quarters, matched to ISRC and ISWC together |
The very first time, step by step
The first reconciliation under this method usually covers more than one quarter of backlog, which means more unmatched tracks than a normal quarter and more time spent on step six. Budget several hours rather than the thirty or forty minutes a steady-state quarter will eventually take.
Once the backlog clears, the routine settles into its normal, much shorter rhythm — the first pass is the investment that makes every quarter after it fast.
It's worth resisting the urge to rush the first pass just to clear the backlog quickly. A metadata gap investigated and fixed properly the first time stays fixed for every subsequent statement on that recording — knowledge and correction that pay off on every reconciliation that follows.
The reconciliation sheet, column by column
| Column | Purpose |
|---|---|
| Track title, ISRC & ISWC | Ties every row back to the same recording and composition |
| Source statement & period | Which distributor, PRO or society reported this line, and when |
| Gross amount, currency & territory | What the source reported before any fees or conversion |
| Fees / commission deducted | What explains the gap between gross and net |
| Recoupment balance affected | Whether this royalty offsets an outstanding advance |
| Status & notes | Matched, flagged, or resolved with a short explanation |
Six columns cover almost every case in practice — enough structure to answer “what happened to this royalty” without so many fields that the sheet itself becomes a burden to maintain.
When a royalty accountant handles this instead
A label or publisher working with an outside royalty accountant or business manager doesn't skip this method — it just moves who runs it. What matters for a clean handoff is that the accountant receives every source statement directly, rather than a pre-summarized figure the label assembled itself, since the summarizing step is exactly where a metadata gap or an unmatched line tends to get quietly smoothed over.
A label that keeps its own light version of this routine running in parallel — even just checking that every expected statement actually arrived — catches a source dropping out of an accountant's process faster than waiting for an annual report to reveal it.
The rhythm that repeats every year
A catalog's reconciliation rhythm tends to follow its release calendar as much as the actual calendar quarter — a busy release season means more new tracks entering the pipeline with no reporting history yet, which means more first-time metadata gaps to catch in the quarters right after.
Recognizing that pattern means budgeting a little more review time for the two or three quarters following a busy release period, rather than expecting every quarter to take the same amount of time regardless of how much new material entered the catalog recently.
Building a clear escalation path
Not every discrepancy needs the same response. A missing statement that's simply not due yet needs nothing. A statement that's genuinely overdue against its normal cycle needs a routine follow-up. A metadata mismatch that's been confirmed and is actively costing the catalog money — a real black-box case — needs a formal claim filed with the relevant society.
| Tier | Response |
|---|---|
| Not yet due | No action — note the expected arrival period and move on |
| Overdue against its normal cycle | A routine follow-up with the source, referencing the specific period |
| Confirmed, costly metadata gap | A formal claim filed with the relevant society, with the corrected registration attached |
Writing that three-tier response down once, rather than deciding case by case under time pressure, keeps a genuinely urgent claim from getting the same low-priority treatment as an ordinary reporting lag. It also gives a new team member a concrete rule to apply on their first quarter, rather than having to develop the same judgment from scratch through trial and error.
What good documentation looks like
A useful note on a resolved exception is short and specific: which recording, which source, what the gap was, and what fixed it — a corrected ISWC registration, a confirmed reporting lag with an expected arrival quarter, a genuine black-box claim filed and its reference number.
What makes documentation actually useful later isn't length, it's that a different person, reading the note eighteen months on, can tell immediately whether the same issue is recurring or whether it's something new that happens to look similar.
Measuring whether the routine works
Two numbers say more than a general sense of whether reconciliation is under control: the percentage of expected statements that arrive and get reconciled within a set window after they're due, and the percentage of catalog tracks with a fully registered ISRC and ISWC.
Both tend to improve together — a catalog with clean registration produces statements that match easily, which makes it obvious quickly when one genuinely doesn't show up.
A third, slower-moving number worth tracking annually is the average time between a statement's due date and the date it was actually reconciled. A catalog that reconciles every statement within a few weeks of arrival is in a fundamentally stronger position to catch a genuine problem quickly than one that lets statements sit unreconciled for months even when the routine technically exists — the routine's existence and its actual timeliness are two different things worth measuring separately.
Who should own this
For a small label or a self-releasing artist, the same person handling releases and distribution usually owns reconciliation too — the volume doesn't yet justify a separate role. Past a certain catalog size, a dedicated royalty administrator or an outside royalty accountant becomes worth the cost specifically because the metadata and matching work scales with the number of tracks and sources, not with how much time any one person has available.
The transition point isn't a fixed catalog size so much as the moment reconciliation starts competing directly with release work for the same person's attention. A label that notices statements consistently sitting unreviewed for a month or more, not because the routine is broken but because there simply isn't time, has usually already passed that point without formally deciding to.
A spreadsheet alone versus a document reader
A spreadsheet is a fine place to keep the reconciliation sheet — the record of what was checked and resolved. It's a poor tool for the actual reading: retyping dozens or hundreds of per-track lines from a PDF or a CSV export, quarter after quarter, is exactly the kind of repetitive, error-prone work a document reader handles more reliably and far faster.
The two aren't competing tools — a document reader feeds structured, matched data into the same spreadsheet a catalog already uses, rather than replacing the spreadsheet itself.
Handing the routine to a new team member
A written version of these eight steps, plus the reconciliation sheet template and the escalation path, is usually enough for someone new to run their first quarter with minimal guidance — as long as they also have direct access to every source portal the catalog actually reports through.
The most common gap in a handoff isn't the method itself, it's access — a new team member who inherits the reconciliation sheet but not the login credentials for a sub-publisher's portal will hit a wall on their very first attempt.
Staying ready for an audit or a catalog sale
A catalog being valued for sale, or a label undergoing a royalty audit on behalf of its songwriters, needs exactly what this routine already produces: a period-by-period record of every statement received, matched, and reconciled against expected income, with documented resolutions for every gap.
A catalog that's never run this routine and needs to reconstruct that history under audit pressure faces a far larger version of the same year-end scramble this guide opened with — except now with a deadline and an external party checking the work.