Implementation of VBA Programming Logic for Optimizing Spreadsheet-Based Financial Recording Systems

Abstract

The financial recording process, which is still carried out semi-manually using Microsoft Excel,is prone to recording errors, data duplication, and delays in financial report preparation. Theseissues hinder the provision of timely and accurate financial information at PT. Sinergi MilenialIndonesia, highlighting the need for a system capable of automating financial data management.This study aims to design and implement a Microsoft Excel-based financial recording system byintegrating Visual Basic for Applications (VBA) and Pivot Table. The study employed an appliedexperimental approach involving data collection through observation, interviews, and literaturereview, followed by system requirements analysis using the SWOT method, system design, implementation, and testing through Black Box Testing. The results indicate that VBA successfullyautomates data validation, transaction storage, and financial data management, while PivotTable provides dynamic data summarization and financial reporting. Testing of all major systemfeatures demonstrated that the system functions in accordance with user requirements. Theimplemented system provides a more structured financial recording and reporting process,minimizes the risk of human error, and facilitates information presentation through dashboardsand financial reports. Therefore, the integration of VBA and Pivot Table offers an effectivesolution for improving the quality of financial data management and supporting faster and moreaccurate decision-making within the company.