Skip to main content
Royalty Reporting
Template · Excel

Licensor remittance worksheet (Excel)

An Excel worksheet that sits between the royalty statement and the payment run — summarizing each licensor's net due for the period, reconciling it against the accrued balance, capturing remittance details (payee, wire/ACH instructions, statement reference), and producing the GL coding for the entry.

Work email required — the download starts immediately. No verification step, no follow-up sequence.

Inside the template

  • Per-licensor remittance summary (statement net due, prior balance, true-up credits)

  • Accrual-to-payment reconciliation block

  • Remittance instruction capture (payee, method, reference, due date)

  • GL coding section (royalty expense, accrued royalties, advance asset)

  • Multi-licensor consolidated payment-run summary tab

  • Example data populated for a 3-licensor apparel scenario

Best fit

Apparel finance teams who prepare statements in one place and process payments in another, and need the tie-out between statement, accrual, payment, and GL to survive review and audit.

Templates help. The platform replaces them.

Walk through royalty calculation, statement generation, advance recoupment, and audit trail in a 30-minute demo.