Compensation Plan Design · Glossary

Commission Reconciliation

What is commission reconciliation?

Commission reconciliation is the end-of-period process of verifying that the commission a system calculated matches the underlying CRM deal data it was based on, matches the finance team's accruals, and matches what payroll actually disbursed. In plain terms, it is a three-way check that reps are paid exactly what they earned and that the finance records agree with the payments. When those sources agree, the period is clean; when they diverge, reconciliation is the work of finding and fixing the gap before anyone is paid.

It is one of the least glamorous and most important jobs in commission operations — and, notably, a term no competitor glossary defines, despite it being the primary pain point in RevOps and sales-operations dispute threads. Nearly every "why is my commission wrong?" argument is, at root, a reconciliation that failed.

The three-way match

Reconciliation works because commission has to agree across three separate systems that each hold a version of the truth:

Source What it holds Must agree with
CRM deal data The deals that closed and their values What the commission was calculated on
Commission calculation What each rep is owed under the plan The CRM data and the accruals
Finance accruals The commission expense booked for the period The calculated commission
Payroll disbursement What was actually paid to reps The calculated, approved commission

When all four line up, the period reconciles. When they do not — a deal was edited after close, an accrual was an estimate, a payout was adjusted by hand — the difference is a discrepancy that has to be traced back to its source and corrected, often with a true-up.

Why commission reconciliation is hard

The difficulty is structural: commission data lives in several disconnected places, and they drift apart over a period. Deals get edited in the CRM after they were used in a calculation; attainment is recomputed once late deals land; accruals were approximations; manual adjustments get made in one system but not reflected in another. Each of those is a small, reasonable event — but together they mean the CRM, the commission calculation, the accrual, and the payroll figure rarely match on their own. Reconciliation is the work of pulling them back into agreement, and when it is done in spreadsheets across those separate systems, it is slow, manual, and easy to get wrong.

What this means?

Reconciliation is where commission trust is either earned or lost. Every "my commission is wrong" dispute is, underneath, a reconciliation that did not happen or did not catch a gap in time. When reps can see that the calculation, the underlying data, and the payout all agree, they trust their pay; when they cannot, they stop trusting the system — and start rebuilding the math themselves.

Reconciliation and shadow accounting

That loss of trust has a name and a measurable cost: shadow accounting, where reps keep their own parallel commission spreadsheets because they do not believe the official numbers. Shadow accounting is a direct symptom of weak reconciliation — if reps could see that the numbers agree, they would not need to recompute them. It is estimated to consume a meaningful slice of every rep's week, and that lost selling time, multiplied across a team, is one of the most-cited justifications for adopting commission software. In other words, reliable reconciliation does not just clean the books; it gives reps back the hours they spend checking the company's math.

Reconciliation vs true-up

These two are closely related and easy to confuse. Commission reconciliation is the broad process of checking that all the commission figures agree — calculation, CRM data, accruals, and payouts. A true-up is one of the corrections that process can produce: an adjusting entry that brings an estimate into line with the actual amount. Put simply, reconciliation is the checking, and a true-up is one kind of fix it turns up. A period can reconcile cleanly with no true-ups, or reconciliation can surface several.

How Visdum handles commission reconciliation

Reconciliation is painful precisely when commission is calculated in one place, accrued in another, and paid from a third — because every hand-off is a chance for the numbers to diverge, and someone then has to hunt the difference across systems. Visdum calculates commission directly from live CRM data, so the deal data, the calculation, and the accrual come from one source rather than three that have to be matched after the fact. Every rep's payout traces back to the specific deals behind it, discrepancies are flagged before payout rather than discovered in a dispute, and finance gets an auditable trail that ties calculation to accrual to disbursement. Reps see the same numbers finance sees — which is what removes the reason for shadow accounting in the first place, and turns reconciliation from an end-of-period scramble into something that largely holds together by design.

Take a self-guided product tour → to see automated reconciliation and audit trails in action, or read the complete commission close playbook.

Related terms

Commission True-Up · Commission Accrual · Quota Attainment · Commission Clawback · Effective Commission Rate

‍

On this page
Example

Calculate your OTE in 30 seconds

Enter your base, quota, and commission rate. Get your projected OTE plus earnings at common attainment scenarios.
Open the OTE calculator →

Frequently asked questions

What is commission reconciliation?

Commission reconciliation is the end-of-period process of verifying that the commission a system calculated matches the underlying CRM deal data, matches the finance team's accruals, and matches what payroll actually paid out. It is essentially a three-way check that reps are paid exactly what they earned and the finance records agree with payments. When those sources disagree, reconciliation is the work of finding and fixing the gap.

Why is commission reconciliation necessary?

Because commission data lives in several disconnected places — the CRM where deals close, the tool that calculates commission, the finance accruals, and payroll — and they drift apart. A deal is edited after close, an accrual was an estimate, a payout was adjusted manually. Reconciliation catches those gaps before they become underpaid reps, disputes, or misstated expense.

What causes commission disputes?

Commission disputes usually trace back to a reconciliation failure: the rep's own numbers, the system's calculation, and the actual payout do not agree, and nobody caught it before payday. Common causes include deals edited after close, CRM-to-system data mismatches, manual adjustments left untracked, and estimates that were never trued up. Reliable reconciliation removes most disputes by ensuring the numbers agree before reps ever see them.

How does reconciliation relate to shadow accounting?

Shadow accounting is when reps keep their own parallel commission spreadsheet because they do not trust the official numbers — and it is a direct symptom of weak reconciliation. When reps cannot see that the calculation, the data, and the payout agree, they rebuild the math themselves, which is estimated to consume significant time per rep each week. Strong reconciliation removes the reason shadow accounting exists.

What is the difference between reconciliation and a true-up?

A true-up is an adjusting entry that corrects an estimated commission to the actual amount; reconciliation is the broader process of checking that all commission figures — calculation, CRM data, accruals, and payouts — agree. A true-up is often one of the fixes that results from reconciliation. Put simply, reconciliation is the checking process, and a true-up is one kind of correction it can produce.

Why does commission reconciliation matter for finance and RevOps?

For finance, it protects the accuracy of reported commission expense and prevents overpayment; for RevOps, it is what keeps reps trusting their pay and cuts down disputes. Because it sits at the junction of CRM, calculation, accruals, and payroll, it is slow and error-prone to do by hand — which is why it is one of the strongest arguments for automating commission on a single system.

Related terms in Compensation Plan Design

Concepts you'll encounter alongside OTE when designing or interpreting a sales comp plan.
MBO (Management by Objectives)
In sales compensation, an MBO (Management by Objectives) is variable pay tied to specific qualitative or non-revenue goals rather than to a revenue quota — think onboarding completion, pipeline coverage, or a strategic project. It is how companies reward outcomes that matter but are not captured by a commission rate, and it is especially common for CSMs and SDRs whose impact on revenue is indirect. It is distinct from the broader management theory of the same name.
Shadow Accounting
Shadow accounting is when sales reps keep their own parallel commission spreadsheets because they do not trust the company's official numbers. It is a symptom, not a habit — reps only rebuild the math when they cannot see how their commission was calculated. The hidden cost is real: every hour a rep spends checking their own pay is an hour not selling, and across a team that adds up to a significant monthly burn.
Commission Reconciliation
Commission reconciliation is the end-of-period process of verifying that the commission a system calculated matches the CRM deal data it was based on, matches the finance team's accruals, and matches what payroll actually disbursed. When those figures agree, reps are paid correctly and the books are clean; when they diverge, the gap has to be found and fixed before payout. It is the single biggest source of commission disputes, and no competitor glossary defines it as a standalone term.
Bookings vs Collections
Commission vs Bonus
TL;DR: Commission and bonus are often used interchangeably, but they are legally and mechanically different. Commission is earnings tied directly to a closed deal — usually a percentage of its value — and in many US states earned commission is protected wages that cannot be withheld without cause. A bonus is a discretionary, often one-time payment not tied to a specific deal, which an employer can generally set, adjust, or withhold. The distinction matters most for disputes, clawbacks, and taxes.
Effective Commission Rate
The effective commission rate is the actual rate a rep earned, calculated as total commission paid divided by total revenue booked — as opposed to the stated rate written in the comp plan. Because accelerators, decelerators, draws, clawbacks, and payout floors all modify the final payout, the effective rate almost never equals the stated rate. It is the single number that tells finance what commission actually costs per dollar of revenue, and it is defined in no competitor glossary.