Sales Commission Excel Template (Free Download) + When to Upgrade

RDNE Stock project via Pexels

Almost every result for "sales commission excel template" hands you a spreadsheet and calls it done. That is fine for a five-rep team paying flat 10% on invoiced revenue. It is not fine for anything with tiers, splits, clawbacks or a mid-quarter plan change — and it will silently break in ways that cost you trust and cash. This piece gives you a genuinely useful UK template, walks through a worked example, and then tells you the five things that will go wrong in the next six to twelve months.

TL;DR

A sales commission Excel template is fine as a starting point for small UK sales teams: build it with a tiered SUMPRODUCT (or IFS) rate formula, a separate NIC estimation column using the 2026/27 employer rate of 15% above the £5,000 secondary threshold (HMRC), and a Xero-shaped export tab with employee ID, pay item, amount and pay date. Commission is taxable as employment income and runs through PAYE like salary (HMRC EIM64615). Expect the spreadsheet to hold together until you hit any of: version-control chaos, formula rot, no audit trail, manual Xero reconciliation, or reps losing trust in the numbers. That is the signal to migrate.

What should a UK sales commission Excel template actually contain?

Most templates online are US-flavoured — no PAYE, no NIC, no Xero. A UK-usable sales commission Excel template needs five tabs, not one:

The critical formula is the tiered rate. For a plan that pays 8% up to quota, 12% from 100–120%, and 16% above 120%, the cleanest approach is a SUMPRODUCT over the marginal bands rather than a nested IF — nested IFs are where errors hide:

=SUMPRODUCT(
  (Attainment > {0, Quota, 1.2*Quota})
  * (Attainment - {0, Quota, 1.2*Quota})
  * ({0.08, 0.04, 0.04})
)

Each band's rate in the third array is the incremental rate over the previous tier (8% → 12% is +4%, 12% → 16% is +4%). This is the same maths every commission platform runs internally; getting it right in Excel is possible, keeping it right across ten quarters and three plan revisions is where it gets hard.

How do you handle NIC and PAYE inside the template?

HMRC treats sales commission as earnings from employment — it is chargeable to tax as employment income and goes through PAYE like base salary (HMRC EIM64615). Your payroll software (Xero or otherwise) handles the actual income tax and employee NIC withholding. What the spreadsheet needs to give you — the finance or RevOps owner — is a forward view of employer cost.

For 2026/27, HMRC sets the employer secondary NIC rate at 15% on earnings above the £5,000 annual secondary threshold, with Employment Allowance of up to £10,500 for eligible employers (Rates and thresholds for employers 2026 to 2027). A £15,000 commission cheque to a rep already above the threshold therefore carries roughly £2,250 of employer NIC on top — that is a real budget line, not a rounding error, and it needs to sit in the template so Finance is not surprised on the 22nd of the month.

A worked example: where the template holds

Take a £45k base + £15k OTE SaaS AE on a 70/30 split — £15k of variable, quota £150k of new ACV per quarter, plan pays 10% up to quota and 15% accelerator above.

Q1 close: £180k ACV, one deal per month.

• First £150k × 10% = £15,000
• Next £30k × 15% = £4,500
• Gross commission: £19,500
• Employer NIC (15% × £19,500, rep already above ST): £2,925
• Total employer cost of the variable line: £22,425

The template handles this cleanly. One rep, one plan, one quarter, deals fully invoiced and locked. The Calc tab spits out £19,500, the Xero Export tab lines it up as a Commission earnings item on the March pay run, and Finance sleeps.

A worked example: where the template breaks

Now change three things — the kind of change any growing UK sales org sees in its second year.

1. The £180k Q1 total includes a £60k deal with a 30-day opt-out written into the MSA.
2. One of the deals was split 60/40 with an outbound SDR who sourced it.
3. The board raised the accelerator threshold from 100% to 110% of quota, effective 1 March — mid-quarter.

Any one of those breaks a static spreadsheet. Together they turn it into a hall of mirrors. The £60k opt-out deal should not be paid on gross signing-day value until the opt-out window has closed — but a template with a single Close Date column and no Locked Date column has no way to hold that logic. The 60/40 split needs a second row keyed to the SDR (and a rule that the two rows must sum to 100%). The mid-quarter plan change means the Plan tab now needs to be time-boxed — deals closed before 1 March use the old accelerator, deals after use the new one, and a VLOOKUP on close date has to pick the right rate.

Comp logic that works on a £10k 14-day SMB deal does not survive a £350k multi-threaded mid-market one.

In practice, this is exactly where contract complexity spikes: once deals cross roughly £100k they stop being clean closed-won numbers. Custom clauses, opt-outs, security reviews and legal redlines appear — and that is precisely where commission errors hide.

What are the 5 failure modes every commission spreadsheet hits?

These are the ones that push UK sales orgs off Excel. In rough order of when they arrive:

1. Version control chaos. Commission_Q3_FINAL_v7_actually_final.xlsx sitting in three inboxes. Nobody knows which sheet reflects the paid number.
2. Formula rot. Someone drags a formula one row too far, or types over a SUMPRODUCT. The error only surfaces two months later when a rep spot-checks their own numbers.
3. No audit trail. Excel does not tell you why a rep's number changed between draft and final. When a dispute lands, there is no diff to point at.
4. Manual Xero reconciliation. Even a well-shaped Xero Export tab still requires someone to open Xero, add pay items, cross-check totals, and re-key any late corrections. See our guide on the Xero commission integration for how that reconciliation is meant to work.
5. Rep distrust. This is the one that ends the spreadsheet era. Reps do not lose faith because a number is occasionally wrong — they lose it when they cannot see how it was built and a correction lands with no warning.

There is a full breakdown of the true cost of running commission on a spreadsheet and the specific calculation errors that repeat in our library — worth reading before you commit to another year of copy-paste.

When is the right time to upgrade from Excel?

Use this as a rough gate. If you tick two or more, the spreadsheet is now costing you more than software would:

A manager's job is not just helping reps close — it is auditing the commission payout against the real contract terms before payroll runs. Once a wrong number is paid, the correction is what does the cultural damage. That audit is the thing a spreadsheet cannot give you at scale; a system with an audit trail can.

Frequently Asked Questions

Is sales commission taxed differently from salary in the UK?

No. HMRC treats commission as earnings from employment, chargeable to tax as employment income and processed through PAYE alongside salary (HMRC EIM64615). Employer NIC applies on the same basis at 15% above the £5,000 secondary threshold for 2026/27 (HMRC).

Can Excel handle tiered commission with accelerators?

Yes, if you use SUMPRODUCT over marginal bands rather than nested IF statements, and store rates in named ranges on a dedicated Plan tab. It stops handling it well when the plan itself changes mid-period, when splits appear, or when deals need a Locked Date distinct from close date.

How do I export commission from my spreadsheet into Xero?

Build a Xero Export tab shaped as: employee ID, earnings type (e.g. Commission), amount, pay period end date. Save as CSV and import into a pay run. Anything more sophisticated — automatic sync, correction handling, reversals — needs a purpose-built Xero commission integration.

How many reps can I realistically run on an Excel commission template?

As a rule of thumb, up to about 8–10 reps on a single-tier plan with no splits or clawbacks. Past that, or if any of those complexity triggers apply, the maintenance cost of the spreadsheet starts to exceed the cost of dedicated software — the analysis in spreadsheet vs commission software walks the numbers.

Should I pay commission on gross deal value or invoiced value?

Where a deal has opt-outs, ramp periods or cancellation clauses, commission should be calculated on the value actually locked in — not the signing-day headline. Paying on gross before the opt-out window closes is the single most common cause of clawbacks and the disputes that follow.