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

Natasya Fitriah Audina; Agus Salim Harahap

doi:10.61987/jemr.v5i5.3060

Authors

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

DOI:

https://doi.org/10.61987/jemr.v5i5.3060

Keywords:

Digital Transformation, Inventory Management, Microsoft Excel, Small and Medium Enterprises

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.

References

Aguedo, C., Espinoza, J., & Pacheco, A. (2024). Improving Inventory Control Through a Web-Based System in a Retail Company. F1000Research. https://doi.org/10.12688/f1000research.145178.1

Antoni, D., Febrianty, & Wadud, M. (2025). A Digital Village Model for Supply Chain Management Capabilities Development in Micro-Small-Medium Enterprise in South Sumatra. Information Technology for Development, 31, 1511–1545. https://doi.org/10.1080/02681102.2025.2502417

Arunadevi, E., Umamaheswari, S., & Wang, S.-P. (2025). Optimising Inventory Systems for Sustainable Practices: Integrating Rebates and Preservation Technology for Effective Amelioration and Deterioration Control. International Journal of Systems Science: Operations & Logistics. https://doi.org/10.1080/23302674.2025.2467790

Ayalew, A. B., Alemu, A. G., & Worku, A. (2025). The Application of ABC-VED with Multi-Criteria Analysis for Drug Inventory Management. Scientific Reports, 16. https://doi.org/10.1038/s41598-025-32068-w

Basir, M. S., Buckmaster, D., Raturi, A., & Zhang, Y. (2024). From Pen and Paper to Digital Precision: A Comprehensive Review of On-Farm Recordkeeping. Precision Agriculture, 25, 2643–2682. https://doi.org/10.1007/s11119-024-10172-7

Bekele, A., Boche, B., Anagaw, Y. K., Ayenew, W., Worku, M., Geremew, D. T., Minwagaw, T., Melkamu, E., Woldeyohanins, A. E., Tefera, B., & Duguma, M. (2025). Inventory Management Performance of Essential Medicines in Public Health Facilities of Jimma Zone, Southwest Ethiopia. PLOS Global Public Health, 5. https://doi.org/10.1371/journal.pgph.0004379

Cantini, A., Costa, F., & Portioli-Staudacher, A. (2024). Driving Corporate Digitization with Reliable Data Through the A3 Approach: An Italian Case Study. International Journal of Lean Six Sigma. https://doi.org/10.1108/IJLSS-03-2024-0055

Chehrazi, N. (2025). Inventory Systems with Record Inaccuracy: Transaction Errors vs. Unobservable Loss. Manufacturing & Service Operations Management, 27, 1183–1204. https://doi.org/10.1287/msom.2023.0274

Grützner, L., Voss, D., & Breitner, M. (2025). Mature Inventory Management for Supply Chain Automation: An Interlinked Process-Reference Model. Electronic Markets, 35. https://doi.org/10.1007/s12525-025-00783-x

Kabera, J., & Mukanyangezi, M. (2024). Influence of Inventory Management Practices on the Availability of Emergency Obstetric Drugs in Rwandan Public Hospitals: A Case of Rwanda Southern Province. BMC Health Services Research, 24. https://doi.org/10.1186/s12913-023-10459-x

Kallmuenzer, A., Mikhaylov, A., Chelaru, M., & Czakon, W. (2024). Adoption and Performance Outcome of Digitalization in Small and Medium-Sized Enterprises. Review of Managerial Science, 19, 2011–2038. https://doi.org/10.1007/s11846-024-00744-2

Li, B., Chen, X., & Xiong, L. (2026). Improving Medication Safety and Efficiency in Hospital Pharmacy Through a Pharmacist-Led, Low-Code Mobile Application: A Prospective Study. Frontiers in Public Health, 14. https://doi.org/10.3389/fpubh.2026.1844863

Mekonen, Z., Cho, D., & Fenta, T. (2025). Logistics Management Information System (LMIS) for Health Commodities at Public Health Facilities in Amhara National Regional State of Ethiopia: A Data Quality Evaluation Survey. Journal of Multidisciplinary Healthcare, 18, 255–266. https://doi.org/10.2147/jmdh.s498995

Mohundro, M., Greene, T., Moore, C., Jones, J., Goldblatt, C., Nelkin, H., & Hays, A. (2024). Impact of an Enterprise Controlled Substance Management System on Labor and Inventory Costs. American Journal of Health-System Pharmacy: AJHP, 82, 427–434. https://doi.org/10.1093/ajhp/zxae305

Panigrahi, R., Shrivastava, A., & Nudurupati, S. (2024). Impact of Inventory Management on SME Performance: A Systematic Review. International Journal of Productivity and Performance Management. https://doi.org/10.1108/IJPPM-08-2023-0428

Panigrahi, R., Shrivastava, A., Sarkar, B. D., & Kaliyan, M. (2025). Inventory Knowledge, Industry 5.0 and Performances: Review and Future Research Agenda. Business Strategy and the Environment. https://doi.org/10.1002/bse.70002

Parisi, L., & Donyavi, S. (2025). Advancing Materials Procurement Processes in Construction: A Framework for Optimising Technology Integration in SMEs’ Construction Supply Chains. International Journal of Construction Management, 26, 1365–1389. https://doi.org/10.1080/15623599.2025.2553610

Puican Rodríguez, V. H., De Jesus Toro López, R., & García Vera, W. R. (2025). Innovations in Inventory Management to Improve the Profitability of Local SMEs. F1000Research, 14. https://doi.org/10.12688/f1000research.168900.3

Rahman, M., Kusumawati, I., Kunta, I. H., Khofsah, S., Dewi, A. T. A., Hikmah, U., & Mudarris, B. (2026). Improving the Quality of Education in Madrasah Tsanawiyah Through Digital Technology-Based Strategic Management. JETech: Journal of Education and Technology, 2(2), 63–72.

Ramos-Miller, M., & Pacheco, A. (2023). Towards Inventory Control Excellence: An Innovative Approach Based on a Web-Based Platform. F1000Research, 12. https://doi.org/10.12688/f1000research.140745.1

Rashid, A., & Rasheed, R. (2023). Mediation of Inventory Management in the Relationship Between Knowledge and Firm Performance. SAGE Open, 13. https://doi.org/10.1177/21582440231164593

Salinas, T., Tornes, L., & Solís, C. (2026). Laboratory Inventory Management Engine (LIME): A Free Tool for Managing Laboratory Inventories via Barcode Scanning and Automatic Cloud-Based Spreadsheet Integration. PLOS ONE, 21. https://doi.org/10.1371/journal.pone.0336412

Shen, J., Bu, F., Ye, Z., Zhang, M., Yan, J., & Huang, T. (2024). Management of Drug Supply Chain Information Based on “Artificial Intelligence + Vendor Managed Inventory” in China: Perspective Based on a Case Study. Frontiers in Pharmacology, 15. https://doi.org/10.3389/fphar.2024.1373642

Sivapriya, N., Rajendran, P., D, B., & S., A. (2026). IoT-Based Smart Pharmacies for Optimizing Stock Management with Diffusion Hierarchical Kernel Auto-Associative Prairie Dog Polynomial Convolutional Attention Network. International Journal of Management Science and Engineering Management, 21, 52–67. https://doi.org/10.1080/17509653.2025.2552454

Sun, Y., Huang, Y., & Feng, Q. (2024). Internal Control and Stock Liquidity. Finance Research Letters. https://doi.org/10.1016/j.frl.2024.105716

Surucu-Balci, E., Iris, Ç., & Balci, G. (2024). Digital Information in Maritime Supply Chains with Blockchain and Cloud Platforms: Supply Chain Capabilities, Barriers, and Research Opportunities. Technological Forecasting and Social Change. https://doi.org/10.1016/j.techfore.2023.122978

Swink, M., Kovach, J., & Roh, J. (2025). Inventory and Supply Chain Planning Systems as Drivers of Supply Chain Resilience: Analyses of Firm Performance Through the COVID-19 Pandemic. Production and Operations Management, 34, 2486–2505. https://doi.org/10.1177/10591478251320528

Taj, S., Imran, A., Kastrati, Z., Daudpota, S. M., Memon, R., & Ahmed, J. (2023). IoT-Based Supply Chain Management: A Systematic Literature Review. Internet of Things, 24, 100982. https://doi.org/10.1016/j.iot.2023.100982

Tessema, Z., Tsigu, T., Tilahun, Z., Tessema, G., Berhan, A., & Ali, E. E. (2026). Health Commodities Inventory Management Performance and Associated Challenges in Selected Public Health Facilities of South Gondar Zone, Amhara Region, North Central Ethiopia: A Mixed-Methods Cross-Sectional Study. PLOS ONE, 21. https://doi.org/10.1371/journal.pone.0349202

Vaio, A., Latif, B., Gunarathne, N., Gupta, M., & D’Adamo, I. (2023). Digitalization and Artificial Knowledge for Accountability in SCM: A Systematic Literature Review. Journal of Enterprise Information Management, 37, 606–672. https://doi.org/10.1108/JEIM-08-2022-0275

Wang, H., Zhang, Y., & Han, X. (2025). A-225 Utilizing Unique Device Identifier Code on Roche Reagent Cartridge for Efficient Inventory Management in a Clinical Chemistry Laboratory. Clinical Chemistry. https://doi.org/10.1093/clinchem/hvaf086.219

Xie, C., & Xie, C. (2025). Inventory Control Strategy Based on Neural Network and Fuzzy Algorithm in Intelligent Warehousing System. Discover Artificial Intelligence, 5. https://doi.org/10.1007/s44163-025-00423-5

Zavaleta Saenz, C. L., Romero Ruíz, A., & Pacheco, A. (2024). Web/Mobile System Innovation: An Efficient Revolution in Warehouse Management. F1000Research. https://doi.org/10.12688/f1000research.144942.1