Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity

(2) Share

Report

Posted on by MS-29042149-0

We use a consolidation entity to consolidate legal entities into one. For balance sheet accounts, we use the end of month rate, and for P&L accounts, we use the average month rate. After running the consolidation, we run the foreign currency revaluation for balance sheet accounts. We wouldn't expect any gains/losses since the transactions should already be translated with the "correct" rate. However, we still encounter quite a few gain/loss transactions after running the foreign currency revaluation.

Could anyone advise why this is happening?

I have the same question (0)

All responses (5)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (1)

Report

Why are you running FX Reval in the consolidation company? Wouldn't you do this at the operating companies and just let the transactions roll up to the consolidation company?

Was this reply helpful? Yes No
MS-29042149-0 62 on at

Like (0)

Report

Hi Frank,

This was the process we have been doing for a while. We would have thought during consolidation it would pull through the transactions and calculate them at the correct exchange rate which is setup. But, we noticed only after we run FX Revaluation in the consolidation company, this is when the balances are updated to the correct values.

If we run FX revaluation right after we consolidate the transactions, we would expect there to be no results but there are transactions that get revalued.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

You have transactions in your consolidation company in other than reporting currency? Do you have different reporting currencies setup in your operating companies? Theoretically, reporting currency should be the same in your operating (child) companies so you can consolidate the results to one currency.

Was this reply helpful? Yes No
MS-29042149-0 62 on at

Like (0)

Report

Hi Frank, in the consolidation company the reporting currency is AUD.

The four legal entities that we are consolidating to the consolidation company have the below reporting currencies:

AUD

NZD

AUD

JPN

During consolidation we have it setup for balance sheet accounts to use the consolidation close exchange rate type. For Foreign Currency Revaluation we have it setup to use the last date of the month exchange rate which should be the same as the consolidation close exchange rate. When we run consolidation, we don't expect any transactions in the Foreign Currency Revaluation, but there appear to be unrealized gain/losses even though consolidation and foreign currency revaluation uses the same rates

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

I've never run into this scenario before as all the clients I've worked with use the same reporting currency in all companies. What if you just don't run revaluation in the Consolidation company? Apart from that, I'd open a MSFT ticket to ask them to explain the logic at play in this scenario. Could be a bug.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates