Royalty Reconciliation Workbook

What’s Included

• Expected — calculated-expected per title × territory × period from your contract schedule.
• Reported — what the platform actually paid (feed this from the Royalty Statement Cleanup output).
• Variance Report — left-joins Expected on Reported and flags MISSING (red), UNDERPAID (amber), OVERPAID (blue), OK (green).

How to Use

1. Fill Expected with your calculated amounts (from contract % × reported gross, or from your own forecast).
2. Paste platform-normalized data into Reported.
3. Open Variance Report — the join happens automatically on Title | Territory | Period.
4. Start with MISSING rows (territory not reported at all) and UNDERPAID rows > your tolerance (default: $50 or 5%, whichever is higher).

Related Tutorials

• Audit Royalty Calculations vs. Contract (/tutorials/audit-royalty-calculations-vs-contract)
• Clean Royalty Statements from Platforms (/tutorials/clean-royalty-statements-from-platforms)

Common Pitfalls

• Join keys drift. “United Kingdom” vs “GB” vs “UK” all break the join. Normalize territories in the Statement Cleanup step first.
• MG recoupment phases. If the title is still recouping MG, “underpayment” is expected — the statement is correct, the expected math is wrong. Mark recouping titles in Expected so the variance excludes them.
• Holdbacks. A territory being held back looks identical to “missing” in a reconciliation. Tag holdback rows in Expected with Status = HELDBACK so the variance report excludes them from MISSING.