Commission Calculator
Every month-end we spend two days arguing over the commission spreadsheet.
Closed deals go in and payouts come out, calculated with your actual plan rules and a record of how each number was reached.
- No.
- 002
- Department
- Sales
- Build time
- 2 hrs
- Difficulty
- Intermediate
- Team size
- 3–30 reps
- Replaces
- QuotaPath
Parts
- 1
Rep payouts
Each rep's earned commission for the period, with attainment against quota.
- 2
Closed deals
Every deal, its rate, any accelerators or splits, and the resulting payout.
- 3
Approve payouts
Finance signs off once, and the period locks so numbers stop moving.
- 4
Plan rules
Tiers, accelerators and splits written down once instead of hidden in formulas.
Data model
- Rep { name, quota, plan_id }
- Plan { tiers[], accelerator_rate, split_rules }
- Deal { rep_id, value, closed_at, split_with? }
- Payout { rep_id, period, amount, approved_by?, approved_at? }
Build prompt
Build an internal tool for my team: "Commission Calculator".
The problem: Every month-end we spend two days arguing over the commission spreadsheet.
Who uses it: a team of 3–30 reps.
What it should do:
- Rep payouts: Each rep's earned commission for the period, with attainment against quota.
- Closed deals: Every deal, its rate, any accelerators or splits, and the resulting payout.
- Approve payouts: Finance signs off once, and the period locks so numbers stop moving.
- Plan rules: Tiers, accelerators and splits written down once instead of hidden in formulas.
Data:
- Rep { name, quota, plan_id }
- Plan { tiers[], accelerator_rate, split_rules }
- Deal { rep_id, value, closed_at, split_with? }
- Payout { rep_id, period, amount, approved_by?, approved_at? }
Constraints:
- Built for one team inside one company. Simple sign-in (or none), no billing, no multi-tenant setup.
- Fast, calm and obvious enough that teammates need zero training.
- Data must persist and be shared across the team.
- Ship the simplest version that works, then tell me what you'd add next.Works with Claude, ChatGPT, Cursor, Lovable, Replit or Type.
Variations
- Each rep sees only their own statement
- Import closed-won deals from your CRM as a CSV
- A 'what if I close this deal' calculator for reps
A new blueprint every week
Sent on Sundays. One tool per email.
More blueprints
Simple CRM
We pay for a giant CRM and use about ten percent of it.
- No.
- 001
- Dept.
- Sales
- Build
- 2 hrs
- Replaces
- HubSpot
Quote Builder
Writing a custom quote takes an hour, every single time.
- No.
- 003
- Dept.
- Sales
- Build
- 1–2 hrs
- Replaces
- PandaDoc
Content Calendar
Our content plan lives in four different docs and nobody trusts any of them.
- No.
- 004
- Dept.
- Marketing
- Build
- 1 hr
- Replaces
- CoSchedule