Neftaly Royalty and Revenue Tracking Template
Royalty and Revenue Tracking Sheet
This template is designed to track the royalty payments and revenue generated from each advertising partnership, ensuring transparency, accuracy, and timely financial reporting. It allows Neftaly Ads to monitor the financial success of campaigns and ensure that revenue is distributed fairly between the company and its partners.
| Partnership Name | Campaign Name | Start Date | End Date | Total Revenue Generated | Neftaly Share (%) | Neftaly Revenue | Partner Share (%) | Partner Revenue | Total Royalty Payment | Royalty Payment Due Date | Payment Status | Notes/Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Partnership 1 | Winter Sale | 01-01-2025 | 01-31-2025 | $15,000 | 50% | $7,500 | 50% | $7,500 | $15,000 | 02-15-2025 | Pending | Follow up on payment. |
| Partnership 2 | Product Launch | 01-10-2025 | 01-24-2025 | $9,000 | 60% | $5,400 | 40% | $3,600 | $9,000 | 02-10-2025 | Paid | Payment received. |
| Partnership 3 | Email Campaign | 01-15-2025 | 01-20-2025 | $2,500 | 70% | $1,750 | 30% | $750 | $2,500 | 02-05-2025 | Pending | Confirm payment details. |
| Partnership 4 | Spring Sale | 01-20-2025 | 01-31-2025 | $12,000 | 55% | $6,600 | 45% | $5,400 | $12,000 | 02-10-2025 | Pending | Confirm invoice with partner. |
| … | … | … | … | … | … | … | … | … | … | … | … | … |
Column Descriptions:
- Partnership Name: The name or identifier of the partnership (e.g., “Tech Co Partnership,” “Retail Client Partnership”).
- Campaign Name: The specific campaign associated with the partnership (e.g., “Holiday Promotion,” “Product Launch”).
- Start Date: The start date of the campaign or partnership.
- End Date: The end date of the campaign or partnership.
- Total Revenue Generated: The total revenue generated by the campaign or partnership.
- Neftaly Share (%): The percentage of revenue that Neftaly Ads is entitled to receive, based on the royalty agreement.
- Neftaly Revenue: The actual amount of revenue earned by Neftaly Ads based on its share.
- Formula: Neftaly Revenue=(Total Revenue Generated×Neftaly Share (%)100)\text{Neftaly Revenue} = \left( \text{Total Revenue Generated} \times \frac{\text{Neftaly Share (\%)}}{100} \right)Neftaly Revenue=(Total Revenue Generated×100Neftaly Share (%))
- Partner Share (%): The percentage of revenue that the partner receives.
- Partner Revenue: The revenue amount owed to the partner based on the agreed share.
- Formula: Partner Revenue=(Total Revenue Generated×Partner Share (%)100)\text{Partner Revenue} = \left( \text{Total Revenue Generated} \times \frac{\text{Partner Share (\%)}}{100} \right)Partner Revenue=(Total Revenue Generated×100Partner Share (%))
- Total Royalty Payment: The total amount that needs to be paid as royalties (for this column, the “royalty” would be the full payment between Neftaly and the partner, if applicable).
- Royalty Payment Due Date: The due date for the payment of the royalty, typically based on the terms of the partnership agreement.
- Payment Status: The current status of the royalty payment (e.g., “Pending,” “Paid,” “Overdue”).
- Notes/Actions: Additional notes about the payment status or any follow-up actions required (e.g., “Follow up on overdue payment,” “Verify revenue with partner,” “Send reminder to client”).
Example of Filled Template:
| Partnership Name | Campaign Name | Start Date | End Date | Total Revenue Generated | Neftaly Share (%) | Neftaly Revenue | Partner Share (%) | Partner Revenue | Total Royalty Payment | Royalty Payment Due Date | Payment Status | Notes/Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TechCo Partnership | Winter Sale | 01-01-2025 | 01-31-2025 | $15,000 | 50% | $7,500 | 50% | $7,500 | $15,000 | 02-15-2025 | Pending | Follow up with TechCo. |
| RetailClient Partnership | Product Launch | 01-10-2025 | 01-24-2025 | $9,000 | 60% | $5,400 | 40% | $3,600 | $9,000 | 02-10-2025 | Paid | Payment received. |
| EmailCampaign Client | Email Campaign | 01-15-2025 | 01-20-2025 | $2,500 | 70% | $1,750 | 30% | $750 | $2,500 | 02-05-2025 | Paid | Confirmed payment received. |
| SpringSeason Client | Spring Sale | 01-20-2025 | 01-31-2025 | $12,000 | 55% | $6,600 | 45% | $5,400 | $12,000 | 02-10-2025 | Pending | Confirm payment details with partner. |
How to Use This Template:
- Data Entry: Input the relevant financial details from each partnership and campaign as payments are processed.
- Monitor Payments: Track the status of payments, ensuring that Neftaly and partners are paid fairly and on time.
- Identify Payment Delays: Use the “Payment Status” column to identify overdue or pending payments and take necessary follow-up actions.
- Revenue Analysis: Regularly review the “Total Revenue Generated” column to assess the overall financial performance of the partnerships and identify areas for improvement or growth.
- Track Royalties: Ensure that the revenue share is distributed correctly based on the agreed terms, and that payments to both Neftaly and the partner are being made in a timely manner.
This Royalty and Revenue Tracking Template helps Neftaly Ads stay organized and ensures transparency in financial dealings with each partner. It provides an efficient way to monitor payments, manage revenue shares, and track the overall performance of each partnership.
Leave a Reply