Payout Reconciliation and Dispute Resolution
Why Reconciliation Cannot Be Skipped
Even well-designed programs generate payout errors. Data discrepancies between your tracking system, your CRM, and your payment processor are common. Duplicate conversions slip through. Commission deal changes are applied to the wrong period. An affiliate is paid in the wrong currency. Reconciliation is the process of catching these errors before they compound into larger financial or relationship problems.
The Reconciliation Workflow
- Step 1 -- Pull the pending payout report: list of all affiliates with approved commissions in the current payout period
- Step 2 -- Cross-check against your tracking data: confirm conversion counts and revenue figures match the source system
- Step 3 -- Verify deal structures: confirm each affiliate is on the correct deal version (watch for deals updated mid-period)
- Step 4 -- Check for manual adjustments: confirm any credits, deductions, or overrides are documented and approved
- Step 5 -- Validate totals against your accounting system: total payout liability should match your accrual ledger
- Step 6 -- Run the payout: once reconciled, trigger the payout run and retain the reconciliation record
| Common Payout Error | Likely Cause | How to Investigate |
|---|---|---|
| Affiliate paid more than expected | Deal updated to higher rate mid-period, or duplicate conversions | Check deal change log and conversion timestamps |
| Affiliate paid less than expected | Qualification rules rejected conversions, hold not released | Review qualification log for each rejected conversion |
| Wrong currency delivered | Currency mapping error or affiliate banking detail change | Check affiliate payment profile and deal currency setting |
| Payout sent to wrong account | Affiliate updated payment details without verification | Audit payment detail change log with timestamps |
| Double payment | Payout run executed twice for same period | Check payout run history and payment gateway confirmations |
Maintaining a Clean Audit Trail
Every payout should be traceable from the originating conversion event through to the payment confirmation. This means logging: the conversion event and its data, which qualification rules ran and what the outcome was, which deal structure was applied, who approved the payout, and the payment reference from the gateway. This trail is your operational record and your legal protection if a dispute escalates.
A clean audit trail also helps when affiliates raise questions about their earnings. Instead of a back-and-forth email thread, you can send a structured report showing every conversion, its status, and the calculated commission. Transparency reduces disputes before they start.
Resolving Payout Disputes
Disputes happen in every program. An affiliate believes they sent 40 conversions but you only show 32. A player they referred was flagged by your fraud system and their commission was rejected. Your job is to resolve the dispute with evidence, not opinion. Have a written dispute policy that states how affiliates should raise a dispute, what evidence you will review, the response timeframe, and the escalation path.
- Step 1: Affiliate submits dispute with specific reference (date, conversion ID, or amount in question)
- Step 2: Affiliate manager pulls the tracking log and qualification record for the disputed conversions
- Step 3: Review for discrepancies -- compare affiliate-side data (if available) with your platform data
- Step 4: Issue a written response with the evidence reviewed and the outcome (approved, partially approved, rejected)
- Step 5: If approved, issue a correction in the next payout cycle or as a manual adjustment
- Step 6: Document the dispute and outcome in your affiliate record for future reference
Never ignore a dispute even if you are confident the affiliate is wrong. An unacknowledged dispute becomes a relationship problem. Respond within 5 business days with the data you reviewed, even if the final outcome is a rejection.
Key Takeaways
- Run a six-step reconciliation workflow before every payout run to catch errors before they compound
- Common errors include duplicate conversions, wrong deal version applied, and currency mapping failures
- Maintain an audit trail from conversion event to payment confirmation for every payout processed
- A written dispute policy with defined timelines reduces conflict and protects both parties
- Respond to disputes within 5 business days with documented evidence -- silence damages trust more than rejection
Explore Further
Key terms and tools related to this lesson. Deepen your understanding and see how Track360 supports these concepts.
Publisher
A publisher is an individual or company that promotes an advertiser's products or services through an affiliate program in exchange for commissions on conversions they drive.
CPA (Cost Per Acquisition)
CPA is a commission model where an affiliate earns a fixed payment for each qualifying action, such as a deposit, registration, or purchase, that a referred user completes.
Hybrid Commission
Hybrid commission combines two payout models, most commonly CPA and RevShare, in a single affiliate deal so operators can reward both conversion volume and long-term customer value.
Negative Carryover
Negative carryover is a policy where a negative revenue balance from one period is rolled into the next period and offsets future affiliate earnings before new commissions are paid out.