A correct commission formula does not prove that a payout file is ready for payroll. Commission reconciliation connects source data, calculated commission, approved amounts, payroll handoff and confirmed payment, and explains the differences between them.
The objective is not to make every total identical. It is to show why each amount changed, which evidence supports it and who is responsible for the next decision.
For the broader foundation, start with our sales commission process guide. This article focuses on reconciling an individual commission cycle, including the follow-up after payroll handoff.
What should commission reconciliation cover?
Start with two separate questions:
- Is the calculated commission correct? Check eligible transactions, participants, rules and adjustments.
- What happened to the approved amount? Check what was due, what was sent downstream, what was confirmed paid and what remains outstanding.
An approved balance can differ legitimately from the current payroll handoff because some amounts are scheduled for another cycle. It can also differ because an item was missed. Reconciliation should establish which explanation applies.
Keep these stages distinct:
| Stage | What it establishes | What it does not establish |
|---|---|---|
| Calculated | The selected rules and inputs produce an amount. | The inputs are correct or the result has been approved. |
| Approved | The responsible approver has accepted the result. | The whole amount is due in the current cycle or has been paid. |
| Handed to payroll | Specified amounts have been sent for downstream processing. | Payroll accepted every item or completed payment. |
| Confirmed settled | Downstream evidence confirms payment of the relevant commission amounts. | The entire commission balance has been cleared. |
These are operational distinctions. They do not determine financial-statement recognition, tax treatment or when compensation is legally due.
Establish the period, source data and owners
Before comparing totals, record the measurement period, source-data cutoff and intended payment cycle. They are not necessarily the same dates.
Also identify the applicable rules and effective dates, eligible participants, currency, calculation basis and treatment of late records. Preserve the source extract and calculation version being reviewed so later changes do not silently alter the comparison.
Assign responsibilities explicitly. The following is an example, not a required organization chart:
| Responsibility | Example owner | Evidence to retain |
|---|---|---|
| Source completeness and transaction identity | RevOps or Sales Operations | Source extract, record IDs and explained differences |
| Eligibility, credit allocation and rule interpretation | Plan owner and relevant manager | Applicable rules, dates and documented decisions |
| Calculation review and adjustments | Commission operations and designated reviewer | Calculation tests, correction reasons and review outcome |
| Approval and amounts due | Authorized approver and Finance | Approved amount, payment schedule and exceptions |
| Payroll acceptance and settlement confirmation | Payroll liaison or Finance | Accepted batch details, rejections and payment confirmation |
A small team may combine responsibilities. The important control is that a decision has a named owner and appropriate review, rather than depending on whoever last edited the spreadsheet.
Reconcile source data to calculated commission
Match transactions by stable identifiers, not just customer names or total revenue. Check for missing records, duplicates, incorrect dates, ineligible participants and transactions assigned to the wrong person.
Then verify the commissionable basis: the value the plan actually uses. Contract value, invoiced revenue and collected cash are different measures. Discounts, excluded services, cancellations, currency conversion and shared sales credit can also affect that basis.
For a simple percentage plan:
Commission = eligible sales basis × commission rate
For other plans, test the relevant thresholds, tiers, accelerators, caps, splits and rounding rules. Include values immediately below, at and above a boundary. State whether a higher rate applies only to the next band or retroactively to earlier sales.
If a source error is found before approval, correct it and retain the original value, revised value and reason. Do not conceal a missing transaction or duplicate by editing only the final payout total.
A reconciled calculation still requires approval. The reviewer must accept the underlying records and decisions, not just the arithmetic.
Reconcile approval to payroll handoff and payment
Build the amount to account for from separately identifiable entries, then deduct confirmed settlements:
Approved amount to account for = opening outstanding balance + new approvals + approved additions − approved reductions
Closing recorded outstanding balance = approved amount to account for − confirmed settlements
Show which portion is due in the current cycle and which portion belongs to another documented payment date. Check that the handoff contains the correct employee identifiers, gross commission amounts, currency, period and batch reference. Record rejected or corrected payroll items separately.
Compare the handoff with the gross commission component in payroll records, not the employee's total net bank receipt. Base salary, deductions and other payroll items can make those totals different.
Finally, obtain downstream settlement confirmation and match it to the relevant entries. Sending data to payroll is not evidence of payment. Do not subtract the handoff and the subsequent payment from the balance as two separate deductions.
If confirmation is missing, investigate with the payment owner before sending the same item again. An unconfirmed payment is not proof that payment failed; a duplicate instruction can create a second payment.
Worked example: reconcile a monthly commission cycle
The following is an illustrative example, not customer data or a recommended commission rate.
Assume a September 2026 monthly measurement period, USD throughout and a 5% rate on eligible sales. The sales basis excludes indirect taxes and already reflects the plan's agreed discounts and exclusions. There are no tiers, caps, splits or currency conversions.
All source corrections occur before approval. Amounts are gross employee commission before deductions; base salary, employer charges, pension and holiday-related amounts are outside this example. Every calculation produces whole dollars.
Correct the sales basis and commission
The initial file contains $800,000 of eligible sales. Review identifies a duplicated $24,000 transaction and a missing $16,000 transaction.
| Calculation stage | Eligible sales | Commission at 5% |
|---|---|---|
| Initial calculation | $800,000 | $40,000 |
| Remove duplicate transaction | −$24,000 | −$1,200 |
| Add missing transaction | +$16,000 | +$800 |
| Corrected total | $792,000 | $39,600 |
The check is:
($800,000 − $24,000 + $16,000) × 5% = $39,600
The designated reviewer then approves the corrected $39,600. This is current-period approved commission, not the entire amount awaiting payment.
Build the approved balance
There is also an $8,000 opening approved outstanding balance and a separately approved $400 correction relating to an earlier period. The $400 is not already included in either the opening balance or the current calculation.
| Balance component | Amount |
|---|---|
| Opening approved outstanding balance | $8,000 |
| Current-period approved commission | +$39,600 |
| Separately approved prior-period addition | +$400 |
| Approved amount awaiting settlement | $48,000 |
$8,000 + $39,600 + $400 = $48,000
Assume the agreed payment schedule makes $45,000 due in the current payroll cycle and $3,000 due in the next cycle. This is an example assumption, not permission to defer compensation that is already due.
The $45,000 current amount is handed to payroll. At the reconciliation cutoff, downstream evidence confirms settlement of $42,000 from that handoff.
Explain what remains
The following table classifies the same $48,000 after that confirmation. Its rows are mutually exclusive; they are not additional amounts to add to the earlier balance table.
| Status at the reconciliation cutoff | Amount |
|---|---|
| Confirmed settled from the current handoff | $42,000 |
| Current handoff: settlement not yet confirmed | $3,000 |
| Scheduled for the next cycle; not handed off | $3,000 |
| Total accounted for | $48,000 |
Recorded outstanding balance = $48,000 − $42,000 = $6,000
That $6,000 needs two different actions: confirm the outcome of the $3,000 already handed off, and retain the other $3,000 for its scheduled cycle. Do not describe both amounts as overdue or assume both have failed to pay.
The $45,000 handoff is a processing stage within the $48,000 balance. Subtracting it as well as the $42,000 settlement would count the same obligations twice.
For how reconciliation fits alongside plan rules, reviews and employee visibility, see our incentive compensation management guide.
Resolve exceptions without hiding the original result
Different discrepancies need different decisions:
| Exception | What to check first | Record the outcome |
|---|---|---|
| Missing or duplicated deal | Transaction ID, eligibility and source cutoff | Corrected basis, amount and reason |
| Disputed sales credit | Applicable allocation rule and ownership dates | Approved allocation and decision owner |
| Correction after approval | Original approved entry and supporting evidence | Separate adjustment, approval and affected cycle |
| Payroll rejects an entry | Employee ID, currency, amount and batch requirements | Rejection reason and controlled replacement |
| Payment confirmation is missing | Accepted batch and downstream payment status | Confirmed result or named follow-up owner |
Give each exception a reference, amount, reason, evidence, owner and next action. Preserve the relationship to the original transaction or approved entry.
Documenting an error does not make it safe to release. Resolve or explicitly escalate material discrepancies before treating affected entries as ready, while following the applicable payment obligations. Do not invent a blanket withholding rule for disputed commission.
For a broader diagnosis of rules, data and approval problems, read our guide to common commission challenges.
Reusable commission reconciliation checklist
Use this at each close, recording an owner and evidence for each completed check:
- Scope: Measurement period, cutoff, payment cycle, currency, participants and applicable rules are identified.
- Source data: Missing records, duplicates, exclusions and credit allocations are reconciled to transaction-level evidence.
- Calculation: Rates, boundaries, rounding and relevant plan conditions have been tested.
- Approval: Required reviews are complete; adjustments retain their reasons and approval records.
- Balance: Opening amounts, new approvals and separate additions or reductions reconcile without double counting.
- Handoff: Due amounts match the approved instructions; employee details, batch references and rejected entries are checked.
- Settlement: Confirmed payments are matched to the gross commission entries, independently of file transmission.
- Follow-up: Remaining balances are classified by cause and timing, with owners and actions for unresolved items.
A reconciliation can account for an amount scheduled for a later cycle without pretending it has been paid. Conversely, an unexplained difference is not resolved merely because the spreadsheet totals match.
Where software helps, and what remains outside it
A controlled spreadsheet can be sufficient for a simple plan with limited exceptions, a reliable source and clear review ownership. Software becomes more useful when multiple rules, participants, adjustments and reviewers make the history difficult to maintain and explain.
Bentega supports commission calculations, review and customer-defined approvals, adjustment history, role-based visibility and payout-status tracking within a broader incentive compensation workflow.
See how Bentega supports incentive compensation management.
Frequently asked questions
How often should sales commission be reconciled?
Reconcile each payout cycle before handoff, then follow up when settlement evidence becomes available. If sales are measured quarterly but payments occur monthly, document how the two periods connect. Retain a clear cutoff for each comparison.
Why can approved commission differ from the amount paid?
An approved balance can contain amounts due in different cycles, separately approved corrections or payments awaiting confirmation. A missed or rejected item can also cause a difference. Separate the amounts by cause instead of assuming every difference is an error or a legitimate delay.
Does “accrued, not paid” mean the accounting is complete?
Not by itself. An operational status can identify an approved amount recorded as outstanding. It does not establish the correct accounting entry, recognition date or tax treatment; those decisions belong to the relevant Finance and payroll processes.
How should a correction after approval be handled?
Preserve the original approved result and document the correction separately, with evidence, reason, amount, reviewer and affected cycle. Follow the applicable approval process rather than silently replacing the historical number.
Does sending a commission file to payroll mean it has been paid?
No. Transmission, acceptance and payment are separate events. Confirm the downstream outcome before marking entries settled, and investigate missing confirmation before sending a replacement instruction.