Sales Commission Reconciliation: A Guide for Finance Teams

Commission reconciliation is one of those finance tasks that sounds simple and never is. In principle, you're just matching what the sales team earned against what payroll paid out. In practice, you're pulling numbers from a CRM, cross-referencing a commission spreadsheet built by someone in sales ops, aligning it with payroll records, and trying to figure out why the totals don't match — again.

If you work in finance at a UK business with a commission-paying sales team, this is probably familiar. This article sets out a practical reconciliation process, covers the most common discrepancies and their root causes, and explains how things tend to break down as teams scale.

What Commission Reconciliation Actually Involves

Commission reconciliation is the process of verifying that the commission amounts calculated for each sales rep match the amounts paid through payroll, and that both match the underlying deal data in the CRM or sales system.

It sits at the intersection of three data sources:

• CRM data — the deals that closed, the amounts, the dates, and the rep assignments
• Commission calculations — typically maintained in a spreadsheet or commission tool, applying the plan rules (rates, tiers, accelerators, SPIFs) to the CRM data
• Payroll records — the actual amounts processed and paid to each rep, including PAYE, National Insurance, and pension deductions

Each of these systems has its own logic, its own update cadence, and its own owner. The CRM is managed by sales ops or the reps themselves. The commission calculations are often run by sales ops, a rev ops team, or sometimes the sales leader directly. Payroll is run by finance or an outsourced payroll bureau.

Reconciliation means making sure the numbers in all three places agree — and when they don't, finding out why.

Why It's Harder Than It Sounds

If commission plans were flat percentage rates on closed-won revenue, reconciliation would be trivial. But most plans involve some combination of:

• Tiered commission rates that change once a rep passes a threshold
• Quarterly or annual accelerators
• Clawbacks on churned or refunded deals
• Split credits between reps on the same deal
• Different rates for new business vs. expansion vs. renewal
• SPIFs and one-off bonuses layered on top

Each of these adds a layer of logic that has to be tracked, calculated, and verified. The more complex the plan, the more opportunities for the commission calculation to diverge from what payroll actually processes.

The problem is compounded by timing. CRM data changes constantly — deals are backdated, amounts are revised, close dates are pushed. A deal might show as closed-won in the CRM on 28 March but not appear in the commission spreadsheet until mid-April. By that time, the March payroll has already run without it.

This is the same class of problem that causes commission calculation errors — manual processes applied to changing data with no single source of truth.

The Typical Reconciliation Workflow

Most finance teams follow some version of this process, even if it's not formally documented:

Step 1: Receive the commission file

Sales ops or the sales leader sends a spreadsheet or export listing each rep's commission amount for the period. This is the "commission run" — the calculated output of the commission plan applied to the period's deals.

Step 2: Review and sense-check

Finance reviews the file for obvious errors: negative amounts, unusually large payouts, reps who appear to have no commission, duplicate entries. This is a basic sanity check, not a detailed audit.

Step 3: Match to CRM deal data

Finance pulls a report from the CRM (or requests one from sales ops) showing the deals that closed in the period. They compare the deal list in the commission file against the CRM report. Discrepancies at this stage usually come from:

• Deals in the CRM that are missing from the commission file
• Deals in the commission file that have been removed or changed in the CRM
• Different deal amounts between the two sources

Step 4: Verify commission calculations

For a sample of deals (or all deals, depending on team size), finance re-calculates the commission using the plan rules. This is where tier breakpoints, accelerators, and split credits get checked. Errors in the calculation logic — wrong rates, incorrect tier thresholds, overlooked accelerators — tend to surface here.

Step 5: Submit to payroll

Once the commission amounts are agreed, finance submits them to the payroll system for processing. Depending on the payroll cycle, this might be part of the monthly payroll run or a separate supplementary payment.

Step 6: Post-payroll verification

After payroll runs, finance checks that the amounts processed match what was submitted. This catches data entry errors, rounding differences, or issues with how payroll software handles variable pay.

Step 7: Document and close

The reconciliation is documented — what was checked, what was corrected, and what was paid. This forms the audit trail.

Common Discrepancies and Their Root Causes

Having a clean reconciliation every month would be ideal. In reality, discrepancies show up regularly. The most common ones fall into a few categories.

CRM data issues

The deal was amended after the commission calculation was done. A deal amount changed, a close date moved, or a deal was reassigned to a different rep. If the commission file was generated from a snapshot of the CRM at a particular point in time, any changes after that snapshot won't be reflected.

Timing mismatches

The commission period and the payroll period don't align. Many businesses calculate commission monthly but run payroll on a different schedule — or the cut-off for deals to count towards a period is ambiguous. A deal that closes on the 30th might or might not make it into that month's commission run, depending on when the extract was pulled.

Calculation errors

The wrong rate was applied. A tier threshold was missed. A clawback wasn't processed. A SPIF was included that should have expired. These are plan logic errors, and they're especially common when commission plans change mid-year or when multiple plan versions are running simultaneously.

This is one of the core problems with running commission calculations in spreadsheets. The logic is fragile, the formulas are hard to audit, and errors compound silently. We've written in detail about the hidden cost of managing commission in spreadsheets — it's directly relevant to reconciliation failures.

Split credit disagreements

Two reps claim credit on the same deal. The CRM shows one owner, but the commission file shows a split. Or the split percentages don't add up to 100%. These are governance issues more than technical issues, but they surface during reconciliation and need a clear resolution process.

Clawback miscalculations

A deal churned or was refunded, triggering a clawback. But the clawback amount in the commission file doesn't match the original commission paid out, or it's applied to the wrong period. Clawbacks that cross pay periods are particularly tricky to reconcile.

Payroll processing errors

The commission amount submitted to payroll differs from what was actually processed. This can happen due to manual data entry errors, rounding in the payroll system, or incorrect tax treatment of the commission payment. Commission should be processed as earnings through PAYE, not as expenses or reimbursements — getting this wrong has tax implications.

Working With Sales Ops vs. Doing It Solo

In larger organisations, reconciliation is a joint effort between finance and sales ops. Sales ops owns the commission calculations; finance owns the payroll and accounting treatment. The handoff point is usually the commission file.

In smaller teams, finance often does everything: pulling the deal data, applying the plan rules, calculating the commission, and running it through payroll. This concentrates all the risk in one function and makes it harder to catch errors through separation of duties.

Wherever you sit, the key is clarity on three things:

1. Who owns the commission calculation? If it's sales ops, finance needs to trust but verify. If it's finance, the sales leader needs to sign off before payroll runs.
2. What is the single source of truth for deal data? If it's the CRM, then the CRM data at a defined cut-off point should be what drives the commission calculation. Late changes get handled in the next period.
3. What's the sign-off process? Someone in sales leadership and someone in finance should both approve the commission run before it goes to payroll. No commission should be paid without dual sign-off.

Audit Trail Requirements

UK businesses don't have a specific regulatory requirement to maintain a commission reconciliation audit trail in the way that, say, financial services firms must evidence best execution. But good practice — and HMRC compliance — requires that you can demonstrate:

• What was paid to each employee and when
• How the commission was calculated (the plan, the rates, the deals)
• That the amounts were processed correctly through PAYE
• That employer NIC was calculated on the commission payments

If HMRC queries payroll during an employer compliance review, they may ask for evidence that variable payments (including commission) were correctly calculated and taxed. Having a documented reconciliation process — even a simple one — provides that evidence.

This is especially relevant given the employer NIC changes that took effect in April 2025, where every pound of commission now carries a 15% employer NIC charge above the £5,000 Secondary Threshold. Getting commission amounts wrong doesn't just affect the rep's pay — it affects the employer's NIC liability. For more on this, see our article on employer NIC and commission in the 2026/27 tax year.

Month-End vs. Pay-Cycle Timing

One of the less obvious challenges in commission reconciliation is the mismatch between accounting periods and pay cycles.

Finance typically works on a calendar month basis. Commission plans often run on calendar months too. But payroll might run on the 25th, or the last Friday of the month, or on a different cycle entirely.

This creates a timing gap. Deals that close in the last few days of the month might not make it into that month's payroll run. The commission gets accrued in one period and paid in the next. That's fine from a cash perspective, but it complicates the reconciliation because you're always carrying forward a balance of unpaid commission.

The solution is to define a clear cut-off:

• Commission is calculated on deals closed by a defined date each month
• The commission file is submitted to payroll by a defined date
• Payroll processes the commission in that month's pay run
• Any deals closed after the cut-off are included in the following month

Document the cut-off dates and communicate them to the sales team. Most disputes about "missing" commission come down to a deal that missed the cut-off by a day — and the rep not knowing the cut-off existed.

Accruals and Provisions

For businesses that report on an accruals basis (which is most UK businesses above the micro-entity threshold), commission needs to be accrued in the period it's earned, not the period it's paid.

This means finance needs to estimate the commission liability at each month-end, even if the commission won't be paid until the following month or quarter. Getting this right matters for management accounts, board reporting, and statutory accounts.

A practical approach:

• Monthly accrual: At month-end, accrue the estimated commission based on the deals closed in that month, using the plan rates. This is your commission provision.
• Reversal on payment: When the commission is actually paid through payroll, reverse the accrual and book the actual expense.
• True-up: At the end of each quarter (or at year-end), compare your accruals against actual commission paid. If there's a persistent over- or under-accrual, adjust the methodology.

For teams with accelerators or tiered structures, the accrual gets more complex. A rep who is likely to hit an accelerator in Q4 will earn commission at a higher rate — but you won't know for certain until the quarter closes. Some businesses accrue at the base rate and true up quarterly. Others model expected attainment and accrue at the blended rate. Neither approach is wrong, but you need to be consistent.

The employer NIC on commission should also be accrued. If you're accruing £50,000 in commission for the month, the employer NIC provision is an additional £7,500 at the 15% rate. Forgetting to accrue the NIC is a common oversight that creates a gap between the provision and the actual cash cost.

How Reconciliation Breaks Down at Scale

Commission reconciliation that works for a team of five reps tends to fall apart at fifteen. And what works at fifteen breaks at fifty.

The breaking points are predictable:

Spreadsheet complexity. A ten-tab commission spreadsheet with VLOOKUP formulas referencing the CRM export can be managed by one person who understands it. When that person goes on holiday or leaves the business, the spreadsheet becomes a black box. When a second person tries to modify it, errors get introduced.

Volume of deals. Reconciling fifty deals a month is manageable. Reconciling five hundred requires tooling or significant time investment. The per-deal verification that's feasible at small scale becomes a sampling exercise — and samples miss things.

Multiple commission plans. When different reps or roles have different plans running simultaneously, the reconciliation has to track which plan applies to which rep and which deals. Plan changes mid-year add another dimension of complexity.

Multi-entity or multi-currency. Teams selling across UK and international entities add currency conversion, transfer pricing, and potentially different payroll systems into the mix.

Audit fatigue. At some point, the monthly reconciliation becomes so time-consuming that it starts getting done less rigorously. Month-end pressure means shortcuts get taken. The reconciliation that used to catch errors starts rubber-stamping them.

This is the point where most finance teams start looking for dedicated commission management software — not because they can't do the reconciliation manually, but because the time and risk cost of doing it manually exceeds the cost of the tool.

A Practical Reconciliation Checklist

For finance teams that want to tighten up their process without overhauling everything, here's a straightforward checklist to work through each commission cycle:

1. Confirm the period dates and deal cut-off with sales ops
2. Receive the commission file and verify the deal count against the CRM
3. Spot-check five to ten deals for correct rate application and deal amounts
4. Verify all clawbacks and adjustments against prior period records
5. Check split credits add up to 100% on shared deals
6. Confirm the total commission amount, including employer NIC, against budget
7. Get dual sign-off (sales leadership and finance) before submitting to payroll
8. After payroll runs, verify processed amounts against submitted amounts
9. Book or reverse the commission accrual in the general ledger
10. File the reconciliation workpapers for audit trail purposes

This process won't catch every error. But it will catch the most common and most expensive ones, and it gives you a documented trail if questions arise later.

Getting Ahead of the Problem

Commission reconciliation is never going to be exciting work. But getting it right protects the business from overpayments, protects reps from underpayments, and keeps finance and sales aligned on the numbers that matter.

The teams that do this well share a few characteristics: a defined cut-off process, a single source of truth for deal data, a clear ownership model for the commission calculation, and a documented sign-off process. None of these require new software — they just require discipline.

That said, if your team is growing and your reconciliation process is already creaking, it's worth considering whether the spreadsheet approach will scale with you. The cost of reconciliation errors — in time, in trust, and in money — tends to compound faster than most teams expect.

---

This article is for general guidance only and does not constitute financial or accounting advice. Commission accounting treatment may vary depending on your company's specific circumstances, reporting framework, and payroll arrangements. Consult your accountant or auditor for advice specific to your organisation.