Pendampingan Sistem Akuntansi dengan Microsoft Excel Macro untuk Penyusunan Laporan Keuangan berdasarkan SAK EMKM

Sari Mujiani, Median Wilestari

Abstract


Usaha Barokah Isi Ulang only manually records purchases and income, with no adjustments to fixed assets or financial statements. As a result, the authors are eager to process the transaction data of Usaha Barokah Isi Ulang, as micro, small and medium enterprise (MSME) in order to generate a more precise financial report. The goal of this service is to provide more knowledge in creating financial reports based on SAK EMKM using the Microsoft Excel Macro accounting system, introduce the Microsoft Excel Macro accounting system, and assist in creating financial reports using the Microsoft Excel Macro accounting system. This program was provided at Usaha Barokah Isi Ulang at Jatisampurna Village, Bekasi on October-- December 2021. The lecture approach, question and answer method, and mentoring method are all used. According to the needs of the owner, the Microsoft Excel Macro accounting system can produce financial reports in a relatively quick, easy, and accurate manner for Usaha Barokah Isi Ulang.


Keywords


Mentoring, Financial Reports, Excel Macro

Full Text:

PDF

References


Farhan, M., Novriansa, A., Kalsum, U., & Mukhtaruddin, M. (2020). Pengenalan Akuntansi bagi Usaha Mikro Kecil dan Menengah (UMKM) di Desa Kota Daro, Kabupaten Ogan Ilir. Sricommerce: Journal of Sriwijaya Community Services, 1(1), 47–54. https://doi.org/10.29259/jscs.v1i1.11

Haryanti, A. D., & Nur, T. (2020). Pendampingan Penyusunan Laporan Keuangan Himawari Handmade Panti Asuhan Muhammadiyah Putri Ulil Abshar. Jurnal Pengabdian dan Peningkatan Mutu Masyarakat (Janayu), 1(1), 46--59. https://doi.org/10.22219/janayu.v1i1.11197

Ikatan Akuntan Indonesia. (2018). Standar Akuntansi Keuangan EMKM. (2018). Jakarta: IAI.

Mardianto & Octaviana (2021). Perancangan Sistem Pencatatan Akuntansi dengan Menggunakan Aplikasi Microsoft Access pada Mas Bro Barbershop. Proceeding Conference on Community Engagement Project, 9(1), 684--690 https://journal.uib.ac.id/index.php/concept

Mujiani, S., Kurniawan, E., Soedarso, P., & Irvan, R. (2022). MSMEs in Jatirasa, Bekasi: Design and Implementation of SAK-EMKM Financial Reports Using Microsoft Excel. Asian Journal of Community Services, 1(2), 37-44.

Setianingsih, N. A., Asmoro, W. K., Andari, A. T. (2021). Pendampingan Penyusunan Laporan Keuangan Berbasis SAK-EMKM dengan Software Accurate Online. Jurnal SOLMA, 10(1), 103–109. https://doi.org/10.22236/solma.v10i1.5627

Syam, D. (2019). Pengantar Akuntansi. Malang: UMM Press.




DOI: http://dx.doi.org/10.33021/aia.v4i1.3625

Refbacks

  • There are currently no refbacks.


Copyright (c) 2022 Sari - Mujiani


Articles in this journal have been indexed in major research databases, including:


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