The Role of Microsoft Excel in Supporting Data-Driven Economic Decision-Making Among MSME Actors in The Digital
DOI:
https://doi.org/10.63822/5z4d7t34Keywords:
Microsoft Excel; MSMEs; data-driven decision-making; financial management; digital transformationAbstract
This article examines the role of Microsoft Excel in supporting data-driven economic decision-making among micro, small, and medium-sized enterprise (MSME) actors in the digital era. The study uses a qualitative literature review by synthesizing academic publications on spreadsheet-based financial recording, digital adoption, accounting information systems, financial literacy, and managerial decision-making. The review indicates that Excel can help MSMEs organize transaction records, summarize sales and expenses, calculate costs and profit, monitor cash flows, manage inventory, compare business performance, and prepare simple financial projections. Functions such as SUM, AVERAGE, IF, SUMIF, sorting, filtering, charts, and PivotTables can convert routine records into information that is easier to interpret. Such information may support decisions concerning pricing, purchasing, stock replenishment, cost control, promotion, and business expansion. Nevertheless, Excel does not automatically guarantee sound decisions. The usefulness of its outputs depends on the completeness, accuracy, consistency, and timeliness of the input data, as well as the user's spreadsheet competence and basic financial literacy. Risks include formula errors, duplicate or missing transactions, uncontrolled file versions, and inadequate data security. The article concludes that Excel is best positioned as an accessible transitional and supporting tool within a broader digital financial-management process, not as a substitute for accounting standards, internal controls, or professional judgment.
References
Adha, A. C., Hendriani, S., & Nelaz, Y. S. (2024). Sales data processing training using Microsoft Excel for UMKM. Awal Bros Journal of Community Development, 5(2), 8–13. https://doi.org/10.54973/abjcd.v5i2.512
Affandi, Y., Ridhwan, M. M., Trinugroho, I., & Adiwibowo, D. H. (2024). Digital adoption, business performance, and financial literacy in ultra-micro, micro, and small enterprises in Indonesia. Research in International Business and Finance, 70, 102376. https://doi.org/10.1016/j.ribaf.2024.102376
Christanty, L., Nugroho, W. S., Nurcahyono, N., & Maharani, B. (2023). Accounting information systems and financial literacy impact on SMEs' performance. MAKSIMUM: Media Akuntansi Universitas Muhammadiyah Semarang, 13(1). https://jurnal.unimus.ac.id/index.php/MAX/article/view/12323
Hamdani, R., Radianto, W. E. D., & Kodrat, D. S. (2026). Digital capabilities, data-driven decision-making, and operational performance in SMEs: A moderated mediation model. Journal of Economics, Entrepreneurship, Management Business and Accounting, 4(5). https://doi.org/10.61255/jeemba.v4i5.1737
Irzavika, N., Gusti, K. W., Hadi, N. T., Wiryanto, F. S., & Muslim, M. P. (2025). Generate financial reports for micro, small and medium enterprises (MSMEs) using Microsoft Excel. International Journal of Community Service Learning, 9(2), 292–300. https://doi.org/10.23887/ijcsl.v9i2.90698
Judijanto, L., Sudarmanto, E., Utami, E. Y., Darman, & Waoma, S. (2024). The effect of accounting information system service quality, technological innovation, and financial literacy on investment decision making in MSMEs in Indonesia. West Science Accounting and Finance, 2(1). https://doi.org/10.58812/wsaf.v2i01.710
Microsoft. (n.d.). Excel help & learning. Microsoft Support. https://support.microsoft.com/en-us/excel
Pertiwi, J. P., & Hana, A. U. (2024). Data-driven decision making in MSMEs: Leveraging free analytics tools for financial planning and efficiency. Journal of Management and Informatics, 4(1). https://doi.org/10.51903/jmi.v4i1.146
Ratnawati, K., Rokhim, R., Wati, C. R., & Dewanta, P. P. (2025). The impact of enhancing digital financial literacy on firm performance: Evidence from digitalisation in Indonesia. International Journal of Technology Intelligence and Planning, 14(1), 78–106. https://doi.org/10.1504/IJTIP.2025.150737
Rofiq, M. H., & Muhammad, R. N. (2022). Penyusunan laporan keuangan berdasarkan SAK EMKM berbantuan Microsoft Excel 2016: Studi kasus UMKM Laila Collection. Indonesian Accounting Literacy Journal, 2(2), 317–336. https://doi.org/10.35313/ialj.v2i2.3204
Rohmah, N. N., & Hastuti. (2021). Penyusunan laporan keuangan UMKM berdasarkan SAK EMKM berbantuan Microsoft Excel. Indonesian Accounting Literacy Journal, 1(3), 691–704. https://doi.org/10.35313/ialj.v1i3.3192
Rosyidiana, R. N., & Narsa, I. M. (2024). Micro, small, and medium-sized enterprises (MSMEs) during the post-pandemic economic recovery period: Digitalization, literation, innovation, and its impact on financial performance. Cogent Business & Management, 11(1), 2342488. https://doi.org/10.1080/23311975.2024.2342488
Ikatan Akuntan Indonesia. (2018). Standar akuntansi keuangan entitas mikro, kecil, dan menengah. Ikatan Akuntan Indonesia.
Tsaqifah, T., Isma, V., Secondson, Y., Jatnika, C., Adawiyah, F. S., & Mahreiz, S. (2024). Pembuatan laporan keuangan berbasis Microsoft Excel. Hexatech: Jurnal Ilmiah Teknik, 3(1), 25–34. https://doi.org/10.55904/hexatech.v3i1.1297
Arrasyidah, H., & Syarif, D. (2024). The effect of financial literacy, internal control systems, and accounting information systems on the quality of MSME financial statements in Bandung City. Journal of Economic, Business and Accounting (COSTING), 7(4). https://doi.org/10.31539/costing.v7i4.10271
Wibowo, M., Muktiyanto, A., Mubarok, F., & Latief, S. H. (2026). Integrated adaptive digital systems and SME's business competitiveness: The role of analytics and decision-making capability. Journal of Economics, Entrepreneurship, Management Business and Accounting, 4(5). https://doi.org/10.61255/jeemba.v4i5.1867
Downloads
Published
Issue
Section
License
Copyright (c) 2026 B.R.E Yunanda, Cintya Fizda Winagri, Inkha Novriani, Levila Risma Nengsi, Marzha Ourora Fadyra (Author)
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
