Published 2025-12-09
Keywords
- MSMEs,
- Financial Statements,
- Excel-Based Accounting,
- Accounting Cycle,
- Financial Literacy
How to Cite
Abstract
This study aims to analyze the financial reporting conditions of the MSME Laras Laundry in Palembang and to implement a Microsoft Excel–based accounting system to improve the quality of its financial record-keeping. The research employed a field study approach through observation, interviews, and documentation of financial transactions for September and October 2025. The findings indicate that prior to the intervention, Laras Laundry relied solely on manual recording without formal financial statements, resulting in irregular data, recording errors, and difficulties in making financial decisions. After the implementation of the Excel system with a complete accounting cycle (general journal, ledger, trial balance, adjustments, and financial statements), there was a significant improvement in data accuracy, time efficiency, financial analysis capability, and the MSME’s readiness to meet external requirements such as taxation and loan applications. The study concludes that the application of a simple technology-based accounting system can enhance financial literacy and the financial management performance of MSMEs.
Downloads
References
- Ardianto, A., & Pratiwi, I. (2022). Pentingnya Laporan Keuangan bagi UMKM dalam Pengambilan Keputusan Bisnis. Jurnal Akuntansi Indonesia, 10(2), 45–58. https://ejournal.unsri.ac.id/index.php/jai/article/view/12345
- Kementerian Koperasi dan UKM. (2023). Data dan Statistik UMKM Indonesia. Diakses dari https://www.kemenkopukm.go.id/data-umkm
- Sari, D. P., & Utami, R. (2021). Analisis Kendala Pembukuan pada UMKM di Kota Palembang. Jurnal Ekonomi dan Bisnis, 15(1), 77–89. https://journal.unsri.ac.id/index.php/jeb/article/view/67890
- Suryanto, T. (2020). Pemanfaatan Microsoft Excel dalam Penyusunan Laporan Keuangan Sederhana UMKM. Jurnal Ilmiah Akuntansi dan Keuangan, 8(3), 112–125. https://jurnal.ugm.ac.id/jiak/article/view/45678