Table of Contents:
1. The Multi-Currency Problem: One Deal, Multiple Views
2. The FX Challenge for Sales Forecasting
3. Where HubSpot & NetSuite Handle FX
4. The FX Conversion Point: Which Rate to Use?
5. FX Gains and Losses: The Accounting Complexity
6. Building a Multi-Currency Deal Dashboard
7. Revenue Forecasting With FX Uncertainty
8. Handling Payment Timing & FX
9. Multi-Currency Commission Complications
10. How HubSpot & NetSuite Work Together on FX
11. How Logiframe Approaches Multi-Currency Deals
12. Frequently Asked Questions
When sales teams operate globally, deals come in different currencies. But finance books everything in USD (or their home currency).
Example:
Sales rep in Europe closes a €100K deal with a German customer. Same day, sales rep in Singapore closes a $SGD 150K deal with a Singapore customer.
Sales perspective:
Deal 1: €100K
Deal 2: SGD 150K
Total pipeline: "Hard to compare, different currencies"
Finance perspective:
Today's rates: EUR = $1.10, SGD = $0.75
Deal 1 USD equivalent: $110K
Deal 2 USD equivalent: $112.5K
Total: $222.5K
But what if exchange rates change? EUR drops to $1.05 next week. Deal 1 is now worth $105K instead of $110K. Did we lose revenue? Not operationally (the German customer still owes €100K), but in USD terms, yes.
This is the FX (foreign exchange) problem that confuses sales and finance.
When you have deals in multiple currencies, your forecast depends on:
Whether deals close (probability)
When deals close (timing)
What exchange rates are (FX rates)
Sales doesn't control #3. But it affects forecast accuracy.
Scenario:
Sales forecast: Q3 revenue will be €500K + $300K + SGD 200K
Using today's rates:
€500K × $1.10 = $550K
$300K = $300K
SGD 200K × $0.75 = $150K
Total USD forecast: $1M
But Q3 spans July, August, September. Exchange rates move every day. By September, rates could be:
EUR = $1.05 (down 5%)
SGD = $0.72 (down 4%)
Revised USD forecast:
€500K × $1.05 = $525K (down $25K)
$300K = $300K
SGD 200K × $0.72 = $144K (down $6K)
Total USD forecast: $969K (down $31K)
If you forecasted $1M but rates moved against you, you'll miss by $31K through no fault of sales.
HubSpot's Role:
HubSpot stores deal information in its original currency:
Deal value: €100K (or whatever currency)
Customer location: Germany
Customer currency: EUR
HubSpot can display deals in home currency (USD) using current exchange rates for reference, but the source data is in local currency.
NetSuite's Role:
NetSuite is the accounting system. When a deal syncs from HubSpot to NetSuite as an invoice or sales order, NetSuite needs to:
Convert the foreign currency amount to USD (for accounting purposes)
Track the exchange rate used (for audit trail)
Record the conversion rate on the date of the transaction
Handle revaluation if payment is delayed (rates change between invoice and payment)
The FX Conversion Point: Which Rate to Use?
When HubSpot deal syncs to NetSuite, which exchange rate should NetSuite use to convert to USD?
Option 1: Today's Rate
Deal closes today (Aug 1): €100K
Today's rate: EUR/USD = 1.10
NetSuite records: $110K
Simple, but rate might change before payment. If customer pays Sept 1 at rate 1.05, there's a $5K gain/loss.
Option 2: Deal Close Date Rate
Deal closes Aug 1: €100K
Aug 1 rate: EUR/USD = 1.10
NetSuite records: $110K
Use the rate on the date the deal closed. Locks in the rate and avoids disputes about "which day's rate."
Option 3: Period-End Rate
Deal closes Aug 1: €100K
Month-end (Aug 31) rate: EUR/USD = 1.08
NetSuite records: $108K
Conservative approach (helps budgeting). But confuses sales ("I closed €100K, why is it $108K?").
Best Practice: Use the rate on the transaction date (deal close date). Locks in the rate and is auditable.
NetSuite needs to:
Store the exchange rate used
Store the conversion date
Track changes to the rate (for FX gains/losses)
When a deal is in a foreign currency, there are two ways to lose/gain money:
Type 1: Realized FX (When Payment Happens)
Deal: €100K, closed Aug 1 at rate 1.10 = $110K
Customer pays Sept 1 at rate 1.05
PaymentUSD received: €100K × 1.05 = $105K
You expected $110K, got $105K.
FX loss: $5K (rates moved against you)
This is a realized loss because the cash was converted.
Type 2: Unrealized FX (While Deal is Open)
Deal: €100K, closed Aug 1 at rate 1.10 = $110K
Sept 1 (before payment), rate changes to 1.05
Unrealized deal value: €100K × 1.05 = $105K
Loss: $5K (on paper, until customer pays)
This is unrealized because payment hasn't happened yet. It could reverse if rates move back.
Accounting Treatment:
Unrealized FX gains/losses typically go to OCI (Other Comprehensive Income), not operating income
Realized FX gains/losses typically go to operating income
Why it matters:
If you report that "revenue was $1M" without separating FX impact, your board doesn't know whether the miss was due to:
Sales not closing deals (operational)
Exchange rates moving (FX)
Both are problems, but different problems with different solutions.
A good HubSpot-NetSuite dashboard for multi-currency deals shows:
Deal Value View:
Deal: €100K
Home currency equivalent (today's rate): $110K
Home currency equivalent (deal close rate): $110K
Home currency equivalent (month-end rate): $108K
Sales sees the deal in EUR (their currency). Finance sees USD equivalent.
Currency Exposure View:
Total EUR exposure: $5.5M (€5M at today's rate)
Total GBP exposure: $3.2M (£2.5M at today's rate)
Total SGD exposure: $1.8M (SGD 2.4M at today's rate)
Total foreign currency exposure: $10.5M
Home currency (USD) deals: $15M
Total pipeline: $25.5M
Finance can see how much of the forecast is exposed to FX risk.
FX Impact View:
If EUR moves to $1.05 (from $1.10), impact: -$250K
If GBP moves to $1.20 (from $1.28), impact: -$200K
If SGD moves to $0.70 (from $0.75), impact: -$120K
Total FX sensitivity: -$570K if all currencies move unfavorably
This shows the risk of FX headwinds.
Currency Breakdown by Rep:
Rep: Maria (Europe-based)
Pipeline: €2M + GBP 1M + USD $500K
Foreign currency exposure: 80%
FX risk: High
Rep: Amit (Singapore-based)
Pipeline: SGD 3M + USD $200K
Foreign currency exposure: 85%
FX risk: High
Rep: James (US-based)
Pipeline: USD $5M + USD 1M (from Canadian sales)
Foreign currency exposure: 10%
FX risk: Low
This shows which reps are most exposed to FX risk.
When building a revenue forecast with multi-currency deals, you need to:
List deals in their original currency
Apply an exchange rate assumption (today's rate? forecast rate? conservative rate?)
Show the USD equivalent
Sensitivity test (what if rates move?)
Example Forecast:
Deal (EUR 100K, closes Sept 15)
Original currency: €100K
Assumption: EUR/USD = 1.10 (current rate)
USD value: $110K
FX risk: ±$3-5K if rate moves ±3-5%
Deal (SGD 150K, closes Sept 30)
Original currency: SGD 150K
Assumption: SGD/USD = 0.75 (current rate)
USD value: $112.5K
FX risk: ±$3-4K if rate moves ±3-4%
Total Q3 forecast: $222.5K
FX risk: ±$6-9K (conservative, assuming adverse movement)
Conservative forecast: $213-217K
This gives finance a range, not a point estimate.
FX exposure exists from deal close until payment is received.
Example:
Deal closes Aug 1: €100K at rate 1.10 = $110K
Payment terms: Net 60
Expected payment: Sept 30
Day 1-60: Open FX risk
If rate stays at 1.10: No gain/loss
If rate moves to 1.05: $5K loss when paid
If rate moves to 1.15: $5K gain when paid
Sept 30: Customer pays €100K
Today's rate: 1.08
Cash received: €100K × 1.08 = $108K
vs. expected: $110K
Realized loss: $2K
If you want to eliminate FX risk, you can:
Ask customer to pay in USD (shift risk to them)
Use a forward contract (lock in a rate)
Invoice in USD (price accordingly)
But most companies just absorb the FX impact.
If sales reps are paid commission, and they're closing deals in different currencies:
Question: Are reps paid in their local currency or home currency?
If local currency:
European rep paid in EUR
Singapore rep paid in SGD
Simple for reps, but finance has FX exposure on payroll
If home currency:
All reps paid in USD
No payroll FX exposure, but reps have FX risk (if they live in Europe/Singapore and USD changes)
If commission rate adjusted by currency:
Rep closing EUR deal: 5% commission
Rep closing SGD deal: 4.5% commission (adjusted for risk)
Complicates compensation but aligns with financial impact
Most companies standardize on home currency for commission.
Step 1: HubSpot captures deal in local currency
Deal: Company A
Currency: EUR
Amount: €100K
Step 2: HubSpot stores both local and USD equivalent
Amount (local): €100K
Amount (USD, at deal close date): $110K
Exchange rate: 1.10
Date: Aug 1, 2026
Step 3: HubSpot syncs to NetSuite
NetSuite receives:
Currency: EUR
Amount (local): €100K
Amount (USD): $110K
Exchange rate: 1.10
Step 4: NetSuite records the invoice/order
NetSuite creates invoice:
Customer: Company A
Currency: EUR
Amount: €100K
USD equivalent: $110K (for P&L/balance sheet)
Exchange rate used: 1.10
Step 5: NetSuite tracks FX revaluation
If payment is delayed and rates change:
Sept 1 (before payment): Rate changes to 1.08
NetSuite revalues the AR:
Original: €100K @ 1.10 = $110K
Revalued: €100K @ 1.08 = $108K
Unrealized loss: $2K
Posts: Debit FX Loss $2K, Credit AR $2K
Step 6: When paid
Sept 30: Customer pays €100K
Rate: 1.07
Cash received: €100K × 1.07 = $107K
vs. revalued amount: $108K
Final realized loss: $1K
We help businesses:
Set up HubSpot to capture deals in local currency with USD conversion
Configure NetSuite to handle FX revaluation correctly
Build dashboards showing FX exposure by currency and rep
Create forecasts that account for FX risk
Sync multi-currency deals reliably from HubSpot to NetSuite
Most clients see better forecast accuracy and clearer understanding of FX impact on profitability.
What exchange rate should we use for forecasting?
Use today's rate for "base case" forecast. Also provide a sensitivity analysis showing impact if rates move ±5%. This gives a range of outcomes.
Should we hedge foreign currency exposure?
Depends on your size and FX exposure. Small exposure: absorb the risk. Large exposure (>$10M): consider hedging via forward contracts. This is a finance strategy decision, not a CRM decision.
How do we handle invoices in mixed currencies?
Not common, but possible. Each line item would have its own currency. NetSuite can handle this; HubSpot might need custom fields.
What if a customer wants to pay in USD instead of their local currency?
Allowed. They'd pay USD equivalent using their own bank's rate. Make sure it's documented (to avoid disputes).