One Currency-Correct Number for the Board: A Multi-Market Story
Giada Esposito
E-commerce Performance Manager
This consumer-goods brand sold into three markets — the eurozone, the UK and the US — and every quarter its founder walked into a board meeting carrying a single profit number she could not fully defend. The revenue was real, the campaigns were real, the spend was real. The trouble was the multi-currency board report FX day of transaction problem hiding underneath: the consolidated profit figure was built in a spreadsheet that re-converted every historical order at whatever exchange rate happened to be current the morning the deck was assembled. Rebuild it a week later and the same quarter reported a different profit. This is the story of how the brand turned a number it had to apologize for into one that finally held up.
Quick answer: When a store sells in several currencies, converting historical orders at today's FX rate re-prices every past sale at a rate that never applied to it, so the board's profit figure drifts from the books and changes every time the spreadsheet is rebuilt. Valuing each order at the day-of-transaction rate — the rate from the day it was actually placed — anchors the consolidated profit and True ROAS to the ledger, producing one defensible figure instead of a fragile estimate.
This is a composite drawn from common cross-border patterns, but the failure mode and the fix are real. The names and exact figures are illustrative; the mechanism that produced an indefensible board number is not.
The boardroom problem: three markets, three currencies, one number expected
The board asked for something reasonable: one figure for the quarter. Total profit, blended ROAS, how the marketing spend paid back. What the board did not see was the machinery behind that single number. Orders arrived in euros, pounds and dollars across the quarter. Ad spend ran in multiple currencies too. To produce one consolidated figure, somebody on the finance side pulled exports from the store and the ad platforms into a spreadsheet and converted everything into the brand's reporting currency.
That conversion was the soft spot. The spreadsheet used one exchange rate per currency — whatever rate was live the day it was built — and applied it across the entire quarter. An order placed in March, when the pound sat at one level, was valued at the rate from the day of the meeting, which was different. The founder knew the number was approximate. She just could not say by how much, and that uncertainty is exactly what a sharp CFO smells.
A board does not need the most precise number imaginable; it needs a number that does not move when nothing real has changed. A consolidated profit figure that shifts every time the spreadsheet is rebuilt — purely because the conversion rate moved — fails that test before anyone questions the underlying campaigns.
Why today's FX rate breaks history: re-converting old orders gives a wrong ROAS
The error is subtle because it feels like a rounding issue and behaves like a structural one. Each historical order was banked at a specific rate on a specific day. When the spreadsheet re-converts that order at today's rate, it is asserting a value the order never had. Do that for a few thousand orders spread across a quarter, each placed on a different day at a different real rate, and you smear the entire revenue side of the report.
The damage is not random in a way that cancels out. It systematically rewards markets where the currency moved one way and penalizes markets where it moved the other, so the per-market ROAS ranking itself becomes partly an artifact of when you happened to build the deck. The full mechanics of why a single rate cannot represent orders that happened across many days at many rates are walked through in why multi-currency ROAS doesn't add up — and once the revenue side is wrong, every margin and ROAS figure stacked on top of it inherits the error.
Currency drift is a method error, not an effort error. The finance team can be meticulous and still produce a wrong number, because the wrongness is baked into the choice of one rate for a period that spanned hundreds of rates. No amount of double-checking the spreadsheet fixes a conversion model that was never right.
The credibility risk: a profit figure the CFO can poke a hole in
The real cost of the wrong number was not a few percent of misstated margin. It was credibility. In one board meeting the CFO asked a simple question: "If I rebuild this next week, do I get the same profit?" The honest answer was no — and that single admission did more damage than any bad campaign could. Once a board learns that a figure is rate-dependent, every other number in the deck inherits the doubt.
This is the quiet tax a fragile consolidation imposes. The marketing team might be allocating budget well, the campaigns might genuinely be profitable, but none of that lands if the headline number cannot survive scrutiny. The founder found herself defending the methodology instead of discussing the business. The brand was not the only one to hit this wall; the same reconciliation pain, framed from the board's side of the table, is exactly what one DTC team solved for its board before the conversation could move forward.
A profit figure that cannot answer "would you get the same number tomorrow?" is not a measurement; it is an opinion with decimals. Boards do not fund opinions. The moment the headline number becomes contestable, the whole report stops being a basis for decisions and starts being a debate about arithmetic.
FX at day-of-transaction: valuing every order at the rate it actually happened
The fix was conceptually small and consequential. Instead of one rate per currency stretched across the quarter, value each order at the day-of-transaction rate — the exchange rate that existed on the day the order was actually placed, the same rate the books used when they recorded it. A UK order from March is converted at March's rate. A US order from May is converted at May's rate. The consolidated figure becomes a sum of orders each valued the way the ledger valued them.
The brand moved its measurement onto Wevion's profitability hub, where FX at the day of transaction is the default rather than a manual step. Order-level data — line items, cost of goods, fees, currency and returns — flowed in from the store, each order carrying the date it occurred, so the conversion happened per order at the correct historical rate automatically. The reconciliation that had been a fragile spreadsheet ritual became a property of the data itself; the step-by-step of doing this deliberately is laid out in how to reconcile ad spend across currencies.
Day-of-transaction FX is not a precision feature for its own sake. It is the only conversion model that lets a multi-currency report tie to the books, because the books recorded each order at the rate of its own day. Match that and the report reconciles; ignore it and the report drifts no matter how careful everyone is.
Building the consolidated profit view across currencies
Solving FX fixed the revenue side, but a board number is profit, not revenue, so the brand pushed the same view further. With order-level data already present, the profitability hub subtracted the real costs per order — cost of goods, processing and platform fees, shipping, returns — and divided net profit by spend to produce True ROAS per campaign and per market, all in one reporting currency. The consolidation that used to require a manual conversion pass now rolled up cleanly because every order was already valued correctly at its source.
Two things mattered about how the view was built. First, it spanned the platforms the brand actually ran on — the same hub consolidates across the six supported ad platforms rather than forcing one report per channel — so the board number was genuinely blended, not a single-channel slice. Second, the order sync kept the cost side current as catalog prices and supplier costs shifted, so True ROAS did not quietly go stale between meetings. The platform reported a roughly 15-minute sync cadence rather than an instant one, which for a quarterly profit picture is invisible: a board number is measured over months, not milliseconds. For brands weighing how to structure this, the trade-offs are compared in ways to handle multi-currency ad reporting.
The leap was from a report that was assembled to a report that was derived. When each order arrives already valued at its own day's rate and tagged with its real costs, the consolidated profit and True ROAS fall out of the data instead of being manufactured in a spreadsheet — and a derived number is far harder to poke a hole in than an assembled one.
Presenting one defensible figure instead of a fragile spreadsheet
The first board meeting after the change went differently. The founder presented one consolidated profit figure and one blended True ROAS, broken out by market, and when the CFO asked the old question — would it be the same next week — the answer was yes. The figure was built on day-of-transaction FX, so rebuilding it produced the same result, because the rates it used were historical facts, not a snapshot of the morning. The conversation moved, for the first time, off the methodology and onto the business.
What changed was not just the number's accuracy but its standing. A defensible figure does not need to be re-litigated, so the marketing team got to spend the meeting discussing where the budget should go rather than whether the report could be trusted. The per-market True ROAS, finally currency-correct, also exposed that the brand's strongest market on revenue was not its strongest on profit once costs and correct FX were applied — a reordering the old spreadsheet had been hiding inside its conversion noise.
The difference between a number and an argument is reproducibility. A figure anyone can rebuild and land on the same answer ends the debate; a figure that depends on when you converted keeps the debate alive forever. Day-of-transaction FX is what moves a board report from the second category into the first.
What a trustworthy cross-border number unlocks for budget conversations
Once the headline figure held up, the downstream conversations changed character. Budget decisions stopped being negotiations over whose spreadsheet to believe and became straightforward reads off a shared, currency-correct view. The team could say a specific market's True ROAS cleared the contribution target and another's did not, and nobody reached for a calculator to check the conversion.
That trust compounded. With a defensible per-market profit figure, the brand could allocate across the eurozone, the UK and the US on actual cross-border economics instead of on a revenue ranking distorted by FX timing. The founder stopped pre-emptively hedging her numbers, the CFO stopped auditing the methodology, and the meetings shortened. The deeper playbook for running cross-border budget decisions off one consolidated view lives in the campaign-scaling cluster.
Wevion's plans start at a permanent free tier (€0), then Starter at €99/mo, Pro at €499/mo, and Plus at €1,499/mo (€1,199 annual, billed yearly at -20%), with Enterprise as a custom plan, and every paid tier includes a 14-day trial that coexists with the free plan. The store connection and the multi-currency profit view sit inside that, so a brand can wire its store and see a currency-correct consolidated figure before committing to a paid tier.
Lesson: currency-correct history is the difference between a number and an argument
The lesson generalizes to any business that sells across currencies and reports up to a board, an investor, or itself. The platforms will hand you revenue and spend in their own currencies, and a spreadsheet will happily convert it all at one rate to give you a tidy headline. That headline will feel authoritative and quietly fail the only test that matters: it will not survive being rebuilt. Value every order at the rate it actually happened, subtract the real costs, and roll the result into one reporting currency, and the figure stops being something you defend and becomes something you present. A board does not fund the brand with the prettiest number. It funds the one it can trust on any day, in any currency, every time someone rebuilds it.
Frequently Asked Questions
The Ad Signal
Weekly insights for media buyers who refuse to guess. One email. Only signal.
Related Articles
Why Your Multi-Currency ROAS Never Adds Up Across Markets
When clients and markets bill in different currencies, your blended ROAS stops being a number and becomes an argument. Spend in dollars, euros and pounds refuses to sum, FX timing quietly shifts last month's "final" figures, and the number your finance team trusts never matches the one your ad dashboards show. This is why multi-currency reconciliation breaks — and what actually fixes it.
How a DTC Brand Reconciles Multi-Currency ROAS for a Board Meeting
The board wants one ROAS number, but the brand spends in dollars, pounds and euros — and a single exchange rate makes that number quietly wrong. This is the story of how one finance-minded marketer normalized three currencies at the day-of-transaction rate and gave the board a ROAS that reconciles to the books.
How to Reconcile Ad Spend Across Currencies (Step by Step)
When accounts bill in different currencies, your blended ROAS only matches finance if you fix two things: one conversion rule for everyone, and a closed period that never re-prices itself. This is the step-by-step method — pick the day-of-transaction rate, normalize every account into one view, and run a weekly habit that keeps marketing and finance reading the same number.