Free Template
Royalty Tracking Sheet
Track revenue by platform, title, and territory with period rollups. Includes formulas for minimum guarantee tracking and overage calculations.
excelgoogle-sheets
What’s Included
- Revenue Input Sheet — Log royalty statements by platform, title, territory, and period
- Platform Summary — Aggregated revenue per platform with period-over-period comparison
- Title Performance — Revenue per title across all platforms and territories
- MG Tracker — Minimum guarantee balance tracking with overage calculation
- Currency Handling — Multi-currency input with conversion rate table
- Reconciliation Log — Track discrepancies between expected and reported revenue
How to Use
- Enter royalty statement data in the Revenue Input sheet
- The summary sheets auto-calculate aggregations
- Update the MG Tracker when new statements arrive
- Use the Reconciliation Log to flag and resolve discrepancies
Key Formulas
- Overage = Total Revenue - Minimum Guarantee (only positive values)
- Revenue Share = Platform Revenue × Distribution Fee × Rights Holder Share
- Period Growth = (Current Period - Prior Period) / Prior Period
Get New Templates
We release new templates regularly. Subscribe to get them in your inbox.