Feature Request - FX Revaluation of Foreign Currency Balances
Transactions can be booked in foreign currencies however Financio does not have a function to revalue these foreign currency balances at month or year end. I believe any company with foreign currency balances would need to revalue the foreign currency balances for each reporting period.
This results in an odd entry where we have to reverse out the entire balance in the foreign currency using an exchange rate equivalent to the current SGD equivalent in financio, and then rebook the amount using the month end rate, in order for both the foreign currency amount and the SGD equivalent amount to be accurate. At times where the amounts are large, the FX rate entered may not be exact enough given the 6 d.p. limitation.
For e.g. after all transactions using various rate throughout the period, the USD balance is 1,000,000, and the SGD equivalent is 1,500,000. But the Month end rate is 1.35. We need to create an entry to reverse out USD 1,000,000 @ 1.50 and then another entry to rebook USD 1,000,000 @1.35. And these entries would need to be individually passed for each account in foreign currency. If the SGD Equivalent amount was 1,510,102.33 we would be unable to enter the FX rate of 1.51010233 given that it would be automatically rounded to 6 d.p. of 1.510102
Would be helpful if there is a way to insert the desired month end rates (or use financio generated rates) to automatically revalue all balances in foreign currency at period ends.
Please sign in to leave a comment.