Free commission tracking spreadsheet template
The exact columns working commission earners use — one row per expected payment, built for reconciling against real payout statements. CSV opens in Excel, Google Sheets, or Numbers. No email required.
Includes four example rows — a paid deal, a scheduled renewal, a payment stuck in the payroll lag, and a short payment in dispute — so you can see the method before you clear them out.
How to use it
- Add the row the day you close — not the day you get paid. The gap between those two dates is where money hides.
- One row per expected payment. Renewals, residuals, and milestone payouts each get their own row with their own due date.
- Reference numbers are sacred. Statement lines rarely carry the client's name the way you wrote it — the policy/loan/invoice number is your match key.
- Reconcile on statement day. Every line matches a row; every due row should appear on a statement. Investigate both kinds of mismatch.
Where the spreadsheet cracks
This method genuinely works at low volume. It cracks when renewal schedules stretch years out, when three payers send three statement formats a month, and when matching lines by hand becomes the chore you skip. That's the point where PayoutVerify does the same job automatically — it reads the statement, matches every line, and flags what's short, missing, or clawed back. The free tier covers 15 active deals, and CSV export means you can leave anytime with your data.
Questions
What columns should a commission tracking spreadsheet have?
Deal/client, the payer's reference number, payer, close date, category, expected amount, expected pay date, status, paid amount, paid date, difference, and notes. The reference number matters most — it's how you match statement lines back to deals.
Should each row be a deal or a payment?
One row per expected payment, not per deal. A deal with renewals or milestone payouts should have a row for each expected payment with its own due date — that's how trailing money stays visible instead of silently disappearing.
How do I use the template to catch short payments?
On every statement day, tick off each statement line against a row and fill in the paid amount and date. Any row past its expected date with no payment, and any negative difference, is a follow-up. The habit matters more than the tool.