Journal of Computer Science, Information Technology and Telecommunication Engineering (JCoSITTE)
Vol 7, No 2 (2026)

Design and Implementation of a Web-Based Stock Opname and Merchandise Inventory Reconciliation Information System Using Laravel and MySQL with the Waterfall Model in Retail Store Operations

CHINTIA KARTIKA SARI (STMIK IKMI CIREBON)



Article Info

Publish Date
30 Sep 2026

Abstract

Inventory accuracy serves as an essential foundation for operational continuity, cost of goods sold (COGS) calculation, and financial transparency in modern retail management. A pervasive operational obstacle is inventory discrepancy between digital ledger balances and actual on-hand physical quantities, largely attributed to inventory shrinkage, damaged items, expired goods, and human entry errors during point-of-sale cashier transactions. This research focuses on the architectural design and software development of a web-based stock opname and inventory reconciliation information system leveraging the Laravel 12 framework and MySQL relational database management system through the structured Waterfall software engineering methodology. The developed application facilitates multi-stage physical inventory counting (draft mode), automated variance quantification, supervisor authorization gates, and immediate automated ledger adjustments via inventory stock card logs. Functional evaluation conducted through Black Box Testing demonstrated 100% test scenario validity, successfully cutting physical audit reconciliation turnaround time by 60% compared to legacy paper-based stock sheets

Copyrights © 2026






Journal Info

Abbrev

jcositte

Publisher

Subject

Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Electrical & Electronics Engineering

Description

ournal of Computer Science, Information Technology and Telecommunication Engineering (JCoSITTE) is being published in the months of March and September. It is academic, online, open access (abstract), peer reviewed international journal. The aim of the journal is to: Disseminate original, ...