Affiliate Reporting: Reconcile Mixed Currencies Before Summing Revenue

A spreadsheet can add a column of numbers even when the amounts represent different currencies. The resulting total may look tidy while answering no useful business question. For performance marketing media buying across global offers, a revenue comparison needs an explicit currency basis before it can support a campaign decision.

This proposed reporting control concerns analytical consistency. It is not an accounting policy, a live exchange-rate source or a forecast of what a network will pay.

Preserve the original amount and currency

Keep each source amount alongside its currency code, source system, transaction or reporting date and approval status. A currency symbol alone may be ambiguous. Do not infer the currency from the audience's country, the merchant's domain or the analyst's spreadsheet settings.

Before combining exports, determine whether each amount is an order value, a provisional commission, an approved commission or a settled receipt. Converting these fields into one currency does not make them equivalent metrics. Use matching definitions and periods for the comparison.

Choose and document a reporting convention

If the analysis requires a single reporting currency, document the conversion source, rate date, direction and treatment of rounding. The chosen convention should fit the question and be applied consistently. Preserve the original amounts so another analyst can reproduce the calculation or apply a different convention without reconstructing the source data.

• Original amount and currency code.
• Reporting currency and conversion rate.
• Rate source and effective date.
• Converted amount and rounding rule.
• Whether the amount is provisional, approved or settled.

Rows without a confirmed currency or applicable rate should remain unresolved and visible. Excluding them from a converted subtotal may be necessary, but the report must disclose the excluded row count and source amounts grouped by currency. An incomplete subtotal must not be presented as the complete campaign total.

Use a small arithmetic check

Consider an entirely hypothetical report with USD 100 and EUR 100 of approved commissions. Assume an illustrative rate of USD 1.10 per EUR, used only for this example. The converted total is USD 100 + USD 110 = USD 210. Adding the original numbers and labeling the result USD 200 would discard the currency distinction.

Do not assume that an export always needs another conversion. A platform may already provide an amount in a selected reporting currency. Confirm the field definition before applying a rate, because converting an already converted amount can introduce another error.

Keep settlement reconciliation separate

The analytical total is not proof of cash received. Settlement may reflect a different conversion basis, adjustments or fees. Reconcile the actual statement and receipt separately, using their documented definitions. Likewise, comparing converted commission with advertising spend requires a consistent reporting basis and clear cost coverage before interpreting margin.

BlueFriday's media buyer information provides broader partnership context. For the daily report, the useful deliverable is a reproducible total with visible assumptions, unresolved rows and a clear distinction between approved revenue and settled cash.