If your company operates in multiple countries, foreign exchange is more than an accounting detail. The exchange rates NetSuite uses affects your transactions, month-end close, consolidated financial statements, and ultimately the numbers you report. For CFOs leading multi‑subsidiary organizations in NetSuite OneWorld, understanding how NetSuite handles foreign exchange in OneWorld helps you avoid surprises and gives you confidence that your financial reporting reflects what’s actually happening across the business..
At Opal Creek, we encourage CFOs to think about FX not as a technical setting but as a control environment. It touches every corner of the business: revenue, expenses, cash, intercompany, and equity. When rates move, the entire financial story moves with them.
Daily FX Rates via Xignite
NetSuite uses a subscription to Xignite to pull daily foreign exchange rates directly into the system. These rates populate the Currency Exchange Rates table and become the official “spot rate” for all foreign‑currency transactions entered that day. Using a consistent third-party rate source helps ensure transactions are valued consistently across subsidiaries and simplifies audit support.
How NetSuite Applies Daily Spot Rates
Every foreign‑currency transaction — vendor bill, invoice, payment, journal entry — is recorded using the Xignite spot rate for its transaction date. That establishes the base‑currency value at initial recognition and establishes the baseline for future realized gains or losses.
Month‑End Rates: Closing vs. Weighted Average
At month end, NetSuite uses two distinct rate concepts aligned with US GAAP and International Finance Reporting Standards (IFRS) guidance.
The balance sheet uses the closing rate — the FX rate on the last day of the accounting period — to translate monetary assets and liabilities. The income statement uses a weighted average rate for the month to translate revenues and expenses that occur throughout the period.
Using different rates for the balance sheet and income statement aligns with GAAP and IFRS translation requirements and produces accurate consolidated reporting.
The Balance Sheet Revaluation Process
Month‑end revaluation is one of the most important controls in OneWorld. Revaluation keeps open foreign currency balances current without changing the underlying transactions. As part of the close process, NetSuite revalues open foreign‑currency transactions and balance sheet accounts, posts unrealized FX gain/loss entries, and automatically reverses them on the first day of the next period.
Strategically, this protects the balance sheet from stale FX values and keeps your financials aligned with current market conditions.
Realized and Unrealized FX Gains and Losses
NetSuite treats gains and losses differently depending on whether a transaction has been settled. When an invoice or bill is paid, NetSuite compares the original transaction rate to the settlement rate and records a realized gain or loss. At month end, open foreign currency balances are revalued to produce unrealized gains or losses.
Realized FX affects earnings; unrealized FX affects valuation. Both are essential for understanding how currency movement impacts performance.
Understanding the CTA Account
The Cumulative Translation Adjustment (CTA) account captures translation adjustments when consolidating foreign subsidiaries into the parent’s reporting currency. It includes translation of subsidiary balance sheets at closing rates, income statements at weighted average rates, and movements from foreign‑currency equity accounts.
The CTA is an equity account — not a gain/loss account — and represents the cumulative effect of translating foreign operations over time. It accumulates the translation differences that arise when NetSuite consolidates foreign subsidiaries. Those differences are recorded in equity rather than as gains or losses, allowing the income statement to reflect operating performance instead of changes caused solely by currency translation.
A Real‑World Example: USD Parent, GBP Subsidiary
Imagine a U.S. parent company consolidating a U.K. subsidiary. Daily GBP transactions use the Xignite spot rate. Month‑end revaluation adjusts GBP monetary balances to the closing USD/GBP rate. The U.K. subsidiary’s P&L is translated at the weighted average USD/GBP rate. The CTA absorbs the difference between closing‑rate balance sheet translation and average‑rate P&L translation. The result is a clean consolidation.
A Final Thought
Financial exchange configuration is something we find ourselves going over with every multi-subsidiary client. It’s easy to ignore until it looks like something doesn't reconcile. Understanding how NetSuite applies to daily rates, revalues balances, and translates subsidiaries makes it much easier to troubleshoot issues and trust your consolidated reporting.
If you ever want to talk through your FX setup or consolidation process, Opal Creek is always happy to help.
