Why is my consolidated exchange rate wrong in OneWorld close?
Most commonly, the Consolidated Exchange Rates table wasn't updated for the current period before consolidation ran, or the wrong rate type (Current, Average, or Historical) was applied for the account being translated. Both cause child-subsidiary amounts to roll up incorrectly into the parent's consolidated financials.
By Zuny Fester, Head of Operations and MarketingPart of the month-end close guide.
| Most common cause | Consolidated Exchange Rates table not updated for the current period |
|---|---|
| Second cause | Wrong rate type applied (Current, Average, or Historical) |
| Where the table lives | Lists > Accounting > Consolidated Exchange Rates |
| When it should be updated | As part of period close tasks, every period |
The three rate types, and why using the wrong one matters
NetSuite's Consolidated Exchange Rates table maintains three rate types per period and subsidiary pair: Current (the balance-sheet rate at period end), Average (typically used for income statement accounts, reflecting the average rate across the period), and Historical (fixed at the rate when a specific transaction, like equity, occurred). Applying the Current rate to an income statement account, or vice versa, produces a translated number that's technically calculated but conceptually wrong for that account type.
Why it's most often just a stale table
The Consolidated Exchange Rates table doesn't update itself automatically — it needs to be maintained as part of period close tasks, each period, for every subsidiary-to-parent currency pair in use. When this maintenance step is skipped or delayed, consolidation runs against a stale rate from a prior period, producing a translated balance that doesn't reflect actual currency movement for the current period.
Next step
Map the finance workflow with the most exposure and prove the automation path.
Bring the invoice, contract, payment reconciliation, or customer finance workflow you have to defend at audit. Loopfour can map the trigger, controls, integrations, and approval loop.
Checklist
Diagnosing a wrong consolidated exchange rate
- Check whether the Consolidated Exchange Rates table was updated for the current period
- Confirm the correct rate type (Current, Average, Historical) is applied per account type
- Verify the elimination subsidiary's consolidated exchange rate is set to 1 relative to its parent
- Re-run consolidation only after the rate table is corrected, not before
Frequently Asked Questions
Sources
Related
Topic
Month-End Close
Month-end close is the set of accounting tasks a company runs after a calendar month ends to turn raw transactions into a finished, trustworthy set of financial statements: reconciling subledgers, boo…
Read moreHow-to
How do I run intercompany elimination during period close in NetSuite?
Complete currency revaluation for every subsidiary first, then run NetSuite's Intercompany Elimination process, which nets out intercompany receivables, payables, and transactions so they don't double-count in the consolidated financials. Any currency revaluation left undone before elimination runs is the most common reason a residual balance is left over afterward.
Read moreDiagnostic
What causes a currency delta that won't eliminate in intercompany close?
Almost always, currency revaluation either didn't run before elimination, used a stale exchange rate, or the elimination subsidiary's consolidated exchange rate isn't set to 1 relative to its direct parent. Any of these leaves the two sides of an intercompany balance valued at different rates, so they can't net to exactly zero.
Read more