Free Template
Royalty Statement Cleanup Workbook
Normalize messy platform royalty CSVs (Netflix, Amazon, Apple) into a canonical title/territory/period schema. Field mapping sheet documents every transform.
excelgoogle-sheets
What’s Included
- Raw Statement Paste — a permissive 10-column input tab; paste whatever layout the platform gave you.
- Canonical Output — 7 columns: Canonical Title, ISO Territory, Period (YYYY-Qn), Gross USD, Net USD, FX Rate, Platform. Formulas pull from the raw paste.
- Field Mapping — reference sheet listing how each platform’s columns map to the canonical schema.
How to Use
- Paste the platform’s CSV into Raw Statement Paste (column order doesn’t matter — the formulas use named references).
- Set the Platform dropdown on row 2 so formulas pick the right mapping.
- Open Canonical Output — one normalized row per source row.
- Save a copy of the output as CSV and feed it into the Royalty Reconciliation template.
Related Tutorials
- Clean Royalty Statements from Platforms (
/tutorials/clean-royalty-statements-from-platforms) - Audit Royalty Calculations vs. Contract (
/tutorials/audit-royalty-calculations-vs-contract)
Common Pitfalls
- Platforms rename columns between quarters. Netflix has changed “Territory” → “Country” → “Country ISO” at least twice. Re-check the mapping every quarter before trusting the output.
- Period encoding. “Q1 2026”, “2026-Q1”, “Jan-Mar 2026”, and “20260331” all mean the same thing. The workbook normalizes to
YYYY-Qn; confirm yours matches before reconciling. - FX rate source. The template uses a static FX table. For audit-grade work, replace with the rate the contract specifies (month-end ECB, monthly average, etc.).
Get New Templates
We release new templates regularly. Subscribe to get them in your inbox.