Microsoft Excel As a Tool for Digitizing Financial Records and Supporting Decision-Making Among MSMEs in Dharmasraya Regency in The Era of Digital Transformation

Authors

  • B.R.E Yunanda STITNU Sakinah Dharmasraya Author
  • Reza Fransiska STITNU Sakinah Dharmasraya Author
  • Chika Anjeli STITNU Sakinah Dharmasraya Author
  • Rezal Putra Nando STITNU Sakinah Dharmasraya Author
  • Sobri Alfajri STITNU Sakinah Dharmasraya Author

DOI:

https://doi.org/10.63822/2zce6460

Keywords:

Microsoft Excel, financial digitalization MSMEs, decision-making, qualitative research

Abstract

This study aims to understand the use of Microsoft Excel as a tool for digitalizing financial records and supporting decision-making among micro, small, and medium enterprises (MSMEs) in Dharmasraya Regency. The study focuses on transaction-recording practices, the use of financial information for operational decisions, perceived benefits, challenges, and support needs. It is designed as a descriptive qualitative field study. Primary data are planned to be collected through semi-structured interviews with MSME owners or managers, observation of bookkeeping practices, and authorized documentation. Secondary data include government statistics, local planning documents, accounting standards, and scholarly articles on Excel-based financial reporting for MSMEs. Data analysis will involve data condensation, data display, and conclusion drawing and verification. Existing literature indicates that spreadsheets can support transaction recording and financial summaries; however, their practical value depends on complete data entry, user understanding, formula checking, and file security. As primary field data have not yet been incorporated into this draft, these statements provide a conceptual basis that must be examined through field research in Dharmasraya

References

Badan Pusat Statistik. (2025a). Statistik E-Commerce 2024. https://www.bps.go.id/id/publication/2025/11/28/647323224ecc656c2933571b/statistik-e-commerce-2024.html

Badan Pusat Statistik Kabupaten Dharmasraya. (2025). Kabupaten Dharmasraya dalam angka 2025. https://dharmasrayakab.bps.go.id/id/publication/2025/02/28/294f2352e5efe17270254fe5/dharmasraya-regency-in-figures-2025.html

Dharmasraya Regency Government. (2021). Rencana Pembangunan Jangka Menengah Daerah (RPJMD) Kabupaten Dharmasraya Tahun 2021–2026. https://dharmasrayakab.go.id/photos/file/RPJMD_Tahun_2021_2026_241228182300.pdf

Heryani, N., Fitri, S. A., Guspendri, N., Rahmi, M., & Fitria, N. (2023). Pendampingan penyusunan laporan keuangan UMKM Laura Pulau Harapan berdasarkan SAK EMKM dengan bantuan Microsoft Excel. KACANEGARA Jurnal Pengabdian pada Masyarakat, 6(3). https://ejournals.itda.ac.id/index.php/KACANEGARA/article/view/1646

Indonesian Institute of Accountants. (n.d.). Standar Akuntansi Keuangan Entitas Mikro, Kecil, dan Menengah (SAK EMKM). https://web.iaiglobal.or.id/SAK-IAI/Tentang%20SAK%20EMKM

Kania, E., & Irawan, A. (2021). Penyusunan laporan keuangan berdasarkan SAK EMKM berbantuan Microsoft Excel pada UMKM Uncal.Co. Indonesian Accounting Literacy Journal, 1(2), 338–352. https://jurnal.polban.ac.id/ialj/article/view/2520

Miles, M. B., Huberman, A. M., & Saldaña, J. (2014). Qualitative data analysis: A methods sourcebook (3rd ed.). SAGE Publications.

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

Rofiq, M. H., & Muhammad, R. N. (2022). Penyusunan laporan keuangan UMKM 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

Wahyuni, E. L., Probowulan, D., & Murwanti, R. (2020). Eksistensi pencatatan keuangan berdasarkan SAK EMKM pada UMKM dengan aplikasi Microsoft Excel. BUDGETING: Journal of Business, Management and Accounting, 2(1). https://doi.org/10.31539/budgeting.v2i1.1740

Published

2026-11-07

How to Cite

Yunanda, B. ., Fransiska, R. ., Anjeli, C. ., Nando, R. P., & Alfajri, S. . (2026). Microsoft Excel As a Tool for Digitizing Financial Records and Supporting Decision-Making Among MSMEs in Dharmasraya Regency in The Era of Digital Transformation. Jejak Digital: Jurnal Ilmiah Multidisiplin, 2(6), 11374-11378. https://doi.org/10.63822/2zce6460