Design and Implementation of an Excel-Based Financial Reporting Application as an Effort to Digitalize and Efficiently Manage Financial Administration at the Kres Kwb Tofu Factory

Dewi Susanti; Mohamad Arief Setiawan; Rizqiyatul Khoiriyah

doi:10.61536/escalate.v4i02.726

Authors

Dewi Susanti Malang State Polytechnic
Mohamad Arief Setiawan Malang State Polytechnic
Rizqiyatul Khoiriyah Malang State Polytechnic

DOI:

https://doi.org/10.61536/escalate.v4i02.726

Keywords:

Accounting Information System, Financial Reporting, Microsoft Excel, Small and Medium Enterprises, Technology Acceptance Model

Abstract

The financial records of the KWB Kres Tofu Factory still use Microsoft Excel without a consistent accounting structure, potentially leading to inefficiencies and recording errors. This study aims to design and implement an Excel-based financial reporting application and evaluate its user acceptance and effectiveness. The study uses applied research with a descriptive qualitative approach. The population consists of parties involved in financial management, while the sample includes business owners and administrative or financial staff. The research instruments include observation, interviews, questionnaires, and pre-tests and post-tests. Data are analyzed descriptively through frequency distribution, averages, and comparisons. The results show an average recording time efficiency of 70.56%, user acceptance of 4.70 with a strongly agree category, and an increase in competency from 30.5 to 83.0. In conclusion, the application successfully supports more structured, efficient, and informative financial recording and reporting

Downloads

Download data is not yet available.

References

Anas, A., & Jatmiko, B. (2020). Implementasi sistem informasi akuntansi digital pada usaha kecil menengah. Jurnal Sistem Informasi dan Akuntansi, 5(1), 45–58.

ANTARA News. (2025). UMKM Indonesia sumbang 61,9% PDB nasional tahun 2025. https://www.antaranews.com

Apriyaningsih, Y., Ramlan, E., Achyani, T., Fajarwaty, A., & Widjojo, J. (2024). Implementasi sistem informasi akuntansi terhadap efisiensi UMKM Ikan Naki. SENADA: Semangat Nasional Dalam Mengabdi, 4(3), 147–170. https://doi.org/10.56881/senada.v4i03.189

Davis, F. D. (1989). Perceived usefulness, perceived ease of use, and user acceptance of information technology. MIS Quarterly, 13(3), 319–340. https://doi.org/10.2307/249008

Ikatan Akuntan Indonesia. (2024). SAK Indonesia untuk entitas mikro, kecil, dan menengah. Ikatan Akuntan Indonesia.

Kementerian Koordinator Bidang Perekonomian Republik Indonesia. (2025). Kontribusi UMKM terhadap PDB Indonesia tahun 2025. https://www.ekon.go.id

Kementerian Usaha Mikro, Kecil, dan Menengah Republik Indonesia. (2025). Data perkembangan UMKM Indonesia 2025. https://www.kemenkopukm.go.id

Lubis, I. S., & Lufriansyah. (2024). Implementasi sistem informasi akuntansi terhadap efisiensi operasional UMKM. Jurnal Ilmiah MEA (Manajemen, Ekonomi, dan Akuntansi), 8(1), 1–15.

Priambodo, R. A. F. A.-Z. P. (2025). Dampak penerapan sistem informasi akuntansi pada efisiensi operasional usaha mikro kecil dan menengah. MNMAE, 14(7), 1–4. https://doi.org/10.8734/mnmae.vli2.359

Pratiwi, Y. E., & Perdana, B. C. (2020). Analisis perancangan sistem informasi akuntansi terhadap pembuatan pembukuan akuntansi berbasis Microsoft Excel pada CV. Surya Anugerah Investindo. Jurnal Riset Akuntansi Aksioma, 19(2), 198–222. https://doi.org/10.29303/aksioma.v19i2.105

Rizki, N., Priyambodo, V. K., Feryansyah, F., Hanani, T., Sukma, P., Tanjung, I. Y., & Agustiningsih, W. (2025). Otomatisasi pelaporan keuangan UMKM berbasis program Microsoft Excel. Jurnal Abdimas Sangkabira, 6(1), 68–75. https://doi.org/10.29303/abdimassangkabira.v6i1.2512