Appendix P: Multi-Currency Flow | NetSuite Implementation Guide

PREREQUISITES

NetSuite Setup Requirements

Required features, configuration, and navigation paths for multi-currency transactions.

Required Features

Setup › Company › Enable Features › Company subtab

Feature	Location	Purpose
Multiple Currencies	Company subtab	Enables foreign currency transactions
Currency Exchange Rate Integration	Company subtab	Auto-updates rates from provider (optional)

⚠️ Important: Feature Lock

Once Multiple Currencies is enabled and transactions are posted, it cannot be disabled. Test thoroughly in Sandbox first.

Key Navigation Paths

Task	Navigation Path
Add/Edit Currencies	`Lists > Accounting > Currencies`
Manage Exchange Rates	`Lists > Accounting > Currency Exchange Rates`
Revalue Open Balances	`Transactions > Financial > Revalue Open Foreign Currency Balances`
Set Base Currency	`Setup > Company > Company Information`
Currency Preferences	`Setup > Accounting > Accounting Preferences > General subtab`
FX Variance Accounts	`Setup > Accounting > Accounting Preferences > Order Management`

Account Setup for FX Gains/Losses

Lists › Accounting › Accounts › New

Create these accounts (if not auto-created):

Account Name	Type	Subtype
Unrealized Currency Gain	Other Income	Unrealized Gain
Unrealized Currency Loss	Other Expense	Unrealized Loss
Realized Currency Gain	Other Income	Realized Gain
Realized Currency Loss	Other Expense	Realized Loss

💡 Mapping FX Accounts

Assign these accounts at Setup > Accounting > Accounting Preferences > Order Management under Currency Gain/Loss fields.

SuiteAnswers References

Topic	Article ID	Title
Revaluation	14972	Revalue Open Foreign Currency Balances
Setup	43498	Setting Up Multiple Currencies
Exchange Rates	10279	Currency Exchange Rate Types
Consolidation	42620	Currency Conversion for Financial Statements

ℹ️ Access SuiteAnswers

Search article IDs at Help > SuiteAnswers or visit suiteanswers.custhelp.com with NetSuite credentials.

Section P.1

Multi-Currency Overview

Understanding FX rates, translation, and when gains/losses are recognized.

Scenario: Global Trading Company

Apex Global Trading is a US-based company (base currency: USD) that:

Purchases electronic components from a German supplier (invoiced in EUR)
Sells finished products to a UK customer (invoiced in GBP)
Reports all financials in USD

Key Transaction Flow

MULTI-CURRENCY TRANSACTION FLOW

flowchart LR
    subgraph PURCHASE["🇪🇺 PURCHASE (EUR)"]
        A["PO Created
€10,000"] --> B["Bill Received
€10,000"]
        B --> C["Payment Made
€10,000"]
    end

    subgraph SALE["🇬🇧 SALE (GBP)"]
        D["SO Created
£15,000"] --> E["Invoice Sent
£15,000"]
        E --> F["Payment Received
£15,000"]
    end

    subgraph REPORTING["🇺🇸 REPORTING (USD)"]
        G["Period End
Revaluation"]
        H["Financial
Statements"]
    end

    PURCHASE --> REPORTING
    SALE --> REPORTING

    style PURCHASE fill:#dbeafe,stroke:#3b82f6,stroke-width:2px,color:#1a1a1a
    style SALE fill:#dcfce7,stroke:#22c55e,stroke-width:2px,color:#1a1a1a
    style REPORTING fill:#fef3c7,stroke:#f59e0b,stroke-width:2px,color:#1a1a1a
    style A fill:#3b82f6,stroke:#2563eb,color:#fff
    style B fill:#3b82f6,stroke:#2563eb,color:#fff
    style C fill:#3b82f6,stroke:#2563eb,color:#fff
    style D fill:#22c55e,stroke:#16a34a,color:#fff
    style E fill:#22c55e,stroke:#16a34a,color:#fff
    style F fill:#22c55e,stroke:#16a34a,color:#fff
    style G fill:#f59e0b,stroke:#d97706,color:#1a1a1a
    style H fill:#f97316,stroke:#ea580c,color:#fff

ℹ️ Key Multi-Currency Concepts

Transaction Rate: Exchange rate at the time of the transaction
Revaluation Rate: Period-end rate for balance sheet accounts
Unrealized Gain/Loss: From revaluation of open balances (temporary)
Realized Gain/Loss: From settling transactions at different rates (permanent)

Exchange Rates for This Example

Date	Event	EUR/USD	GBP/USD
Jan 5	PO Created	1.0850	1.2700
Jan 10	SO Created / Invoice Sent	1.0900	1.2750
Jan 15	Vendor Bill Received	1.0920	1.2780
Jan 31	Period End Revaluation	1.0800	1.2650
Feb 5	Customer Payment Received	1.0750	1.2600
Feb 10	Vendor Payment Made	1.0700	1.2550

Section P.2

Purchase Order (EUR)

Creating a purchase order in a foreign currency.

Create Purchase Order

Transactions › Purchases › Enter Purchase Orders

PURCHASE ORDER #PO-2025-00201
═══════════════════════════════════════════════════════════════

Vendor:           TechParts GmbH (Germany)
Currency:         EUR (Euro)
Date:             January 5, 2025
Expected Receipt: January 20, 2025

LINE ITEMS:
───────────────────────────────────────────────────────────────
Line  Item              Qty    Unit Price    Amount (EUR)
───────────────────────────────────────────────────────────────
1     CHIP-MCU-32       100    €50.00        €5,000.00
2     SENSOR-TEMP-PRO   50     €100.00       €5,000.00
───────────────────────────────────────────────────────────────
                               TOTAL         €10,000.00
═══════════════════════════════════════════════════════════════

EXCHANGE RATE (Jan 5):
EUR/USD: 1.0850
USD Equivalent: $10,850.00

STATUS: Pending Receipt

💡 PO Exchange Rate

The PO records the rate at creation for reference, but no GL entries occur until the bill is received. The actual GL posting will use the rate at bill entry date.

Section P.3

Sales Order & Invoice (GBP)

Creating a sales order and invoice in British Pounds.

Create Sales Order

Transactions › Sales › Enter Sales Orders

SALES ORDER #SO-2025-00301
═══════════════════════════════════════════════════════════════

Customer:         Britannia Electronics Ltd (UK)
Currency:         GBP (British Pound)
Date:             January 10, 2025
Requested Ship:   January 25, 2025

LINE ITEMS:
───────────────────────────────────────────────────────────────
Line  Item              Qty    Unit Price    Amount (GBP)
───────────────────────────────────────────────────────────────
1     PROD-SENSOR-KIT   25     £600.00       £15,000.00
───────────────────────────────────────────────────────────────
                               TOTAL         £15,000.00
═══════════════════════════════════════════════════════════════

EXCHANGE RATE (Jan 10):
GBP/USD: 1.2750
USD Equivalent: $19,125.00

STATUS: Pending Fulfillment

Invoice Generated

Transactions › Sales › Create Invoices

INVOICE #INV-2025-00301
═══════════════════════════════════════════════════════════════

Customer:         Britannia Electronics Ltd
Currency:         GBP
Invoice Date:     January 10, 2025
Due Date:         February 9, 2025 (Net 30)

LINE ITEMS:
───────────────────────────────────────────────────────────────
Line  Item              Qty    Unit Price    Amount (GBP)
───────────────────────────────────────────────────────────────
1     PROD-SENSOR-KIT   25     £600.00       £15,000.00
───────────────────────────────────────────────────────────────
                               TOTAL         £15,000.00
═══════════════════════════════════════════════════════════════

EXCHANGE RATE (Jan 10): GBP/USD = 1.2750
USD EQUIVALENT: $19,125.00

GL Impact - Invoice (at transaction rate 1.2750)

Dr: Accounts Receivable (GBP) $19,125.00

Cr: Revenue - Product Sales $19,125.00

Note: Revenue is recorded in USD at the transaction date rate. A/R is recorded in both GBP (£15,000) and USD ($19,125).

Section P.4

Vendor Bill Received (EUR)

Receiving and posting the vendor bill with current exchange rate.

Enter Vendor Bill

Transactions › Purchases › Enter Bills

VENDOR BILL #BILL-2025-00201
═══════════════════════════════════════════════════════════════

Vendor:           TechParts GmbH
Currency:         EUR
Bill Date:        January 15, 2025
Due Date:         February 14, 2025 (Net 30)
Linked PO:        PO-2025-00201

LINE ITEMS:
───────────────────────────────────────────────────────────────
Line  Item              Qty    Unit Price    Amount (EUR)
───────────────────────────────────────────────────────────────
1     CHIP-MCU-32       100    €50.00        €5,000.00
2     SENSOR-TEMP-PRO   50     €100.00       €5,000.00
───────────────────────────────────────────────────────────────
                               TOTAL         €10,000.00
═══════════════════════════════════════════════════════════════

EXCHANGE RATE (Jan 15): EUR/USD = 1.0920
USD EQUIVALENT: $10,920.00

Note: Rate changed from 1.0850 (PO date) to 1.0920 (Bill date)

GL Impact - Vendor Bill (at transaction rate 1.0920)

Dr: Inventory Asset $10,920.00

Cr: Accounts Payable (EUR) $10,920.00

Note: A/P is recorded in both EUR (€10,000) and USD ($10,920). The USD amount will be revalued at period end.

ℹ️ Inventory Costing Note

Inventory is recorded at the USD equivalent at the bill date. If using standard costing, any difference would create a Purchase Price Variance. The inventory value does not change with subsequent FX movements - only A/P is revalued.

Section P.5

Period-End Revaluation

Revaluing open foreign currency balances at month end.

January 31 Currency Revaluation

Transactions › Financial › Revalue Open Foreign Currency Balances

At January 31, we have two open foreign currency balances:

A/R (GBP): £15,000 open invoice
A/P (EUR): €10,000 open bill

REVALUATION PROCESS

flowchart TB
    A["📊 Open FC Balances"] --> B["🔄 Apply Period-End Rates"]
    B --> C["📈 Compare to Book Value"]
    C --> D{"Difference?"}
    D -->|"Higher"| E["📗 Unrealized Gain"]
    D -->|"Lower"| F["📕 Unrealized Loss"]
    E --> G["Journal Entry"]
    F --> G
    G --> H["Next Period:
Auto-Reverse"]

    style A fill:#3b82f6,stroke:#2563eb,color:#fff
    style B fill:#8b5cf6,stroke:#7c3aed,color:#fff
    style C fill:#6366f1,stroke:#4f46e5,color:#fff
    style D fill:#fef3c7,stroke:#f59e0b,color:#1a1a1a
    style E fill:#dcfce7,stroke:#22c55e,color:#1a1a1a
    style F fill:#fee2e2,stroke:#ef4444,color:#1a1a1a
    style G fill:#ec4899,stroke:#db2777,color:#fff
    style H fill:#fef3c7,stroke:#f59e0b,color:#1a1a1a

A/R Revaluation (GBP)

A/R REVALUATION - GBP
═══════════════════════════════════════════════════════════════

Open Balance:     £15,000.00

Original Rate (Jan 10):     1.2750
Original USD Value:         $19,125.00

Period-End Rate (Jan 31):   1.2650
Revalued USD Value:         $18,975.00

CHANGE:
───────────────────────────────────────────────────────────────
Original Value:             $19,125.00
Revalued Value:             $18,975.00
───────────────────────────────────────────────────────────────
UNREALIZED LOSS:             ($150.00)

Reason: GBP weakened against USD (1.2750 → 1.2650)
        The £15,000 receivable is now worth less in USD.

GL Impact - A/R Revaluation

Dr: Unrealized FX Loss $150.00

Cr: Accounts Receivable (FX Adjustment) $150.00

This entry auto-reverses on Feb 1.

A/P Revaluation (EUR)

A/P REVALUATION - EUR
═══════════════════════════════════════════════════════════════

Open Balance:     €10,000.00

Original Rate (Jan 15):     1.0920
Original USD Value:         $10,920.00

Period-End Rate (Jan 31):   1.0800
Revalued USD Value:         $10,800.00

CHANGE:
───────────────────────────────────────────────────────────────
Original Value:             $10,920.00
Revalued Value:             $10,800.00
───────────────────────────────────────────────────────────────
UNREALIZED GAIN:              $120.00

Reason: EUR weakened against USD (1.0920 → 1.0800)
        The €10,000 payable now costs less in USD to settle.

GL Impact - A/P Revaluation

Dr: Accounts Payable (FX Adjustment) $120.00

Cr: Unrealized FX Gain $120.00

This entry auto-reverses on Feb 1.

⚠️ January P&L Impact

Net unrealized FX impact for January:

Unrealized Loss (A/R): ($150.00)
Unrealized Gain (A/P): $120.00
Net Unrealized Loss: ($30.00)

These amounts reverse on Feb 1 and are replaced by actual realized gains/losses when payments occur.

Section P.6

Customer Payment Received (GBP)

Receiving payment and recognizing realized FX gain/loss.

Payment Received

Transactions › Customers › Accept Customer Payments

CUSTOMER PAYMENT #PMT-2025-00301
═══════════════════════════════════════════════════════════════

Customer:         Britannia Electronics Ltd
Payment Date:     February 5, 2025
Payment Method:   Wire Transfer

PAYMENT DETAILS:
───────────────────────────────────────────────────────────────
Amount Received (GBP):      £15,000.00
Exchange Rate (Feb 5):      1.2600

Amount in USD:              $18,900.00

Applied To:
  Invoice INV-2025-00301:   £15,000.00 / $18,900.00 (Paid in Full)

Realized FX Calculation

REALIZED FX CALCULATION - CUSTOMER PAYMENT
═══════════════════════════════════════════════════════════════

Original Invoice (Jan 10):
  GBP Amount:               £15,000.00
  Rate:                     1.2750
  USD Booked:               $19,125.00

Payment Received (Feb 5):
  GBP Amount:               £15,000.00
  Rate:                     1.2600
  USD Received:             $18,900.00

REALIZED LOSS:
───────────────────────────────────────────────────────────────
USD Booked (A/R):           $19,125.00
USD Received:               $18,900.00
───────────────────────────────────────────────────────────────
REALIZED FX LOSS:            ($225.00)

This is a permanent loss - the GBP weakened between
invoice date and payment date.

GL Impact - Customer Payment with FX Loss

Dr: Cash (Bank - USD) $18,900.00

Dr: Realized FX Loss $225.00

Cr: Accounts Receivable (GBP) $19,125.00

🎯 Consultant Tip: FX Loss Analysis

The realized loss of $225 represents:

GBP rate moved from 1.2750 to 1.2600 (-1.18%)
On £15,000, this equals $225 less received
Consider: hedging strategies, faster collection terms, or pricing adjustments for UK customers

Section P.7

Vendor Payment Made (EUR)

Making payment and recognizing realized FX gain.

Payment Made

Transactions › Bank › Make Payments

VENDOR PAYMENT #VPMT-2025-00201
═══════════════════════════════════════════════════════════════

Vendor:           TechParts GmbH
Payment Date:     February 10, 2025
Payment Method:   Wire Transfer (EUR)

PAYMENT DETAILS:
───────────────────────────────────────────────────────────────
Amount Paid (EUR):          €10,000.00
Exchange Rate (Feb 10):     1.0700

Amount in USD:              $10,700.00

Applied To:
  Bill BILL-2025-00201:     €10,000.00 / $10,700.00 (Paid in Full)

Realized FX Calculation

REALIZED FX CALCULATION - VENDOR PAYMENT
═══════════════════════════════════════════════════════════════

Original Bill (Jan 15):
  EUR Amount:               €10,000.00
  Rate:                     1.0920
  USD Booked:               $10,920.00

Payment Made (Feb 10):
  EUR Amount:               €10,000.00
  Rate:                     1.0700
  USD Paid:                 $10,700.00

REALIZED GAIN:
───────────────────────────────────────────────────────────────
USD Booked (A/P):           $10,920.00
USD Paid:                   $10,700.00
───────────────────────────────────────────────────────────────
REALIZED FX GAIN:             $220.00

This is a permanent gain - the EUR weakened between
bill date and payment date, so we paid less USD.

GL Impact - Vendor Payment with FX Gain

Dr: Accounts Payable (EUR) $10,920.00

Cr: Cash (Bank - USD) $10,700.00

Cr: Realized FX Gain $220.00

Section P.8

FX Impact Summary

Complete analysis of currency impacts across all transactions.

Total FX Impact Analysis

FX IMPACT SUMMARY - APEX GLOBAL TRADING
═══════════════════════════════════════════════════════════════

JANUARY (Unrealized - Auto-reversed Feb 1):
───────────────────────────────────────────────────────────────
A/R Revaluation (GBP):        ($150.00)  Loss
A/P Revaluation (EUR):          $120.00  Gain
───────────────────────────────────────────────────────────────
Net January Unrealized:         ($30.00)

FEBRUARY (Realized - Permanent):
───────────────────────────────────────────────────────────────
Customer Payment (GBP):        ($225.00)  Loss
Vendor Payment (EUR):           $220.00  Gain
───────────────────────────────────────────────────────────────
Net February Realized:           ($5.00)

═══════════════════════════════════════════════════════════════
TOTAL REALIZED FX IMPACT:        ($5.00)
═══════════════════════════════════════════════════════════════

The unrealized amounts were estimates that reversed.
The realized amounts are the actual economic impact.

Transaction Summary in USD

Transaction	Foreign	USD Booked	USD Settled	FX Impact
Sale to UK Customer	£15,000	$19,125	$18,900	($225) Loss
Purchase from German Vendor	€10,000	$10,920	$10,700	$220 Gain
Net Realized FX Impact				($5) Loss

🎯 Key Takeaways

Revenue is fixed at invoice date: $19,125 revenue recorded regardless of when GBP is received
Inventory cost is fixed at bill date: $10,920 inventory cost regardless of when EUR is paid
FX impacts P&L separately: Gains/losses flow through FX accounts, not Revenue or COGS
Monitor currency exposure: £15,000 A/R was exposed from Jan 10 to Feb 5 (26 days)
Consider hedging: Forward contracts or options can lock in rates to eliminate uncertainty

GL Account Summary

GL IMPACT BY ACCOUNT
═══════════════════════════════════════════════════════════════

BALANCE SHEET:
───────────────────────────────────────────────────────────────
1000 Cash                       $8,200.00 DR  ($18,900 - $10,700)
1100 Accounts Receivable             $0.00     (closed)
1200 Inventory                 $10,920.00 DR
2000 Accounts Payable                $0.00     (closed)
───────────────────────────────────────────────────────────────

INCOME STATEMENT:
───────────────────────────────────────────────────────────────
4000 Revenue - Product Sales   $19,125.00 CR
5000 Cost of Goods Sold        $10,920.00 DR  (when sold)
───────────────────────────────────────────────────────────────
     Gross Profit               $8,205.00

7100 Realized FX Gain            $220.00 CR
7200 Realized FX Loss            $225.00 DR
───────────────────────────────────────────────────────────────
     Net FX Loss                  ($5.00)

═══════════════════════════════════════════════════════════════
NET MARGIN (after FX):          $8,200.00
═══════════════════════════════════════════════════════════════