Operational Processes

In Corporate Treasury, processes are often data driven. As a consequence, data sources should be, to the extent possible, in a database format. Organizing data source in databases allow tools (ERP, TMS, Excel, etc.) and programs (based on Power Query, VBA, Python, etc.) to streamline and automate processes while mitigating the risk of errors.

In addition, the business user can leverage technologies like ChatGPT/Gemini/Copilot to help him building programs/codes, based on a clear description of i) the context and the objective of the tool, ii) the datasource(s) (columns, file format, etc.) and the expected output (file format, data, etc.).

Below are some important steps to help optimizing and automating processes: