Design of financial statement preparation based on SAK EMKM using microsoft excel

Ifa Rosania Afif  -  Universitas Islam Negeri Maulana Malik Ibrahim Malang, Indonesia
Nawirah Nawirah*  -  Universitas Islam Negeri Maulana Malik Ibrahim Malang, Indonesia

(*) Corresponding Author

Purpose - Micro, Small and Medium-sized Enterprises (MSMEs) are a pillar of the Indonesian economy, as evidenced by the ability of MSMEs to save the economy in Indonesia during the monetary crisis in 1998. There was a significant increase in the number of MSMEs in Indonesia, inseparable from the problems that caused the failure of MSME actors. Among the affecting factors are the simple management, lack of supervision of the production process and the quality caused by the system on the entity, the simple recording of financial statements, and limited market access. The purpose of this study is to facilitate the MSMEs XXX in preparing financial statements based on SAK EMKM using Microsoft Excel software.

Method - This research uses a qualitative approach. The location of this research is MSMEs XXX which is located on Sunan Muria II Street No. 16 Malang. The data collection uses observation and interview techniques directly to researchers, the analytical method used is hermeneutics which means an approach to analyze and interpret data centered on the meaning of qualitative data.

Result - The design of financial report preparation based on SAK EMKM using Microsoft Excel in MSMEs XXX includes income statement, financial position report, and notes on financial statements. The MSMEs found problems in preparing the financial statements because of the lack of adequate resources and supporting software.

Implication - UMKM xxx is expected to be able compile financial statements based on SAK EMKM with microsoft excel software.

Originality - This research is the first study at UMKM xxx by making financial reports based on SAK EMKM with microsoft excel software .

Keywords : MSMEs; financial statements; software

  1. Aziz, dkk. (2009). Alternative Pembiayaan terhadap UMKM melalui Pasar Modal di Indonesia, Jakarta: Centre for Finance, Investment and Securities Law (CFISEL).
  2. Ghony, M. D., & Almansyur, F. (2012). Metodologi Penelitian Kualitatif, Jogjakarta: Ar-Ruzz Media.
  3. Hapsari, R. K., dkk. (2016). Perancangan dan Pengembangan Pengelolaan Keuangan UMKM Berbasis Sistem Informasi.
  4. Harahap, S. S. (2012). Teori Akuntansi, Jakarta: Rajawali Pers.
  5. Hery. (2015). Pengantar Akuntansi, Jakarta: PT. Grasindo.
  6. Hubais, M. (2009). Prospek Usaha Kecil dalam Wadah Kubator Bisnis, Ghalia Indonesia.
  7. IAI. (2016). Exposure Draft Standar Akuntansi Keuangan Entitas Mikro Kecil dan Menengah, Jakarta: DSAK IAI.
  8. Jusup, A. H. (2011). Dasar-Dasar Akuntansi, Yogyakarta: STIE YKPN.
  9. Kieso, W., & Warfield. (2018). Akuntansi Keuangan Menengah, Jakarta: Salemba Empat.
  10. Krisdiartiwi, M. (2008). Pembukuan Sederhana Untuk UKM, Jakarta: Med Press.
  11. Nurlela & Elvia, H. (2016). Penerapan Laporan Keuangan Usaha Kecil Menengah berbasis SAK ETAP pada Toko Jamu Nikisami, 5(2).
  12. Purwanti, E. (2017). Analisis Pengetahuan Laporan Keuangan pada Industri Konveksi di Salatiga, 10(20).
  13. Putra, H. A., & Kurniawati, E. P. (2012). Penyusunan Laporan Keuangan Pada untuk Usaha Kecil dan Menengah Berbasis SAK ETAP.
  14. Rudianto. (2012). Pengantar Akuntansi, Jakarta: Erlangga.
  15. Sarosa, S. (2012). Dasar-Dasar Penelitian Kualitatif, Jakarta: Indeks.
  16. Sekaran, U. (2006). Research Methods for Business, Jakarta: Salemba Empat.
  17. Shonhadji, N., dkk. (2017). Penerapan Penyusunan Laporan Keuangan pada Usaha Kecil Menengah Berbasis SAK EMKM di Surabaya.
  18. Sugiyono. (2013). Metode Penelitian Bisnis, Bandung: Alfabeta.
  19. Suwardjono. (2003). Akuntansi Pengantar, Yogyakarta: BPFE.
  20. Tatik. (2018). Implementasi SAK EMKM (Standar Akuntansi Keuangan Entitas Mikro, Kecil, dan Menengah) pada Laporan Keuangan UMKM (Studi Kasus pada UMKM XYZ Yogyakarta), 14(2).
  21. Widjaja, Y. R., dkk. (2018). Penyusunan Laporan Keuangan Sederhana untuk Industri Konveksi, 1(1).

Journal of Islamic Accounting and Finance Research
Published by Department of Sharia Accounting, Faculty of Islamic Economics and Business, Universitas Islam Negeri Walisongo Semarang, Indonesia
Jl Prof. Dr. Hamka Kampus III Ngaliyan Semarang 50185
Phone: +62 852-2589-5726
Website: https://febi.walisongo.ac.id/
Email: jiafr@walisongo.ac.id

ISSN: 2715-0429 (Print)
ISSN: 2714-8122 (Online)

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

View My Stats
apps