SBIE Average Rule calculation in Translated currency is Likely Off
Summary:
The SBIE Average rule in Translated currency looks off. After translating the opening & closing balance amounts, the average value is also translated using the average FX rate, instead of taking the average of the translated opening & closing balance amounts. Please see example below and help suggest any workaround for the below.
Content (please ensure you mask any confidential information):
For example: in screenshot below,
Entity Currency of "Average-SBIE Tangible assets" is 151727 (As expected)
SGD reporting of "Average -SBIE Tangible assets" is calculated as Entity currency * Avg FX rate (151727 * 0.881849) = 133800 as shown below in automated column
Manual calculation is (254080 + 13644)/2 =133862
Globe income automation configuration