Best process for overrides when there are multiple hierarchies?

Summary:

We have multiple hierarchies for entity where the parents in the shared hierarchy may have a different currency. Was wondering if there was a solution other than having users enter the override twice.

Content (please ensure you mask any confidential information):

For example, The parent Mercer Australia and its base entities are in AUD currency. Users enter an dollar override to any of the base entities and we translate the parent in 1st hierarchy. The parent of Mercer Australia is USD in the fist hierarchy. Mercer Australia is also in a shared hierarchy, where its parent is AUD.

As a result the override entered and translated in the first hierarchy does not carry over into the shared hierarchy. My solution currently, is having users do override process once, then I clean up differences to shared after based on vlookup of same parent which has different values in the override accounts.