PERANCANGAN SISTEM INFORMASI AKUNTANSI BERBASIS VISUAL BASIC FOR APPLICATION (VBA) MACRO EXCEL PADA CV. CHANDRADIMUKA MAKMUR PERKASA

Abstract

Abstrak

Kerja praktik ini dilaksanakan di CV Chandradimuka Makmur Perkasa, sebuah perusahaan pertambangan mineral non logam yang berlokasi di Banjarnegara, Jawa Tengah. Pencatatan keuangan perusahaan sebelumnya dilakukan secara manual, sehingga berpotensi menimbulkan kesalahan, keterlambatan analisis, dan hambatan dalam pengambilan keputusan manajerial. Untuk mengatasi permasalahan tersebut, dirancang sistem informasi akuntansi berbasis Visual Basic for Application (VBA) Macro Excel dengan pendekatan metode Waterfall. Sistem ini dikembangkan melalui tahapan analisis kebutuhan, desain sistem menggunakan DFD dan ERD, implementasi kode VBA, serta verifikasi dengan data transaksi aktual perusahaan. Hasil pengembangan menunjukkan bahwa sistem mampu mengotomatisasi pencatatan transaksi, menghasilkan laporan keuangan sesuai siklus akuntansi (jurnal umum, buku besar, neraca lajur, laporan laba rugi, perubahan modal, dan neraca), serta meminimalkan risiko kesalahan pencatatan. Dengan demikian, sistem informasi akuntansi yang dirancang dapat meningkatkan efisiensi, akurasi, dan keandalan proses pencatatan keuangan perusahaan, sekaligus mendukung pengambilan keputusan yang lebih cepat dan tepat.

Kata kunci: Sistem Informasi Akuntansi, VBA Macro Excel, Metode Waterfall, Otomatisasi Pencatatan Keuangan

Abstract

This internship was carried out at CV Chandradimuka Makmur Perkasa, a non-metallic mineral mining company located in Banjarnegara, Central Java. Previously, the company's financial records were kept manually, which had the potential to cause errors, delays in analysis, and obstacles in managerial decision-making. To overcome these problems, an accounting information system based on Visual Basic for Application (VBA) Macro Excel was Designed using the Waterfall method. This system was developed through the stages of needs analysis, system Design using DFD and ERD, VBA code Implementation, and Verification with the company's actual transaction data. The results of the development show that the system is capable of automating transaction recording, generating financial reports in accordance with the accounting cycle (general journal, ledger, trial balance, income statement, changes in capital, and balance sheet), and minimizing the risk of recording errors. Thus, the Designed accounting information system can improve the efficiency, accuracy, and reliability of the company's financial recording process, while supporting faster and more accurate decision making.

Keywords: Accounting Information System, Excel VBA Macro, Waterfall Method, Financial Recording Automation