Contact
+55 (11) 9 9686 9874
Yuri de Stefani
VBA-Excel accounting program
While working at Verdeal, a company in Embu das Artes/SP/Brazil, I developed a VBA-Excel program to automate the company's bookkeeping processes.
The program uses data from payment vouchers, extracts, and employee wages to automatically generate accurate bookkeeping records. This saves time and reduces the risk of human error, improving the company's overall financial management.
I have included some sample data in the following images to demonstrate how the program works (note that the data used is fictitious).
​
Payment voucher:
Extract:
Salary:
​The following image shows the bookkeepping made by the program on VBA-Excel:
The next image shows a part of the VBA code:
This project allowed me to further develop my skills in VBA programming and financial management, as well as gain valuable experience in using technology to improve business processes. It also showcases my ability to take on complex projects and deliver effective solutions for real-world problems.