IMPLEMENTASI PENGGUNAAN MICROSOFT EXCEL VBA UNTUK MEMBUAT LAPORAN KEUANGAN SEDERHANA UMKM XYZ STUDIO

Authors

  • Olivya Balqis Axshelby Politeknik Ubaya, Indonesia
  • Diah Anugrah Sharasanti Politeknik Ubaya, Indonesia

DOI:

https://doi.org/10.29040/jap.v25i2.16234

Keywords:

Financial Recording, Microsoft Excel VBA

Abstract

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.

Author Biographies

Olivya Balqis Axshelby, Politeknik Ubaya

Accounting Student

Diah Anugrah Sharasanti, Politeknik Ubaya

Accounting

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

2025-01-16

How to Cite

Axshelby, O. B., & Sharasanti, D. A. (2025). IMPLEMENTASI PENGGUNAAN MICROSOFT EXCEL VBA UNTUK MEMBUAT LAPORAN KEUANGAN SEDERHANA UMKM XYZ STUDIO. Jurnal Akuntansi Dan Pajak, 25(2). https://doi.org/10.29040/jap.v25i2.16234

Citation Check

Similar Articles

1 2 3 4 5 6 7 8 9 10 > >> 

You may also start an advanced similarity search for this article.