Skip to main content
Engineering August 29, 2026 · 8 min read

Why Your Multi-Currency TikTok Shop Profit Is Wrong (And How We Calculate It)

Selling in GBP, paying USD for TikTok Ads, and sourcing in CNY? Here is how AxonRow handles Point-in-Time FX conversions across settlements, ads, and COGS without dirty math.

The Cross-Border Dilemma

If you operate TikTok Shops across multiple markets, your financial stack likely looks like a currency puzzle:

  • Your Shop sells in the United Kingdom, settling in British Pounds (£ / GBP).
  • Your TikTok Ads Business Center is registered in the US or Hong Kong, spending in US Dollars ($ / USD).
  • Your Supplier & Inventory COGS are negotiated in USD or Chinese Yuan (¥ / CNY).
  • Your Headquarters / CFO wants an executive overview of all European and US stores converted into Reporting Currency (USD or EUR).

When you spend $1,000 on TikTok Ads to generate £3,000 in UK GMV, what was your actual ROAS? What was your true profit margin?

Most analytics platforms get this wrong — sometimes catastrophically so.

3 Common (and Dangerous) Multi-Currency Mistakes

1. The “Label-Only” Currency Bug

The most common bug in SaaS dashboards: taking the raw $1,000 spend from TikTok’s Ads API and simply displaying it as £1,000 under your UK shop view.

Because £1 is worth roughly $1.27, you didn’t spend £1,000 — you spent approximately £790. Slapping a pound sign on a dollar figure creates a ~27% error on ad costs, making campaigns look significantly less profitable than they actually were.

2. Today’s Spot Rate Applied to History

Many reporting tools fetch today’s exchange rate (say, $1.30) and multiply all historical data by it.

If you spent money in June when the exchange rate was $1.25, re-calculating June with August’s rate rewrites history. Your closed-month financial statements drift overnight, creating false accounting variances and making month-over-month comparisons meaningless.

3. Currency Blending Without Normalization

Summing £10,000 in UK sales with $15,000 in US sales into a single unqualified “25,000 Revenue” figure. Blended totals without unified conversion make portfolio-level decision making impossible.

How AxonRow Handles Multi-Currency

We designed our multi-currency engine around three non-negotiable rules: Point-in-Time Accuracy, Shop-Level Domain Isolation, and Deterministic Financial Transparency.

┌───────────────────────────────────────────────────────────┐
│                    Go Backend & Dataform                  │
│                                                           │
│  TikTok Ads API (USD)  ──► PIT FX (stat_date) ──► GBP     │
│  Supplier COGS (USD)   ──► PIT FX (order_date)──► GBP     │
│  Settlement (GBP)      ─────────────────────────► GBP     │
│                                                    │      │
│  Shop Level: 100% Settled Currency (£)            ▼      │
│                                             Net Profit (£)│
│                                                    │      │
│  All-Shops Cockpit: ──► Daily PIT FX ──► Org Reporting ($)│
└───────────────────────────────────────────────────────────┘

Pillar 1: Point-in-Time (PIT) FX Conversion

Exchange rates fluctuate every trading day. Therefore, currency conversion must never use static or current-day rates.

AxonRow synchronizes daily official reference exchange rates (from central banks including the European Central Bank) across 30+ currency pairs (USD, GBP, EUR, MYR, THB, PHP, IDR, SGD, SAR, CNY, and more).

When an ad campaign runs on 2026-07-15:

Ad Spend (GBP) = Ad Spend (USD) × ConversionFactor(USD → GBP, "2026-07-15")
  • If you look at July 15 today, tomorrow, or next year, the converted number will never change.
  • Weekends and bank holidays are automatically forward-filled from the most recent trading close.

Pillar 2: Shop Settlement Currency as the Atomic Source of Truth

Every financial calculation in AxonRow begins at the Single Shop Level.

For any specific shop (e.g. DemoShop UK):

  1. The Shop’s Settlement Currency (GBP) is king.
  2. TikTok Ads spend billed in USD is converted to GBP on the exact date the impressions were served.
  3. Inventory COGS recorded in USD or CNY are converted to GBP on the date of order creation using our Point-in-Time SCD2 cost timeline.
  4. Platform fees, referral commissions, shipping fees, and refunds (which TikTok’s Finance API provides in GBP) are subtracted directly.

Result: GMV, Ad Spend, COGS, Fees, and True Net Profit all live in identical, pure GBP (£). Zero currency distortion.

Pillar 3: The 5-Bucket Financial Identity

In AxonRow’s profit model, every cent is categorized into one of five mutually exclusive buckets:

Earned = Taken + Spent + Lost + Kept (Net Profit) + Taken Drift
  • Earned (Revenue / GMV): Total customer payment in settlement currency.
  • Taken (Platform Fees): Commission, payment processing, shipping deductions.
  • Spent (Ad Spend): Advertising spend converted to settlement currency at PIT rate.
  • Lost (Refunds): Customer return and cancellation deductions.
  • Kept (Net Profit): True retained earnings.

Because Spent is converted at the exact day grain into the settlement currency, the five-bucket reconciliation checksum holds mathematically true across multi-currency operations.

Pillar 4: All-Shops Portfolio View (Org Reporting Currency)

When an executive switches from a single shop to “All Shops (Global)”:

  1. Each individual shop’s 5-bucket daily totals (already clean in GBP, EUR, THB, etc.) are converted to the Organization’s chosen Reporting Currency (e.g. USD).
  2. The conversion applies that specific calendar date’s rate.
  3. The resulting cross-shop GMV, Net Profit, and Blended ROAS reflect true purchasing power in your reporting currency.

What About Bank Spreads and Wire Fees?

We believe in complete transparency about the boundaries of analytical conversion:

Central bank reference rates (ECB / Fed) represent mid-market wholesale rates. When your bank or credit card company actually charges you for USD ad spend or transfers GBP payouts to your local account, they apply a 0.5% – 2.0% FX spread/markup.

  • We do not guess your private credit card markup, because every seller’s banking contract is different.
  • What we provide is a deterministic, auditable, and structurally consistent benchmark that eliminates 99% of currency distortion without phantom numbers.
  • For precise bank reconciliation, actual bank payout settlement records can be matched against our P&L reports.

The Takeaway

Multi-currency accounting isn’t just about rendering the right symbol ($, £, €) on a dashboard card. It is about:

  1. Converting every line item on its historical business date (PIT FX).
  2. Normalizing all ad spend and COGS into the shop’s settlement currency before calculating profit.
  3. Preserving immutable financial history.

With AxonRow, whether you are scaling TikTok Shop UK with a US ad account or managing 10 stores across Southeast Asia, your ROAS, margin, and net profit are mathematically sound.