Reconciliation (with example cases)

What is a Reconciliation?

A reconciliation is an adjustment made to commissions that have already been paid.

• Positive reconciliation → Results in an additional payout

• Negative reconciliation → Results in a clawback

In simple terms, a reconciliation represents the difference between what was originally paid and what should have been paid based on updated information.

When Do Reconciliations Occur?

Reconciliations are triggered by retroactive changes that affect commission calculations. Common scenarios include:

1. Deal Cancellations

When a deal is canceled after a commission has already been paid, the most immediate effect is straightforward: the commission associated with that deal is no longer valid and must be clawed back. This represents the direct impact of the cancellation.

However, in many compensation models, the consequences extend beyond a single deal. Because deals contribute to an employee’s overall target attainment, removing one can lower the total achievement for a given period. This, in turn, may shift the employee into a different commission tier. As a result, not only the canceled deal but potentially all deals within that period need to be recalculated under the new attainment level.

Centify’s Reconciliation module handles this complexity automatically. It does not only reverse the commission for the canceled deal but also recalculates all affected payouts and captures the full downstream impact as a single, coherent reconciliation.

2. Retroactive Target Changes

Targets are typically defined in advance, but real-world situations often require adjustments after the fact. For example, an employee’s target may be reduced due to parental leave, part-time arrangements, or changes in role responsibilities. If these updates are applied after commissions have already been paid, the original calculations may no longer be accurate.

In such cases, Centify recalculates past commissions using the updated target values. This recalculation can affect both the level of attainment and the resulting payout amounts. The system then determines the difference between the originally paid commissions and the corrected amounts.

This difference is recorded as a reconciliation, ensuring that compensation remains fair and aligned with the employee’s actual circumstances.

3. Deal Value Adjustments

Even after a deal has been closed, its value may change due to contract renegotiations, pricing adjustments, or scope modifications. Since commissions are often directly tied to deal value, any such change has a direct impact on the commission calculation.

When a deal value is updated, Centify automatically recalculates the corresponding commission based on the new amount. This ensures that the payout reflects the most accurate and current deal data.

The system then compares the recalculated commission with the original payout and records the difference as a reconciliation. This guarantees that any increase or decrease in deal value is properly reflected in the final compensation.

4. Variable Compensation Updates

Changes to an employee’s variable compensation - such as those resulting from promotions or adjustments to compensation plans - can sometimes be applied retroactively. If these updates are not reflected in the system at the time of payout, commissions may have been calculated using outdated parameters.

Once the correct compensation data is applied, Centify recalculates all affected commissions based on the updated structure. Depending on the nature of the change, this can lead to either higher or lower payouts.

The difference between the original and recalculated commissions is then captured as a reconciliation. This ensures that compensation remains consistent and accurate, even when structural changes are applied after the fact.

How Reconciliations Work

1. Creation

Reconciliations are created automatically whenever Centify detects a discrepancy between previously paid commissions and newly recalculated results. This typically happens after underlying data has changed - such as deal updates, target adjustments, or compensation changes - and the system reprocesses the affected payouts.

Instead of requiring manual intervention, Centify continuously evaluates whether recalculations lead to differences. Whenever such a delta is identified, it is captured as a reconciliation, ensuring that no discrepancy goes unnoticed.

2. Validation

Once a reconciliation has been generated, it enters a validation step. This ensures that adjustments are reviewed before they impact payouts, adding an important layer of control and transparency to the process.

During this stage, reconciliations can either be approved or rejected. Approval confirms that the recalculated difference is correct and should be applied, while rejection discards the reconciliation if it is deemed invalid or unnecessary. This step allows organizations to maintain oversight and ensure that only accurate adjustments are processed.

3. Application

After approval, the reconciliation is applied to payouts. How this happens depends on the status of the original payout.

If the payout has already been completed, the reconciliation is recorded as a separate correction entry. This creates a clear and traceable adjustment that reflects the difference without altering the original payout record.

If the payout is still pending, the reconciliation is incorporated directly into it. In this case, it functions as a true-up, meaning the adjustment is included before the payout is finalized. This approach avoids the need for separate corrections later on and ensures that the final payout is accurate from the start.

Why Reconciliations Matter

Reconciliations are essential for maintaining:

• Accuracy – Ensuring payouts reflect the latest data

• Transparency – Making all adjustments visible and traceable

• Fairness – Aligning compensation with actual performance and agreements

By systematically identifying and correcting discrepancies, Centify ensures that even complex, retroactive changes are handled reliably and efficiently.

Key Takeaway

Reconciliations allow you to confidently manage change in dynamic commission environments. Whether it’s a canceled deal, a revised target, or updated compensation, Centify ensures every payout is correct - no matter when the change occurs.