How to Reconcile Ad Spend Across Currencies (Step by Step)

To reconcile ad spend across currencies, you need exactly two things: one conversion rule that everyone uses, and a closed period that never silently re-prices itself. Get those right and your blended ROAS will finally match the figure finance reads from the bank. Get either wrong and the two numbers drift apart every time someone reopens the report. This is the step-by-step method, designed to keep a human in control of every budget decision.

Step 1 — Choose the Day-of-Transaction Rate (and Commit to It)

Before any spreadsheet, decide your rule. The candidates are today's spot rate, the month's average, the invoice-post rate, and the day-of-transaction rate. Only the last one freezes history: each day's spend is converted at the exchange rate on the day it actually happened, exactly as your accountant books a foreign transaction.

Why this matters so much: any rule that uses today's rate re-prices the past every time you reload. A closed month stops being closed. The day-of-transaction rate is the single decision that makes everything downstream reconcilable, so write it into your reporting playbook and make it non-negotiable.

Step 2 — Normalize Every Account Into One Reporting Currency

Now collect spend from every account and convert it, day by day, into your single reporting currency at the day-of-transaction rate. Done by hand this is brutal: a daily FX lookup per account per platform, multiplied across a portfolio. It is exactly the repetitive work that gets skipped under deadline, which is why most teams quietly fall back to a single spot rate and inherit the drift.

This is the part worth automating. Wevion pulls every connected platform's spend and reported results into one screen, normalized to a single reporting currency and converted at the day-of-transaction rate, so the normalized figure is something you read rather than rebuild. Data syncs roughly every 15 minutes, so the picture stays current without being a live feed you have to watch. The platform does the conversion arithmetic; you keep every decision.

For the mechanics of how the conversion and the comparison matrix work, see the cross-channel analytics features guide. For the narrative of why the unfixed version breaks, the why multi-currency ROAS never adds up piece walks through the failure modes.

Step 3 — Freeze Closed Periods

A reconciliation is only trustworthy if a closed period stays closed. Once a month ends and you have booked each day's spend at its day-of-transaction rate, that month's converted total must never change again. This is the difference between a number finance can audit and a number that floats.

In practice, freezing means two disciplines. First, never re-convert historical spend at a newer rate "to keep it consistent" — that is the exact mistake that re-prices the past. Second, treat each closed month's normalized total as a fixed line you reconcile against, not a value you recompute. When the bank statement and your frozen total differ, the gap is real economic drift, not FX noise.

Step 4 — Run the Weekly Log and Monthly Reconciliation

Reconciliation is a habit, not a heroic month-end push. Build two cadences:

1. Weekly log. Pull the portfolio's blended spend and ROAS in your reporting currency, already converted at the day-of-transaction rate, and write the number down. This keeps the budget decision current and surfaces drift while it is small.
2. Monthly reconciliation. Compare the sum of your frozen weekly figures against the bank statement, where the money truly settled. Because nothing was re-priced, any gap is returns, refunds or late-settling revenue — real signal worth investigating, not a currency artifact to explain away.

This is also where the human-in-control principle earns its keep. The normalized view tells you which market's converted ROAS is genuinely weak; you decide whether to pause it, and you approve the budget shift. Because Wevion is an ad platform and not only a dashboard, the same screen that shows the reconciled view is where you act — move budget off a genuinely weak market and toward a genuinely strong one without switching tools or re-deriving the currency math. For how this blended figure feeds the actual budget call, the reported vs true ROAS framework shows where it fits.

A worked example

Say you run three accounts in March: a US account spending $30,000, an EU account spending €25,000, and a UK account spending £18,000. Your reporting currency is the euro. The naive method converts all three at the March 31 spot rate and calls it done. The correct method converts each day's slice of spend at that day's rate.

Why the difference is not academic: suppose the dollar was strong early in March and weakened later, and most of the US spend landed in the first ten days. The day-of-transaction method books those early dollars at the stronger early rate, producing a higher euro figure than the month-end spot rate would. The gap between the two methods can easily reach a few percent of the US line — and on a portfolio scaling spend, a few percent of the spend base is the difference between a market that looks profitable and one that looks like it should be paused. The naive method would have told you to cut a market the correct method shows is fine.

Run this once by hand and you will understand why nobody sustains it across a full portfolio every week. That is precisely the arithmetic worth handing to software, while you keep the judgment.

Step 5 — Make the Number Auditable for Both Sides

The final step is the one that ends the marketing-versus-finance argument for good: agree, in writing, that both teams read from the same frozen anchor. Marketing's converted ROAS and finance's ledger figure now share a conversion rule and a freeze convention, so they can only differ by real economic factors — which means a difference becomes a question to investigate, not a fight about whose number is "real."

When leadership can trace the blended ROAS back to the day-of-transaction rate and the bank statement, they stop demanding the raw CSVs and re-deriving the math themselves. The team that owns the campaigns gets to own the narrative again, which is the whole point of reconciling in the first place.

A Note on Scope

Be honest internally about what this method does and doesn't solve. It fixes the currency unit problem (you can finally sum across markets) and the FX-timing problem (closed periods stay closed). It does not adjudicate attribution — if two platforms claim the same sale, normalized currency makes the over-count visible but does not resolve it. And it is not a profit feature; profit needs cost and return data from your order system. Reconcile the spend side first, because it removes the largest and most fixable source of the mismatch.

There is one more boundary worth naming for client-facing teams. If a client insists on seeing performance in their own currency, you do not abandon the day-of-transaction rule — you apply it twice, once into your internal reporting currency and once into theirs, both frozen. The trap is using a different timing rule per client; as long as every conversion uses the day-of-transaction rate, the two deliverables stay internally consistent and reconcile back to the same underlying spend. The currency on the page changes; the anchor underneath it does not.

The Bottom Line

Reconciling ad spend across currencies comes down to one rule and one discipline: book every day's spend at its day-of-transaction rate, and freeze closed periods so they never re-price. Normalize every account into one reporting currency, run a weekly log and a monthly bank reconciliation, and keep the human in control of every budget move. Wevion automates the conversion grind — every platform's spend in one currency at the day-of-transaction rate, launch and reporting on one screen — starting with a permanent free tier (€0), then Starter at €99/mo, Pro at €499/mo, Plus at €1,499/mo (€1,199 annual, billed yearly at −20%), and Enterprise as a custom plan, with a 14-day trial on every paid tier that coexists with the free plan. For the wider workspace this routine lives in, the ads management platform hub maps the rest.