At a glance
Per-channel revenue stacked by currency_code over the trailing 30 days. The merchant’s view of “which channels are bringing in which currencies”, essential for FX exposure planning, payment-processor configuration, and tax-jurisdiction routing. BigCommerce’s multi-currency support pairs naturally with channel-native sales; this card is the cross-product visibility merchants need to manage that stack.
| What it counts | SUM(total_inc_tax) GROUP BY channel_id, currency_code over the trailing 30 days, displayed as a stacked bar per channel. Each channel shows its currency split as proportions and absolute values; totals are NOT FX-converted by default (each currency is shown in native amount). |
| API endpoint | GET /stores/{store_hash}/v2/orders with currency_code per order; GET /v3/channels for channel metadata. The OpenSearch index materialises per-channel-per-currency-per-day aggregates. |
| VAT / tax treatment | Tax-inclusive in each currency. Note that VAT-inclusive USD and VAT-inclusive GBP carry different tax components; the comparison is structurally apples-to-oranges in unconverted view. |
| Shipping | Included in each currency. |
| Discounts | Deducted. |
| Refunds | Not deducted. |
| Cancelled orders | Excluded. |
Incomplete orders | Excluded. |
| Currency | The decomposition variable. Shows native currency by default (USD orders in USD, GBP in GBP); converted-display option converts to a single reporting currency using daily FX rates. |
| Channel coverage | All BC channels. POS terminals are typically single-currency (the till’s configured currency); web channels are typically single-currency per storefront; marketplaces are channel-locked (Amazon UK = GBP, Amazon US = USD). The card surfaces the few channels that legitimately mix currencies (multi-currency web storefronts, B2B portal with international customer groups). |
| B2B Edition behaviour | B2B portal can mix currencies if customer-group price lists are configured per-region. The card surfaces which customer groups buy in which currency, useful for cash-flow planning. |
| FX rate handling | When converted display is selected, the rate is daily_fx_rate * order_total_native. We use ECB daily rates for EU pairs and OpenExchangeRates for others. Don’t expect the converted total to match what your payment processor settled, processors apply their own FX and fees; the gap is typically 1-3%. |
| Time window | 30D rolling. |
| Alert trigger | None (pattern card). |
| Roles | owner, finance |
Calculation
Calculated automatically from your BigCommerce data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK skincare brand on BigCommerce Enterprise with multi-storefront (UK, US, EU) and B2B Edition. Snapshot for 1 Apr to 30 Apr 26.channel_id | Channel | GBP | USD | EUR | AUD | Total (GBP equiv) |
|---|---|---|---|---|---|---|
1 | UK Stencil web | £180,420 (100%) | $0 | €0 | A$0 | £180,420 |
2 | US Stencil web | £0 | $108,500 (100%) | €0 | A$0 | £86,800 |
3 | EU Stencil web | £0 | $0 | €92,140 (100%) | A$0 | £79,240 |
12000004 | B2B portal | £45,000 (62%) | $18,200 (20%) | €11,400 (13%) | A$3,200 (5%) | £72,800 |
1019847 | Amazon UK | £42,300 (100%) | - | - | - | £42,300 |
1019848 | Amazon US | - | $51,600 (100%) | - | - | £41,280 |
1020114 | POS UK store | £8,200 (100%) | - | - | - | £8,200 |
| Headline | £511,040 |
- Most channels are mono-currency by design. Each storefront, each marketplace listing region, each POS terminal is currency-locked. The interesting row is the B2B portal, which carries 4 currencies because B2B Edition customer groups can be regionalised. That’s where FX exposure planning lives.
- B2B portal currency mix tells the wholesale-customer geography story. 62% GBP / 20% USD / 13% EUR / 5% AUD reflects the merchant’s wholesale customer book by country. If GBP suddenly drops to 40% MoM, the cause is usually a US wholesale customer placed an unusually large PO, not currency-trend movement. Always check absolute volumes alongside percentages.
- The headline GBP-equivalent total is FX-rate-sensitive. When USD strengthens 5% vs GBP, the total grows 5% just from FX without any volume change. For accurate revenue trend always view in either native-currency-only mode or constant-currency mode (using last-period FX rates). Configure under Settings → FX → Constant currency.
- Payment processor settlement gap. Merchant’s Stripe US account settled $108,500 on US storefront orders, matching this card. But the merchant’s Stripe UK account settled £179,890 on UK orders, less than the card’s £180,420. The £530 gap is Stripe’s currency conversion fees on a small sub-set of cross-border UK-storefront orders that processed through USD acquirer routing. Reconcile against payment processor before flagging as a data issue.
- EU storefront concentration is pure-EUR. Healthy from an FX-exposure standpoint, the merchant’s EU costs (some Lithuanian fulfilment) are EUR-denominated, so EUR revenue and EUR cost natural-hedge.
- For finance teams, view in native-currency mode for FX exposure planning; view in converted mode for board reporting.
- For the B2B portal specifically, watch for currency-mix shifts month-over-month, they signal customer-book changes.
- Reconcile against payment processor for each currency separately; the gateway’s FX fee creates a small structural gap.
- Pair with BC Revenue by Currency for the cross-channel currency rollup.
- For multi-storefront stores, this card is essential for understanding which storefront drives which currency exposure.
Sibling cards merchants should reference together
| Card | Why pair it with Currency Mix by Channel |
|---|---|
| BC Revenue by Currency | The cross-channel rollup; this card is the per-channel decomposition. |
| BC AOV by Country | Country and currency are correlated but not identical; pair for the geography view. |
| BC Channel Revenue Trend | Trend per channel with currency-aware comparison. |
| Total Revenue | Headline rollup; FX-converted to single currency. |
| BC Orders by Channel | Volume context; currency mix shifts can reflect order-count shifts. |
| BC Channel AOV | Per-channel AOV needs currency context for cross-channel comparison. |
| BC Channel Top Products | Pair to identify which SKUs sell in which currency. |
| BC Guest vs Registered | B2B portal currency mix correlates with the registered-customer cohort. |
Reconciling against the vendor’s own dashboard
Where to look in BigCommerce Control Panel: Settings → Currency shows the currencies configured on the store. Analytics → Sales shows revenue but doesn’t natively split by currency-and-channel; you need Reports → Custom to build the cross-tab. For multi-storefront: Storefronts → All storefronts shows per-storefront revenue; pair with the configured currency for each storefront. Why our currency split may differ from BC’s storefront analytics:| Reason | Direction |
|---|---|
| FX rate timing. We use ECB / OXR daily rates; BC may use different rate provider. Converted totals can differ by 0.5-2%. | Either direction (rate-dependent) |
| B2B Edition cross-currency. B2B portal can have customer-group-specific currencies; BC’s main analytics may aggregate to the merchant’s primary. | Vortex IQ surfaces granularity; BC main view less so |
| POS terminal currency. Each terminal has a configured currency; some BC plans surface per-terminal, others aggregate. | Different granularity |
| Refund-currency timing. A refund processed in USD on a GBP order can muddle the figures depending on processor handling. | Various |
| Rounding. Per-line item rounding and FX rounding compound for multi-line orders. | Sub-1% gap |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
stripe.stripe_revenue_by_currency | Should match Stripe-paid orders per currency within 1-2% | Stripe’s settlement currency may differ from order currency (acquirer routing); the gap is typically 0.5-2%. |
paypal.pp_revenue_by_currency | Should match PayPal-paid orders per currency | PayPal applies its own FX which can differ from BC’s recorded rate. |
adyen.adyen_settlement_currency | Adyen’s settlement currency split should match this card’s processor-routed view | Adyen offers settlement-currency-of-choice; merchants who route all to USD see only USD on Adyen, multi-currency on this card. |
presentment_currency) and Adobe Commerce (per base_currency_code); merchant-facing semantics are equivalent though Adobe’s multi-currency model is stronger and Shopify’s is weaker than BC’s.