Commission Calculator

The problem this kills

Every pay period the same dread returns. Someone opens the master commission spreadsheet, pastes in the month's closed deals, and starts wiring formulas across tabs — flat rates here, tiered brackets there, an accelerator that kicks in after quota, a split between the AE and the SDR. One stale cell reference, one deal that lands right on a tier boundary, one deal pasted twice, and a rep gets shorted or overpaid. Then come the disputes: a rep emails finance asking why their number dropped, and nobody can explain the math because the formula is buried fourteen columns deep.

The spreadsheet doesn't show its work, doesn't stop duplicates, and doesn't remember who approved what. Commissions are real money and real morale, and you're calculating them on the most fragile tool in the building.

What you'll build

A small web app — built for the way your team actually pays commissions — that does the boring, high-stakes math correctly and shows every step:

• Import closed deals from a CRM export or a plain CSV (rep, deal, amount, close date, product).
• Apply each rep's commission plan — flat percentage, tiered brackets, post-quota accelerators, and multi-rep splits — with the calculation laid out line by line.
• Produce a per-rep statement that explains how every dollar was earned: which deals, which rate, which tier each dollar fell into, what the split was.
• Route the batch for approval — sales ops or finance reviews the computed statements, fixes anything odd, and approves before a cent flows.
• Export a payroll-ready CSV in the exact columns your payroll system expects, and email each rep their statement.

What's inside the Implementation Plan

The plan is a single markdown file you paste into Claude Code. It builds the whole tool step by step, and it opens by interviewing you about your business — your current process, your CRM and payroll systems, the real field names in your deal export, your typical and peak deal volumes, and the exact tier/accelerator/split rules you pay on. It reads back a short tailored spec, you give a thumbs-up, and only then does it build. You get a tool shaped around your commission plans, not a generic template you have to bend to fit.

Inside you'll find: the discovery interview, the data model tuned to your answers, the tiered/accelerator/split calculation engine with fully transparent math, the reviewer approval gate, the payroll CSV export, the rep statement emails, and a "How to know it works" verification checklist. There's also a No-API fallback so you can build the entire thing today off a deals CSV — no CRM integration required.

The governance it includes (this is the point)

This isn't a spreadsheet with a fresh coat of paint. The plan bakes in the controls finance actually needs:

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own deals and statements.
• A complete audit trail — who imported, who computed, who approved, and exactly when.
• A hard human approval gate before any payout is finalized: the tool drafts the statements, a person reviews and approves, and only then is the batch committed and exported.
• Duplicate guards keyed on deal ID, so the same deal can never pay commission twice.

Who it's for

Sales ops, finance teams, and founders who calculate commissions by hand each month and brace for the disputes. If you've ever stared at a commission spreadsheet at 11pm trying to figure out why two formulas disagree, this is for you. No coding experience needed — you'll describe how you pay, and the AI builds the tool.

You've got this — paste the first prompt and let the interview tailor it to your business.