Gesico drives automation for efficient financial management
Microsoft Solutions - Process AutomationGesico, a prominent entity in debt collection and recovery management, has established a new paradigm in the financial sector through its innovative approach and commitment to operational excellence. With a solid track record and proven effectiveness, Gesico has implemented advanced technological solutions that have revolutionized its internal processes and enhanced user experience. This success story, in collaboration with Itequia, illustrates how the implementation of advanced technological solutions has optimized Gesico’s internal processes, improving efficiency and user experience.
01. The Challenge
Gesico’s main challenge was the monthly management of settlements. The company manually generated an Excel file (with more than 2000 lines) containing detailed information on collections made for different clients. This process consumed significant time and resources. Each month, considerable effort was dedicated to compiling all the information, generating up to 300 individual reports for each client, and preparing payment orders for the bank. Additionally, the manual operation presented a high risk of errors.
With the ambition to optimize this process, Gesico sought a solution that would allow them to set a cut-off date closer to the end of the month, free up human resources for higher-value tasks, and minimize manual errors.
02. The Solution
The collaboration with Itequia results in a comprehensive automation solution using SharePoint and Power Automate, which includes:
- Folder Structure: A meticulously organized folder structure has been designed in SharePoint to facilitate access and management of the documents necessary for automation.
- Data Automation: We have implemented an automated process to transform raw data into structured formats, making it easier to analyze and report.
- Power Automate Flow: A Power Automate flow has been implemented that is automatically triggered when the Excel document with raw data is uploaded. It generates individual Excel reports for each client, check Excels, and the necessary PDFs for distribution.
- Settlement Customization: Adding a key functionality to tailor settlements to the specific needs of each client. This is achieved through customization based on various business logics, such as non-compensation of invoices, zero VAT, or payment preferences by transfer, all linked to master tables easily maintained by the client through SharePoint.
The implementation of these tools simplifies the management of settlements and continues to mark a new era in Gesico’s operational efficiency, constantly raising the standard of excellence in the sector.
Technology
03. Highlights
Implementing this automation solution has provided clear benefits:
Operational Efficiency
A drastic reduction in settlement processing time has been achieved, going from days to hours.
Report Accuracy
Automation has minimized manual errors, resulting in more accurate and reliable financial reports.
Resource Optimization
Staff have been freed from repetitive tasks, allowing them to focus on higher value-added activities.
Flexibility in Financial Management
The company can now set cut-off dates closer to the end of the month, providing greater agility in financial decision-making.
Scalability without Compromise
Gesico has been able to scale its operations while maintaining quality and accuracy, reinforcing its position as a market leader.
These significant advancements demonstrate how Gesico, with the help of Itequia, has transformed challenges into opportunities, redefining financial management with intelligence and strategy.