Technical Deep-Dive · 10 min read
Multi-Currency Revenue Tracking: USD-Equivalent Consolidation for Global DTC
A DTC brand selling in USD, EUR, GBP, AUD and CAD has several revenue numbers, and ad accounts billed in yet another currency. This playbook covers how Admaxxer shows everything in one workspace display currency, where its exchange rates come from, how to pin your own rate, and how to separate currency movement from real growth in your own reporting.
Five currencies, five numbers, one view
A DTC brand selling across the US, UK, Eurozone, Australia and Canada has several revenue ledgers, each correct in its own currency. The job of the analytics layer is to show them in one currency without hiding where the numbers came from. Get the reading wrong and a 3% currency move can mask 3% of real growth — or a 3% currency tailwind can look like 3% of real growth.
- Five currencies, five different stories: a single rolled-up figure is right for most decisions, but the exchange rate behind it matters.
- One display currency: Admaxxer converts every amount from its native currency into one display currency, so revenue, spend, MER and ROAS compare like with like. The workspace owner sets the default; anyone can switch their own view with the currency selector on the dashboard.
- Your own rate wins: missing rates are filled in automatically from a free public reference-rate feed covering about 160 currencies, and any rate you set under Settings → Exchange rates always wins and is never overwritten.
- Currency movement can look like growth: if EUR strengthens 5% against USD, EUR revenue converted to USD rises 5% with no change in real sales.
How Admaxxer converts amounts
There are two common ways to convert foreign-currency revenue: at the rate on the day of each order, or at one rate applied when you view the report. Admaxxer does the second. Each amount is stored in its native currency and converted into your display currency when the dashboard loads, using the workspace's rate for that currency pair. The same rate is applied to every date in the report.
What you get today:
- Hover any converted money tile to see the native amount, the rate applied and the rate's as-of date.
- Native amounts are never changed, so switching the display currency or a rate re-converts everything consistently.
- If no rate exists for a pair, the amount is shown in its native currency with a warning, never converted with a guess.
Not available yet:
- A separate exchange rate per order or per day. One rate per currency pair covers the whole period you are viewing.
- An automatic FX-neutral (constant-currency) revenue series.
Because the same rate covers every date, a change in that rate shifts past periods too. For reports that must stay fixed, pin your own rate.
Auto-filled reference rates, and your own rate when you need it
| Source | How it works |
|---|---|
Auto-filled when missing | Each workspace has its own exchange-rate table. When a currency pair you need has no rate, Admaxxer fetches one from a free public reference-rate feed covering about 160 currencies, in both directions. This is best-effort; if the feed is unavailable, set the rate yourself. |
Your rate always wins | Set a rate under Settings → Exchange rates and it replaces the auto-filled one and is never overwritten. Finance teams use this to reconcile at a fixed monthly, quarterly or budget rate. |
Two questions, two ways to read revenue
"What did we earn in our reporting currency?" and "How much did sales really grow?" are different questions. Admaxxer doesn't produce a separate FX-neutral series yet, but you can answer both.
| View | When to use it |
|---|---|
In your display currency | Everything converted at the workspace's rates. Use it for ad budget allocation, MER targets and day-to-day decisions: blended MER and ROAS compare revenue and spend in the same currency. |
At a fixed reference rate | Pin one rate per currency (for example your budget rate for the year) in Settings → Exchange rates, or compare revenue in native currency. With the rate held still, converted revenue moves only with real sales. Use it for board reporting, year-over-year comparisons and organic-growth analysis. |
Worked example with made-up numbers: converted at each month's rate, June grew 12% over May; at a fixed rate it grew 8%. The 4-point gap is currency movement. Label which basis a growth figure uses whenever you report it.
# UK + US + EU DTC brand, June vs May revenue, reported in USD.
# Done in your own spreadsheet from native-currency revenue.
# "Fixed rate" = one reference rate per currency you pick for the year.
CURRENCY JUNE NATIVE REVENUE JUNE RATE AT JUNE RATE FIXED RATE AT FIXED RATE
USD $312,400.00 1.00000 $312,400.00 1.00000 $312,400.00
GBP GBP 89,200.00 1.27840 $114,033.28 1.22000 $108,824.00
EUR EUR 161,700.00 1.08120 $174,829.96 1.03000 $166,551.00
AUD AUD 48,100.00 0.66200 $ 31,842.20 0.65000 $ 31,265.00
CAD CAD 32,900.00 0.73450 $ 24,165.05 0.73040 $ 24,030.00
------------ ------------
TOTAL $657,270.49 $643,070.00
# At each month's rate: June $657,270 vs May $586,847 = +12.0%
# At the fixed rate: June $643,070 vs May $595,250 = +8.0%
# The 4-point gap is currency movement, not extra sales.
Shopify revenue is recorded in your shop currency
Shopify Markets orders carry two sets of amounts: the currency the customer paid in (presentment currency) and your shop currency. Admaxxer records Shopify revenue in your shop currency, so a single foreign-currency order can never relabel a dashboard in another currency. From there it is converted into your display currency like every other amount.
Shopify converts presentment amounts into shop currency with its own rates. If you compare Admaxxer with Shopify Admin, compare shop currency with shop currency.
Ad accounts billed in another currency
Each ad connection carries its account currency. A UK Meta account may bill in GBP while your store sells in USD. When the account currency differs from your display currency, Admaxxer converts the spend with the workspace's rate for that pair, so blended MER, ROAS and CPA compare revenue and spend in the same currency.
If you run separate stores in different currencies, each store can be its own workspace with its own default currency. See the multi-currency reference at /documentation/architecture/multi-currency for the display-currency settings.
Five mistakes that corrupt multi-currency reporting
- Comparing different currencies. Checking Admaxxer in your display currency against Shopify Admin in shop currency, or against an ad platform in its account currency, produces a gap that is only conversion. Compare in the same currency, or hover the tile for the native amount.
- Treating a rate change as a sales change. One rate covers every date in a view, so updating a rate moves past periods too. Pin a fixed rate before you produce figures that must stay put.
- Mixing bases in one report. Showing "June revenue +12%" (current rates) next to "Q2 organic growth +8%" (fixed rate) without saying which is which confuses readers. Always label the basis.
- Expecting revenue to match your bank deposits. Payment providers convert payouts with their own rates and fees, so converted revenue and bank deposits rarely match exactly. Note the gap in your reconciliation rather than chasing it in the dashboard.
- Ignoring a missing-rate warning. When a pair has no rate, the amount stays in its native currency with a warning. Totals that mix it with converted amounts are off until you add the rate in Settings → Exchange rates.
Frequently asked questions
- Why does the FX rate and its date matter for revenue reporting?
- Because a currency move can look like growth. If EUR strengthens 5% against USD between two months, EUR revenue converted to USD rises 5% with no change in real sales. Admaxxer converts each amount from its native currency into your workspace display currency using the workspace's rate for that currency pair, and hovering a money tile shows the native amount, the rate applied and the rate's as-of date. For month-over-month comparisons that must exclude currency movement, use a fixed rate you set yourself.
- Where does Admaxxer get FX rates from?
- Each workspace has its own exchange-rate table. When a currency pair you need has no rate, Admaxxer fetches one from a free public reference-rate feed covering about 160 currencies. Any rate you set yourself under Settings → Exchange rates always wins and is never overwritten, which suits finance teams who reconcile at a fixed quarterly rate. If no rate is available, the amount is shown in its native currency with a warning rather than converted with a guess.
- Can Admaxxer separate FX impact from organic growth?
- Not automatically yet: there is no FX-neutral revenue series or forecast in Admaxxer today. To separate the two yourself, compare revenue in native currency, or pin a fixed reference rate in Settings → Exchange rates for the period you are analysing, so the converted numbers move only with real sales. Ad-spend decisions can still use the display-currency view, since that is what the spend costs you.
- What about Shopify Markets: is multi-currency handled automatically?
- Shopify Markets orders arrive with both the currency the customer paid in (presentment currency) and your shop currency. Admaxxer records Shopify revenue in your shop currency, so one foreign-currency order cannot relabel a dashboard in another currency, and then converts it to your workspace display currency like every other amount.
- How are ad accounts billed in a different currency handled?
- Each ad connection carries its account currency. When it differs from your display currency, Admaxxer converts the spend with the workspace's rate for that pair, so blended MER and ROAS compare revenue and spend in the same currency. If you run separate stores in different currencies, each store can be its own workspace with its own display currency.
Run this playbook in your own dashboard
Admaxxer ships the pixel + server-side purchases to Meta, TikTok and Klaviyo + Maxxer AI agent + cohort analytics out of the box. The playbook above becomes a live surface in your account after a 5-minute setup.