Design of Inventory Accounting Information System Using Waterfall Method in Kuliner Sultan MSMEs

Abstract

This study focuses on designing and developing an inventory accounting information system for Kuliner Sultan, a micro-enterprise specializing in traditional food, using Microsoft Excel and the Waterfall method. The business previously relied on manual inventory recording, leading to frequent errors, reporting delays, and difficulties in real-time stock monitoring, particularly across multiple branches. Using the five stages of the Waterfall model—requirement analysis, design, implementation, testing, and maintenance—data were gathered through interviews and direct observation. The result is a simple, user-friendly system that allows for accurate recording of incoming and outgoing goods, as well as inventory reporting. This system is expected to improve operational efficiency, minimize manual errors, and support better inventory control for MSMEs with limited access to advanced technology.