Perancangan Sistem Pencatatan Persediaan dan Penjualan Berbasis Spreadsheet pada Toko Sembako BA

Abstract

Toko Sembako BA merupakan usaha grosir dan eceran kebutuhan pokok yang pencatatan persediaan dan penjualan masih dilakukan secara manual menggunakan buku nota. Kondisi tersebut menyebabkan ketidakakuratan informasi stok, risiko kehilangan data transaksi, serta laporan yang belum terstruktur. Penelitian ini bertujuan merancang dan membangun sistem pencatatan persediaan dan penjualan berbasis spreadsheet yang mengintegrasikan metode First In First Out (FIFO), First Expired First Out (FEFO), dan sistem pencatatan perpetual. Penelitian menggunakan pendekatan kualitatif dengan model pengembangan System Development Life Cycle (SDLC) Waterfall yang meliputi analisis kebutuhan, perancangan, implementasi sistem, dan pengujian menggunakan Black Box Testing. Hasil penelitian menunjukkan bahwa system membantu mengotomatisasikan pencatatan persediaan dan penjualan, memperbarui stok secara real-time, mempercepat proses pencatatan transaksi, mengurangi kesalahan perhitungan stok, mendukung pengendalian persediaan melalui notifikasi, serta menerapkan metode FIFO untuk perhitungan HPP dan penilaian persediaan, serta metode FEFO untuk pengeluaran barang berdasarkan tanggal kedaluwarsa terdekat.

BA Grocery Store is a wholesale and retail business selling daily necessities that still records inventory and sales manually using paper invoices. This condition results in inaccurate stock information, the risk of transaction data loss, and unstructured reports. This study aims to design and develop a spreadsheet-based inventory and sales recording system that integrates the First In First Out (FIFO) method, the First Expired First Out (FEFO) method, and a perpetual inventory system. The study employed a qualitative approach using the System Development Life Cycle (SDLC) Waterfall model, which includes requirements analysis, system design, implementation, and Black Box Testing. The results indicate that the system helps automate inventory and sales recording, updates stock data in real time, accelerates transaction recording, reduces stock calculation errors, supports inventory control through notifications, applies the FIFO method for cost of goods sold calculation and inventory valuation, and implements the FEFO method for issuing products based on the nearest expiration date.