Pengembangan Kertas Kerja Pencatatan dan Pengelolaan Persediaan Klien Berbasis Excel VBA Pada PT XYZ

Abstract

Penelitian ini bertujuan mengembangkan kertas kerja pencatatan dan pengelolaan persediaan berbasis Microsoft Excel VBA pada PT XYZ. Permasalahan utama yang dihadapi perusahaan adalah proses entry, klasifikasi barang, rekonsiliasi, perhitungan HPP, dan penyusunan laporan yang masih manual sehingga rentan terhadap human error, perbedaan kode dan nama barang, serta keterlambatan penyajian informasi persediaan. Penelitian menggunakan pendekatan Research and Development dengan model prototyping melalui tahap komunikasi, perencanaan, pemodelan, konstruksi, serta pengujian dan evaluasi. Data diperoleh melalui observasi, wawancara, dokumentasi, dan studi pustaka. Hasil penelitian menghasilkan kertas kerja berbasis VBA yang dilengkapi form transaksi, master data, validasi input, smart search, kartu stok, perhitungan HPP FIFO, jurnal otomatis, rekonsiliasi, dan laporan persediaan. Pengujian menunjukkan seluruh fitur utama berjalan sesuai kebutuhan pengguna.

This study aims to develop a Microsoft Excel VBA-based working paper for inventory recording and management at PT XYZ. The main problems faced by the company include manual data entry, item classification, reconciliation, cost of goods sold calculation, and report preparation, which increase the risk of human error, inconsistencies in item codes and names, and delays in inventory information. This study employed a Research and Development approach using a prototyping model consisting of communication, planning, modelling, construction, testing, and evaluation stages. Data were collected through observation, interviews, documentation, and literature study. The result is a VBA-based working paper equipped with transaction forms, master data, input validation, smart search, stock cards, FIFO-based COGS calculation, automatic journals, reconciliation, and inventory reports. Testing shows that all main features operate according to User needs.