Tima Miroshnichenko via Pexels
Most search results for a sales commission excel template hand you a US-built grid: flat percentages, no PAYE column, no clawback logic, and a "payout" figure that quietly ignores that commission in the UK is taxed as ordinary earnings. That's fine until you paste the number into payroll and someone gets a nasty surprise. This guide gives you a genuinely useful UK-shaped template structure you can build in an afternoon — with tiered rates, clawback tracking and a clean export to Xero — and then tells you honestly when a spreadsheet stops being the right tool.
TL;DR: A good UK sales commission Excel template needs at least three tabs: a plan/rates tab, a deal ledger, and a per-rep payout summary. Commission is treated as normal earnings, so it runs through PAYE and Class 1 National Insurance like salary — the spreadsheet calculates the gross commission and payroll (or Xero) handles the deductions. Track commissionable value separately from headline contract value so opt-outs and cancellations don't trigger clawbacks. A spreadsheet holds up for roughly up to 5 reps on simple plans; splits, accelerators reconciled quarterly, and real-time rep visibility are where it breaks.
What should a UK sales commission Excel template include?
A UK sales commission Excel template should be built as three linked tabs, not one sprawling sheet. Separating the plan rules from the deal data from the payout summary is what makes it auditable — and auditability is the whole point of moving off a scribbled calculation.
| Tab | What it holds | Why it matters |
|---|---|---|
| 1. Plan & rates | Quota, base rate, tier thresholds, accelerator rates, clawback/rebate period | One place to change the rules; every formula references it |
| 2. Deal ledger | Deal ID, rep, close date, gross contract value, commissionable value, rate applied, commission earned, clawback flag, status | The audit trail — one row per deal, never overwritten |
| 3. Payout summary | Per rep, per pay period: total gross commission, adjustments, amount to send to payroll | This is what Finance and Xero actually consume |
The single most important design decision is keeping gross contract value and commissionable value in two separate columns. They are not the same number, and conflating them is the root cause of most clawback fights (more on that below).
A template you assembled yourself is one you understand. The structure above takes about an hour in Excel or Google Sheets, and you'll debug your own plan's quirks as you go — far more valuable than a pretty grid you don't trust.
How is commission taxed in a UK spreadsheet — does the template calculate PAYE?
No — and it shouldn't try to. Your commission Excel template should calculate the gross commission a rep has earned. The Income Tax and National Insurance deductions happen in payroll, because commission is treated as ordinary employment earnings, not a separate category. HMRC's guidance on operating PAYE confirms your payroll software "will work out how much tax and National Insurance to deduct" once the gross figure lands (HMRC, Rates and thresholds for employers 2026 to 2027).
What this means in practice: the spreadsheet's job ends at gross commission. But it helps to understand what happens next, because reps will ask. For the 2026 to 2027 tax year, HMRC sets the Personal Allowance at £12,570, the basic rate at 20% up to £37,700 of taxable income, and the higher rate at 40% from £37,701 to £125,140. Employee (Class 1) National Insurance for a standard category A employee is 8% on earnings between the primary threshold (£1,048 a month) and the upper earnings limit (£4,189 a month), then 2% above that.
The part that hits you, not the rep, is employer's National Insurance. As HMRC confirms, the employer secondary Class 1 rate is 15% on earnings above the £417-a-month secondary threshold for 2026 to 2027. Commission is earnings, so every £1,000 of commission you pay carries roughly £150 of employer NIC on top — a real cost that belongs in your commission budget, not a rounding error. We've broken the full arithmetic down in the true cost of commission and employer NIC, and the tax mechanics for reps in how commission is taxed in the UK.
Your spreadsheet calculates gross commission. Payroll handles the tax. Confusing the two is how reps end up disputing a correct number.
How do you handle tiered commission and accelerators in Excel?
Tiered commission and accelerators are handled in Excel with nested IF statements or a lookup against your plan tab — never by typing rates directly into each deal row. Hard-coded rates are how a plan change silently fails to apply to half your ledger.
Here's a concrete worked example. Say a rep carries a £120,000 quarterly quota, earns 8% commission on revenue up to quota, and hits a 12% accelerator on everything above it. They book £150,000 for the quarter.
- On the first £120,000 (to quota): £120,000 × 8% = £9,600
- On the £30,000 above quota: £30,000 × 12% = £3,600
- Total gross commission: £13,200
In the ledger, that's a formula referencing the tier thresholds on your plan tab, so when Finance signs off a rate change for next quarter you edit one cell and every future calculation follows. If you're designing the accelerator itself — and whether a step-change or a smooth ramp behaves better — that's a plan-design question we cover in designing commission accelerators, not a spreadsheet one.
How do you track clawbacks in a commission spreadsheet?
You track clawbacks by never paying on money that isn't locked in yet. This is where the gross-versus-commissionable split earns its place. In practice, the most damaging clawback we see doesn't come from a rep gaming the system — it comes from Finance paying commission on the gross signing-day contract value, in a rush to hit payroll, before the deal's opt-out or cancellation window has closed.
Work through it. A rep closes a £60,000 deal on the last day of the quarter. The contract has a 14-day opt-out clause. Finance, racing the payroll cut-off, pays 8% on the full £60,000 — £4,800. Ten days later the customer cancels £20,000 of it. The commissionable value was only £40,000, so the rep was overpaid £1,600. Now you're clawing money back from someone who did nothing wrong, and the correction — not the original error — is what does the cultural damage.
The fix in the template is structural, not clever: a commissionable value column that starts at zero (or excludes the at-risk portion) until the opt-out, ramp or rebate window closes, and a status column (pending / locked / clawed back) that gates whether a row flows into the payout summary. Calculate commission on the value actually locked in, not the headline. Our commission clawback policy guide covers how to word the underlying rule so it's enforceable.
A manager's job isn't only to help reps close — it's to shield them from internal operational mistakes. Sanity-check every payout against the real contract terms before Finance runs payroll. Once a wrong number is paid, reversing it costs you trust you can't easily rebuild.
How do you export commission to Xero from the template?
You export commission to Xero by mapping your payout summary tab to a pay-item import: employee name or ID, the commission pay item, the gross amount, and the pay period. Xero then applies PAYE and NIC as part of its payroll run — you don't pre-calculate deductions in the sheet. Keep the summary tab's columns in the exact order and naming Xero's import expects, so the export is a copy-paste rather than a monthly reformatting job. We walk through the mechanics in connecting commission to Xero.
The discipline that matters: only locked rows should reach the export. If your status column and your summary formulas are wired correctly, an at-risk deal simply won't appear in the file you send to payroll — which is exactly the protection the manual process lacks.
When does the Excel template stop working?
An Excel commission template stops being safe at a predictable set of thresholds. It's not about spreadsheet skill; it's about the number of moving parts a human can reconcile by hand before something slips.
| You're probably fine with Excel | You've outgrown it when… |
|---|---|
| Up to ~5 reps | The team passes 5–10 and every plan tweak means editing dozens of rows |
| Flat or single-tier rates | You add split deals — two reps, one number, and formulas that no longer reconcile to 100% |
| Monthly, single-approver payout | You run quarterly reconciliation across accelerators, draws and clawbacks |
| Reps trust a monthly statement | Reps want real-time visibility and keep their own shadow spreadsheet |
| One person owns the file | Multiple editors, version conflicts, and no record of who changed what |
The tell is rarely a wrong number. It's the appearance of shadow accounting — reps quietly tracking their own commission because they don't trust yours, which we've written about in why shadow accounting is a warning sign. Disputes are fundamentally a trust-and-visibility problem: reps don't lose faith because a figure is occasionally wrong, they lose it when they can't see how it was built and a correction lands with no warning. A spreadsheet can't give you a live audit trail or self-service rep visibility, and no amount of formula cleverness fixes that. For the full cost picture, see our spreadsheet vs commission software comparison.
Frequently Asked Questions
Is a free Excel commission template enough for a small sales team?
For a team of up to about five reps on a flat or single-tier plan paid monthly, a well-structured Excel template is genuinely enough. The three-tab structure — plan, ledger, summary — gives you most of what you need. It breaks down once you add split deals, accelerators reconciled quarterly, or reps who want to see their numbers in real time.
Does a commission spreadsheet need to calculate PAYE and National Insurance?
No. A commission spreadsheet should calculate only the gross commission earned. HMRC's employer guidance is explicit that PAYE and National Insurance are worked out by your payroll software once the gross figure is entered, because commission is treated as ordinary employment earnings.
What contract value should commission be calculated on?
Commission should be calculated on the value actually locked in — the commissionable value — not the gross signing-day headline. Where a deal carries an opt-out, ramp or cancellation clause, paying on the gross total before that window closes is the most common cause of clawbacks that damage rep trust.
How much does employer's National Insurance add to a commission payment?
For the 2026 to 2027 tax year, HMRC sets the employer secondary Class 1 National Insurance rate at 15% on earnings above the £417-a-month secondary threshold. So roughly £150 of employer NIC applies to every £1,000 of commission paid — a cost that belongs in your commission budget.
Can Excel handle split commissions between two reps?
Excel can technically model a split, but split deals are where spreadsheets most often stop reconciling — the two rep rows must always sum to exactly 100% of the deal, and a single fat-fingered percentage breaks it silently. Split-heavy or team-based plans are a strong signal you've outgrown the template.
Ready to fix your commission process?
See your own comp plan running in Commit. 20 minutes, no slides.