Multi-creator projects — joint series, co-produced courses, bundled products — all need a transparent, trackable way to split revenue. Skipping this at the start is the most common reason collab partnerships break down.
Define which revenue streams go into the shared pool
Before building the spreadsheet, agree on which revenue gets pooled:
- Product or course sales (net of platform fees)
- Brand sponsorship income
- AdSense or platform monetization
- Affiliate commissions
- Live stream or super chat revenue
Not everything needs to be shared — for example, if one creator brings in their own sponsor, the group may agree they keep that separately.
Basic spreadsheet structure
Sheet 1: Split configuration
Record each person's percentage: Creator A 40%, Creator B 35%, Creator C 25% — or whatever formula the group agreed on. Note the reasoning (who contributes what: capital, production, audience size).
Sheet 2: Monthly revenue tracking
Columns for month, source, gross amount, platform fee, net revenue. Fill in monthly. The net revenue total feeds the payout formula.
Sheet 3: Payout calculation
Automated formula: =NetRevenue * SplitPercentage. Record expected payout date and status (pending / paid). Keep full history of all payout rounds.
Things to agree on before building the spreadsheet
- Who maintains and updates the spreadsheet?
- Review frequency: monthly or quarterly?
- Minimum payout threshold to avoid micro-transactions?
- Payment method: bank transfer, PayPal, or other?
- What happens if a creator leaves the project midway?
Download tutorials on building Google Sheets or Excel revenue trackers using Klypio YouTube downloader or @KlypioBot.
Also see: creator collaboration agreement template VN, payment escrow for creator collab VN.