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.
Part of the month-end close guide.
| Most common cause | Currency revaluation not run, or run with a stale rate, before elimination |
|---|---|
| Second cause | Elimination subsidiary's consolidated exchange rate isn't set to 1 vs. its parent |
| Where it posts | Cumulative Translation Adjustment - Elimination (CTA-E) account |
| Fastest check | Compare the transaction-currency and base-currency amounts on the Intercompany Elimination Report |
What a currency delta actually is
An intercompany transaction is recorded on both entities' books, often in two different currencies. Between the transaction date and the period-end date, the exchange rate between those currencies moves. If both sides of the transaction aren't revalued to the same period-end rate before elimination runs, the two amounts won't be equal and opposite, and a residual — the currency delta — is left over instead of netting cleanly to zero.
The two places this actually goes wrong
First, and most commonly, currency revaluation simply wasn't run for one or more subsidiaries before elimination — either skipped entirely, or run with an exchange rate that hadn't been updated for the current period. Second, and less obvious, an elimination subsidiary's own consolidated exchange rate has to be set to exactly 1 relative to its direct parent subsidiary; if that setting is wrong, or the elimination subsidiary's base currency and country combination doesn't match its parent's, the elimination math is comparing amounts that were never supposed to be directly comparable in the first place.
How to trace it
Pull the Intercompany Elimination Report and compare the Source Trans Amount in transaction currency against the Source Trans Amount in base currency for the specific intercompany pair showing a residual. If the base-currency amounts on the two sides of the transaction don't match despite the transaction-currency amounts being identical, that's the signature of a revaluation that either didn't run or used the wrong rate.
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.
Field mapping
Where a currency delta hides on the Intercompany Elimination Report
| Report field | What to check |
|---|---|
| Source Trans Amount (Trans Currency) | Should be equal and opposite on both sides of the intercompany pair |
| Source Trans Amount (Base Currency) | Should also be equal and opposite — if not, revaluation is the likely culprit |
| Elimination subsidiary's consolidated exchange rate | Must equal 1 relative to its direct parent subsidiary |
| CTA-E account balance | Should reflect only genuine translation adjustments, not an unresolved data error |
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 moreDiagnostic
When do Excel consolidations become too risky for month-end close?
Risk crosses from unlikely to expected once two or more are true: 4+ legal entities consolidated, 2+ reporting currencies, 3+ people editing the close workbook, or 50+ manual journal entries per close. Below those, a well-built workbook is usually manageable; above them, nothing stops a broken formula from producing a confident, wrong number.
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 more