runbookify
← All plans
Payroll & Timekeeping / Commissions & Bonuses

Commission Dispute Desk: Turn 'You Shorted Me' Emails Into a Tracked, Auditable Process

Reps file commission disputes against the exact statement line, ops investigates with the deal data attached, and any adjustment is approved by finance before it hits the next payout run — no more chaotic email threads.

IntermediateA weekendBuilds onNext.jsSupabaseResend
What you'll build

A web tool where a rep files a dispute against a specific commission statement line, ops investigates with the deal data attached, records the resolution (upheld or denied with an explanation), finance approves any adjustment, and the tool produces a forward adjustment line for the next run, logs the resolution, and notifies the rep — every step SLA-tracked and audited.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.

Before you start

  • A Supabase account (free)
  • A Vercel account (free)
  • A Resend account (free)
  • Your commission statements (from your calculator or as CSV)
  • Your underlying deal data (CSV or export)
  • Claude Code or any AI coding agent

The problem this kills

Every commission cycle, the statements go out — and the inbox detonates. "You shorted me on the Acme deal." "This split is wrong." "Where's my accelerator?" The messages land as a flood of half-described complaints scattered across email, Slack, and hallway conversations, each one missing the deal number, the expected amount, or both. Sales ops spends days playing detective: which statement line? which deal? what did the plan actually say? Meanwhile reps feel ignored, the same dispute gets re-litigated three times, and a quiet manual edit to an already-paid run blows up the audit trail.

It's chaotic, it's slow, and it quietly erodes trust in the whole comp plan. You don't need a $40k comp platform to fix it, and you don't need to be a developer.

What you'll build

A simple internal web tool: a dispute desk. A rep logs in, picks the exact statement line they're challenging, sees the deal data attached to it, and submits a dispute with their expected-vs-paid amounts and a reason. The dispute lands in an ops queue with an SLA clock so nothing rots. Ops opens it, reviews the underlying deal data right beside the disputed line, and resolves it — upheld or denied, with a written explanation. If the resolution is "upheld," ops drafts an adjustment — and here's the key: it never edits the paid run. Instead it becomes a forward delta, a clean adjustment line queued for the next commission run. Finance reviews and approves the adjustment before a cent moves. The tool then writes the adjustment line for the next run, logs the full resolution, and emails the rep what happened and why.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how disputes reach you today, what your commission calculator or statement CSV looks like and exactly what its columns are named, how a statement line links to a deal in your CRM, your real dispute volumes per cycle, your resolution and approval rules, and the messy edge cases (split deals, clawbacks, two reps claiming the same deal) — and then it tailors the data model, the SLA rules, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through importing statements and deals, the rep dispute-intake form locked to a real statement line, the ops investigation-and-resolution screen, the finance approval gate, the forward-adjustment generator, and the rep notification — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no API to your commission system.

The governance it includes (this is the point)

This is money owed to people, so it ships with the controls a finance team needs: login so only your team can use it, row-level security so reps see only their own disputes while ops and finance see the queue, a complete audit trail of who filed, investigated, resolved, and approved what and when, a hard human-approval gate so no adjustment is committed to a payout run until finance signs off, and duplicate guards keyed on rep + statement line so the same complaint can't be filed or paid twice. Adjustments always flow forward as deltas on the next run — the tool never quietly rewrites a run that's already been paid.

Who it's for

Sales ops, comp analysts, and finance partners who get a wave of "you shorted me" messages every commission cycle and want them turned into a tracked, fair, defensible process instead of a frantic email hunt. If you can describe how a dispute travels from a rep to a resolution today, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your first tracked dispute move from intake to approved adjustment the same afternoon.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.