Intermediate

Reconciliation

Also known as: Commission Reconciliation, Payout Reconciliation

What is Reconciliation?

Reconciliation is the process of matching the conversions and commissions a partner recorded against the figures the broker reports, and resolving any gaps. It is the accounting check that the money paid matches the activity actually driven.

Key takeaways
  • Matches partner-tracked conversions against the broker's reported figures
  • Catches under-payment for the partner and over-payment or fraud for the broker
  • Do it at sub-ID level, not just the grand total
  • Most gaps trace to failed postbacks, cookie/attribution mismatches or rejected conversions
  • A tight discrepancy percentage signals healthy tracking on both sides

How it works

Reconciliation runs on a schedule, usually monthly, aligned with the payout cycle. The partner exports their own conversion data and lines it up against the broker's commission statement, comparing counts and values for the same period. The headline metric is the discrepancy percentage: the gap between the two figures divided by the partner's own count.

The critical discipline is granularity. A total-level match can look clean while one traffic source silently loses every conversion and another over-counts, the two errors cancelling out. Reconciling at the sub-ID or source level exposes those hidden failures. Where a real gap appears, both sides trace it, most often to a postback that failed for one source, a cookie window mismatch, or conversions the broker rejected for quality or fraud, and the broker credits any genuinely missed conversions.

  1. Export both datasets

    Pull the partner's tracker data and the broker's statement for the same period.

  2. Match at sub-ID level

    Compare conversion counts and values per source, not just the total.

  3. Calculate discrepancy

    Divide the count gap by the partner's own figure to get the discrepancy percentage.

  4. Trace each gap

    Investigate whether missing conversions stem from failed postbacks, attribution windows or rejections.

  5. Settle the difference

    The broker credits genuinely missed conversions and both sides log the fix.

Why it matters for partnership: Tracking is never perfect. Postbacks fail, cookies expire, and conversions get attributed differently on each side. Regular reconciliation is how a partner catches under-payment and how a broker catches over-payment or fraud.

Formula
Discrepancy % = (Broker-reported conversions − Partner-tracked conversions) ÷ Partner-tracked conversions × 100
Real World Example

An affiliate's tracker shows 52 FTDs but the broker's statement shows 47. Reconciliation traces the five missing conversions to a postback that failed for one traffic source, and the broker credits them.

Pro Tip

Reconcile monthly at the sub-ID level, not just the total. Aggregate numbers can look close while a single source silently loses every conversion.

Common Pitfalls

Only reconciling the grand total, which hides source-level tracking failures that net out by coincidence.

FAQ

What causes most reconciliation gaps?

Failed or delayed postbacks, cookie/attribution-window mismatches, and conversions rejected by the broker for quality or fraud reasons.

Sources & further reading