Implementation of VBA Programming Logic for Optimizing Spreadsheet-Based Financial Recording Systems
Implementasi Logika Pemrograman VBA Untuk Optimasi Sistem Pencatatan Keuangan Pada Spreadsheet
DOI:
https://doi.org/10.33050/sensi.v12i2.4534Keywords:
Microsoft Excel, Visual Basic for Applications (VBA), Pivot Table, Financial Recording System, Black Box TestingAbstract
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. These issues hinder the provision of timely and accurate financial information at PT. Sinergi Milenial Indonesia, 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 by integrating Visual Basic for Applications (VBA) and Pivot Table. The study employed an applied experimental approach involving data collection through observation, interviews, and literature review, followed by system requirements analysis using the SWOT method, system design, implementation, and testing through Black Box Testing. The results indicate that VBA successfully automates data validation, transaction storage, and financial data management, while Pivot
Table provides dynamic data summarization and financial reporting. Testing of all major system features demonstrated that the system functions in accordance with user requirements. The implemented system provides a more structured financial recording and reporting process, minimizes the risk of human error, and facilitates information presentation through dashboards and financial reports. Therefore, the integration of VBA and Pivot Table offers an effective solution for improving the quality of financial data management and supporting faster and more accurate decision-making within the company.
Downloads
References
T. Gulati, A. Singla, and P. Saini, “Digital finance in the era of digital transformation: a bibliometric analysis and systematic literature review,” Apr. 13, 2025, Emerald
Publishing. doi: 10.1108/DTS-01-2025-0018.
W. Breuer and A. Knetsch, “Recent trends in the digitalization of finance and accounting,” Nov. 01, 2023, Springer Science and Business Media Deutschland GmbH. doi: 10.1007/s11573-023-01181-5.
Padriyansyah and T. S. Pratiwi, “Analisis Penggunaan Microsoft Excel dalam Pembukuan Keuangan Perusahaan: Sebuah Kajian Literatur,” Jurnal Riset Manajemen dan Akuntansi, vol. 5, no. 1, pp. 256–268, Apr. 2025, doi: 10.55606/jurima.v5i1.5159.
E. Ramadhani, F. H. Ratnapertiwi, N. N. Salma, Sulikah, and S. Nurhayati, “Analisis
Penggunaan Metode Spreadsheet dalam Penyusunan Laporan Keuangan,” Prosiding National Seminar on Accounting, Finance, and Economics, vol. 2, no. 3, pp. 100–108,
T. V. Rachmananda and A. Susanti, “Analisis Pencatatan Keuangan dan Implementasi Penggunaan Aplikasi Akuntansi Berbasis VBA Excel pada CV XYZ,” JURNAL
LENTERA AKUNTANSI, vol. 10, no. 2, pp. 243–260, Nov. 2025, doi: 10.34127/jrakt.v10i2.1861.
W. F. Maulidin et al., “Pembukuan Digital yang Efisien untuk UMKM (Pendekatan
Pengembangan Prototipe Excel VBA),” INFOMATEK: Jurnal Informatika, Manajemen
dan Teknologi, vol. 27, no. 1, 2025, doi: 10.23969/infomatek.v27i1.22525.
S. Kosasi and F. G. Pebriana, “Pelatihan Pembuatan Laporan Dan Analisis Data
Menggunakan Pivot Table Pada Excel,” Jurnal Pengabdian Pada Masyarakat (Jurdimas),
vol. 3, no. 2, pp. 2963–3788, 2026, doi: 10.36774/jurdimas.v3i2.1733.
Z. Zai, Anton, and E. Suroningsih, “Designing A Financial Accounting Information
System Spreadsheet-Based,” RISTANSI: Riset Akuntansi, vol. 7, no. 1, pp. 200–215, May
, doi: 10.32815/ristansi.v7i1.2964.
D. Dinata, M. C. Rizky, D. M. U. Taringan, C. K. Saraan, and I. E. Sembiring, “Dampak
Ekonomi Digital Terhadap Pertumbuhan Ekonomi di Indonesia,” Benefit: Journal of
Bussiness, Economics, and Finance, vol. 2, no. 1, pp. 27–35, Feb. 2024, doi:
70437/benefit.v2i1.335.
M. Yao, “RPA Technology Enables Highly Automated Development of Corporate
Financial Accounting Processes,” Applied Mathematics and Nonlinear Sciences, vol. 9,
no. 1, Jan. 2024, doi: 10.2478/amns-2024-0541.
S. Munnangi, “Revolutionizing Loan Systems Through Intelligent Automation,”
International Journal of Research In Computer Applications and Information Technology (IJRCAIT), vol. 7, no. 2, p. 1508, 2024, doi: 10.5281/zenodo.14220828.
N. L. Farhiyah, H. Faizah, B. Hartono, and A. G. Daud, “Perancangan Sistem Informasi Manajemen Laboratorium Otomasi Berbasis Web Dengan Metode Prototype,” RIGGS: Journal of Artificial Intelligence and Digital Business, vol. 4, no. 3, pp. 1730–1735, Aug. 2025, doi: 10.31004/riggs.v4i3.2217.
A. Agiltriawan, R. Wakasara, and I. F. Hanif, “Analisis Sistem Informasi Manajemen Pada Sistem Enterprise Terhadap Bisnis Pengembangan Era Modern,” Bridge : Jurnal
Publikasi Sistem Informasi dan Telekomunikasi, vol. 3, no. 2, pp. 88–96, May 2025, doi:
62951/bridge.v3i2.433.
M. K. Mustafid and M. I. Prajawati, “Pengaruh Digital Payment Dan Financial Literacy Terhadap Financial Management,” JIAKu: Jurnal Ilmiah Akuntansi dan Keuangan, vol. 5, pp. 95–105, 2026, doi: 10.24034/jiaku.v5i12.7619.
J. B. W. Halwa, N. M. Verdiansyah, S. Andarini, and I. R. Kusumasari, “Penerapan
Spreadsheet Otomatis dalam Transformasi Digital pada Usaha Persewaan Alat Outdoor: Say Equipment’s,” Jurnal Pemberdayaan Ekonomi dan Masyarakat, vol. 2, no. 3, p. 13, Jun. 2025, doi: 10.47134/jpem.v2i3.735.
