Design Of A Vba-Based Financial Recording And Transaction Tracking Application In Excel At Kartika Laundry, South Jakarta City
DOI:
https://doi.org/10.24256/kharaj.v8i1.9600Keywords:
MSMEs, Financial Recording, VBA Excel, Accounting System, Kartika LaundryAbstract
This study aims to design and implement a financial recording application based on Microsoft Excel, utilizing Visual Basic for Applications (VBA), for the micro, small, and medium enterprise (MSME) Laundry Kartika. The main problem identified is the lack of internal control in financial recording practices, which are still carried out manually without adequate recording procedures, resulting in transaction data that are not systematically documented and are at risk of loss or distortion of financial information. In addition, the absence of an effective accounts receivable and payable tracking mechanism causes credit transactions to often go unrecorded, which may lead to uncollectible receivables and reduce the reliability of financial reports. The developed application, AKLUN (Aplikasi Akuntansi Laundry), provides key features such as automated transaction input, preparation of general journals and ledgers, presentation of income statements and balance sheets, a fixed asset depreciation tracker, and a user authentication-based security system. The application development was carried out using the waterfall model, which includes stages of needs analysis, system design, implementation, testing, and maintenance. The implementation results indicate that AKLUN can improve the regularity and consistency of transaction recording, enhance financial documentation from previously unstructured to more systematic and well-documented, and provide an accountable and reliable accounts receivable and payable tracking mechanism. Thus, AKLUN serves as a relevant, effective, and adaptive digital solution to support efficient and responsive financial management for MSMEs in the context of digital transformation.
References
Amalia, N., Putri, D., & Kurniawan, R. (2023). Analisis Kendala Penyusunan Laporan Keuangan UMKM di Jawa Timur. Jurnal Ekonomi Dan Bisnis, 12(2), 44–58.
Hasmawati, Aponno, C., Siahaya, S. L., & Usmany, R. (2023). Preparation of simple financial statements for MSME using Microsoft Excel accounting application. . . Brilliant International Journal of Management and Tourism (BIJMT), 3(3).
Hayati, U., Prihartono, W., Saeful, A., & Triyono, A. (2023). Penyusunan laporan keuangan sederhana berbasis Excel untuk usaha mikro. AMMA: Jurnal Pengabdian Masyarakat, 1(3).
Indonesia, I. A. (2016). Standar akuntansi keuangan entitas mikro, kecil, dan menengah (SAK EMKM). DSAK IAI.
Keunis. (2022). Analisis Pencatatan dan Pelaporan Keuangan UMKM di Indonesia. Jurnal Keunis, 10(1), 34–41.
Madan, N. (2020). A review of access to finance by micro, small and medium enterprises and digital financial services in selected Asia-Pacific least developed countries. UN ESCAP.
Nisa, A. Z. (2025). Penerapan SAK EMKM dan pengendalian internal terhadap kualitas laporan keuangan UMKM di Jombang. Owner: Riset & Jurnal Akuntansi, 9(3).
Pressman, R. S. (2014). Software engineering: A practitioner’s approach. McGraw-Hill Publisher.
Puspitasari, D., & Basuki, T. (2021). Pemanfaatan Microsoft Excel VBA dalam Otomatisasi Proses Bisnis pada Usaha Kecil Menengah. Jurnal Sistem Informasi Bisnis, 11(2), 112–120.
Qimyatussa’adah, Nugroho, S. W., & Hartono, H. R. P. (2020). Pengetahuan dan pemahaman pelaku UMKM atas SAK EMKM. Monex. Journal Research Accounting Politeknik Tegal, 9(2).
Rofiqoh, I., Zulhawati, Buchdadi, A. D., & Gurendrawati, E. (2023). Buku UMKM naik kelas: Pemberdayaan ekonomi skala mikro. Pustaka Pelajar.
Romney, M. B., & Steinbart, P. J. (2020). Accounting information systems. Pearson Education.
Sommerville, I. (2004). Software engineering. Harlow: Pearson.
Sumarsono, J. A. (2021). Penyusunan laporan keuangan berbasis kas menggunakan VBA Microsoft Excel pada Jamur Borobudur. (Tugas Akhir, Universitas Tidar).
Supriyanto, D., & Utami, N. (2022). Peran Kebijakan Manajemen dalam Penguatan Sistem Pengendalian Internal pada UMKM. Jurnal Manajemen Bisnis, 18(2), 102–111.
Suwardjono. (2016). Teori akuntansi: Perekayasaan pelaporan keuangan. BPFE.
Downloads
Published
How to Cite
Issue
Section
Citation Check
License
Copyright (c) 2026 Shintya Permatahati, Inanda Shinta Anugrahani
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. In line with the license, authors are allowed to share and adapt the material. In addition, the material must be given appropriate credit, provided with a link to the license, and indicated if changes were made. If authors remix, transform or build upon the material, authors must distribute their contributions under the same license as the original.
