Implementation of a Web-Based Management Information System for Monitoring Sales and Stock of Goods in MSMEs
Keywords:
MSMEs, Management Information Systems, Sales Monitoring, Inventory, Digital Transformation
https://doi.org/10.56134/jaci.v3i2.172
Abstract
Digital transformation is crucial for Micro, Small, and Medium Enterprises (MSMEs) to improve business management effectiveness and competitiveness in the digital economy. However, most MSMEs still rely on manual transaction recording and inventory management, leading to operational constraints such as data entry errors, delays in preparing sales reports, and difficulties with real-time inventory monitoring. This community service activity aims to implement a web-based management information system to support sales monitoring and inventory management at Lasari Kopi MSME in Makassar City. The novelty of this activity lies in integrating sales monitoring, automated transaction recording, and real-time inventory management into a single web-based dashboard tailored to the operational needs of small-scale MSMEs. The implementation method uses an implementative-participatory approach through the stages of identifying partner needs, system development, application implementation, user training, and system evaluation. The evaluation was conducted using Black Box Testing and the System Usability Scale (SUS), with 15 respondents, including business owners and MSME employees. The implementation results show that all system features function as intended, with no functional errors. Furthermore, the usability evaluation achieved a SUS score of 89.4, which is considered Excellent. The system implementation also successfully improved business operational efficiency by accelerating the transaction recording process from an average of 4–5 minutes to 1–2 minutes and improving the accuracy of real-time inventory monitoring. Thus, the implementation of a web-based management information system has proven to support the digital transformation of MSMEs by improving administrative effectiveness, operational efficiency, and more integrated and sustainable business data management.
Downloads
References
Al-Hattami, H. M. (2024). Impact of AIS success on decision-making effectiveness among SMEs in less developed countries. Information Technology for Development, 30(3), 472–492. https://doi.org/10.1080/02681102.2022.2073325
Al‐Hattami, H. M., Battour, M., & Al‐Bukhrani, M. A. (2025). Digital accounting systems in SMEs: Do they influence marketing performance? A moderated mediation analysis. Strategic Change, 34(5), 747–758. https://doi.org/10.1002/jsc.2654
Alam, M. K., Thakur, O. A., & Islam, F. T. (2024). Inventory management systems of small and medium enterprises in Bangladesh. Rajagiri Management Journal, 18(1), 8–19. https://doi.org/10.1108/RAMJ-09-2022-0145
Almasi, S., Bahaadinbeigy, K., Ahmadi, H., Sohrabei, S., & Rabiei, R. (2023). Usability evaluation of dashboards: A systematic literature review of tools. BioMed Research International, 2023(1), 9990933. https://doi.org/10.1155/2023/9990933
Ayuningtyas, C., Zaky, M. D., Sandi, M. R., Murad, D. F., & Murad, S. A. (2026). Potential for Improving Lecturers’ Catur Dharma Through Siecados V2 Dashboard Monitoring. 2026 IEEE International Conference on Interdisciplinary Approaches in Technology and Management for Social Innovation (IATMSI), 4th, 1–6. https://doi.org/10.1109/IATMSI68868.2026.11466139
Azizah, S. N., Suradi, Koeswinarno, Fakhruddin, M., & Yuliani, I. (2024). The Influence of Digital Transformation in Speeding Up the Empowerment of the Muslim Women’s Economy to Improve the Performance of Micro, Small, and Medium Enterprises (MSMEs) in Ponorogo. In Strategic Islamic Business and Management: Solutions for Sustainability (pp. 71–107). Springer. https://doi.org/10.1007/978-3-031-61778-2_5
Berihun, N. G., Dongmo, C., & Van der Poll, J. A. (2023). The Applicability of Automated Testing Frameworks for Mobile Application Testing: A Systematic Literature Review. In Computers (Vol. 12, Issue 5, p. 97). https://doi.org/10.3390/computers12050097
Bindeeba, D. S., Atuhaire, S., Bakashaba, R., & Tukamushaba, E. K. (2025). Digital business process integration and sustainability among smes: the mediating role of operational efficiency and the moderating role of credit access. Journal of Sustainable Business, 10(1), 11. https://doi.org/10.1186/s40991-025-00121-6
Cosa, M., & Torelli, R. (2024). Digital Transformation and Flexible Performance Management: A Systematic Literature Review of the Evolution of Performance Measurement Systems. Global Journal of Flexible Systems Management, 25(3), 445–466. https://doi.org/10.1007/s40171-024-00409-9
Dallocchio, M., Lambri, M., Sironi, E., & Teti, E. (2024). The role of digitalization in cross-border e-commerce performance of Italian SMEs. Sustainability, 16(2), 508. https://doi.org/10.3390/su16020508
Daraghmi, Y.-A., & Daraghmi, E.-Y. (2022). RAPD: rapid and participatory application development of usable systems during COVID19 crisis. IEEE Access, 10, 93601–93614. https://doi.org/10.1109/ACCESS.2022.3203582
Farida, I., & Aryanto, A. (2022). Digitalization of Accounting for MSMEs in Tegal City. Tegal International Conference on Applied Social Science & Humanities (TICASSH 2022), 124–128. https://doi.org/10.2991/978-2-494069-09-1_17
Göransson, B., Gulliksen, J., & Boivie, I. (2003). The usability design process–integrating user‐centered systems design in the software development process. Software Process: Improvement and Practice, 8(2), 111–131. https://doi.org/10.1002/spip.174
Hamdat, A., Ceskakusumadewi, B., Samalam, A. G., Rizal, M., & Lawalata, I. L. D. (2024). The Impact of Management Information Systems on Decision-Making Efficiency. Vifada Management and Digital Business, 1(2), 56–74. https://doi.org/10.70184/qpw1rq78
Handayani, J., & Masrokhah, S. (2024). Digital Transformation, Sustainability, And Msme Performance: The Role Of Organizational Agility. Ultima Management: Jurnal Ilmu Manajemen, 16(2), 298–318. https://doi.org/10.31937/manajemen.v16i2.3911
Hossain, Q., Yasmin, F., Biswas, T. R., & Asha, N. B. (2024). Integration of Big Data Analytics in Management Information Systems for Business Intelligence. Saudi J Bus Manag Stud, 9(9), 192–203. https://doi.org/10.36348/sjbms.2024.v09i09.002
Khoshniat, N., Jamarani, A., Ahmadzadeh, A., Haghi Kashani, M., & Mahdipour, E. (2024). Nature-inspired metaheuristic methods in software testing. Soft Computing, 28(2), 1503–1544. https://doi.org/10.1007/s00500-023-08382-8
Kumar, R., Dutta, G., & Phanden, R. K. (2025). Digitalization adoption barriers in the context of sustainability and operational excellence: implications for SMEs. Engineering Management Journal, 37(4), 355–371. https://doi.org/10.1080/10429247.2024.2372519
Ladani, J., Sanodiya, M., Thakur, S., Kadoo, T., & Pandey, K. (2025). Web Based Inventory and Warehouse Management System. International Conference on Innovations and Advances in Cognitive Systems, 181–192. https://doi.org/10.1007/978-3-031-97709-1_14
Lewis, J. R. (2018). Measuring Perceived Usability: The CSUQ, SUS, and UMUX. International Journal of Human–Computer Interaction, 34(12), 1148–1156. https://doi.org/10.1080/10447318.2017.1418805
Nery, M. P., dos Santos Neto, S. J., Alves, R. S., Santana, J. V. dos S., Griza, S., & Martins, C. O. D. (2025). Development of educational software for stainless steel selection and evaluating usability using the System Usability Scale (SUS). International Journal of Mechanical Engineering Education, 53(4), 957–972. https://doi.org/10.1177/03064190241266978
Nuñez, I., Cano, E. E., Cruz, E., Concepción, D., Navarro, N., & Rovetto, C. (2024). Improving usability in mobile apps for residential energy management: a hybrid approach using fuzzy logic. Applied Sciences, 14(5), 1751. https://doi.org/10.3390/app14051751
Panigrahi, R. R., Shrivastava, A. K., & Kapur, P. K. (2024). Impact of inventory management practices on the operational performances of SMEs: review and future research directions. International Journal of System Assurance Engineering and Management, 15(5), 1934–1955. https://doi.org/10.1007/s13198-023-02216-4
Purbaya, M. A., Suwawi, D. D. J., & Darwiyanto, E. (2022). User Interface Design Pattern Selection and Implementation for Designing a Web-Based Transaction and Goods Record-Keeping Application for Micro, Small and Medium Enterprises. 2022 1st International Conference on Software Engineering and Information Technology (ICoSEIT), 256–260. https://doi.org/10.1109/ICoSEIT55604.2022.10029983
Putri, G. A., Widagdo, A. K., & Setiawan, D. (2023). Analysis of financial technology acceptance of peer to peer lending (P2P lending) using extended technology acceptance model (TAM). Journal of Open Innovation: Technology, Market, and Complexity, 9(1), 100027. https://doi.org/10.1016/j.joitmc.2023.100027
Ren, S. (2022). Optimization of enterprise financial management and decision‐making systems based on big data. Journal of Mathematics, 2022(1), 1708506. https://doi.org/10.1155/2022/1708506
Sarmas, E., Marinakis, V., & Doukas, H. (2025). Scalable Framework for Intelligent System Architecture to Address Challenges in the Energy Sector. In Artificial Intelligence for Energy Systems: Driving Intelligent, Flexible and Optimal Energy Management (pp. 63–83). Springer. https://doi.org/10.1007/978-3-031-85209-1_3
Setiawan, B., Pamungkas, B., Mekaniwati, A., & Kusuma, P. M. (2025). The strategic role of digital transformation, dynamic and agile capabilities for the performance of micro, small, and medium enterprises (MSMEs). The Bottom Line. https://doi.org/10.1108/BL-08-2024-0120/1248892
Singh, S., Kumar, R., Badhoutiya, A., Sharma, U., Alkhayyat, A., & Shah, S. K. (2024). Web-Based Inventory, Stock Monitoring and Control System Powered by Local Encrypted Web Server. 2024 11th International Conference on Computing for Sustainable Global Development (INDIACom), 741–744. https://doi.org/10.23919/INDIACom61295.2024.10498795
Skalka, J., & Drlík, M. (2023). Development of automatic source code evaluation tests using grey-box methods: A programming education case study. IEEE Access, 11, 106772–106792. https://doi.org/10.1109/ACCESS.2023.3317694
Susanti, E., Mulyanti, R. Y., & Wati, L. N. (2022). Systematic literature review: Increasing performance of women MSMEs through competitive advantage based on digital transformation and innovation. International Conference on Global Innovation and Trends in Economics and Business (ICOBIS 2022), 25–61. https://doi.org/10.2991/978-94-6463-068-8_4
Syahrul, S., Tanaka, H., & Anderson, M. (2026). Development of a Web-Based Radar Monitoring and Failure Analysis System Integrated with the TopSky ATS. Ceddi Journal of Information System and Technology (JST), 5(1), 53–64. https://doi.org/10.56134/jst.v5i1.162
Vasconcelos, L. T., Silva, F. Z., Ferreira, F. G., Martinho, G., Pires, A., & Ferreira, J. C. (2022). Collaborative process design for waste management: co-constructing strategies with stakeholders. Environment, Development and Sustainability, 24(7), 9243–9259. https://doi.org/10.1007/s10668-021-01822-1
Vlachogianni, P., & Tselios, N. (2022). Perceived usability evaluation of educational technology using the System Usability Scale (SUS): A systematic review. Journal of Research on Technology in Education, 54(3), 392–409. https://doi.org/10.1080/15391523.2020.1867938
Yin, J., & Sun, L. (2025). Digital logistics, supply chain finance, and supply chain efficiency. Finance Research Letters, 108324. https://doi.org/10.1016/j.frl.2025.108324
Published
How to Cite
Issue
Section
Copyright (c) 2026 Ummiati Rahmah, Neneng Awaliyah, Akbar Iskandar, Ruth Ruth
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
