Partner Performance: Notes about the partner’s performance during the period (e.g., delays in payments, changes in revenue generation, etc.).
Payment Issues: Any issues or discrepancies related to payments (e.g., missed deadlines, incorrect amounts).
Follow-up Actions: Actions taken to resolve outstanding payments or performance issues, such as contacting the partner or renegotiating terms.
Usage Instructions
General Information:
Complete the partner details such as the name, contract number, start/end dates, royalty rate, payment frequency, and payment due date.
Royalty Payment History:
Record every royalty payment made, indicating the amount, payment status (paid or unpaid), payment method (check, bank transfer, etc.), and any relevant notes (e.g., delays or adjustments).
Royalty Performance Metrics:
Track the revenue generated through the partnership, calculate the expected royalty based on the agreed-upon royalty rate, and record the actual royalty paid. This will help compare the expected vs. actual performance.
Outstanding Royalties:
Maintain a list of any unpaid royalties, their due dates, and the follow-up actions taken to ensure that payments are received in a timely manner.
Monthly/Quarterly Summary:
Summarize the total revenue, total expected royalties, total paid royalties, and total outstanding royalties for each month or quarter. This gives a high-level view of the performance across all partnerships.
Notes Section:
Use this section to capture any important details about individual partnerships, payment issues, or action items to follow up on.
Tracking and Reporting Tips
Set reminders for payment due dates to ensure timely follow-up and minimize overdue payments.
Compare expected royalties to actual royalties to spot any discrepancies and address them quickly.
Review outstanding amounts regularly and communicate with partners to resolve any issues promptly.
Use the monthly/quarterly summary to track performance across all partnerships and assess the overall financial health of your media collaborations.
This Royalties Tracking Template will help streamline the monitoring and management of royalty payments and ensure all financial obligations are being met accurately. Let me know if you’d like to customize it further or add any additional features!
Leave a Reply