How to build a sales commission tracker for your SMB

Your best sales rep has no idea what they’ve earned this month. They’ll find out at close. Maybe a few days after, when Finance finishes running the numbers in a workbook, only one person fully understands. If something looks off, there’s a dispute. Finance has to trace it back through five VLOOKUP chains that pull from three different imported files. The Finance manager loses two days.

The spreadsheet was fine when you had five reps on a straightforward base-plus-percentage plan. It stopped being fine when your comp plan grew.

How to tell you need a custom commission tracker

Most Finance teams don’t notice their spreadsheet is failing until it’s too late.

Commission close takes more than two days

If your process involves manually exporting from the CRM, cleaning the data, reconciling against invoices, and then running calculations, you need a custom commission tracker. Every hour spent on the spreadsheet is an hour not spent on anything else.

Reps ask mid-month

“Hey, what am I tracking at?” Twenty minutes to answer. Five reps, four times a month. That’s a full day gone, every month, just telling people what they’ve already earned.

You’ve had a commission dispute in the last six months

Disputes almost always trace back to a formula error, a missing deal, or ambiguity in a clawback clause. When a rep can’t see the calculation logic, they can’t catch the error either. They just see a number that doesn’t match their mental model.

The model lives on one person’s laptop

When that person is out at close, commission processing stops. That’s not a risk. That’s a guarantee. If two of those are true, the spreadsheet is your process now, not a workaround.

Off-the-shelf software vs a custom internal tool

Tools like QuotaPath, Qobra, and Spiff are mature products. For a team of 20+ reps on a standard comp plan, with clean Salesforce or HubSpot data, they’re a good answer. The integration is straightforward. The UI is polished. The per-seat cost is reasonable at scale.

The problem is that most SMBs don’t have a standard comp plan.

Multi-tier accelerators. Clawback windows tied to payment terms. Split attribution between SDRs and AEs. Different structures for different product lines. Different rates for new business vs expansion.

This is normal at a 20-person sales team that’s been operating for a few years.

When you put a non-standard plan into standard software, one of two things happens: you work around the tool (which defeats the purpose), or you simplify the comp plan to fit the software (which affects how reps are paid).

Ten reps at $40/user/month is $4,800 a year. A custom commission tracker for that same team runs $12K-$25K as a one-time project. At year three, the custom build is cheaper, and it doesn’t require workarounds.

Add in the Finance hours. If your current process consumes 12 hours per month at a $150/hour rate, that’s $21,600 a year in manual processing costs that a custom tool eliminates or reduces. The payback period is often under 18 months, sometimes faster.

What a custom commission tracker actually includes

There are four parts to a well-built commission tool.

Deal data import

Your deal and revenue data live somewhere, and it needs to flow into the commission tool automatically. If it’s in Salesforce or HubSpot, this is easy via API. If it’s spread across three systems with manual consolidation steps in between, it’s a problem which needs to be solved.

Calculation logic

You need to define your compensation plan. Tiered rates, clawback windows, split attribution percentages, accelerator thresholds. When the deal data comes in, the calculation runs automatically without needing anyone’s input.

Rep-facing dashboard

Each rep sees their running commission total, deal-level breakdown, and projected month-end based on the current pipeline. Mobile-accessible.

Manager and Finance approval workflow

Before commissions are processed, managers review. Finance approves. Every override is logged. There’s an audit trail in case a dispute arises six months later.

Depending on your situation, you might also want a payroll export to Gusto or ADP, a comp plan modelling tool for leadership to run “what if” scenarios before changing plans, or YTD earnings history for reps.

Scope the project before you hire an agency

Three questions will define the scope more accurately than anything else.

What are your three most complex comp scenarios? Walk through your actual edge cases.

The deal that spanned two quarters, the rep who moved mid-year with an accelerator reset, the clawback you triggered last spring. If you can clearly describe those three cases, you can harden the calculation logic. If you have more than five genuinely complex scenarios, the build is larger. Budget accordingly.

Who needs to see what?

Reps need their own data and a deal breakdown. Managers need team data plus approval controls. Finance needs everything, plus exception flags and payroll export. Execs might want a liability summary. Defining this upfront prevents scope creep.

The temptation is to build for everyone from day one. Start with who actually blocks close right now.

Where does your deal data live?

Clean data in one CRM takes 1 week of integration. Having data spread across a CRM, an invoicing tool, and a custom tracking spreadsheet increases complexity. The quality of your underlying data dictates the quality of your commission tracker.

Platform and cost

For most SMBs, the build is either WeWeb or Bubble, and the choice depends on your data setup and the complexity of the comp plan logic.

WeWeb connects to any backend (Xano, Supabase) and produces a clean, fast, mobile-accessible interface. If your priority is a polished dashboard that reps actually use, and your calculation logic can live in a separate data layer, WeWeb is the right frontend.

Bubble handles the calculation logic, workflow, and interface in one place. If your comp plan has complex conditionals and you want everything in a single system without a separate backend, Bubble’s full-stack approach is more efficient to build and easier to maintain.

Both platforms are what we use at NocodeAssistant. The choice between them depends on your data architecture and how complex your comp plan logic is. Talk to us about which fits your situation

Here’s how the scope maps to timeline and cost

Simple (1 comp plan, <10 reps, manual data import)

• Timeline: 3–4 weeks
• Includes: calculation engine, rep dashboard, Finance view, manual CSV import
• Cost: $8K–$15K

Medium (2–3 plan types, CRM integration, approval workflow):

• Timeline: 5–8 weeks
• Includes: everything above + live CRM sync, manager approval, audit trail, payout export
• Cost: $15K–$25K

Complex (multi-tier accelerators, clawbacks, multi-role plans, historical recalculation):

• Timeline: 8–12 weeks
• Includes: everything above + complex calculation engine, comp plan modeling tool, compliance-grade audit log
• Cost: $25K–$40K

The interface is usually the simple part. The calculation logic is where complexity adds up.

If explaining your comp plan to a new Finance hire takes more than 20 minutes, you’re in Medium or Complex territory.

For how these numbers compare to general internal tool costs, see our guide to custom internal tool costs

Where to start

Pick the one comp scenario that covers your highest volume of reps and affects closing the most. Document it in full, including every edge case you can think of.

Then answer the three scoping questions. Then calculate the cost of your current process per month in Finance hours.

If commission tracking is one of several manual processes your ops team handles, our guide on when to replace spreadsheets with a custom internal tool explains how to decide what to fix first.

If it’s the right time to build, book a discovery call. We’ll work through your comp plan structure, data sources, and team workflow in 45 minutes and come back with a clear scope and a realistic cost estimate.