Sales Commission Tracker

What’s Included

Commissions — one row per deal. Columns for Agent, MG, Commission %, Earned (auto-computed = MG × %), Paid, Outstanding (auto-computed = Earned − Paid), Payout Due date, Status (Due / Partial / Paid / Written Off), Notes.
Agent Roster — agents you pay commissions to, their default commission %, territory coverage, contact info, and contract end date. Useful when an agent contract is about to expire.
Totals row — sums MG, Earned, Paid, Outstanding at the bottom of the Commissions sheet.
Conditional formatting — Paid rows highlight green, Due rows highlight red and bold.
Data validation — Status column is a dropdown; prevents typos that would defeat the auto-formatting.

For every signed deal, add a row with Agent, MG, and Commission %. The Earned column fills itself.
As payouts go out, update the Paid column. Outstanding updates automatically.
When a deal is fully paid, set Status to “Paid” — the row turns green and is visually excluded when you’re scanning for what’s still owed.
The Totals row at the bottom tells you immediately how much commission liability is outstanding across all deals.

This template tracks what your company owes to sales agents (in-house reps + external agencies like ICM, UTA, Paradigm). It does not track:

Producer participations — residual payments to talent/producers based on film performance. That’s a much more complex modeling problem (waterfall definitions, back-end points, holdbacks on talent deals). For that, look at dedicated participations software — the Vistex Counterpoint review covers the enterprise-grade option.
Royalty-to-licensor payouts — what you pay the IP owner after platform revenue flows in. Use the separate Royalty Tracking Sheet for that.

Sales Pipeline Tracker — upstream of this; once a deal hits Contracted, copy the MG + agent into this sheet.
Royalty Tracking Sheet — licensor-side payouts (different direction).
Rights Management Software Reviews — when spreadsheet commissions stop scaling (usually around 50+ active deals).