IMPLEMENTASI PENGGUNAAN MICROSOFT EXCEL VBA UNTUK MEMBUAT LAPORAN KEUANGAN SEDERHANA UMKM XYZ STUDIO
DOI:
https://doi.org/10.29040/jap.v25i2.16234Keywords:
Financial Recording, Microsoft Excel VBAAbstract
Financial recording is a significant point for small to multinational companies. Financial recording provides information about the company’s condition that later will be used as the basis of decision making for the company. Microsoft Excel is a beneficial program for financial recording. This program is quite simple to use, can be adjusted with user’s preferences, and easy to obtain. In Microsoft Excel there is a Macro Visual Basic feature. This feature helps users to automate required action, so that users could work effectively and efficiently. Considering the importance of financial recording for decision making, the author wrote this final report that discusses “Simple Financial Recording Using Microsoft Excel VBA for UMKM XYZ Studioâ€. UMKM XYZ Studio is a manufacturing company for women’s syar’i clothes that is located in South Tangerang. For the purpose of data collection, the Author used some techniques which are questionnaire, literature studies, and documentation. Result of data collection and the process of creating a simple financial recording application using Microsoft Excel VBA are explained in this report.
References
Amani, T. (2018). Penerapan SAK-EMKM Sebagai Dasar Penyusunan Laporan Keuangan UMKM:(Studi Kasus di UD Dua Putri Solehah Probolinggo). ASSETS: Jurnal Ilmiah Ilmu Akuntansi, Keuangan dan Pajak, 2(2), 12-30.
Andarsari, P. R., & Dura, J. (2018). Implementasi pencatatan keuangan pada usaha kecil dan menengah. Jurnal Ilmiah Bisnis dan Ekonomi Asia, 12(1), 59-65.
Anggraini, S. A. P. A., Martantina, L. M., & Sharasanti, D. A. S. (2024). Implementasi Perhitungan Pajak Penghasilan Atas Transaksi E-Commerce Pada Dearsi Toserba Kabupaten Tuban. Jurnal Akuntansi dan Pajak, 24(2), 1-15.
Hasanah, N., Muhtar, S., dan Muliasari, I. 2020. Mudah Memahami Usaha Mikro Kecil dan Menengah. Uwais Inspirasi Indonesia. Ponorogo
IAI. 2018. Standar Akuntansi Keuangan Entitas Mikro, Kecil dan Menengah., Jakarta: Dewan Standar Akuntansi Keuangan
Lee, C. 2016. Belajar Excel Macro VBA Step-by-Step. PT Elex Media Komputindo. Jakarta.
Madcoms Madiun. 2018. Lebih Mudah Mengelola Database dengan Macro Excel.Andi. Yogyakarta
Rayyani, W. O., Abdi, M. N., Winarsi, E., & Warda, W. (2020). Peningkatan daya saing umkm melalui optimalisasi penyusunan laporan keuangan. Jurnal Dedikasi Masyarakat, 3(2), 97-105.
Wende, M. E., & As’ari, H. (2023). Pelatihan dan Pendampingan Penyusunan Laporan Keuangan Sederhana UMKM. Jurnal Peradaban Masyarakat, 3(3), 129-132.
Downloads
Published
How to Cite
Issue
Section
Citation Check
License
The copyright of the article fully belongs to the Jurnal Akuntansi dan Pajak and publishing rights belong entirely to LLPM STIE AAS SurakartaÂ
Â
This work is licensed under a Creative Commons Attribution 4.0 International License.