Ref 2022-004: Foreign exchange translation methodology (repeat of prior year finding 2021-005, 2020-006 and 2019-006) (significant deficiency)Federal Agency: AllProgram: AllAssistance Listing: AllAward #: AllAward year: FY22, FY21, FY20, FY19Pass-through: All applicableManagement confirms ...
Ref 2022-004: Foreign exchange translation methodology (repeat of prior year finding 2021-005, 2020-006 and 2019-006) (significant deficiency)Federal Agency: AllProgram: AllAssistance Listing: AllAward #: AllAward year: FY22, FY21, FY20, FY19Pass-through: All applicableManagement confirms that the requirement to input and apply daily foreign exchange rates into the new ERP system to ensure compliance with accounting standards and Plan?s accounting policies remains in place.As in prior years, management calculated the impact of using incorrect exchange rates during FY22 and confirmed that differences were immaterial. Global Hub Treasury continues to monitor Country Office exchange rates for correctness and volatility and takes action to make changes during the month. Management confirms that the BPC system-generated figures for CTA are now fully understood, and documentation has been shared with PwC as in the prior year to explain the logic. Furthermore, PwC has agreed with the methodology used to calculate the CTA figure used in various note workings in FY22 (mainly WW Note 6 ? Reserves and the cash flow statement). Miscellaneous balancing items are now down to approximately ?550k, and the origins of these balances are known. Work will be undertaken to fully clear these amounts for FY23.It should be noted that the current SAP transaction system will be updated prior to 30 June 2023 to enable an automated upload of daily foreign exchange rates, to remedy this deficiency prior to starting the new financial year (FY23). The daily upload of foreign exchange rates will also be included in the new ERP system design as part of the Y.O.D.A programme. This should ensure compliance with the accounting standards and Plan?s accounting policies going forward.(Corrective actions introduced in FY22 & FY23 will be project planned and reviewed through the FY23 year-end close, and these will be closely monitored during FY24 to a final resolution with an anticipated closure, if not earlier, by 30 June, 2024 . Chief Financial Officer, Celine Thibaut, +33672261874)