Commission Reconciliation: 5-Step Process for Finance

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

This pattern is especially common in mid-market sales orgs: smaller teams tend to use flat rates, while larger teams layer in accelerators and tiered structures, and every extra rule is another place for the reconciliation to diverge.

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 isn't formally documented:

Step 1: Receive the commission file

Sales ops or the sales leader sends a spreadsheet or export listing each rep's commission for the period. Finance's first check is completeness: every rep on the payroll who is on a commission plan should appear, and every row should say which deals it covers.

Step 2: Match deals against the CRM

Check that each deal on the file is closed-won in the CRM, in the right period, at the right value. Look especially for deals whose value or close date changed after the file was prepared, and for closed-won deals that are missing from the file altogether.

Step 3: Check rates and tiers against the signed plan

Recalculate a sample, and every large payout, from the plan document rather than the spreadsheet's formulas. Confirm which tier each rep is in, whether tiers are marginal or retroactive, and whether any accelerator, cap or clawback applies this period.

Step 4: Reconcile to payroll

Agree the approved total per rep to the figure going into payroll, and after the pay run, to what was actually paid. If you use Xero, this is the point where re-keying errors appear.

Step 5: Approve, record and archive

Get sign-off from the sales leader and finance, and keep the file, the approvals and any adjustments together. That record is what you'll need for audit, for year-end reporting, and for the next dispute.

How to Make Reconciliation Faster

The workflow above is slow because each step re-checks work done by hand somewhere else. Three changes remove most of it: calculate commission directly from CRM data rather than an exported spreadsheet, lock each period's figures once approved so later CRM edits show up as adjustments instead of silent changes, and give each rep a statement they can check before payroll rather than after.