Sector: IT Services
Share this content
An international oil & gas company—operator of Argentina’s largest gas pipeline network—needed to speed up the consolidation of its mutual investment fund (MIF) data for tax reporting and SAP accounting. Until recently, this task was handled manually, across multiple banks and funds, requiring several days of work from one person—resulting in high time costs, operational risk, and the potential for human error.
We built a custom application on the Microsoft Power Platform that uses AI to automate the processing of MIF data. All MIF statements (including share values, prices, and monthly performance) arrive in PDF format and are uploaded to a folder. The app reads each file, extracts the data, and organizes it in a structured Excel file—one tab per fund. It also generates a consolidated monthly report. Once the process is complete, it automatically sends a confirmation email via Outlook and flags any issues. The only task left for the analyst is to review the file and post the data into SAP.
The process now takes hours instead of days, with fewer errors and faster results—right after receiving the documents. It also streamlines the management of large volumes of data and offers: Automatic calculation of mutual fund balances and amounts subject to Gross Income Tax Flexibility to easily incorporate new funds and/or banks. This solution is designed to work with SAP.
