Excel For Accounting : Perancangan Laporan Keuangan Supplier Produk Agrikultur
Abstract
This research aims to determine a model for designing simple financial reports for micro, small, and medium enterprises (MSMEs) using Microsoft Excel (EFA) at PT. FreshGo Indonesia, is a food supplier company, especially agricultural products such as fruit, vegetables, meat, seafood, and also provides superior products from Indonesian MSMEs. This research uses descriptive qualitative methods to produce financial reports consisting of profit and loss reports, and balance sheets. Data collection techniques were carried out using interviews, documentation, and observation methods. Meanwhile, the data used in this research is transaction data and other information about finances for one month. The results of this research are in the form of simple financial reports based on Microsoft Excel (EFA) which are used to record daily transactions so that financial reports can be prepared for a certain period.
Downloads
References
Audita, A. T. F., Arum, D. P., & Tannar, O. (2022). Penerapan Laporan Keuangan Berbasis Aplikasi Keuangan Digital Pada UMKM Andin Ecoprint. KARYA: Jurnal Pengabdian Kepada Masyarakat, 2(3), 115–119.
Hery. (2015). Pengantar Akuntansi. PT. Grasindo.
Ikatan Akuntansi Indonesia. (2018). Standar Akuntansi Keuangan Entitas Mikro Kecil dan Menengah. Jakarta: Dewan Standar Akuntansi Keuangan.
Kieso, D. E., Weygandt, J. J., & Kimmel, P. D. (2019). Financial Accounting With IFRS (4th ed.). John Wiley and sons.
Monarasi, S., & Yutanto, H. (2021). Rancang Bangun Penyusunan Laporan Keuangan Bagi UMKM SOMANO Berbasis EFA (Excel For Accounting). Wahana : Tridarma Perguruan Tinggi, 73(2), 103–118.
Mutiah, R. A. (2019). Penerapan Penyusunan Laporan Keuangan pada UMKM Berbasis SAK EMKM. International Journal of Social Science and Business, 3(3), 223–229. https://doi.org/10.23887/ijssb.v3i3.21000
Santy Setiawan, Riki Martusa, Meythi Meythi, Rapina Rapina, & Dien Noviany Rahmatika. (2022). Preparation Of Micro, Small, Medium Enterprises Financial Statements For Thai Community Using The Microsoft Excel Application. International Journal of Innovative Technologies in Economy, 4(40). https://doi.org/10.31435/rsglobal_ijite/30122022/7930
SeptianaMS03, Sugiono, & Tukasno. (2023). Desain Laporan Keuangan Berbasis Microsoft Excel Pada UMKM. PEDULI : Jurnal Pengabdian Kepada Masyarakat, 2(1). http://www.ejournal.staidarussalamlampung.ac.id/index.php/peduli/article/view/435
Sesilia Maria Novita, P. W. (n.d.). Desain Microsoft Excel For Accounting Bagi UMKM (Studi Kasus Pada Ls Farm Mojokerto).
Sugiyono. (2018). Metode Peneltian Kuantitatif, Kualitatif dan R & D. Alfabeta.
