---
title: Commission Reconciliation Checklist | Bentega
description: Reconcile sales commission from source data to approval, payroll handoff and confirmed payment, with a worked example and practical close checklist.
image: https://www.bentega.io/hubfs/From%20sales%20data%20to%20settled%20commission.png
---

[Skip to content](https://www.bentega.io/blog/commission-reconciliation-checklist#main-content)

[![Bentega.io incentive compensation management logo](https://www.bentega.io/hubfs/Bentega%20wordmark%20navbar_1000x100.svg)](https://www.bentega.io/)

- [Product](https://www.bentega.io/product)
- Solutions

    - [By role](https://www.bentega.io/solutions)

          - [CFOs & Finance](https://www.bentega.io/solutions/cfos-finance-incentive-control)
          - [Sales & RevOps](https://www.bentega.io/solutions/sales-revops-incentive-compensation)
          - [HR & People](https://www.bentega.io/solutions/hr-people-variable-pay-governance)
          - [GTM Teams](https://www.bentega.io/solutions/gtm-leaders-incentive-compensation)

                  - [Customer Success](https://www.bentega.io/use-cases/customer-success-incentives)
- [Pricing](https://www.bentega.io/pricing)
- [Services](https://www.bentega.io/services)
- Resources

    - [Guides](https://www.bentega.io/compensation-sales-performance-guides-free-downloads-bentega)

          - [Incentive Compensation](https://www.bentega.io/incentive-compensation)
          - [Incentive Compensation Management (ICM)](https://www.bentega.io/incentive-compensation-management)
          - [Sales Compensation](https://www.bentega.io/sales-compensation)
          - [Sales Commission](https://www.bentega.io/sales-commission)
          - [Commission Structures](https://www.bentega.io/sales-commission-structure)
          - [Bonus](https://www.bentega.io/bonus)
          - [Performance Pay](https://www.bentega.io/performance-pay)
          - [SPIF](https://www.bentega.io/spif)
          - [On-Target Earnings](https://www.bentega.io/on-target-earnings)
          - [KPIs and Metrics](https://www.bentega.io/kpis-and-metrics)
          - [Motivation](https://www.bentega.io/work-motivation)
          - [Incentive Compensation Governance](https://www.bentega.io/incentive-compensation-governance)
    - [Blog](https://www.bentega.io/blog)
    - [Glossary](https://www.bentega.io/glossary)
    - Tools

          - [OTE Calculator](https://www.bentega.io/tools/ote-calculator)
          - [Sales Commission Calculator](https://www.bentega.io/sales-commission-calculator)
    - [Newsletter](https://www.bentega.io/newsletter)
- About

    - [About Bentega](https://www.bentega.io/about)
    - [Contact Us](https://www.bentega.io/contact-us-bentega)

[Log in](https://app.bentega.io/) [Book a demo →](https://www.bentega.io/demo)

 Sep 8, 2026

# Commission reconciliation: from source data to payroll settlement

![Picture of Andreas S. Loktu](https://app.hubspot.com/settings/avatar/3f41a5dd11434c453a87cb1de7df2224) [Andreas S. Loktu](https://www.bentega.io/blog/author/andreas-s-loktu)

Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.bentega.io/blog/commission-reconciliation-checklist) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.bentega.io/blog/commission-reconciliation-checklist) [X Twitter icon](https://twitter.com/intent/tweet?url=https://www.bentega.io/blog/commission-reconciliation-checklist) [envelope icon](mailto:?body=https://www.bentega.io/blog/commission-reconciliation-checklist)

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, but to show why each amount changed, which evidence supports it and who is responsible for the next decision.

Quarter-end creates a related problem before every commission amount is final. Finance still needs to explain how plan rules, attainment, approvals and unresolved exceptions connect to the estimate being carried. Our [quarter-end incentive accrual guide](https://www.bentega.io/blog/quarter-end-incentive-accrual-guide) shows how to build that bridge.

For the broader foundation, start with our [sales commission process guide](https://www.bentega.io/sales-commission). This article focuses on reconciling an individual commission cycle, including the follow-up after payroll handoff.

![From sales data to settled commission](https://www.bentega.io/hs-fs/hubfs/From%20sales%20data%20to%20settled%20commission.png?width=1100&height=577&name=From%20sales%20data%20to%20settled%20commission.png)

## 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. 

If the applicable rules changed during the period, use our [mid-quarter commission change guide](https://www.bentega.io/blog/changing-commission-plans-mid-quarter) to confirm the effective date, treatment of existing pipeline and which version governs each result before reconciling the calculation.

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. These controls sit inside a broader [incentive compensation governance framework](https://www.bentega.io/incentive-compensation-governance) that defines the rules, evidence, decision rights, payout states, and retained history behind the amount.

## 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](https://www.bentega.io/incentive-compensation-management).

## 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.

For allocation methods, cost examples and ownership rules behind disputed credit, see our [guide to split commissions and sales crediting](https://www.bentega.io/blog/split-commissions-sales-crediting).

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.

If the affected amount has already been paid, identifying the difference is only the first step. Our [guide to compensation clawbacks and recovery](https://www.bentega.io/blog/clawback-in-compensation-plans-risk-management) explains how to separate the corrected calculation from the decision about whether recovery is permitted.

For a broader diagnosis of rules, data and approval problems, read our [guide to common commission challenges](https://www.bentega.io/blog/common-sales-commission-challenges-and-how-to-fix-them).

## 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](https://www.bentega.io/product).

## 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 an accrued incentive amount mean the accounting is complete?

No. An accrued incentive amount can be recorded in the incentive compensation subledger before payment. That does not by itself determine the statutory accounting entry, recognition date, tax treatment, or other accounting treatment. Those decisions remain part of the organisation's Finance and accounting 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.

[Sales Commission](https://www.bentega.io/blog/tag/sales-commission)

## Related posts

[![Tiered Commission structure example explained](https://www.bentega.io/hs-fs/hubfs/Tiered%20commission%20example.png?height=200&name=Tiered%20commission%20example.png)](https://www.bentega.io/blog/tiered-commission-structure-example-how-to-scale-incentives)

## [Tiered commission structure example: marginal vs. retroactive rates](https://www.bentega.io/blog/tiered-commission-structure-example-how-to-scale-incentives)

[![Commission-Based Pay](https://www.bentega.io/hs-fs/hubfs/Commission%20Payouts.png?height=200&name=Commission%20Payouts.png)](https://www.bentega.io/blog/the-impact-of-commission-based-pay-on-sales-performance)

## [The Impact of Commission-Based Pay on Sales Performance](https://www.bentega.io/blog/the-impact-of-commission-based-pay-on-sales-performance)

[![sales KPIs and incentives](https://www.bentega.io/hs-fs/hubfs/Bloggbanner%20-%20Driving%20sales%20success%20(Bloggbanner).png?height=200&name=Bloggbanner%20-%20Driving%20sales%20success%20(Bloggbanner).png)](https://www.bentega.io/blog/driving-sales-success-harnessing-sales-kpis-and-incentives-for-optimal-performance)

## [Sales KPIs: which metrics should affect compensation?](https://www.bentega.io/blog/driving-sales-success-harnessing-sales-kpis-and-incentives-for-optimal-performance)

---

[Follow us on LinkedIn](https://www.linkedin.com/company/bentega) [Follow us on Facebook](https://www.facebook.com/profile.php?id=61564040605445) [Follow us on Instagram](https://www.instagram.com/bentegasoftware/) [Follow us on YouTube](https://www.youtube.com/channel/UCSoZx0FpEf_zqKHdIzm1ftA)

---

- [Product](https://www.bentega.io/product)
- Solutions 
    - [By role](https://www.bentega.io/solutions) 
          - [CFOs & Finance](https://www.bentega.io/solutions/cfos-finance-incentive-control)
          - [Sales & RevOps](https://www.bentega.io/solutions/sales-revops-incentive-compensation)
          - [HR & People](https://www.bentega.io/solutions/hr-people-variable-pay-governance)
          - [GTM Teams](https://www.bentega.io/solutions/gtm-leaders-incentive-compensation)
- [Pricing](https://www.bentega.io/pricing)
- [Services](https://www.bentega.io/services)
- Resources 
    - [Guides](https://www.bentega.io/compensation-sales-performance-guides-free-downloads-bentega) 
          - [Incentive Compensation](https://www.bentega.io/incentive-compensation)
          - [Incentive Compensation Management (ICM)](https://www.bentega.io/incentive-compensation-management)
          - [Sales Compensation](https://www.bentega.io/sales-compensation)
          - [Sales Commission](https://www.bentega.io/sales-commission)
          - [Commission Structures](https://www.bentega.io/sales-commission-structure)
          - [Bonus](https://www.bentega.io/bonus)
          - [Performance Pay](https://www.bentega.io/performance-pay)
          - [SPIF](https://www.bentega.io/spif)
          - [On-Target Earnings](https://www.bentega.io/on-target-earnings)
          - [KPIs and Metrics](https://www.bentega.io/kpis-and-metrics)
          - [Motivation](https://www.bentega.io/work-motivation)
          - [Incentive Compensation Governance](https://www.bentega.io/incentive-compensation-governance)
    - [Blog](https://www.bentega.io/blog)
    - [Glossary](https://www.bentega.io/glossary)
    - Tools 
          - [OTE Calculator](https://www.bentega.io/tools/ote-calculator)
          - [Sales Commission Calculator](https://www.bentega.io/sales-commission-calculator)
    - [Newsletter](https://www.bentega.io/newsletter)
- About 
    - [About Bentega](https://www.bentega.io/about)
    - [Contact Us](https://www.bentega.io/contact-us-bentega)
- [Log in](https://app.bentega.io)

[![Incentive Compensation Software by Bentega](https://www.bentega.io/hubfs/bentega%20logo%20footer.svg "Incentive Compensation Software by Bentega")](https://www.bentega.io/)

© 2026 Bentega | [Privacy Policy](https://www.bentega.io/privacy-policy) | [Cookie Policy](https://www.bentega.io/cookie-policy)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Andreas S. Loktu",
    "url" : "https://www.bentega.io/blog/author/andreas-s-loktu"
  },
  "dateModified" : "2026-10-19T10:55:05.730Z",
  "datePublished" : "2026-09-08T08:44:44.000Z",
  "headline" : "Commission Reconciliation Checklist | Bentega",
  "image" : [ "https://www.bentega.io/hubfs/From%20sales%20data%20to%20settled%20commission.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://www.bentega.io/blog/commission-reconciliation-checklist",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.bentega.io/hubfs/Bentega%20ICM%20platform%20logo.svg"
    },
    "name" : "Bentega"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.bentega.io/#organization",
  "@type" : "Organization",
  "areaServed" : "Global",
  "description" : "Bentega provides incentive compensation management software for commissions, bonuses, SPIFs, OTE-based payouts, KPI incentives, and broader variable pay.",
  "foundingLocation" : {
    "@type" : "Place",
    "name" : "Norway"
  },
  "knowsAbout" : [ "Incentive compensation management", "Sales commissions", "Bonus plans", "SPIF campaigns", "On-target earnings", "KPI-based incentives", "Variable pay governance" ],
  "legalName" : "Bentega AS",
  "logo" : {
    "@type" : "ImageObject",
    "url" : "https://www.bentega.io/hubfs/bentega%20logo%20footer.svg"
  },
  "name" : "Bentega",
  "sameAs" : [ "https://www.linkedin.com/company/bentega", "https://www.facebook.com/profile.php?id=61564040605445", "https://x.com/BentegaSoftware", "https://www.instagram.com/bentegasoftware/", "https://www.youtube.com/channel/UCSoZx0FpEf_zqKHdIzm1ftA" ],
  "url" : "https://www.bentega.io/"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.bentega.io/#website",
  "@type" : "WebSite",
  "inLanguage" : "en",
  "name" : "Bentega",
  "publisher" : {
    "@id" : "https://www.bentega.io/#organization"
  },
  "url" : "https://www.bentega.io/"
}
```