Automatización de la consolidación de información financiera para la gestión de riesgo de grupo

Abstract

This work documents the design and implementation of an automation system, developed in Google Colab, for consolidating the financial information of the Keralty group, a multinational health sector company operating in Colombia and with an additional presence in seven countries. The project arose from a specific need within the Group Risk area: the manual consolidation of financial reports (accounts receivable, accounts payable, avales and guarantees, advances, pending invoicing, disputed invoices [billed with claims/glosas], financial obligations, and revenue dependency, among others) took between one and two days of work per run and was prone to classification errors and outdated data. To date, nine financial reporting lines have been automated for the 29 companies of the group in Colombia, in addition to a financial indicator engine (CAMEL model) with an extended scope covering the group's international operations. The consolidation time was reduced from one or two days to approximately five minutes of extraction per run, a reduction of close to 99.7%. Beyond the time savings, the validation process of each automation against previous manual consolidations made it possible to identify and correct information errors that already existed in the manual process, improving the quality of the input used for the group's financial risk management. This document reformulates the original approach of the project to reflect the work actually performed, its actual validation methodology, and its relevance to financial risk management in a business group with multinational operations.