Commission Tracker Template — Change One Rate and Every Linked Deal's Payout Recalculates Live

Commission tracking in spreadsheets breaks the moment a rate changes. Someone updates cell B2, forgets to drag the formula down, and three reps get underpaid. Or the quarterly rate adjustment hits and suddenly every deal needs manual recalculation. The system does not scale because the system was never a system — it was a spreadsheet pretending to be one.

The OpenSource AI Pro Commission Tracker is a formula-driven database where commission rates live in one place and every linked deal recalculates automatically when a rate changes. Unpaid and overdue commissions surface through formula flags. Event-triggered alerts notify finance when payouts are due. No per-seat fees, self-hosted on Baserow, open source.

Key Features

• Live Commission Recalculation — Commission amounts are formula fields that multiply deal value by the linked rate. Change a rep's rate or tier structure and every associated deal's payout updates instantly. No manual recalculation, no missed rows.

• Unpaid & Overdue View — A formula flag marks commissions as overdue when the deal is closed-won and the payout date has passed without a payment record. A filtered view shows exactly which commissions are unpaid and how late they are.

• Event-Triggered Payout Alerts — When a deal closes and a commission becomes payable, an automation emails the finance team with the rep name, deal, and calculated amount. The stamp ensures one notification per deal close — no duplicates if deal details are edited after closing.

• Tiered Rate Support — Rate tables support flat percentage, tiered, and override structures. Link a rep to their rate schedule and the formula handles the math, including mid-quarter rate changes applied only to deals closed after the effective date.

• Rep-Level Rollups — Each sales rep record rolls up total earned, total paid, and total outstanding. Reps and managers see the same numbers without anyone building a separate report.

• Period Filtering — Track commissions by month, quarter, or custom period. Compare performance across periods without duplicating data or building pivot tables.

How It Works

Formula Flags. The Commission_Amount field is a formula that multiplies the deal's value by the linked commission rate. The Is_Overdue flag checks whether the deal status is "Closed Won," the commission payment date has passed, and no payment record exists. The Days_Overdue field counts the gap. All formulas are live — they recalculate as data changes.

Event-Triggered Alerts. A Baserow automation watches the deal status field. When a deal transitions to "Closed Won," the automation sends an email to the finance team with the rep name, deal value, commission rate, and calculated payout amount. The _notified_closed stamp prevents duplicate alerts. If a deal is reopened and re-closed, the stamp resets and the alert fires again.

Scheduled Digest. A second automation runs weekly. It collects all unpaid commissions, groups them by rep, totals the amounts, and sends a summary to finance. The digest also flags any commissions overdue by more than 30 days for escalation.

Who It's For

• Sales operations teams managing commission calculations for 5-200 reps who need accuracy without dedicated commission software
• Finance teams processing commission payouts who need a clear record of what is owed, what has been paid, and what is overdue
• Sales managers who want reps to see their earnings in real time without giving them access to the full finance system
• Startup founders who have outgrown spreadsheet-based commission tracking but cannot justify $15-30/user/month for CaptivateIQ or Spiff
• Agency owners paying commissions to account executives on closed deals and retainer upsells

vs the Alternatives

| Feature | OpenSource AI Pro | CaptivateIQ/Spiff | Airtable | Google Sheets | |---|---|---|---|---| | Auto recalculation on rate change | Formula-driven, instant | Built-in but $15-30+/user | Manual or scripted | Manual formula drag | | Overdue payout flag | Formula-driven, live | Varies by plan | Manual | Manual conditional formatting | | Email alert on deal close | Built-in, exactly-once | Built-in | Paid tier | Requires Apps Script | | Per-seat pricing | Zero — unlimited users | $15-30+/user/month | $20+/seat/month | Free but no automation | | Self-hosted | Yes, on Baserow | No | No | No |

What's Included

Tables:

• Deals — deal name, rep link, value, close date, status, commission amount (formula)
• Sales Reps — name, email, rate schedule link, total earned rollup, total paid rollup
• Commission Rates — rate name, percentage, tier structure, effective date
• Payments — rep link, deal link, payment date, amount, method

Key Formula Fields:

• Commission_Amount — deal value multiplied by linked rate
• Is_Overdue — boolean flag (closed-won + unpaid + past payout date)
• Days_Overdue — integer count of days past expected payout
• Total_Earned / Total_Paid / Total_Outstanding — rep-level rollups

Automations (2):

1. Event-triggered deal-closed alert with _notified_closed stamp
2. Scheduled weekly unpaid commissions digest

Views:

• All Deals (grid)
• Unpaid Commissions (filtered)
• Overdue Payouts (filtered + sorted)
• By Rep (grouped with rollup totals)
• By Period (filtered by quarter/month)

Get Started Free

Download the Commission Tracker and import it into your Baserow instance. No per-seat fees, no row limits, no vendor lock-in. Commission accuracy that runs on your server.

Download Free Template

Related Templates

• Sales CRM Pipeline Template — Track deals from lead to close with weighted pipeline forecasting
• Invoice & Payment Tracker Template — Manage receivables with automatic overdue detection
• Budget Tracker Template — Monitor departmental spending with over-budget flags