How do you reconcile affiliate payouts in multiple currencies?
Short answer: Record the original customer transaction currency, the merchant's settlement or balance currency, and the affiliate's payable currency as separate fields. Apply a documented FX rate source and timestamp, record conversion and payout fees explicitly, and reconcile every approved commission to its source transaction and final payout. Do not sum amounts in different currencies as if they were interchangeable.
This becomes especially important for SaaS programs with international partners, annual subscriptions, refunds and merchant-of-record billing. A customer may pay in euros, the merchant may settle in US dollars, and the partner may withdraw in another currency. Each conversion can introduce timing differences, fees and rounding. For vendor-level payout options, see our automated affiliate payouts guide.
Separate three currencies in your data model
| Currency field | What it represents | Why it matters |
|---|---|---|
| Transaction currency | Amount paid or refunded by the customer | Supports customer invoice and eligible revenue calculation |
| Merchant balance currency | Currency used by the processor or merchant balance | Supports settlement, processor fee and payout reconciliation |
| Affiliate payable currency | Currency in which partner liability is defined | Supports partner statements and payout obligations |
| Affiliate settlement currency | Currency actually received after payout conversion | Supports partner payment confirmation and fee transparency |
Sometimes two or more of these currencies are the same. Still store their role explicitly. Otherwise a future currency change or processor migration can make historical commission calculations impossible to reproduce.
Write the FX and fee policy before calculating commissions
The affiliate agreement should state the commissionable base, when the exchange rate is fixed, which party bears payout conversion fees, whether commissions are rounded per transaction or per payout batch, and how refunds affect already paid rewards. Common choices include fixing the affiliate liability in transaction currency at conversion time or fixing it in a program currency when the commission is approved. Both require consistent documentation.
Do not choose an exchange rate retrospectively because it gives a more convenient answer. Save the provider rate or your agreed independent reference, the rate timestamp, currency pair and conversion direction. For currencies with different minor-unit rules, use integer minor units or decimal arithmetic rather than binary floating-point for the accounting ledger.
What Paddle's payout reconciliation report actually reconciles
Paddle's payout reconciliation documentationbalance_movement_in_balance_currency to reconcile the remittance amount. That is different from summing customer-facing transaction currency amounts.
The report can include sales, refunds, credits, chargebacks and fees. Paddle's May 27, 2026 update added fields and rows including rebates and SWIFT fees, improving visibility into remittance movements. Those processor report movements are not automatically affiliate commissions; you still need your program's separate payable ledger.
Why merchant payout and affiliate commission totals differ
Merchant settlement reflects processor and merchant-of-record deductions, taxes, timing and FX. Affiliate commission reflects the contract's eligible revenue definition and payout status. If the contract excludes taxes but includes revenue before processor fees, the affiliate base will not equal the merchant's net remittance. A difference is not automatically an error; it needs a documented bridge.
Worked example with currency conversion and fees
Assume a customer pays EUR 100 for an eligible subscription and the program awards 20% of eligible revenue. The affiliate earns EUR 20 under the stated policy. Suppose the program converts this liability at an illustrative rate of 1 EUR = 1.10 USD. The payable balance becomes USD 22.00 before payout fees. If an explicitly agreed USD 1.00 payout fee is charged to the affiliate, the net partner settlement would be USD 21.00.
This example is arithmetic only, not a live FX quote or a statement about Paddle's or any payout provider's fees. A different policy might define commissions in USD from the outset, or the provider might handle conversion at payout time. The ledger should show each step rather than collapsing everything into one amount.
What if the customer later receives a partial refund?
Assume an approved EUR 25 refund relates entirely to the eligible subscription. Under proportional reversal, the original EUR 20 commission decreases by EUR 5. If the affiliate liability was fixed in USD at the original conversion rate, the correcting entry would be USD 5.50 under that policy. If your policy instead uses the refund-date rate, record the resulting FX difference separately. Never silently mix methods within a reporting period.
Build an immutable reconciliation ledger
At minimum, preserve the program ID, affiliate ID, source transaction ID, adjustment ID where applicable, commission ID, original amount and currency, eligible base, rate source, rate timestamp, converted amount, fee amount, payout batch ID and payment reference. Every adjustment should point back to the original entry.
Paddle's adjustment.created documentationPaddle refund reconciliation guide
Monthly multi-currency reconciliation workflow
- Freeze the period's eligible transaction and adjustment records by stable IDs.
- Validate commission rule versions and exclude unapproved or duplicate entries.
- Calculate the commission in the agreed base currency, preserving original minor units.
- Convert using the documented FX policy and save the exact rate metadata.
- Group approved payable balances by affiliate and payout currency.
- Apply disclosed fees, minimum thresholds and outstanding negative adjustments.
- Generate payout batches with unique IDs and immutable remittance records.
- Reconcile the processor's merchant balance movements to its remittance separately.
- Reconcile affiliate payout confirmations to the affiliate liability ledger.
- Investigate differences as FX, rounding, timing, fees, refunds or missing records.
Common errors that create reconciliation gaps
Summing mixed currency amounts
EUR 100 plus USD 100 is not a meaningful total without conversion. Group by currency first, then report translated totals with rate assumptions disclosed.
Using the wrong conversion date
A rate at purchase may differ from a rate at payout. Decide which date governs commission liability and separately record realized FX differences where relevant.
Reversing a refund twice
Refund creation, approval and settlement can produce multiple events about one adjustment. Use a stable adjustment ID and state transitions to create exactly the intended correcting ledger entry.
Ignoring payout failures
A payout request is not the same as a confirmed transfer. Keep pending, failed and settled batches separate and verify provider status before retrying.
Finance and integration acceptance checklist
- Test two transaction currencies settling into one merchant balance currency.
- Test a partner payout in a third currency and record the conversion rate.
- Test currencies with different decimal precision and rounding rules.
- Reconcile a refund approved after the original payout period.
- Check chargeback fees and merchant settlement fees without treating them as automatic affiliate deductions.
- Replay the same adjustment event and verify one correction.
- Compare Paddle report balance movements with remittance advice.
- Compare affiliate ledger balances with actual payout confirmations.
Frequently asked questions
Should commissions use the customer's currency or the merchant's currency?
Either can work if the affiliate agreement specifies it. Keep both original and converted amounts to support reconciliation.
Can Paddle's payout reconciliation report replace an affiliate ledger?
No. It reconciles merchant settlement movements. Affiliate liability and commission eligibility require separate program records.
Is an FX difference necessarily an error?
No. Timing and policy may create legitimate differences. They should be classified and documented, not hidden.
Sources and editorial disclosure
- Paddle: payout reconciliation report
- Paddle: May 2026 reconciliation report update
- Paddle: adjustment events
Official documentation reviewed 31 October 2026. Currency rates, fees and numerical examples are hypothetical and do not represent live pricing. This is editorial operational guidance, not financial or tax advice or a hands-on vendor test.