OpenRights Entertainment Rights & Catalog Intelligence

Free Downloads

Templates for Rights & Catalog Management

Production-ready Excel and Google Sheets templates. Download, customize, and start using immediately. No signup required.

Format
Domain

Showing 19 of 19 templates

Apple iTunes Metadata Template — `.itmsp` Package & metadata.xml

Sample .itmsp directory plus the metadata.xml schema you need to clone-and-edit for first-time delivery to Apple TV / iTunes. Fully-formed example covering provider, vendor ID, ratings, chapters, assets, posters, trailers, and the per-territory products block.

First-time delivery of a movie title to Apple TV / iTunes (creates the Vendor ID and ships masters, posters, captions, and metadata)

xmlpdf
Details & Download →

Royalty Reconciliation Workbook

Reconcile platform-reported royalties against calculated expectation. Variance report flags underpayment, missing territories, and late statements.

Spot underpayment or missing territory payouts on a platform royalty statement

excelgoogle-sheets
Details & Download →

Royalty Statement Cleanup Workbook

Normalize messy platform royalty CSVs (Netflix, Amazon, Apple) into a canonical title/territory/period schema. Field mapping sheet documents every transform.

Turn a raw platform royalty CSV into something your reconciliation workbook can ingest

excelgoogle-sheets
Details & Download →

Payment Reconciliation Template

Match invoices to payments received. Flags DUPLICATE, MISSING, and MISMATCH (amount) statuses; shows aging days on overdue invoices.

Reconcile a bank statement against your invoice register every month

excelgoogle-sheets
Details & Download →

Avails Data Quality Scorecard

Score your avails sheet across 7 checks: required fields, date coherence, exclusivity vocabulary. Paste once into the generic source tab, read the quality score.

Audit an avails file before shipping it to a platform or aggregator

excelgoogle-sheets
Details & Download →

Title Deduplication Worksheet

Find duplicate titles via EIDR/ISAN exact match + normalized-key match. Formula-driven flags in red; pair with the Apps Script for Levenshtein fuzzy matching.

Catch duplicate titles in a catalog before they split royalties and confuse avails

excelgoogle-sheets
Details & Download →

Contract Register with Quality Score

Master register of every contract with a per-row completeness score. Traffic-light status (OK ≥ 90%, WARN 70–89%, FAIL < 70%) to prioritize cleanup.

See at a glance which contracts have metadata gaps that will bite you later

excelgoogle-sheets
Details & Download →

Title Metadata Cleanup Workbook

Title workbook with dropdown validation for type/genre/language/rating, EIDR format check, and a missing-value report so you can see gaps at a glance.

Normalize title records to controlled vocabularies before catalog delivery

excelgoogle-sheets
Details & Download →

Contract Metadata Audit

Audit a single contract against 20 required fields: parties, term dates, rights, territory, MG, holdbacks, governing law. Completeness score with traffic-light status.

Audit a contract before filing it — catch gaps before they become avails problems

excelgoogle-sheets
Details & Download →

Contacts Master List (Dedupe-Ready)

A canonical contacts workbook with built-in dedupe helper columns — normalized key and dupe-count formulas that flag duplicates in red as you type.

Maintain a single source-of-truth contacts list across the sales and acquisitions team

excelgoogle-sheets
Details & Download →

Contacts Data Quality Audit

Score your rights-holder contacts database across 8 checks: missing names/emails/phones, invalid email format, duplicates, stale records. Traffic-light scorecard.

Audit a contacts database before a mail-merge, CRM import, or annual refresh

excelgoogle-sheets
Details & Download →

Sales Commission Tracker

Per-deal commission calculations for in-house reps and outside agents. Auto-computed Earned + Outstanding columns, overdue highlighting, totals row.

Track what every salesperson is owed and when it's due

excelgoogle-sheets
Details & Download →

Territory Rate Card

Asking prices per territory × window × tier (A/B/C). Illustrative starting point for indie features — edit to match your catalog and commercial terms.

Standardize asking prices across the sales team for consistent pitches

excelgoogle-sheets
Details & Download →

Deal Memo / Letter of Intent Template

One-page LOI form covering parties, licensed content, rights granted, commercial terms, delivery, and signatures. Print-ready or export to PDF.

Capture agreed deal terms in a one-page LOI before the long-form contract

excelgoogle-sheets
Details & Download →

Sales Pipeline Tracker

Track every deal from lead to signed contract. Stage definitions, probability weighting, overdue deal highlighting, and a cross-reference tab for your existing avails.

Track live content licensing deals through the sales pipeline

excelgoogle-sheets
Details & Download →

Royalty Tracking Sheet

Track revenue by platform, title, and territory with period rollups. Includes formulas for minimum guarantee tracking and overage calculations.

Reconcile royalty statements and track revenue across platforms

excelgoogle-sheets
Details & Download →

Catalog Health Checklist (47 Points)

Comprehensive audit checklist covering metadata completeness, territory code consistency, date format standardization, identifier validation, and rights chain verification.

Audit your catalog data quality before distribution or platform onboarding

excelpdf
Details & Download →

Data Cleaning Checklist

Step-by-step process for cleaning entertainment catalog data before distribution or platform onboarding. Covers common issues and fixes.

Clean up your catalog data before submitting to a new platform

excelgoogle-sheets
Details & Download →

Multi-Territory Avails Tracker

Pre-formatted spreadsheet for tracking content availability windows across territories. Includes conditional formatting, date validation, and territory code reference.

Track which titles are available in which territories and windows

excelgoogle-sheets
Details & Download →