Implementasi Microsoft Access sebagai Pencatatan Akuntansi pada UMKM Rumah Makan Pak Teguh

Hendi Hendi, Ming Ming

Abstract


This community service activity was carried out to assist Pak Teguh's Madura Satay Restaurant in Lumajang, a micro, small, and medium enterprise (MSMEs), in overcoming the problem of manual financial record keeping. Manual record keeping often leads to calculation errors and loss of transaction data. Therefore, a simple Microsoft Access-based accounting system was designed to assist in recording sales and purchase transactions and automatically generate financial reports. The implementation method included interviews and observations to analyze needs, system design, implementation, and evaluation of users. The results of the activity showed that the application of this system improved time efficiency and the accuracy of financial records. The system also made it easier for business owners to monitor their financial condition in real time. Thus, the use of Ms. Access as an accounting system proved to be effective in supporting SME financial management to be more accurate and structured.


Keywords


Microsoft Acces, MSMEs, Accounting System.

Full Text:

PDF

References


Candy Candy, & Kelvin Kelvin. (2024). Digitalisasi Pencatatan Laporan Keuangan pada UMKM Surya Mobil. MENGABDI : Jurnal Hasil Kegiatan Bersama Masyarakat, 2(6), 72–79. https://doi.org/10.61132/mengabdi.v2i6.1046

Felia Putri, D., & Nurlaila, N. (2022). Analisis Sistem Pencatatan Manual Laporan Keuangan Terhadap Kinerja Akutan Di Perusahaan Umum Daerah Pasar Kota Medan. SIBATIK JOURNAL: Jurnal Ilmiah Bidang Sosial, Ekonomi, Budaya, Teknologi, Dan Pendidikan, 1(6), 763–770. https://doi.org/10.54443/sibatik.v1i6.90

Hendi, Budi Harsono, & Winny. (2024). The Effect of Tax Avoidance and Corporate Governance on Firm Value with Sustainability Reporting as Moderation. Media Riset Akuntansi, Auditing & Informasi, 24(2), 1411–8831. http://dx.doi.org/10.25105/mraai.v24i2.18809

Hendi, Harsono, B., & Versia, S. (2025). Auditor Characteristics and Tax Avoidance: The Mediating Effect of Audit Quality. Jurnal Ekonomi Bisnis Dan Kewirausahaan, 14(1), 114–136. https://doi.org/10.26418/jebik.v14i1.87137

Hendi, & Riksen Sitorus. (2023). An Empirical Research on Audit Report Timeliness. Jurnal Akuntansi Dan Keuangan, 25(1), 39–53. https://doi.org/10.9744/jak.25.1.39-53

Hendi, & Versia Silvana. (2024). Pembuatan Sistem Keuangan Dengan Menggunakan Aplikasi Microsoft Acces Di Botanic Coffee. Communnity Development Journal, 5(Tahun).

Itan, I., & Febriana, H. (2023). Desain Sistem Pencatatan Akuntansi dan Pelaporan Keuangan Berbasis Microsoft Access untuk Usaha D Mart Article History. ALAMTANA: Jurnal Pengabdian Masyarakat UNW Mataram. https://doi.org/10.51673/jaltn.v4i3.1860

Luthfiah, S., Yulina, B., & Fithri, E. J. (2024). Rancangan Sistem Informasi Akuntansi Penjualan Tunai Menggunakan Microsoft Access pada UMKM Mie Ayam Dzohir Palembang. Jurnal Pengabdian Masyarakat Akuntansi, Bisnis & Ekonomi (JPMABE), Volume 2 Nomor 4. https://doi.org/https://doi.org/10.5281/zenodo.14699831

Nyaman, Vitriya, R., & Tofan, A. (2025). The Role Of Financial Management In The Sustainability Of Micro, Small, And Medium Enterprises (MSMES) In East Java. In Management Studies and Entrepreneurship Journal (Vol. 6, Issue 4). https://doi.org/https://doi.org/10.37385/msej.v6i4.8132

Radyanto, M. R., & Hayati, E. N. (2021). Sistem Perbaikan Berkelanjutan UMKM Terdampak Pandemi COVID-19 Dengan Menerapkan Rekayasa Ulang Proses Bisnis. PROFISIENSI: Jurnal Program Studi Teknik Industri. https://doi.org/https://doi.org/10.33373/profis.v9i2.3665

Yanto, D., & Kusumawardani, M. (2024). Microsoft Access Solusi Sistem Akuntansi Bagi Usaha Menengah (Apotek Adil Farma). Jurnal Pengabdian Masyarakat Akuntansi, 2(2).




DOI: https://doi.org/10.31004/abdira.v6i1.1213

Refbacks

  • There are currently no refbacks.


Copyright (c) 2025 Ming Ming, Hendi Luo

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