Perancangan dan Penerapan Microsoft Excel Macro untuk Penyusunan Laporan Keuangan Berdasarkan SAK EMKM pada CV Rai Jaya Granit

Abstract

UMKM CV Rai Jaya Granit, yang bergerak di bidang pemasok granit dan keramik, merancang sistem aplikasi pencatatan keuangan berbasis Microsoft Excel Macro untuk mengatasi permasalahan pencatatan keuangan. Penelitian ini bertujuan mengidentifikasi perancangan sistem, sistem informasi akuntansi berbasis Excel Macro, serta penerapannya pada UMKM. Metode System Development Life Cycle (SDLC) model waterfall digunakan melalui tahapan analisis kebutuhan, desain, implementasi, integrasi, dan pengujian dengan metode Blackbox. Hasil penerapan sistem menunjukkan dampak positif pada pencatatan penjualan, pembelian, dan pengelolaan persediaan, sehingga meningkatkan efisiensi serta efektivitas pencatatan keuangan usaha tersebut.

UMKM CV Rai Jaya Granit, which is engaged in granite and ceramic suppliers, designed a Microsoft Excel Macro-based financial recording application system to overcome financial recording problems. This research aims to identify system design, Excel Macro-based accounting information systems, and their application in MSMEs. The System Development Life Cycle (SDLC) method of the waterfall model is used through the stages of needs analysis, design, implementation, integration, and testing with the Blackbox method. The results of the system implementation show a positive impact on recording sales, purchases, and inventory management, thereby increasing the efficiency and effectiveness of the business's financial records.