VBA EXCEL BASED INCOMING AND OUTCOMING CASH INFORMATION SYSTEM APPLICATION FOR FARMUSHROOM UMKM
Article Sidebar
VBA EXCEL,
UMKM,
Information System Design
Main Article Content
Abstract
Oyster mushrooms are one of the most widely consumed mushroom commodities by the Indonesian people, both in the form of ready-to-eat food and other types of processed food. Oyster mushrooms have various superior potentials, both in terms of composition, nutrition and economic aspects. This has encouraged the emergence of oyster mushroom cultivation businesses or businesses (including white oyster mushrooms). (Rahmawati et al., 2022). The making of this project 1 aims to determine the profit and loss that exists in oyster mushroom MSMEs which are increasingly trending in this day and age.The method used in this research is the Waterfall method where we start the process of making this project 1 by analyzing the needs of MSMEs, then we design the system, after the system is finished we implement, then testing and maintenance. This Project Report discusses the development of cash-in and cash-out book applications using Microsoft Excel with Visual Basic for Applications (VBA). This application is designed to assist users in managing finances at Farmushroom MSMEs effectively and efficiently. (Octovina Hamise et al., 2020) Based on the results we obtained from the literature, the authors can conclude that oyster mushrooms are a very good business opportunity to improve the economy of the Indonesian people, especially for the agricultural sector, where people can innovate and develop their ideas related to this oyster mushroom so that it is attractive to sell and healthy when consumed. Therefore the author makes a cash book application to support the transaction process in MSMEs. By utilizing this application, MSMEs can increase efficiency and accuracy in processing MSME data.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
References
Hale, 2008. (2016). KANDUNGAN KARBOHIDRAT DAN PROTEIN JAMUR TIRAM PUTIH (Pleurotus ostreatus) PADA MEDIA TANAM SERBUK KAYU KEMIRI (Aleurites moluccana) DAN SERBUK KAYU CAMPURAN. In Jurnal Eksakta (Vol. 1, pp. 38–41).
Inayah, T., & Prima, E. (2022). Budidaya Jamur Tiram dan Pengolahannya Sebagai Upaya Meningkatkan Ekonomi Kreatif Desa Beji. Jumat Pertanian: Jurnal Pengabdian Masyarakat, 3(2), 96–99. https://doi.org/10.32764/abdimasper.v3i2.2881
Novianti, A., & Epi, Y. (2023). Penyusunan Laporan Keuangan Berdasarkan Standar Akuntansi Keuangan Entitas Mikro Kecil dan Menengah (SAK-EMKM). TIN: Terapan Informatika Nusantara, 4(7), 454–463. https://doi.org/10.47065/tin.v4i7.4677
Octovina Hamise, C., Julio Maharibe, A., Sonny Lintong, J., Akuntansi, J., & Negeri Manado, P. (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 & Kewirausahaan, 16(1), 2020.
Rahmawati, R., Idsan, R. S., & Purnamawati, I. (2022). STRATEGI PENGEMBANGAN USAHA BUDIDAYA JAMUR TIRAM PUTIH (Pleurotus ostreatus) DI KABUPATEN LANGKAT, SUMATERA UTARA (STUDI KASUS: UMKM RUMAH JAMUR). Waluyo Jatmiko Proceeding, 15(1), 95–102. https://doi.org/10.33005/waluyojatmiko.v15i1.23
Rohmah, N. N., Akuntansi, H. J., & Bandung, P. N. (2021). Penyusunan Laporan Keuangan UMKM Berdasarkan SAK EMKM Berbantuan Microsoft Excel (Studi Kasus Pada UMKM Skinka) Arrangement of MSME Financial Reports Based on SAK EMKM Assisted By Microsoft Excel (Case Study on Skinka MSME). Indonesian Accounting Literacy Journal, 01(03), 691–704.
Rosmiah, R., Aminah, I. S., Hawalid, H., & Dasir, D. (2020). BUDIDAYA JAMUR TIRAM PUTIH (Pluoretus ostreatus) SEBAGAI UPAYA PERBAIKAN GIZI DAN MENINGKATKAN PENDAPATAN KELUARGA. Altifani: International Journal of Community Engagement, 1(1), 31–35. https://doi.org/10.32502/altifani.v1i1.3008
TJOKROKUSUMO, D. (2015). Diversifikasi produk olahan jamur tiram (Pleurotus ostreatus) sebagai makanan sehat. December 2015, 2015–2020. https://doi.org/10.13057/psnmbi/m010828
Zulfarina, Z., Suryawati, E., Yustina, Y., Putra, R. A., & Taufik, H. (2019). Budidaya Jamur Tiram dan Olahannya untuk Kemandirian Masyarakat Desa. Jurnal Pengabdian Kepada Masyarakat (Indonesian Journal of Community Engagement), 5(3), 358. https://doi.org/10.22146/jpkm.44054
Richter, L. E., Carlos, A., & Beber, D. M. (n.d.). Komputerisasi Pencatatan Akuntansi dan Pelaporan Keuangan berbasis Microsoft Excel pada UMKM Umita Food and Drink. 9(1), 1655–1663..
ROHMAN, M. (2021). Penyusunan Laporan Keuangan Menggunakan Visual Basic for Application (Vba) Macro Excel Di Urffeine Cafe. http://etd.repository.ugm.ac.id/penelitian/detail/203036
Sambodo, B., Pratama, N., Jaya, S., Maisyarah, S., & Amelia, S. (2023). Pentingnya laporan keuangan pada UMKM. Community Development Journal, 4(2), 4153–4157.
Abdurahman, H., & Riswaya, A. R. (2014). Aplikasi Pinjaman Pembayaran Secara Kredit Pada Bank Yudha Bhakti. Jurnal Computech & Bisnis, 8(2), 61–69.
Rasyid. (2014). PENGERTIAN VBA EXCEL. Pontificia Universidad Catolica Del Peru, 8(33), 44.
H. Tanuwijaya and H. Manurung, Maruli, “Penerjemah Dokumen Inggris-Indonesia Menggunakan Mesin Penerjemah Statistik Dengan Word Reordering dan Phrase Reordering,” J. Ilmu Komput. dan Inf., vol. 2, no. 1, pp. 17–24, 2009.
Undang-Undang Republik Indonesia Nomor 20 Tahun. (2008). Undang-Undang Republik Indonesia Nomor 20 Tahun 2008. 1.