MODEC, the world’s largest independent operator of offshore floating production systems for the oil and gas industry, was managing its foreign exchange (FX) hedging process manually.
Qiurong Chong, Financial Planning & Treasury Manager
In 2020, the company decided to automate this process, successfully reducing the time spent on it from three days to within one day.
Headquartered in Tokyo, MODEC is a general contractor for the engineering, procurement, construction and installation (EPCI) of floating systems for deep-sea oil production. These systems include FPSO (floating production storage and offloading) units, FSO (floating storage and offloading) units, floating liquefied natural gas (FLNG) facilities, tension-leg platforms (TLPs), semi-submersible platforms, mooring systems and new technologies to meet the challenges of gas production floaters.
As largest independent operator of FPSO’s in the world, MODEC specializes in units for offshore deep sea oil production. “Then we either sell it to our clients or own and operate it on client’s behalf for 20 to 25 years,” says Qiurong Chong, Financial Planning & Treasury Manager at MODEC. Her business unit is located in Singapore and handles the conversion and EPCI of the FPSOs. From there, majority of the constructed FPSOs are handed over to MODEC’s business unit in Brazil responsible for the operations and maintenance of the vessels. “Our operations are therefore substantially in Brazil. But we do have presence in Australia, Ghana and Vietnam too.”
Need for automation
As a global company, MODEC deals with a lot of vendors and major equipment suppliers. Chong: “Our vendors are located everywhere. Some are in China, where we usually do our transactions in US dollars. The major equipment vendors are located in Europe, such as Italy, Germany and The Netherlands. Therefore, the euro is one of the main foreign currencies. And since our functional currency is US dollars, we are exposed to a significant FX risk.”
MODEC’s finance department was managing the FX hedging process manually with the use of spreadsheets. By the end of 2019, there were approximately 350 outstanding FX forwards hedging the future cash flows of the purchase orders (POs) associated with MODEC’s projects. “The POs contain the information we need from the vendors for the FX process, including the cost in dollar value, the breakdown of the payment milestones and the expected payment date,” Chong explains.
The PO information was extracted from its system to be incorporated in an Excel overview driving their hedging activities. This was a labor-intensive process and since the expected number of FX transactions increased, MODEC decided to automate this process. Chong: “With Excel you have less control over the data integrity and only a few people had access to the account data. There were quite some governance concerns on this manual spreadsheet. We wanted to improve this process. And as our company grows, with an increasing number of projects running at the same time, the effort that we spend on updating and maintaining hundreds of transactions was too much.”
SAP TRM for straight-through-processing
Previously, all FX forwards were communicated via email, letter or phone and processed through a single cash centre between two banks. Bank accounts exist within each bank for all the currencies transacted, which total around eight for each bank. Monthly valuations are provided by the banks and upon settlement the bank automatically debits and credits MODEC’s bank accounts accordingly. GL journal entries were manually created in SAP. In the coming years, the number of FX forwards is expected to grow to 500 or more.
In the summer of 2020, MODEC Finance decided to implement SAP TRM for the straight-through-processing of FX forwards. Chong: “We asked around in the market about what system they used for their FX transactions. Our accounting migrated to SAP in 2017, which is quite recent. And since our information on vendors and POs are all in SAP, we thought: why not integrate everything together? That is why we decided to choose SAP TRM.”
Meeting the requirements
Thereafter, the new system needed to be integrated and automated. “We had been working with SAP successfully for some time and they recommended Zanders to support us. We reached out and asked Zanders for a demo. During that demo the team showed us the flow and functionalities that the TRM module in SAP could offer. It met our requirements, and we felt comfortable as Zanders could explain what we did not understand. It is important to be able to communicate with consultants in very simple terms and things that our department could understand. That is why we chose Zanders to support us in this project.”
Chong then asked Zanders to customize a program that could correctly capture the exposure positions and hedge relationships with the FX forward contracts. “Once a new PO is created, it can read that information and integrate it into the treasury module. We had quite some difficulties in trying to make the program to what it should be. The way we use SAP is not very standard, at some points, things got quite complex, but Zanders was able to resolve the complexities. Now the program is running very well. This process is expected to provide hedge accounting documentation under IFRS 9 and generate GL journal entries for monthly valuations and settlement.”
Qiurong Chong, Financial Planning & Treasury Manager
Meeting the requirements
Thereafter, the new system needed to be integrated and automated. “We had been working with SAP successfully for some time and they recommended Zanders to support us. We reached out and asked Zanders for a demo. During that demo the team showed us the flow and functionalities that the TRM module in SAP could offer. It met our requirements, and we felt comfortable as Zanders could explain what we did not understand. It is important to be able to communicate with consultants in very simple terms and things that our department could understand. That is why we chose Zanders to support us in this project.”
Chong then asked Zanders to customize a program that could correctly capture the exposure positions and hedge relationships with the FX forward contracts. “Once a new PO is created, it can read that information and integrate it into the treasury module. We had quite some difficulties in trying to make the program to what it should be. The way we use SAP is not very standard, at some points, things got quite complex, but Zanders was able to resolve the complexities. Now the program is running very well. This process is expected to provide hedge accounting documentation under IFRS 9 and generate GL journal entries for monthly valuations and settlement.”
Connected
“We kicked off the project in August 2020 with a key user training, which was very useful – it prepared us well for the whole process. After that we had four weeks of requirements gathering, which was quite intensive but very productive. We had a few challenging areas that required additional effort by Zanders to do some research. Eventually all challenges were resolved, and we went live in February this year, so the project took about a half year.”
The systems are now connected. “So far, the systems are running well. There have been some small issues here and there – then we reached out to Zanders to resolve it. Zanders consultants Michiel and Mart were really very helpful throughout the whole process. Even our hedge accounting entries are done by the system. The automation reduces the processing time from an average of three days to within one day. The main beneficial part for us is that the business has the hedge documentation available from the system. In the past, we spent hours on computing effectiveness for the hundreds of transactions. When we were using Excel, we were only doing this on a quarterly basis. Now we can do it every month.”
Next steps
Are there still any challenges to be met for MODEC Finance? Chong: “We are still trying to stabilize the work process and get the hang of the new system. Once everything is more stable, there are some things we may explore. Automating this FX transaction was a first step for us in the treasury department. We are still doing many other reports manually for our headquarters in Japan. By bringing our HQ onboard this TRM module, we can have a seamless flow of information between us and them, which reduces any lag time and the need for us to extract the reports for them.”
Would like to know more about our treasury system support in Asia? Then please contact Michiel Putman Cramer via +81 3 6892 3047.
Zanders Transfer Pricing Suite is an innovative, cloud-based solution designed for companies looking to automate the Transfer Pricing compliance of financial transactions. With over five years
Find out more
Mid 2023, Bolt successfully implemented its new full-fledged treasury management system (TMS). With assistance of Zanders consultants, the mobility company implemented Kyriba – a necessity
Find out more
In countries worldwide, associations of credit information providers play a crucial role in registering consumer-related credits. They are mandated by regulation, operate under local law and
Find out more
Zanders Transfer Pricing Suite Zanders Transfer Pricing Suite is a cloud-based solution for companies seeking to automate the calculation and documentation of intercompany
Find out more
Zanders Transfer Pricing Suite Would you like to hear more about the bank selection process or other treasury-related challenges? Then please contact Michal Zelazko.
Find out more
Next steps From its new stable treasury basis, Sony's treasury is now ready for further steps for the future. In 2021, the system will be rolled out to Sony Group
Find out more
Adam Smith Award This year, during the annual Adam Smith Award contest (organized by Treasury Today), Kongsberg Automotive Group AG won an award for the Best FinTech
Find out more
Zanders and Sulzer Zanders and Sulzer started their cooperation in 2008 with a full treasury scan, a cash management blueprint and a full review of the treasury
Find out more
Contact Us If you have any inquiries or would like more information about the global implementation of a new treasury system, please don't hesitate to contact Olga
Find out more
In a continued effort to ensure we offer our customers the very best in knowledge and skills, Zanders has acquired Fintegral.
