Your cart is currently empty!
SayPro Royalty Tracking Spreadsheet
SayPro is a Global Solutions Provider working with Individuals, Governments, Corporate Businesses, Municipalities, International Institutions. SayPro works across various Industries, Sectors providing wide range of solutions.
Email: info@saypro.online Call/WhatsApp: Use Chat Button 👇
SayPro Royalty Tracking Spreadsheet
This Royalty Tracking Spreadsheet is designed to manage and monitor payments, royalty distribution, and the overall revenue-sharing process for each campaign. It ensures transparency and accountability for both SayPro Ads and its partners.
Spreadsheet Sections:
- Royalty Overview
- Partner Information
- Campaign Financial Breakdown
- Royalty Calculation & Distribution
- Payment Tracking
- Payment Summary
1. Royalty Overview
| Field | Details |
|---|---|
| Partner Name | [Partner Name] |
| Campaign Title | [Campaign Title] |
| Campaign Duration | [Start Date] to [End Date] |
| Total Ad Spend | [Total Ad Spend Amount] |
| Revenue Generated | [Total Revenue Generated] |
| Royalty Percentage (SayPro) | [SayPro’s Royalty Percentage] |
| Royalty Percentage (Partner) | [Partner’s Royalty Percentage] |
| Total Royalties Payable | [Calculated Total Royalties] |
2. Partner Information
| Partner Name | Contact Person | Phone Number | Payment Terms | |
|---|---|---|---|---|
| [Partner 1] | [Name] | [Email] | [Phone Number] | [e.g., 30 days] |
| [Partner 2] | [Name] | [Email] | [Phone Number] | [e.g., 45 days] |
3. Campaign Financial Breakdown
| Campaign Title | Ad Spend | Revenue Generated | Gross Profit | Royalty Payment Due (Partner) | Royalty Payment Due (SayPro) |
|---|---|---|---|---|---|
| [Campaign 1] | [Amount] | [Amount] | [Amount] | [Calculated Amount] | [Calculated Amount] |
| [Campaign 2] | [Amount] | [Amount] | [Amount] | [Calculated Amount] | [Calculated Amount] |
4. Royalty Calculation & Distribution
| Campaign Title | Total Revenue | Total Ad Spend | Partner Royalty Percentage | Partner’s Royalty Amount | SayPro Royalty Percentage | SayPro’s Royalty Amount |
|---|---|---|---|---|---|---|
| [Campaign 1] | [Revenue] | [Ad Spend] | [Percentage] | [Calculated Amount] | [Percentage] | [Calculated Amount] |
| [Campaign 2] | [Revenue] | [Ad Spend] | [Percentage] | [Calculated Amount] | [Percentage] | [Calculated Amount] |
5. Payment Tracking
| Campaign Title | Partner’s Royalty Payment Due | Date Due | Date Paid | Amount Paid | Remaining Balance |
|---|---|---|---|---|---|
| [Campaign 1] | [Amount] | [Due Date] | [Paid Date] | [Paid Amount] | [Remaining Balance] |
| [Campaign 2] | [Amount] | [Due Date] | [Paid Date] | [Paid Amount] | [Remaining Balance] |
6. Payment Summary
| Partner Name | Total Royalty Due (This Period) | Total Paid | Outstanding Balance | Date of Final Payment |
|---|---|---|---|---|
| [Partner 1] | [Total Due] | [Total Paid] | [Balance] | [Final Payment Date] |
| [Partner 2] | [Total Due] | [Total Paid] | [Balance] | [Final Payment Date] |
Royalty Distribution Example Calculation
- Total Revenue Generated: $10,000
- Total Ad Spend: $5,000
- Partner’s Royalty Percentage: 30%
- SayPro’s Royalty Percentage: 70%
Partner’s Royalty Amount:
- $10,000 (Total Revenue) * 30% = $3,000
SayPro’s Royalty Amount:
- $10,000 (Total Revenue) * 70% = $7,000
Instructions for Use:
- Enter Campaign Details: Fill in the basic details for each campaign, including the campaign title, total ad spend, and the revenue generated.
- Calculate Royalty: Input the royalty percentage for both SayPro and the partner, and calculate the royalty amount for both parties based on the total revenue.
- Track Payments: Record the amount due and the amount paid for each royalty distribution, along with the dates to track outstanding balances.
- Summarize Payments: At the end of each period, summarize the total royalty amounts due and paid to ensure transparency and accuracy in financial reporting.
This Royalty Tracking Spreadsheet ensures that all financial aspects of royalty distribution are monitored, payments are tracked, and partners receive accurate and timely payments based on their agreements. Adjust as needed based on your specific business needs or royalty-sharing model.
Leave a Reply