Royalty Statement Reconciliation for Producers

Why Producers Must Reconcile Statements

Streaming and sync money arrives late, split across distributors, collection societies, publishers, and beat marketplaces. If you only watch PayPal deposits, you cannot tell a real decline in streams from a missing ISRC, a wrong split, or a statement you never downloaded.

Reconciliation is not full corporate accounting. It is a producer-scale control: expected lines vs paid lines, every month or quarter, with exceptions that have owners and due dates. The worked numbers below are examples for teaching the method — not forecasts of your catalog.

What You Are Matching

Never merge composition and master cash into one unlabeled bucket. A “missing” PRO payment does not mean the distributor failed — different rights, different pipes.

Spreadsheet Schema (Copy This)

Use three sheets: Catalog, Statements, Exceptions. Keep one workbook per calendar year.

Sheet A — Catalog (one row per monetizable asset)

Columns: asset_id | title | isrc | upc | work_id | asset_type (master/beat/composition) | your_share_pct | co_writers | distributor | pro | release_date | territory_notes | expected_sources (flags) | active (Y/N)

Sheet B — Statements (one row per paid line)

Columns: stmt_id | source (distributor/pro/marketplace/…) | period_start | period_end | received_date | asset_id | isrc_or_work | store_or_society | units_or_plays | gross_amount | fee_or_commission | net_amount | currency | your_share_applied | expected_net | variance | match_status (matched/partial/unmatched) | notes

Sheet C — Exceptions

Columns: exception_id | opened_date | stmt_row_or_asset | type (missing_stmt / wrong_split / unknown_isrc / negative_adj / fx / late) | severity (L/M/H) | owner | status (open/waiting/closed) | next_action | due_date | resolution | closed_date

• variance formula variance = net_amount - expected_net (same currency). Convert FX in a separate column before comparing.
• expected_net sketch For teaching: expected_net ≈ units * rate_estimate * your_share_pct when you have a rate; otherwise mark expected_net blank and only match presence/absence of lines.
• match_status rules matched if |variance| ≤ threshold (e.g. $1 or 2%); partial if same asset but gap; unmatched if no catalog row.

Worked Example Rows (Illustrative)

Scenario: Producer P has a 50% writer share on Song S (work_id W-100), ISRC US-XX1-00-00001 on the master, distributed digitally, and a $49 beat lease on the side. Figures are made-up for the tutorial.

Reading the example: DSP lines are within tolerance. PRO expected ~$25 for the quarter but paid $0 → open a high-severity exception (registration or society lag). Marketplace lease matches. Unknown ISRC $6.10 needs catalog research — often a wrong upload or a feature you forgot.

Monthly Reconciliation Workflow

1. Freeze the period
   Pick calendar month M for distributor cash and the overlapping PRO quarter. Do not mix open periods in one pass.
2. Download all statements
   Distributor CSV, PRO PDF/CSV, marketplace payout export, sync invoices. Store in /Royalties/2026/03/raw/.
3. Import to Statements sheet
   One row per line item. Do not pre-sum in your head — sum with pivot tables later.
4. Join to Catalog
   Match ISRC / work_id / order. Unmatched → exception.
5. Compute variance
   Where you have expected_net, flag outside tolerance. Where you do not, check presence and odd zeros.
6. Work exceptions oldest first
   High severity first. Log tickets and email threads in notes — not only in your inbox.
7. Close the month
   Write a 5-line summary: total net by source, open exceptions count, cash received vs statement net (bank timing).

Exception Playbook

• Unknown ISRC / title Search distributor; check features and alternate mix ISRCs; ask collaborator for metadata export.
• Zero PRO on active radio/stream hit Confirm work registered, writer shares, performing party IPs; check if performances fall in unpaid period.
• Wrong split Compare to signed split sheet; if dashboard share differs, file correction with admin/distributor.
• Negative adjustment Read statement notes (returns, fraud, prior overpay). Attach the explanation PDF to the row.
• FX noise Convert with statement FX rate, not your bank’s rate, when comparing expected vs paid.
• Marketplace vs bank Statement net may predate payout batching. Match on payout ID when available.

Common Mistakes

• Reconciling only PayPal Deposits lag and combine sources. Always start from statements.
• Mixing master and publishing Separate pipes prevent false “missing money” panic.
• No catalog sheet Without ISRCs and shares, every month is archaeology.
• Closing exceptions in your head If it is not in the Exceptions sheet, it will return next quarter.
• Treating estimates as invoices expected_net is a control, not a legal receivable, unless a contract says so.

Cadence That Fits a Working Producer

Block 90 minutes on the same day each month after distributor CSVs land. Mid-quarter, spend 30 minutes only on open High exceptions. At year-end, export the workbook PDF for taxes with your accountant — reconciliation is for control; tax treatment depends on your locale and professional advice.

When you onboard a new release, add Catalog rows the same week as ISRC assignment, not when the first statement confuses you. Tie this to clean metadata habits in ISRC and credits checklists and rights docs from beat licensing contracts.