Journal of Educational Management Research
Vol. 5 No. 5 (2026)

From Manual Records to Digital Inventory: Examining Microsoft Excel as a Transitional Technology for MSME Inventory Management

Natasya Fitriah Audina (Sekolah Tinggi Ilmu Manajeman Sukma Medan)
Agus Salim Harahap (Sekolah Tinggi Ilmu Manajeman Sukma Medan)



Article Info

Publish Date
23 Aug 2026

Abstract

This study aims to examine the transition from manual to digital inventory recording using Microsoft Excel and its implications for inventory management in a small business. A qualitative case study design was employed at Jaka Ponsel. Data were collected through semi-structured interviews, direct observation, and documentation involving personnel directly engaged in inventory management. Data were analyzed through data condensation, data display, and conclusion verification, with source and technique triangulation used to strengthen credibility. The findings indicate that the manual system was functional for basic recording but became increasingly limited in data accessibility, updating, verification, and stock monitoring as transaction activities increased. The transition to Microsoft Excel consolidated inventory information, facilitated data retrieval, supported formula-assisted calculations, improved stock updating, and enabled more systematic monitoring. However, digitalization did not automatically ensure accuracy because data quality remained dependent on user discipline, timely input, and regular verification. The study concludes that Excel can serve as a practical transitional technology for MSMEs. The implication is that gradual digitalization can strengthen inventory management when supported by standardized procedures and user adaptation.

Copyrights © 2026






Journal Info

Abbrev

jemr

Publisher

Subject

Humanities Education Social Sciences

Description

Journal of Educational Management Research is an international peer-reviewed journal which publishes original and significant contributions to educational management, administration, and leadership, in its broadest sense, from all over the world. This includes primary research projects in schools ...