Sales Commission Reconciliation: A Guide for Finance Teams

Commission reconciliation—verifying that calculated commissions match payroll payouts and align with CRM deal data—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.

Executive Summary

Commission reconciliation is the process of verifying that commission amounts calculated in your spreadsheet or commission tool match what payroll actually paid, and that both align with CRM deal data. For UK finance teams managing sales teams of 5–100 reps, this process typically involves pulling data from three sources (CRM, commission tool or spreadsheet, payroll records), sense-checking for errors, and investigating discrepancies. Misalignments often stem from timing delays between CRM updates and payroll cut-offs, complex plan rules (tiers, accelerators, clawbacks, splits), or outdated deal data. A structured monthly process—receive the commission file, validate against CRM deal data, audit payroll outputs, document and resolve variances—prevents overpayments and disputes. Best practice is to automate this using a dedicated commission platform rather than spreadsheets, which eliminates most reconciliation work entirely.

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.

Commission 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

Based on our experience working with 100+ finance and RevOps teams, this pattern is especially common in mid-market sales orgs. Early-stage teams (5–15 reps) often use flat rates; companies with 30+ reps typically layer in accelerators and tiered structures to manage costs at scale.

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.

In a 2025 survey of 100+ UK SaaS businesses with commission-paying sales teams, 87% reported spending 4+ hours per month on commission reconciliation. 64% cited timing misalignment between CRM and payroll as the primary source of discrepancy.

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

Based on our experience working with 100+ finance and RevOps teams, the following workflow represents the most common approach. 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