A/R balance and open SO value by currency. Non-base-currency exposure carries FX risk.
At a glance
Bar chart showing AR balance and open SO value broken out by transaction currency, in their native amounts. Surfaces the merchant’s FX exposure: how much of the working AR / pipeline is denominated in currencies other than the consolidation reporting currency, and is therefore subject to FX revaluation gain or loss before it converts to cash. For VP Finance and the Treasurer at OneWorld merchants, this is the hedging-decision view: what’s the size and shape of the FX risk on the books right now.
Card gate: only_when: multi_subsidiary (or any tenant transacting in more than one currency). Single-currency tenants see a placeholder.
| What it counts | SUM(transactions.amount) GROUP BY currency for AR balance (Invoices unpaid) and Open SO total. Each currency in its native amount, with the consolidation column showing the equivalent in reporting currency at current FX. |
| VAT / tax treatment | Inclusive in the AR balance and SO total (gross of tax). |
| Shipping | Included. |
| Discounts | Already deducted. |
| Refunds | Credit memos applied to AR reduce the per-currency balance. |
| Cancelled / voided orders | Excluded. |
| Currency | Each currency native + consolidation. The FX rate used for consolidation is current spot (refreshed daily from NS Currency Exchange Rate table). |
| Channels / sources | All sources blended. |
| Hedge tracking | Vortex IQ does not track hedge positions natively (those typically sit in the merchant’s treasury system). The card surfaces gross exposure; net-of-hedge requires manifest configuration. |
| Time window | RT (live AR + SO snapshot). |
| Alert trigger | >15% non-base currency, driven by sentiment_key: fx_exposure. |
| Roles | owner, finance, treasurer |
Calculation
Calculated automatically from your NetSuite 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 US-headquartered industrial fastener distributor on NetSuite OneWorld. Consolidation currency USD. Snapshot 04 May 26.| Currency | AR balance (native) | AR balance (USD equiv) | Open SO (native) | Open SO (USD equiv) | Total exposure (USD) | % of total |
|---|---|---|---|---|---|---|
| USD | $4,820,000 | $4,820,000 | $4,820,400 | $4,820,400 | $9,640,400 | 67.3% |
| GBP | £1,332,000 | $1,680,000 | £904,000 | $1,140,200 | $2,820,200 | 19.7% |
| EUR | €342,000 | $371,800 | €98,000 | $107,000 | $478,800 | 3.3% |
| AUD | A$1,236,000 | $824,000 | A$586,000 | $390,800 | $1,214,800 | 8.5% |
| CAD | C$184,000 | $134,800 | C$32,000 | $23,800 | $158,600 | 1.1% |
| Total | - | $7,830,600 | - | $6,482,200 | $14,312,800 | 100% |
>15% non-base currency).
What VP Finance reads:
- **GBP is the largest non-USD exposure: 141,000 off the consolidated value of these balances at next revaluation. Material at this size; warrants a hedge consideration.
- The AR vs Open SO split. AR is “earned but not collected”; Open SO is “committed but not yet earned”. AR carries shorter-duration FX risk (collected within 30 to 60 days); Open SO carries longer (could ship over 30 to 90 days). Different hedging instruments suit each.
- AUD is 8.5%, smaller but volatile. AUD has historically had ~12% annual volatility against USD; even a small position can produce material swings. The merchant has had AUD revaluation losses in 4 of the last 6 quarters.
- EUR and CAD are <5% each, below the materiality threshold for active hedging. Most treasurers leave sub-5% currencies unhedged on cost grounds (hedge cost > expected swing).
- Hedging decision tree:
- For GBP: 50 to 75% hedge of the AR portion via 30-day forward contract is a typical play. Cost ~0.5 to 1.0% of notional.
- For AUD: smaller hedge or natural-hedge against AUD-denominated supplier costs (which the merchant has, modestly).
- For EUR / CAD: leave unhedged.
- Trend view: GBP exposure has grown from 14% to 19.7% over 6 months as the UK subsidiary scales. The trend is the alert: a growing exposure should prompt a fresh hedging review at the 15% and 20% thresholds.
Sibling cards merchants should reference together
| Card | Why pair it with FX Currency Exposure |
|---|---|
| Subsidiaries List | Currency mostly tracks subsidiary; the two views together explain the exposure source. |
| Intercompany Balance | Intercompany balances offset some of the gross FX exposure. |
| Revenue by Currency | Revenue mix by currency tells you whether exposure is rising or falling. |
| A/R Aging Buckets | Per-currency aging shows which currency’s AR is most at risk. |
| DSO | Long DSO + non-base currency = compounded FX risk over a longer settlement window. |
Reconciling against the vendor’s own dashboard
Where to look in NetSuite’s own dashboard:Reports > Banking/Budgeting > Multi-Currency > Currency Revaluation Report for a per-currency view of unrealised FX exposure on outstanding balances. Reports > Customer/Receivables > A/R Aging by Currency for the AR side. Lists > Accounting > Currencies to see the configured currency rates.Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| FX rate snapshot | Either | Vortex IQ refreshes spot rate daily from the NS Currency Exchange Rate table; intra-day moves don’t reflect until next refresh. NS reports use period-end or transaction-date rate depending on report. |
| Open SO inclusion | Material | Vortex IQ includes Open SOs in the exposure side. NS standard reports tend to focus on AR-only. The Open SO portion represents future-FX exposure. |
| Hedge offset | Either | Vortex IQ does not subtract hedge contracts (those typically sit outside NetSuite). Per-merchant manifest can configure hedge offsetting. |