Multi-currency Advertising Reporting: How to Compare Accounts Billed in Different Currencies
How agencies can report ad accounts billed in USD, EUR, GBP and other currencies side by side — choosing a reporting currency and exchange rates, and avoiding common mistakes.
Keep every account's original currency, convert spend and conversion value into one reporting currency using a documented exchange-rate method, and calculate totals, CPA and ROAS from the converted figures. Always label converted numbers so they can be traced back to the source amounts.
Why multi-currency reporting is tricky
Agencies working across markets often manage ad accounts billed in different currencies — a US account in USD, a European account in EUR, a UK account in GBP. Adding those numbers together without conversion produces a total that means nothing. Converting carelessly produces totals that cannot be reconciled with invoices.
Step 1: Choose a reporting currency
Pick the currency the audience thinks in — usually the client's or the agency's home currency. Use one reporting currency per report; mixing them defeats the purpose.
Step 2: Choose an exchange-rate method
| Method | How it works | Good for |
|---|---|---|
| Daily rate | Convert each day's spend at that day's rate | Accurate trend and performance reporting |
| Monthly average | Convert the month at an average rate | Simple monthly summaries |
| Fixed (budget) rate | Use one agreed rate for a period | Comparing against budgets and plans |
Whichever you choose, document it and apply it consistently. Changing methods between months creates differences that look like performance changes but are not.
Step 3: Convert both sides of each ratio
ROAS divides conversion value by spend. If spend is converted but value is not — or they use different rates — the ratio is distorted. Convert spend and conversion value with the same method before calculating ROAS. CPA only needs spend converted, because conversions are counts.
Step 4: Aggregate from converted totals
Portfolio figures should be calculated from summed, converted values:
Portfolio ROAS = Σ converted value ÷ Σ converted spend
Averaging each account's ROAS ignores account size and gives the wrong answer.
Example
Hypothetical figures, converted at illustrative rates:
| Account | Original spend | Rate to USD | Converted spend (USD) |
|---|---|---|---|
| Client — US | USD 41,200 | 1.00 | $41,200 |
| Client — EU | EUR 22,600 | 1.08 | $24,408 |
| Client — UK | GBP 18,900 | 1.26 | $23,814 |
| Total | — | — | $89,422 |
Common mistakes to avoid
- Summing amounts in different currencies without converting.
- Hiding the original currency, so converted figures cannot be checked.
- Using different rates for spend and value in the same ROAS.
- Reconciling invoices against converted amounts instead of billing-currency amounts. See our reconciliation guide.
How AdNumora handles currencies
AdNumora keeps each account's original billing currency alongside amounts converted into a reporting currency you choose. Converted figures are clearly labeled, portfolio totals are summed from converted values, and CPA and ROAS are calculated consistently — see ROAS vs CPA.