Skip to main content
Question

Currency Revaluation - Revaluation posted on $0 balance in account


Forum|alt.badge.img+7

Hi,


We have had an issue reported where the GL account had a $0 balance however, when the currency revaluation process was run at end of month, the account posted a very large revaluation loss.

 

Has anyone here had something similar?

 

Many thanks​​​​​​

Forum|alt.badge.img+2
  • Sidekick (Customer)
  • January 30, 2025

Hi, 

 

Were you able to get to the bottom of this ? 

 

We are having the same issue. The unmatched amount on the account is the amount of the revaluation voucher. 

 

Thank you 


Forum|alt.badge.img+19

Hi Aurelia, 

See your currency revaluation settings for the given account. 

If your account, such as AR Trade has the setting to post back to the original account, then at month end, AR Trade (open items) will not match GL due to the revaluation value. This can be a reconciling item (reason for the difference) or if the revaluation is posted to another account via posting control, then AR should match. 

As for the original issue - ​@taenaren

 

Depending on the account and “Used in Ledger” this drives the currency revaluation.   Assume used in ledger was GL, this uses the GL balance for the revaluation.  However, if used in accounts receivable (or AP), IFS then uses the invoices as the source for the revaluation. Hypothetically, you could have hundreds of open invoices, yet GL could have no balance. The revaluation will calculate gain or loss based on the open invoices, not GL. 

Typically, the AR / AP trade accounts should have the revaluation based on the invoices not the GL balance (used in ledger).  

Best regards, 

Thomas


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings