You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!