The Commission Tracker Template That Recalculates Itself When Rates Change

Lead: Most commission tracker templates give you a column for the rate and a column for the total. Ours gives you a rate table that every deal reads from live. We analyzed the commission-tracking templates from monday.com, Airtable, and Notion, kept the one idea each got right, fixed what none of them solved, and rebuilt the result as a free, open source Baserow template you can download and own outright.

Why commission spreadsheets quietly go stale

Every organization that pays people a percentage of what they sell — sales teams, real estate brokerages, insurance agencies, affiliate programs, agencies with rev-share partners — eventually ends up with a commission sheet. It starts simple: a tab, a rep column, a rate column, a total column. It works for a month.

Then someone gets promoted into a higher rate tier. Or the company changes the enterprise rate from 10% to 12% for deals closed after July 1st. Now the sheet has to remember which deals were closed under which rate — a fact no spreadsheet cell tracks on its own. The usual fix is a note in the margin, or a second tab, or a formula copied down and manually adjusted for the rows above the rate change. Every one of those fixes is a place a mistake can hide.

The second failure mode is quieter and more expensive: nobody notices when a commission goes unpaid. A deal closes, a payout date passes, and the rep just... doesn't get paid on time, because nothing in the sheet distinguishes "this row is fine" from "this row has been sitting unpaid for two weeks." Someone has to remember to check. A commission tracker earns its place when it can't forget — when a rate change doesn't require touching old rows, and an overdue payout surfaces itself. That's the standard we used when we rebuilt this category, and it's the test we'd suggest you apply to any commission template you're evaluating, including ours.

What the big three actually give you

We ran the commission-tracking materials from monday.com, Airtable, and Notion through our extraction pipeline — the same rubric, the same review panel, all three scored on demand, reusability, and enterprise readiness. Each one contains exactly one idea worth keeping. None contains all three, and none of them ships the mechanism that actually closes the gap.

monday.com: the right instinct on rate history

monday.com's dedicated commission-tracking board gets one thing right that most spreadsheet templates miss entirely: a manager can adjust a rep's commission percentage for the current period without disturbing the math on already-closed rows from prior periods. That's a real insight — commission history has to be immutable even while the rate going forward changes. The board also ships a payroll-notification automation, turning "email finance the numbers" into a single click.

What it's missing: the rate itself lives as a column on a flat board, not as its own record. There's no way to see, in one place, every rate tier your organization pays and every deal governed by each one. And nothing in the board flags a payout that's gone unpaid past its due date — the automation assumes a human already caught the exception and is ready to notify payroll about it.

Airtable: the right structural instinct, unverifiable

Airtable's Commissions Sample base is positioned explicitly as a commissions-management solution, not a spreadsheet replica — the framing itself implies the correct idea: commission data belongs in a relational base with distinct record types, not a single sheet. That's the right instinct to build from.

What it's missing, at least publicly: the actual structure is gated behind Airtable's own template preview, so there's no way to audit the calculation logic, the table relationships, or the field design without duplicating the base into an account first. A template you can't inspect before adopting is asking for trust it hasn't earned. And going by what similar Airtable Universe "sample" bases in this category typically ship, it's likely demo-depth — a handful of illustrative records, not a system that shows an unpaid, overdue commission the moment you open it.

Notion: the right two-layer framing

Notion's Sales Commission Tracking template pitches itself around auto-calculating "profits, payouts, and commissions" while managing "reps and payments" — which correctly separates commission tracking into two linked concerns: a reps/performance layer and a payments layer. That two-layer instinct is exactly right, and it's the shape our rebuild takes further.

What it's missing: Notion databases in this category are almost universally a single flat database with rollup properties simulating relationships, not genuinely independent tables with their own governable fields. That means "auto-calculate" most likely means a per-row formula property, not a Commission_Rules table an admin can edit once and have every linked deal recalculate against. And there's no visible exception flag for an overdue payout — "manage your payments" implies a status a human updates manually, not a flag that fires itself.

The three, side by side

Each commercial template wins exactly one column. Ours is the only one with a check in every row.

<!-- COMPARISON GRID: embed content/comparison-grid-commission-tracker.html here -->

| Capability | monday.com | Airtable | Notion | OpenSource AI Pro | |---|---|---|---|---| | Commission rate as its own governable record | ✗ No | ◐ Unverifiable (gated) | ✗ No | ✓ Yes | | Rate change doesn't disturb past deals | ✓ Yes | ◐ Unverifiable | ◐ Unverifiable | ✓ Yes | | Formula-driven unpaid/overdue flag | ✗ No | ✗ No | ✗ No | ✓ Yes | | Relational data model (reps · deals · rate tiers) | ✗ No | ◐ Unverifiable | ✗ No | ✓ Yes | | Inspectable calculation logic | ✗ No | ✗ No | ✗ No | ✓ Yes | | Self-host & own your data | ✗ No | ✗ No | ✗ No | ✓ Yes |

Competitor details reflect each platform's public template pages as of July 2026.

The rebuild: all three ideas, one open source template

Our Commission Tracker template combines monday.com's rate-history instinct, Airtable's relational-base framing, and Notion's reps-plus-payments split — built on Baserow, the open source Airtable alternative you can self-host. Then we added the piece none of them ship: a formula-driven flag that catches an unpaid commission the moment it goes overdue.

The Starter edition ships with:

Three linked tables. Reps, Commission_Rules, and Deals — each a real entity, not a column. A deal links to the rep who closed it and to the commission rule that governs it. The commission rate isn't retyped on every row; it's read live from its own record.

A Commission_Rules table that's actually a rate book. Standard, Senior, Enterprise, Renewal — however many tiers your organization pays, each is its own row with its own rate and a plain-language description of when it applies. Change the Enterprise rate from 12% to 13% once, and every deal linked to that rule recalculates immediately. Nothing to drag down, nothing to re-type, no risk of updating nine rows and missing a tenth.

A Commission_Owed formula nobody has to compute by hand. Deal amount times the linked rule's rate, rounded to the cent, recalculated the instant either input changes. Click the field definition and read exactly how the number was derived — no vendor black box deciding what a rep is owed.

An Unpaid_Overdue flag that fires itself. The moment a deal's payout is still marked Pending past its due date, the flag lights up — no report to run, no end-of-pay-period spreadsheet comb-through. This is the exact mechanism none of the three commercial sources ship.

An Unpaid & Overdue view that leads the template. Open the template, click once, see every commission that's gone past due — across every rep, every rate tier. This is the view that replaces the "did payroll actually go out" Slack message.

Working sample data with deliberate exceptions. Twelve deals across five reps and four rate tiers — three of them deliberately unpaid and overdue, plus two rows built specifically to prove the flag doesn't cry wolf: one paid on time despite an old due date, one still pending but genuinely not due yet.

[VIDEO EMBED: Pattern of the Week — How Commission Calculation Actually Works]

What "open source" buys you here

The fair question: plenty of commission-tracking SaaS tools exist. Why does open source matter for this specific category?

No per-seat pricing on a tool every rep technically touches. Dedicated commission-management platforms typically charge per user, and in a category where the whole point is transparency for the people being paid, giving every rep a login without a per-seat fee is a real structural advantage. Self-hosted Baserow has no per-seat cost at any team size.

The calculation is inspectable by the people it affects. Commission disputes are common, and they're worse when the formula deciding a paycheck lives behind a vendor's UI instead of a field definition anyone with access can open and read. That's not a hypothetical for HR, finance, or legal teams in regulated industries — it's the difference between "trust us" and "verify it yourself."

Your commission data stays on infrastructure you control. Rep names, deal values, and payout amounts are sensitive compensation data. Self-hosting keeps it inside your own boundary instead of a third-party SaaS database.

[VIDEO EMBED: Teardown — What monday.com's Commission Board Gets Right (and Doesn't)]

How the lifecycle works

The workflow underneath the template is the one we found, in fragments, across all three commercial sources:

Deal Closed → Commission Rule Applied → Commission Calculated → Payout Due → Payout Confirmed (or Flagged Overdue)

The Starter edition implements the full spine at the calculation layer: reps and rate tiers as governable records, a live Commission_Owed calculation, and an Unpaid_Overdue flag that needs no automation to fire. The Operational edition (coming next) adds a by-rep total-owed rollup, a payout-batch view for closing out a full pay period in one action, and a manager approval field before a commission can be marked Paid. The Enterprise edition adds rep-scoped visibility (a rep sees only their own commission rows), a rate-change audit trail, and a dispute-flag workflow for contested amounts.

That tiering is deliberate, and it's worth being direct about scope: this is a commission-calculation and payout-tracking tool, not a sales pipeline. It has no deal-stage field, no close-probability score, no lead-to-close reporting — those belong to CRM software, and blurring the line would make this worse at the one job it's built for.

Get the Starter template

The Starter edition is free, with working sample data, deployable to any Baserow instance — cloud or self-hosted.

[DOWNLOAD CTA: Get the free Commission Tracker Starter template →] (Email-gated download. You'll also get our weekly pattern breakdown — one reusable workflow pattern, every week, no filler.)

Evaluation checklist for any commission tracker template

Building your own, or evaluating another tool? Hold any candidate against these five questions:

1. Is the commission rate its own record, or is it retyped on every deal row?
2. Can you change a rate going forward without disturbing the math on already-closed deals?
3. Does anything flag an overdue, unpaid commission automatically, or does someone have to remember to check?
4. Can you open the field that calculates a rep's payout and actually read the logic?
5. Does using this tool require paying per seat for every rep who needs visibility into their own numbers?

The three commercial sources we studied each pass one, maybe two. The point of an open source rebuild is to pass all five — and to let you verify that claim by reading the template's own formula.

---

OpenSource AI Pro covers open source tools and AI adoption for higher education, healthcare, and legal teams. The Template Intelligence series analyzes commercial workflow templates and rebuilds the best patterns as open source deliverables.