To ensure accurate tracking and management of royalties, it is important to maintain clear and detailed records of all royalties received, as well as any pending amounts. The following Royalties Data template will allow SayPro to keep track of royalties, monitor outstanding payments, and maintain financial accountability with media and strategic partners.
1. Royalties Received
Partner Name
Campaign/Project
Royalty Agreement
Royalty Amount Due ($)
Royalty Amount Received ($)
Payment Date
Outstanding Amount ($)
Payment Status
[Partner Name]
[Campaign/Project Name]
[Agreement Type/Details]
[$ Amount Due]
[$ Amount Received]
[MM/DD/YYYY]
[$ Outstanding]
[Paid/Unpaid]
[Partner Name]
[Campaign/Project Name]
[Agreement Type/Details]
[$ Amount Due]
[$ Amount Received]
[MM/DD/YYYY]
[$ Outstanding]
[Paid/Unpaid]
2. Pending Royalties
Partner Name
Campaign/Project
Royalty Agreement
Royalty Amount Due ($)
Due Date
Payment Status
Follow-up Actions
[Partner Name]
[Campaign/Project Name]
[Agreement Type/Details]
[$ Amount Due]
[MM/DD/YYYY]
[Pending/Not Paid]
[e.g., Email follow-up]
[Partner Name]
[Campaign/Project Name]
[Agreement Type/Details]
[$ Amount Due]
[MM/DD/YYYY]
[Pending/Not Paid]
[e.g., Email follow-up]
3. Royalties Payment History
Partner Name
Campaign/Project
Royalty Amount Due ($)
Amount Paid ($)
Payment Date
Payment Mode
Outstanding Amount ($)
[Partner Name]
[Campaign/Project Name]
[$ Amount Due]
[$ Amount Paid]
[MM/DD/YYYY]
[e.g., Bank Transfer, Check]
[$ Amount Outstanding]
[Partner Name]
[Campaign/Project Name]
[$ Amount Due]
[$ Amount Paid]
[MM/DD/YYYY]
[e.g., Bank Transfer, Check]
[$ Amount Outstanding]
4. Total Royalties Overview
Total Royalty Amount Due ($)
Total Royalty Amount Received ($)
Total Outstanding Amount ($)
Total Pending Royalties ($)
[$ Total Due]
[$ Total Received]
[$ Total Outstanding]
[$ Total Pending]
5. Payment Discrepancies and Follow-up Actions
Partner Name
Campaign/Project
Discrepancy Type
Amount in Dispute ($)
Reason for Discrepancy
Follow-up Action
Resolution Status
[Partner Name]
[Campaign/Project Name]
[e.g., Underpayment, Late Payment]
[$ Amount in Dispute]
[e.g., Payment missing, Incorrect amount]
[e.g., Contact partner]
[Resolved/Unresolved]
[Partner Name]
[Campaign/Project Name]
[e.g., Underpayment, Late Payment]
[$ Amount in Dispute]
[e.g., Payment missing, Incorrect amount]
[e.g., Contact partner]
[Resolved/Unresolved]
6. Royalty Agreement Summary
Partner Name
Campaign/Project
Royalty Percentage (%)
Royalty Agreement Terms
Start Date
End Date
[Partner Name]
[Campaign/Project Name]
[X% Royalty]
[e.g., 5% of revenue per article published]
[MM/DD/YYYY]
[MM/DD/YYYY]
[Partner Name]
[Campaign/Project Name]
[X% Royalty]
[e.g., 5% of revenue per article published]
[MM/DD/YYYY]
[MM/DD/YYYY]
7. Final Royalties Report Summary
Total Royalty Agreements Signed
Total Amount Due ($)
Total Amount Received ($)
Outstanding Amount ($)
Pending Royalties ($)
[X Agreements]
[$ Total Due]
[$ Total Received]
[$ Total Outstanding]
[$ Total Pending]
How to Use the Royalties Data Template:
Royalties Received:
Record the partner, campaign/project, royalty agreement details, amounts due, amounts received, payment date, and outstanding balances. This will help track how much revenue has been generated and how much is still pending.
Pending Royalties:
List any royalties that have not been paid yet, along with the due dates and any follow-up actions required (e.g., emails, calls). This will help monitor overdue payments and ensure timely follow-up.
Royalties Payment History:
Keep track of historical payment details, including the payment method used and whether there are any outstanding amounts. This provides a clear audit trail for all royalty transactions.
Total Royalties Overview:
A summary of total royalties due, received, and pending. This high-level overview can be used to quickly assess the state of royalties for the period.
Discrepancies and Follow-up Actions:
Record any discrepancies between amounts due and received, including the reason for the discrepancy. Include follow-up actions to resolve these issues and track their resolution status.
Royalty Agreement Summary:
Document the terms of each royalty agreement, including percentages, and the start and end dates. This helps ensure that the terms are understood and adhered to.
Final Royalties Report Summary:
Summarize the total number of agreements, amounts due, received, outstanding, and pending for the quarter. This summary allows senior management to review the overall financial picture.
By using this template, SayPro can maintain organized and up-to-date records of all royalties, monitor payments, track outstanding amounts, and resolve discrepancies quickly. Let me know if you need further adjustments!
Leave a Reply