African CFOs running multi-country operations rarely deal with just two currencies. A typical INNOVIOR client touches USD, EUR, KES, UGX, TZS, RWF, and sometimes MUR or ZAR — all in the same close cycle. NetSuite handles this well when it's set up right, and badly when it isn't. This guide walks through what "set up right" actually looks like.
The three layers of FX in NetSuite
Multi-currency in NetSuite isn't one feature — it's three layered behaviours, and most pain comes from confusing which layer is responsible for what.
Layer 1 — Transaction currency
Every transaction is denominated in a transaction currency, which can differ from the subsidiary's base currency. NetSuite stores both: the foreign-currency amount and the base-currency equivalent at the exchange rate on that date. Get this wrong (e.g., using a stale rate at the point of transaction) and every downstream layer inherits the error.
Layer 2 — Subsidiary base currency revaluation
At period close, monetary balances denominated in non-base currencies get revalued against the period-end rate. This is where unrealised FX gain or loss is posted to the P&L (or balance sheet, depending on the account's revaluation setting). Set up Currency Revaluation Account preferences once, audit monthly, and you'll have far fewer surprises.
Layer 3 — Consolidation FX
At the parent level, each subsidiary's base currency is translated into the consolidation currency. Average rates for income statement items, period-end rates for balance sheet items, equity translated at historical rates. The CTA (Cumulative Translation Adjustment) is the plug.
Five practical setup decisions
- Exchange rate source. Define one source of truth — ECB, FRB, or your central bank — and automate the daily pull. Don't let people type rates into transactions.
- Currency types. Mark rates as Spot, Period End, or Historical. NetSuite will use the right one for the right context (revaluation vs consolidation vs intercompany).
- Revaluation accounts. Decide per-account whether unrealised FX is posted to P&L (the default for most operating accounts) or balance sheet (for some equity-adjacent accounts).
- Intercompany currency policy. Settle intercompany in one designated currency and document it. Multi-leg intercompany in mixed currencies is a debugging nightmare at year-end.
- Period-end rate locking. Once a period is closed, lock the rates. Forensic accounting reopens nothing more often than unlocked period-end rates that someone "corrected" three months later.
The reports that matter
Three saved reports every multi-currency NetSuite tenant should have:
- Trial Balance by Subsidiary in Multiple Currencies. Side-by-side: transaction currency, subsidiary base currency, consolidation currency. Lets you spot translation anomalies in seconds.
- FX Variance Report. Realised vs unrealised, P&L impact vs balance sheet impact, current period vs YTD. Live in this report at month-end.
- Open FX Exposure by Account. Lists all monetary balances in non-base currencies. Treasury teams use this for hedging decisions.
Common pitfalls (and how to avoid them)
Manual rate entry on transactions. Always use the system rate. If you need to override, do it via a journal — never on the source document.
Skipping revaluation in months with low FX volatility. Even small moves compound. Revaluate every period; don't make it optional.
Treating CTA as an error. CTA is real. Track it, explain it in your notes, don't try to "clean it up" with reclass journals.
Conflating realised and unrealised FX. They are different accounts, different stories, different audit treatment. Don't merge them on the P&L.
"We were closing on the 14th instead of the 7th every month, and 70% of that was FX-related rework. We fixed three things — automated the rate pull, locked period rates, and rebuilt the revaluation setup — and we closed on the 6th in our first month after the change." — Group CFO, INNOVIOR client (financial services)
Where to start
If you're already on NetSuite and your close cycle is dragging on FX, the first 4-hour engagement is usually enough to diagnose where in the three layers the problem lives. If you're scoping a new multi-country implementation, we model the consolidation entity and rates structure before anything else — it sets the constraint for every other design decision.
Reach out at info@innoviorafrica.co.ke or book a free consultation.
