Success story

Smart Automation for Investment Fund Reconciliation

Sector: Global IT Services

Share this content

Streamlining Processes through Automation

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.

Rated 5 out of 5