Improving the Efficiency of MSME Financial Statements through Microsoft Excel-Based Applications
Keywords:
Financial reports, MSMEs, Microsoft Excel-based applicationsAbstract
This article discusses the use of Microsoft Excel application to improve the efficiency of financial statements in Micro, Small and Medium Enterprises (MSMEs). The purpose of this study is to evaluate the effectiveness of using Excel applications in preparing MSME financial statements, as well as to identify benefits and constraints that may arise in the use of this application. The research method used is a case study by collecting data through interviews and observations of MSMEs that use Excel applications in preparing financial statements. The results showed that the use of Excel applications can increase the efficiency of preparing MSME financial statements. This application allows MSMEs to easily organize and manage their financial data, perform automatic calculations, and present financial information in a more accurate and structured manner. In addition, the use of Excel applications also speeds up the process of preparing financial statements and minimizes human error. In conclusion, the use of Microsoft Excel application can increase the efficiency of preparing MSME financial statements. This application allows MSMEs to manage financial data more efficiently, perform automatic calculations, and present financial information accurately. However, it should be noted that the use of the Excel application also requires adequate user understanding and skills. Therefore, training and mentoring in the use of this application is highly recommended to maximize its benefits for MSMEs.
References
S. M. Novita and P. Wulanditya, “Desain Microsoft Excel For Accounting Bagi Umkm (Studi Kasus Pada Ls Farm Mojokerto),” J. Ris. Terap. Akunt., vol. 4, no. 2, pp. 192–205, 2020, [Online]. Available: https://jurnal.polsri.ac.id/index.php/jrtap/article/view/2247
J. Arifin, “Menyusun Laporan Keuangan untuk UKM dengan Microsoft Excel,” Jakarta PT Elex Media Komputindo, 2006.
R. Suciani, “Pencatatan Keuangan Berbasis Microsoft Excel Pada Umkm (Studi Kasus Di Toko Putri Busana Tegal),” pp. 1–7, 2019.
V. Ayumi, H. Noprisson, U. M. Buana, P. Learning, and J. Barat, “PENGGUNAAN MICROSOFT EXCEL UNTUK PEMBUATAN LAPORAN KEUANGAN Pendahuluan Metode Tabel 1 Langkah pembelajaran PBL Hasil dan Pembahasan Gambar 1 Foto Kegiatan Pemaparan,” vol. 1, pp. 38–40, 2022.
O. Mustopa, S. Pangemnan, and Ruhiyat, “Desain Aplikasi Akuntansi UMKM Berdasarkan SAK EMKM Berbasis Microsoft Excel (Studi Kasus Pada UMKM Mawaddah Cosmetics Manado),” Pros. Semin. Nas. Prod. Terap. Unggulan Vokasi Politek. Negeri Manad., vol. 1, no. 1, 2022.
B. Harto, R. Komalasari, and R. Mustofa, “Peningkatan Kapasitas dan Kapabilitas Pengelolaan Keuangan Berbasis Aplikasi Excel dan Sesuai SAK EMKM Pada UMKM Moochi Lembang,” Ikra-Ith Abdimas, vol. 4, no. 1, pp. 47–54, 2021, [Online]. Available: https://journals.upi-yai.ac.id/index.php/IKRAITH-ABDIMAS/article/download/879/667
F. RAHMANTO, “PERANCANGAN PENYUSUNAN LAPORAN KEUANGAN BERBASIS MICROSOFT EXCEL DI UMKM ZAK-WOOW CONVECTION.” Universitas Gadjah Mada, 2019.
Lestari, A. Marlinah, and M. F. Syarlis, “PENYUSUNAN LAPORAN KEUANGAN SESUAI SAK EMKM MENGGUNAKAN MICROSOFT EXCEL ( Studi Kasus Pada UD . Tani Maju di Kec . Biringbulu Kab . Gowa ),” J. Manaj. dan Akunt., vol. 1, no. 2, pp. 215–224, 2023.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Derry Nugraha, Fazrian Thursina, Anjani, Putri Devina, Ade Irma, Neli Deti
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.