← All blueprints

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
PayoutsOCTOBERALANA LIMA$4,210BCBEN CHO$3,180CWCY WARD$5,940CLOSED DEALVALUENorthwind renewal · Ana$48,000Bluebird new logo · Cy$72,500Acme upsell · Ben$31,800Approve payouts123

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

prompt.txt
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