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

Eris Anjani Putri
Evi Octavia

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

Articles

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:

https://doi.org/10.29303/abdiinsani.v11i3.1620