Desenvolvimento De Uma Automação Para O Setor De Contas A Pagar De Uma Construtora Através Da Utilização Do Sienge

Abstract

The automation of routine tasks is a strategy that can bring numerous benefits to companies, especially in terms of productivity and cost reduction. In this study, the automation of accounts payable in a construction company was developed using the Sienge platform. First, Power Query was used to consolidate the bank statements into a single table and link the names of the incoming payment documents to the titles based on the bank statement data in PDF format. The next step was to use the Python programming language to create an automation capable of reading data from the Excel spreadsheet, attaching proof-of-payment files, and marking the appropriate titles for each row as paid. Thus, by applying automation, it was possible to create an efficient and accurate tool that helped improve the company's internal processes and reduce operating costs. This work has shown the importance of using automation tools in the construction industry as a strategy to increase company productivity and efficiency.