Perancangan Sistem Informasi Akuntansi Penjualan Berbasis Microsoft Excel VBA pada UMKM Warung Sembako

Abstract

UMKM Warung Sembako masih melakukan pencatatan transaksi penjualan, persediaan, dan kas secara manual sehingga berisiko menimbulkan kesalahan pencatatan, ketidaklengkapan data, serta keterlambatan penyusunan laporan. Penelitian ini bertujuan untuk menganalisis mekanisme administrasi transaksi penjualan, merancang Sistem Informasi Akuntansi Penjualan berbasis Microsoft Excel VBA, serta mengevaluasi kelayakan sistem. Penelitian ini menggunakan metode deskriptif kualitatif dengan pendekatan applied research. Pengembangan sistem dilakukan menggunakan System Development Life Cycle (SDLC) model Waterfall. Sistem yang dikembangkan memiliki lima fitur utama, yaitu dashboard, stok barang, penjualan, laporan penjualan, dan buku kas. Hasil Black Box Testing menunjukkan seluruh fitur berfungsi sesuai kebutuhan pengguna sehingga sistem dinyatakan layak digunakan.

Grocery Shop MSME still records sales transactions, inventory, and cash manually, resulting in recording errors, incomplete data, and delays in report preparation. This study aims to analyze the sales transaction administration mechanism, design a Sales Accounting Information System using Microsoft Excel VBA, and evaluate the feasibility of the developed system. The study employed a qualitative descriptive method with an applied research approach. The system was developed using the System Development Life Cycle (SDLC) Waterfall model. The developed system consists of five main features: a dashboard, inventory management, sales, sales reports, and a cash book. The results of Black Box Testing indicate that all system features functioned in accordance with user requirements. Therefore, the system is considered feasible for implementation.