How to Calculate Split Commissions in Excel

When do commissions need to be split?

Split commissions come up in a few common scenarios:

• AE + SDR splits — the SDR who sourced the meeting gets a smaller percentage (e.g., 10%) of the deal commission, the closing AE gets the rest
• Co-sell deals — two AEs work a deal together, often 50/50 or by an agreed percentage
• Account handoffs — a deal started by one rep is closed by another after a territory or role change mid-cycle
• Overlay roles — a sales engineer or specialist gets a flat percentage for technical involvement

The key is to handle splits without rewriting your core commission formula for every deal — that's how spreadsheets become unmaintainable.

Step 1: Add a split allocation table to your deal log

Rather than hardcoding splits into formulas, add columns to your Deal Log that capture the split as data:

This keeps every deal's split explicit and auditable — no need to remember "this one was 90/10" six months later.

Step 2: Calculate each rep's split commission

Multiply the deal's commission amount by each rep's allocation percentage:

For the Acme Corp example at an 8% rate: Sarah earns $48,000 × 0.08 × 0.90 = $3,456 and James earns $48,000 × 0.08 × 0.10 = $384. Together they total the full $3,840 commission — the split just divides it.

Step 3: Roll splits up into each rep's payout total

If your Deal Log has one row per deal but a rep can appear as either "Primary" or "Secondary," your SUMIF needs to check both columns:

This gives Sarah's total payout across deals where she was either the primary closer or a secondary contributor — without double-counting or missing rows.

Handling accelerators on split deals

One subtlety: does a split deal count toward both reps' quota attainment, or only the primary rep's? Most plans count the full deal value toward the primary rep's quota (since they're accountable for the number) and treat the secondary rep's split as a bonus that doesn't affect their own accelerator tier. Whichever you choose, state it explicitly in your written commission plan — see our guide on what to include in a commission plan template.

Why this gets messy in a from-scratch spreadsheet

Splits multiply your formula complexity: every SUMIF, accelerator lookup, and clawback calculation now needs to account for a rep appearing in either the primary or secondary column. In a homegrown sheet, this usually means duplicating formulas or adding helper columns that are easy to break when someone edits a row.