Success story

Smart Automation for Investment Fund Reconciliation

Sector: Oil & Gas

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.

Rated 5 out of 5