Success story: RPA Intelligent Automations

Smart Automation for Investment Fund Reconciliation

Share this content

The Need

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.

Technology used

To implement this solution, we used: · AI Builder to extract and process key data from PDF files uploaded to SharePoint · Power Automate to automate the workflow · Excel Online for data processing and storage · Outlook for process notification

The solution

- - - - 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 benefit

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.