Affiliate payout reconciliation for finance teams

For a finance team, affiliate payouts are just another flow of money that has to tie out — but it's a flow with FX, per-transfer fees, refund clawbacks, and multiple rails layered on top. Done reactively, reconciliation becomes a quarter-end forensic exercise. Done each cycle against a clean approval trail, it's a quick three-way match. This post lays out the playbook.

What does affiliate payout reconciliation involve?

Reconciliation involves matching commissions earned to payouts approved to amounts actually settled by the payment gateway, and explaining every difference between them with fees, FX, and timing. When those three layers agree — adjusted for known fees and conversion — the cycle is reconciled.

What's the three-way match?

The three-way match is the core of payout reconciliation. Each layer should explain the next:

1. Commissions earned: what your campaign rules generated from attributed, cleared conversions.
2. Payouts approved: the subset of those commissions that cleared the window, met the threshold, and were approved into a batch.
3. Amounts settled: what the gateway's settlement report says actually left your account, including fees and FX.

The gaps between these layers are expected and explainable: commissions held back below threshold or still in their clearing window account for the gap between earned and approved; fees and FX account for the gap between approved and settled.

How do I handle fees and FX in reconciliation?

Treat fees and FX as explicit, named differences rather than rolling them into the payout total. For each payout run, record the gross approved amount, the fees deducted by each rail, the FX rate applied to any converted payout, and the net that actually left your account. This keeps your fee spend and FX gain or loss visible as their own lines instead of hiding inside a single gross number.

• Record per-rail fees separately so you can see where cost concentrates.
• Capture the actual settlement FX rate, and record the difference from your estimate as FX gain or loss.
• Tie clawbacks from refunded conversions back to the original commission so reversals are traceable.

What about failed and retried payouts?

Failed payouts are the classic source of a stubborn reconciliation gap. A payout was approved but the transfer bounced — wrong bank details, an invalid PayPal email, an underfunded balance — so the money never moved. Track each payout's status so a failed transfer shows as approved-but-not-settled rather than vanishing, and reconcile it again once it's corrected and retried.

The difference between a five-minute reconciliation and a five-hour one is whether you can see the full chain — commission, approval, dispatch, settlement, retry — in one place. Reconciliation is easy when nothing is hidden.

How does Afflio make reconciliation easier?

Afflio drives commissions, approvals, and payouts from the same data and across multiple rails behind one flow, which is what turns reconciliation into a check instead of a reconstruction. Because each payout traces back to the approved commission and forward to its dispatch status, finance can match earned to approved to settled without stitching together exports from several systems — and FX-aware statements give the per-payout detail needed to explain conversion differences.