Preparation Of Simple Financial Statements For MSME Using Microsoft Excel Accounting Application
A Case Study On The Mawar Ikat Weaving Group In Tawiri Negeri
Abstract
The Mawar Ikat Weaving Group in Tawiri village or negeri has not been able to record accounting or prepare financial reports in accordance with the Financial Accounting Standards for Micro, Small and Medium Entities (FAS MSMEs). This business has not implemented an automated accounting recording system yet and only uses paper. Besides, there is no human resources who understand accounting. Therefore, there is no financial reports according to FAS MSMEs. Financial reports are also recommended to be presented computerised, for example by using Microsoft Excel. Financial reports from Excel were chosen because they are neat, easy to read and understand, automatically calculated accurately, practical when there are changes, and cost-effective.The application of this standard is expected to help and facilitate the Mawar Ikat weaving business in preparing financial reports.This research is a type of action research aiming to improve the quality of a situation or problem by carrying out actions or interventions systematically planned and tested. Recording company transactions into journals and preparing financial reports involve several stages of the accounting process, namely Designing the List of Accounts, Recording Transactions in the Journal Posting to the Ledger, Preparation of the Balance Sheet, and Preparation of Financial Statements. The preparation of simple financial statements using the excel accounting application is a positive step for MSME players. Despite limited resources, a basic understanding of accounting and the ability to prepare financial statements will help MSMEs maintain the sustainability of their business and fulfil internal and external financial information needs.
References
Apdian, D., Rostiani, Y., Jajang, J., & Sari, F. (2021). Sistem Informasi Akuntansi Laba Rugi Berbasis Microsoft Excel Pada Usaha Mikro Kecil Menengah (UMKM) Lucycake Karawang. Jurnal Interkom: Jurnal Publikasi Ilmiah Bidang Teknologi Informasi Dan Komunikasi, 16(2), 39–45. https://doi.org/10.35969/interkom.v16i2.109
Baridwan, Z. (2014). Intermediate Accounting (Kedelapan). BPFE.
E.L Wahyuni,Probuwulan, M. (2020). EKSISTENSI PENCATATAN KEUANGAN BERDASARKAN SAK EMKM PADA UMKM DENGANAPLIKASI MICROSOFT EXCEL. Journal of Business, Management and Accounting, 2(1).
Gamaliel, F., & Arliyanto, P. Y. D. (2021). Sistem Aplikasi Akuntansi Pabrik Berbasis Microsoft Excel. JUBIKOM | Jurnal Aplikasi Bisnis Dan Komputer, 1(3), 95–106.
Hamise, C. O., Maharibe, A. J., & Lintong, J. S. (2020). Desain Aplikasi Akuntansi Untuk Reseller Online Shop Berdasarkan SAK EMKM Berbasis VBA Macro Microsoft Excel (Studi Kasus Online Shop Roch Store Manado). Jurnal Bisnis Dan Kewirausahaan, 16(1), 44–57. https://doi.org/10.31940/jbk.v16i1.1823
Handayani Sri Rezky ;Arfianty;Yadi Arodhiskara. (2022). Penyusunan Laporan Keuangan Berdasarkan SAK EMKM pada Usaha Mikro, Kecil dan Menengah (1st ed.). PT. Nasya Expanding Management.
Ikatan Akuntan Indonesia. (2018). Standar Akuntansi Keuangan Entitas Mikro, Kecil dan Menengah (1st ed.). Grha Akuntan.
Kustiadi, P. (2022). Dahsyat Perkembangan UMKM di Kota Ambon Pasca Pandem Meningkat dari 14 Ribu Menjadi 60 Ribu Pedagang). Tvonenews.Com. https://www.tvonenews.com/daerah/regional/78057- dahsyat-perkembangan-umkm-di-kota-ambon-pasca-pandemi- meningkat-dari-14-ribu-menjadi-60-ribu-pedagang).
Lohanda, D. 2018. (2018). Pengaruh Tingkat Pendidikan, Pemahaman Akuntansi, Pelatihan Penyusunan Laporan Keuangan Terhadap Pelaporan Keuangan Umkm. Prodi Akuntansi UNY, 1, 1–20. http://journal.student.uny.ac.id/ojs/index.php/profita/article/view/13819/13344
Mardoni, Z., Putra, W., & Putri, T. M. (2023). Penerapan Microsoft Excel dalam Mengoptimalkan Pencatatan dan Pembukuan pada Budidaya Ikan Hias Sarasah di Kampung Tematik Bungus Teluk Kabung Kota Padang. 01(01), 10–16.
Mustopa, O., Pangemnan, S., & Ruhiyat. (2022). Desain Aplikasi AkuntansiUMKM Berdasarkan SAK EMKM Berbasis Microsoft Excel (Studi Kasus Pada UMKM Mawaddah Cosmetics Manado). 1(1).
Novita, S. M., & Wulanditya, P. (2020). Desain Microsoft Excel For Accounting Bagi Umkm (Studi Kasus Pada Ls Farm Mojokerto). Jurnal Riset Terapan Akuntansi,4(2), 192–205. https://jurnal.polsri.ac.id/index.php/jrtap/article/view/2247
Nuvitasari, A., Citra Y, N., & Martiana, N. (2019). Implementasi SAK EMKM Sebagai Dasar Penyusunan Laporan Keuangan Usaha Mikro Kecil dan Menengah (UMKM). International Journal of Social Science and Business, 3(3), 341. https://doi.org/10.23887/ijssb.v3i3.21144
S. Munawir. (2014). Analisa Laporan Keuangan. Liberty.
Sholikin, A., & Setiawan, A. (2018). Kesiapan UMKM Terhadap Implementasi SAK EMKM (Studi UMKM Di Kabupaten Blora). JIFA (Journal of Islamic Finance and Accounting), 1(2), 35–50. https://doi.org/10.22515/jifa.v1i2.1441
Supriyanto, D., Sulanjana, R. A., & Mulyana, I. (2020). Keuangan Sederhana Dan Penyajian Laporan Keuangan Menggunakan Software Akuntansi Berbasis Excel Pada Clothing “Dobujack” Kota Bandung. Dharma Bhakti Ekuitas, 4(2), 411–416.https://doi.org/10.52250/p3m.v4i2.97
Tomasowa, T. E. D. (2018). Aplikasi Excel for Accounting Dalam Menyusun Laporan Keuangan Pada Pemerintahan Desa. Jaka - Jurnal Jurusan Akuntasi, 3(1), 36. https://doi.org/10.32511/jaka.v3i1.233
Vidyasari R;Febryan. (2022). Komputerisasi Pencatatan Akuntansi dan Pelaporan Keuangan berbasis Microsoft Excel pada UMKM Umita Food and Drink. Jurnal Account, 9(1).
Warsono, S. dkk. (2017). Panduan Pengembangan Aplikasi Akuntansi Berbasis Excel. AB Publisher.
Yazfinedi. (2018). Usaha Mikro, Kecil, dan Menengah di Indonesia: Permasalahan dan Solusinya. Jurnal Ilmiah Kesejahteraan Sosial, XIV(25), 33–41.
Yusmaniarti, Y., & Ekowati, S. (2019). Laporan Keuangan Koperasi Berbasis Media Excel For Accounting (EFA). Jurnal Pengabdian Masyarakat Bumi Raflesia, 2(1). https://doi.org/10.36085/jpmbr.v2i1.294
