Automatización en el Área de Reconciliaciones Bancarias: SLB

Abstract

This improvement plan was carried out during the professional practices in the SLB company, where he worked as an intern in the Bank Reconciliation area. The work describes as a report the organization of the company and the work area, and identifies opportunities for improvement in the process of collecting, viewing, downloading and presenting data related to bank transactions performed by the company. The proposed improvement plan consists of the development of a macro in Excel that connects directly with the SAP accounting system (where the transactions are displayed), organizes the information of the different transactions and downloads them into an Excel workbook where a report is later made to see the fundamental information in a summarized manner. In this way, a manual process was automated, generating efficiencies mainly in terms of time for the SLB's bank reconciliation team. The tool proposed as an improvement plan will be available for continuous use in this area.