How FCCS_Mvmts_FX_Opening and FCCS_Mvmts_FX_Movement are calculated under the YTD translation method
In our application, the default translation method is set to Year-To-Date (YTD).
FX_SubTotal = FX_Opening + FX_Movement. I want to understand how the system calculates FX_Opening and FX_Movement under this method.
My Understanding
1. FX_Opening
- January 2025: (Ending Rate Jan25 − Ending Rate Dec24) × Opening Balance
- February 2025: (Ending Rate Feb25 − Ending Rate Dec24) × Opening Balance
2. FX_Movement
- January 2025: (Ending Rate Jan25 − Avg Rate Jan25) × Current Period Movement
- February 2025: (Ending Rate Feb25 − Avg Rate Feb25) × Current Period Movement
Observation:
a. In January 2025, the system’s calculation matches my manual formulas.
b. In February 2025, my manual calculation produces the same FX_SubTotal as the system, but the split between FX_Opening and FX_Movement does not match.