How to set up multi-currency and consolidated exchange rates in NetSuite OneWorld

Prerequisites

These steps assume the Administrator role with Use Classic Interface enabled. NetSuite menu paths are role- and centre-dependent, so a custom role may surface different navigation.

• A NetSuite OneWorld account with the subsidiary hierarchy and each subsidiary's base currency already set.
• The Administrator role, or a role with the Currencies, Accounting Lists and Manage Accounting Periods permissions.
• The full list of currencies your subsidiaries transact in and the rate source (manual entry or an exchange-rate provider), agreed before go-live.

Steps

1. Enable Multiple Currencies. Go to Setup > Company > Enable Features > Company subtab and enable Multiple Currencies (this sits alongside the OneWorld / Subsidiaries capability). This switches on the currency records, the exchange-rate tables and the consolidated exchange rate engine.
2. Create the currency records. Go to Lists > Accounting > Currencies > New and create one record per currency your subsidiaries use — ISO code, symbol and display format. Every subsidiary base currency and every foreign currency you transact in needs a record before it can be used.
3. Maintain transaction exchange rates. Go to Lists > Accounting > Currency Exchange Rates. The Current rate here is what NetSuite applies when a foreign-currency transaction posts into a subsidiary's base currency. Enter rates manually per date, or connect an exchange-rate provider so they update automatically.
4. Review consolidated exchange rates each period. Go to Lists > Accounting > Consolidated Exchange Rates. NetSuite creates a row per accounting period for each child-to-parent subsidiary pair, with three rates: Current (applied to balance sheet accounts), Average (income statement) and Historical (equity). Review and override these before running any consolidated report for the period.
5. Revalue open currency balances at close. As part of the period close, run Revalue Open Currency Balances before consolidation so unrealised gains and losses on open foreign-currency balances post to the period being closed. This keeps the base-currency figures that feed consolidation accurate.
6. Run consolidated financial reports. Run financial reports in the parent (consolidated) subsidiary context. NetSuite translates each subsidiary's base-currency balances to the parent base currency using the period's consolidated exchange rates; the difference between rate types posts to the cumulative translation adjustment (CTA) account.

Gotchas

• Transaction exchange rates and consolidated exchange rates are different tables doing different jobs — transaction rates convert a posting into a subsidiary's base currency; consolidated rates translate that base currency up to the parent. Fixing a consolidation variance by editing the transaction rate is a common wrong turn.
• Consolidated exchange rates are auto-seeded but editable per period. A default or stale rate left unreviewed on a new period silently skews the consolidated reports — review them every period as a close step.
• The Historical rate translates equity accounts. If it is left at the wrong value, opening equity translates incorrectly and the consolidated balance sheet won't tie — the difference lands in the cumulative translation adjustment (CTA) account.
• Consolidated exchange rate rows exist per accounting period, created when the periods are generated. If accounting periods aren't set up, the rows don't exist and consolidated reports have nothing to translate with.
• A subsidiary's base currency is fixed once it has any transaction, so the currencies feeding consolidation can't be corrected later by editing rates — get the base currencies right when you build the hierarchy.

Where this bites in an implementation

This bites at the first consolidated month-end. If the consolidated exchange rates were never reviewed, or the historical rate was left at a default, the consolidated P&L and balance sheet show variances that look like posting errors but are really translation setup — and a large, unexplained CTA balance is the tell. Unwinding it means restating each prior period's rates and re-running the reports. In an implementation, make currency-rate maintenance and a consolidated-rate review explicit monthly close steps from the first period, not a problem you discover during reporting.

Frequently asked questions

What is the difference between currency exchange rates and consolidated exchange rates?

Currency (transaction) exchange rates convert a foreign-currency transaction into the subsidiary's base currency at the moment it posts. Consolidated exchange rates translate each subsidiary's base-currency balances up to the parent's base currency for consolidated reporting. They are different tables for different purposes — both have to be right.

Why doesn't my consolidated balance sheet tie after translation?

Usually the historical rate on equity, or a default or stale consolidated rate left unreviewed for the period. NetSuite posts the translation difference to the cumulative translation adjustment (CTA) account, so a large or unexpected CTA balance almost always points to a consolidated-rate setup issue rather than a booking error.

Can I override the consolidated exchange rate NetSuite calculates?

Yes. Consolidated exchange rates are editable per period for each subsidiary-to-parent pair. Override the rate before you run consolidated reports for that period; if you change it after reporting, re-run the reports so they pick up the corrected rate.