01 — The problem
Why commission spreadsheets trigger disputes every payout cycle
Most teams start with a commission tracker template in Excel or Google Sheets. It works for one plan and five reps. Then come split deals, quota accelerators, renewals at a lower rate and clawbacks on cancelled contracts. The formulas grow, one person maintains them, and reps cannot see how their number was calculated.
So reps keep shadow spreadsheets, disputes arrive by email after payroll, and finance spends days checking lines by hand.
02 — What to build
Plans, splits and payout statements to include
Commission plans per role: base rate, tiers, accelerators above quota and effective dates
Closed deals imported from a CRM export, with amount, close date, product line and rep
Splits and overrides for shared deals and manager overrides
Calculations per rep and period, including clawbacks
Rep statements showing every deal and how its commission was calculated
Disputes
a rep flags a line, sales ops reviews, the resolution is logged
Finance approval before payout, with an export for payroll
03 — How to build it
Building a sales commission tracker in Henosia
Create a private project; nothing goes live until you publish.
Add mock data
a closed-deals export, quotas and your plan documents.
Connect a database for plans, deals, statements and disputes.
Describe the plan rules in Plan mode
The agent asks clarifying questions and proposes a plan before building.
Build a first version and recalculate last quarter to compare with what you paid.
Iterate on edge cases: mid-period plan changes, partial cancellations, reps changing teams.
Publish with role-based access.
An example Plan-mode prompt:
Build a commission tracker for our sales team.
Import closed-won deals monthly with rep, amount, product line and close date.
Reps earn 8% up to quota and 12% above quota; renewals pay 4%; split deals divide commission by split percentage.
Claw back commission if a deal is cancelled within 90 days.
Reps see only their own statement and can dispute a line; sales ops resolves disputes and finance approves payouts before export.Paste it into a private Henosia project in Plan mode. The agent asks questions and proposes a plan first.
04 — Before you go live
Finance sign-off and rep visibility before the first payout
Before real data goes in, decide:
- Who owns the plan rules and approves changes, ideally sales ops and finance together
- Fixed rules for calculations, so every number is reproducible
- A human approval step for every payout. The app does not post to payroll or accounting automatically; any integration is scoped per system, direction and access level.
- Who sees what: reps see their own earnings, managers their team, finance everything
Commission work starts once a deal closes. Stages and forecasts before that belong in a sales pipeline app.
Start a private project in Henosia and turn your commission spreadsheet into a first version.
Start a private project05 — FAQ
Frequently asked questions
How is a commission tracker different from a sales pipeline app?
A sales pipeline app manages deals before they close: stages, next steps and forecasts. A commission tracker starts after close, calculating what each rep earned, handling splits, clawbacks and disputes, and sending payouts to finance for approval. Closed deals from the pipeline become the input for commissions.
Can a commission tracker app replace my Excel template?
Yes, for most teams that outgrow a spreadsheet. The app keeps plan rules, deals and statements in one database, shows reps how each number was calculated and logs disputes and approvals. Start by loading your current commission tracker spreadsheet as mock data and comparing results.
Do I need developers to build commission tracking software?
Not for a first version. A sales ops or finance lead can describe plans, splits and approvals in Plan mode and build without writing code themselves. Involve IT when you connect live CRM data, plan a payroll export or decide who approves publishing.
Who can see commission data in the app?
You decide. Henosia Authentication ties apps to your company email domain and supports more granular app-level access and optional IP restriction. Reps can see only their own statements, managers their team and finance everything. Confirm specific security requirements with Henosia for your setup.