Media, Music & Royalty Accounting
Music Streaming Royalty & Advance Recoupment Formula
Calculate Pro-Rata DSP Master Royalty Pool Payout, Contractual Artist Royalty Credited, Remaining Unrecouped Label Advance, and Payable Artist Cash Royalty.
Recoup recording advances from the artist’s royalty share—never 100% of gross receipts!
Under standard Digital Service Provider (DSP) pro-rata master-recording accounting, a streaming platform pools monthly net subscription/ad revenue Pool_Net and allocates Gross Master Receipts by stream share: Gross_Master = Pool_Net * (Catalog_Streams / Total_Platform_Streams). The #1 royalty-audit misconception among emerging catalog owners is assuming a $50,000 recording advance recoups as soon as Gross_Master reaches $50,000! In reality, major and independent label deals credit recoupment ONLY from the artist’s contractual royalty fraction r_art * Gross_Master—meaning at a 20% artist royalty rate, the catalog must generate $50,000 / 0.20 = $250,000 of Gross Master Receipts before a single dollar of cash payable clears MAX(0, Earned_Artist_Royalty - Unrecouped_Advance)!
Verify on Monthly_DSP_Pool = $500,000,000 (B2), Total_Platform_Streams = 100,000,000,000 ($0.0050/stream pool rate, B3), Artist_Catalog_Streams = 40,000,000 (B4), Artist_Royalty_Rate = 0.20 (20.0%, B5), and Unrecouped_Advance_Balance = $50,000 (B6): Gross Master Pool Payout is $500M * (40M / 100B) = $200,000.00 (E2); Credited Artist Royalty is 0.20 * $200,000 = $40,000.00 (E3); Remaining Unrecouped Advance is MAX(0, 50,000 - 40,000) = $10,000.00 (E4); and Payable Artist Cash Check is MAX(0, 40,000 - 50,000) = $0.00 (E5)! Double streams to 80,000,000 (B4 = 80,000,000): Credited Royalty hits $80,000.00, wiping out the $50,000 advance (E4 = $0.00) and releasing $30,000.00 in cash (E5)!
| Music Royalty Waterfall Metric ($500M Pool, 100B Total, 40M Artist, 20% Rate, $50k Adv) | Formula | Verified Output |
|---|---|---|
| Gross Master Pool Receipt ($) | Pool_Net * (Catalog_Streams / Total_Streams) | $200,000.00 ($0.0050 / stream) |
| Credited Artist Royalty ($) | Gross_Master * Artist_Royalty_Rate | $40,000.00 ($250k Gross Breakeven) |
| Ending Unrecouped Advance ($) | MAX(0, Beg_Advance - Credited_Royalty) | $10,000.00 ($0.00 @ 80M streams) |
| Payable Artist Cash Check ($) | MAX(0, Credited_Royalty - Beg_Advance) | $0.00 ($30,000.00 @ 80M streams) |
Pro-Rata Streaming Royalty & Advance Recoupment Formula
Validate Pool_Net > 0, Total_Platform_Streams > 0, 0 <= Catalog_Streams <= Total_Platform_Streams, and 0 < Artist_Royalty_Rate <= 1!
=LET(pl_n, B2, st_t, B3, st_c, B4, rt_a, B5, ad_u, B6, IF(OR(pl_n <= 0, st_t <= 0, st_c < 0, st_c > st_t, rt_a <= 0, rt_a > 1, ad_u < 0), "Invalid Streaming Ledger", LET(gr_m, pl_n * (st_c / st_t), cr_a, gr_m * rt_a, ROUND(MAX(0, cr_a - ad_u), 2))))Remaining Unrecouped Advance Balance Formula
Compare a 20% traditional label royalty against an 85% distribution-services deal (B5 = 0.85) in a shared business-affairs workbook: at 40M streams, Credited Royalty jumps to $170,000 and Net Cash Payable reaches $120,000!
=IF(ISTEXT(E3), E3, ROUND(MAX(0, B6 - E3), 2))Try the example
Use the original values or change them to test your understanding.