3 Free Sales Commission Excel Templates (UK, 2026/27)

If you need a sales commission template in Excel right now, this article gives you three: a flat-rate tracker, a tiered calculator with quota attainment, and a clawback/adjustment log. Each one uses UK-specific columns — gross commission, an employer National Insurance estimate, and net-to-rep after PAYE — so the number you show a rep is the number that survives payroll. But we're not going to pretend a spreadsheet is forever. The more useful thing we can do is tell you the exact point each template stops protecting you.

These are build-it-yourself layouts, not a magic download. That's deliberate: a template you assembled column by column is one you actually understand when a rep queries their number at 5pm on the last day of the quarter.

Template 1: the flat-rate commission tracker

The flat-rate template is the right sales commission template in Excel for a small team paid a single percentage on every deal, with no tiers and no quota gate. Think two or three reps selling one product at, say, 8% of deal value.

Build these columns, left to right:

Column	Example	Formula / note
Rep name	Priya S.	—
Deal / invoice ref	INV-1042	Match to your accounting system
Close date	2026-05-12	Determines which pay period it lands in
Deal value (£)	12,000	The value actually locked in, not the headline
Commission rate	8%	—
Gross commission (£)	960	=DealValue*Rate
Employer NIC estimate (£)	144	=Gross*15% (see note below)
Notes	—	Opt-out window, disputes, splits

The employer NIC column matters because commission is earnings, and earnings above the secondary threshold attract employer's National Insurance. For 2026/27 the employer (secondary) Class 1 NIC rate is 15% on earnings above the secondary threshold of £5,000 a year, per HMRC's rates and thresholds for employers 2026 to 2027. A rep on any real salary is already past that threshold, so as a planning estimate every £1,000 of gross commission costs the business roughly £150 in employer NIC on top. Budget for it in the same row you calculate the payout — otherwise commission looks 15% cheaper than it is.

Template 2: the tiered commission calculator with quota attainment

Once a plan has a quota gate or an accelerator, the flat template lies to you. The tiered template models attainment — the percentage of quota a rep has hit — and applies different rates to revenue below and above target.

Columns to build:

Column	Example	Formula / note
Rep name	Tom R.	—
Quota (£)	500,000	Period target
Actual revenue (£)	600,000	Locked-in value
Attainment	120%	=Actual/Quota
Base rate	3%	Applies up to quota
Accelerated rate	5%	Applies to revenue above quota
Gross commission (£)	20,000	See worked example
Employer NIC est. (£)	3,000	=Gross*15%
Est. net to rep (£)	11,600	Higher-rate assumption below

How do you calculate tiered commission with an accelerator?

The common spreadsheet error here is applying the accelerated rate to all revenue once a rep crosses quota, not just the portion above it. On a 120%-attainment rep that mistake overpays by thousands. In practice, this is one of the most frequent commission calculation errors we see teams make, and a flat spreadsheet won't flag it — it just pays the wrong number.

What does a rep actually take home from £20,000 of commission?

Commission is taxed through PAYE exactly like salary — it is not a special category. For a rep who is already a higher-rate taxpayer, that commission sits in the 40% band. According to HMRC's Income Tax rates for 2026/27, the higher rate of 40% applies to income from £50,271 to £125,140 (England, Wales and Northern Ireland; Scotland has its own bands). On top of that, employee National Insurance on earnings above the upper earnings limit is charged at 2%.

So take our rep with a base salary that already uses up the basic-rate band. Their £20,000 gross commission is taxed at 40% PAYE plus 2% employee NIC — a 42% deduction — leaving roughly £11,600 in their pocket. Meanwhile the business pays the £20,000 plus £3,000 employer NIC — a £23,000 true cost. One deal, three very different numbers. A rep who only ever sees the £20,000 headline will feel short-changed on payday, which is why showing the net figure in the plan itself prevents an argument later. We go deeper on the mechanics in our guide to how commission is taxed in the UK.

Template 3: the clawback and adjustment log

The third template exists because deals change after they close. A contract cancels in its cooling-off window, a customer downgrades during a ramp, a signing-day figure turns out to include an opt-out the rep already knew was coming. If you pay on the gross signing-day value and adjust later, you create a clawback — and clawbacks are where trust dies.

Columns to build:

Column	Example	Note
Rep name	Dan M.	—
Original deal ref	INV-1042	Links to the tracker
Amount paid (£)	960	What actually went out
Reason for adjustment	Opt-out exercised	Be specific
Adjustment (£)	-480	Negative = clawback
Net position (£)	480	Running balance
Date flagged	2026-06-01	—
Approved by	Manager	Who signed it off
Xero reference	—	For the payroll export

In practice, the single most damaging clawback we've seen traces back to Finance paying commission on the gross total contract value in a rush to hit the payroll deadline — before the deal's opt-out window had closed. When the customer opted out, the correction landed on the rep with no warning. The fix is a discipline, not a formula: calculate commission on the value actually locked in, not the signing-day headline, whenever a deal carries opt-out, ramp or cancellation clauses. A manager's real job here is to sanity-check the payout against the true contract terms before payroll runs — because once a wrong number is paid, it's the correction that does the cultural damage, not the original mistake. If you're formalising this, our commission clawback policy guide for the UK covers what to put in writing.

Reps don't lose faith because a number is occasionally wrong. They lose it when they can't see how it was built and a correction lands with no warning.

How do you export commission from a spreadsheet into payroll?

Whichever template you use, payroll needs a clean handoff. The practical format for a Xero payroll import is a stripped-down sheet: employee name or ID, a single pay item (e.g. "Commission"), the amount, and the pay period. Keep that export tab separate from your working calculations so a stray formula edit never changes what's actually paid. We walk through the mechanics in our Xero commission integration guide.

The risk with a manual export is version drift: the number in the working sheet, the number the rep saw, and the number in the payroll file quietly diverge. When they don't reconcile, you get shadow accounting — reps keeping their own private spreadsheet because they don't trust yours.

When does an Excel commission template stop working?

Every spreadsheet template has a breaking point. Here's where each of these three fails, and the symptom you'll notice first.

Template	Breaks when…	Symptom you'll see
Flat-rate tracker	You add a second product, a tier, or pass ~5 reps	Rows multiply; rates get hard-coded and go stale
Tiered calculator	You add deal splits, approvals, or pass ~10 reps	Formulas nest 4+ levels deep; nobody but you can audit them
Clawback log	Finance asks for a full audit trail, or deals cross ~£100k	You can't reconstruct who approved what, or when

That last row matters more than it looks. In mid-market, once a deal crosses roughly £100,000 it stops being a clean "closed-won" number: custom clauses, opt-outs, security reviews and legal redlines appear — and that's exactly where commission errors hide. Comp logic that works fine on a £10,000 SMB deal with a 14-day term does not survive a £350,000 multi-threaded contract. A spreadsheet has no memory of who changed a cell, so when Finance (or an auditor) asks "why was this paid?", you're reconstructing history from email.

The honest signal to graduate isn't a rep count — it's time and trust. When you're spending a chunk of every month rebuilding formulas, when disputes recur because reps can't see how their number was built, and when a single correction damages morale, the spreadsheet has become the expensive option. We put real numbers on that trade-off in the true cost comparison of spreadsheets versus commission software, and cover the graduation decision in when to upgrade from a commission spreadsheet.

Frequently Asked Questions

Is Excel good enough for managing sales commission?

Excel is genuinely fine for a small, simple plan — a handful of reps on a flat or single-tier rate with no splits or clawbacks. It stops being good enough when you add deal splits, approval workflows, real-time rep visibility or an audit trail Finance can rely on. At that point the hours spent maintaining formulas and resolving disputes usually exceed the cost of dedicated software.

How is commission taxed in the UK?

Commission is treated as earnings and taxed through PAYE just like salary, with National Insurance also due. For 2026/27, HMRC sets the higher Income Tax rate at 40% on income from £50,271 to £125,140 in England, Wales and Northern Ireland, and employers pay 15% secondary Class 1 National Insurance on earnings above the £5,000 secondary threshold. A higher-rate rep therefore keeps roughly 58% of gross commission after 40% tax and 2% employee NIC.

What columns should a UK commission spreadsheet have?

At minimum: rep name, deal reference, close date, the locked-in deal value, commission rate, and gross commission. Add an employer NIC estimate column (15% of gross) so the business budgets the true cost, and a net-to-rep column so the number reps see matches their payslip. If deals can change after closing, add a separate clawback/adjustment log linked by deal reference.

Should I pay commission on the total contract value?

Not if the deal carries opt-out, ramp or cancellation clauses. Paying on the gross signing-day value before those windows close is the most common cause of clawbacks. Calculate commission on the value actually locked in, and sanity-check every payout against the real contract terms before payroll runs.

When should we move off Excel to commission software?

The trigger is time and trust, not a fixed headcount. If you're rebuilding formulas most months, disputes keep recurring because reps can't see how their number was built, or Finance needs an audit trail Excel can't produce, you've passed the point where a spreadsheet saves money. Adding splits, accelerators or approval workflows usually forces the decision.