SAK EMKM Implementation in Practice: Designing Financial Statements for MSMEs Using Excel-Based Tools (A Case Study of PT Satya Utama Abadi)
Main Article Content
Abstract
Micro, Small, and Medium Enterprises (MSMEs) play a vital role in national economic growth; however, many still fail to implement proper financial reporting in accordance with applicable accounting standards. PT. Satya Utama Abadi, as an MSME entity, faces challenges in preparing its financial statements due to the absence of a well-structured and documented accounting system. This study aims to design financial reports based on the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM), enabling the company to produce accurate and relevant financial information.
The research employs a descriptive method with a field study approach through observation, interviews, and direct work practice at the company. The results of this study show that the implementation of a structured Excel-based system enabled PT. Satya Utama Abadi to prepare complete financial statements in accordance with SAK EMKM, including an opening trial balance, general journal, four-column ledger, trial balance, adjusting journal, income statement, statement of financial position, and closing journal. This design not only improved the accuracy and reliability of financial reporting but also provided practical templates that can be directly adopted by the company. It is expected that this financial report design can serve as a reference for the company in improving the quality of its financial information and supporting more accurate decision-making.
Article Details
Section

This work is licensed under a Creative Commons Attribution 4.0 International License.
References
Hafiz, M. P. (2025, Maret 17). 70% Kesulitan, Paper.Id Dorong Digitalisasi Keuangan Umkm. Retrieved From Marketeers: Https://Www.Marketeers.Com/70-Kesulitan-Paper-Id-Dorong-Digitalisasi-Keuangan-Umkm/
Hasmawati, H., Aponno, C., Siahaya, S. L., & Usmany, R. (2023). Preparation of Simple Financial Statements for MSME Using Microsoft Excel Accounting Application: A Case Study On The Mawar Ikat Weaving Group In Tawiri Negeri. Brilliant International Journal Of Management And Tourism, 3(3), 52–62. DOI:10.55606/bijmt.v3i3.2214
Pratiwi, U. N., & Octavia, E. (2021, Februari 11). Tinjauan Prosedur Akuntansi Pengeluaran Kas Atas Pengajuan Dan Pembayaran Klaim Jaminan Hari Tua Pada Bpjs Ketenagakerjaan Kcp Bandung Barat. Jurnal Akuntansi Bisnis Dan Ekonomi, 1881-1900. DOI:
https://doi.org/10.33197/jabe.vol7.iss1.2021.632
Rachman, A. A., Rachmawati, R., Lizwaril, R., Dianita, M., & Barus, I. S. (2022). Pendampingan Penyusunan Anggaran Harga Pokok Produksi Bantal Bayi Pada Babyfynn Sass Bandung. Jurnal Pustaka Mitra, 23-29.
Rachmanto, A., & Utami, E. R. (2024). Optimizing Financial Reporting in Small Businesses: Leveraging Microsoft Excel for Efficiency and Accuracy. Proceeding of International Conference on Business, Economics, Social Sciences, and Humanities (ICOBEST), 7, 284–294. DOI: 10.34010/icobest.v7i.538
Sihotang, E. T., Nita, R. A., & Budiana, K. M. (2025). Excel-based assistance in financial management of micro-enterprises in the catering industry. Journal of Community Service and Empowerment, 6(1), 11–19. DOI:10.22219/jcse.v6i1.37003
Susiani, R., Yusuf, P. S., Ilyas, S., Agustina, I. L., & Apriliana, T. (2024). Pelatihan Penyusunan Laporan Keuangan Sederhana Bagi Kelompok Usaha Ekonomi Produksi Ngudi Lestari Binaan Kantor Desa Kembang Kapanewon Nanggulan Kabupaten Kulon Progo Yogyakarta. Jurnal Abdimas Bina Bangsa, 694-699. DOI: https://doi.org/10.46306/jabb.v5i1.1011
Tarmidi, D., Hendiarto, R. S., Paramudhita, R. R., Putra, I. G., Sunjana, F. R., & Wini, R. (2024). Pelatihan Penyusunan Laporan Keuangan Digital Berbasis Syariah Yang Berkesinambungan Guna Meningkatkan Kinerja Keuangan Umkm Binaan Pondok Pesantren Al Mubaarok Caringin Bandung. Jurnal Abdi Insani, 885-893. DOI: