Build an affiliate payout reconciliation sheet
Match approved commissions with actual deposits and explain the gaps.
Keep three independent amounts
Export gross, reversed, and approved commissions by transaction or cohort. Record the deposit separately with date and currency. A $1,000 gross month with $140 in reversals has $860 approved before any fees or withholding.
Reconcile to the payment statement
If the deposit is $820, identify the $40 difference as a fee, withholding, earlier adjustment, or unresolved item. Do not deduct it from traffic revenue until you understand its basis. A payout may also cover commissions from different months.
Decide which figure belongs where
Use approved commissions for offer performance and bank deposits for cash planning. Keep an unresolved balance and check it against the next statement. Save only the identifiers and documents your reporting process actually needs.
Try a related tool
Measure earnings per tracked referral click after refunds and reversals. Use counts and commissions from the same cohort.
