Implementasi Sistem Akuntansi berbasis Excel pada Kamayel Premium Wash
DOI:
https://doi.org/10.63822/tr6mn128Keywords:
Microsoft Excel; SME; Practical Work; Financial ReportsAbstract
Kamayel Premium Wash is an MSME that used to manually record accounting and prepare financial reports. However, Kamayel Premium Wash no longer records cash inflows and outflows or prepares financial reports. The coronavirus pandemic, which caused a decline in sales, caused Kamayel Premium Wash to experience a drastic drop in turnover. Kamayel Premium Wash finally eliminated employees working there to reduce the burden of salaries that must be paid to employees and also stopped stocking goods. With no salary payments and no inventory collection, Sugeng Santoso, the owner, also stopped preparing financial reports. Currently, the profits and losses received by Kamayel Premium Wash and the expenses incurred are also unknown in detail. After the author conducted an interview with Sugeng Santoso and learned the information, the author then created a system using the Microsoft Excel application that aims to help Sugeng Santoso to create financial reports and determine the profits or losses he earned easily. For the next PkM who conduct research, the author also recommends that this system can be refined and developed further according to the economic conditions and the needs of MSMEs (Micro, Small and Medium Enterprises) in the future.
References
Ahyar, H., Maret, U. S., Andriani, H., Sukmana, D. J., Mada, U. G., Hardani, S.Pd., M. S., Nur Hikmatul Auliya, G. C. B., Helmina Andriani, M. S., Fardani, R. A., Ustiawaty, J., Utami, E. F., Sukmana, D. J., & Istiqomah, R. R. (2020). Buku Metode Penelitian Kualitatif & Kuantitatif (Issue March).
Gie. (2020). Pengertian Lengkap Tentang Buku Besar Dan Cara Membuatnya. Accurate. https://accurate.id/akuntansi/pengertian-buku-besar-adalah/
Hapsari, D. P., Susanto, A., & Widodo, T. (2022). Digitalisasi sistem akuntansi pada UMKM: Tantangan dan peluang dalam meningkatkan kualitas laporan keuangan. Jurnal Akuntansi dan Keuangan Indonesia, 19(2), 145–160.
Lestari, R., & Kurniawan, A. (2023). Implementasi sistem akuntansi berbasis Microsoft Excel terhadap peningkatan kinerja keuangan UMKM sektor jasa. Jurnal Akuntansi Bisnis, 21(1), 55–69.
Mulyana, D. (2016). Metodologi Penelitian Kualitatif (P. R. Rosdakarya (ed.)). PT. Remaja Rosdakarya.
Putri, N. A., Handayani, S. R., & Pratama, B. C. (2022). Pengaruh penggunaan sistem informasi akuntansi terhadap kualitas laporan keuangan UMKM. Jurnal Ilmiah Akuntansi dan Bisnis, 17(1), 89–101.
Rachmawati, I. N. (2017). Pengumpulan Data Dalam Penelitian Kualitatif: Wawancara. Jurnal Keperawatan Indonesia, 11(1), 35–40. https://doi.org/10.7454/jki.v11i1.184.
Rahmawati, E., & Prasetyo, E. (2023). Peran laporan keuangan sederhana dalam pengambilan keputusan UMKM. Jurnal Riset Akuntansi Kontemporer, 15(2), 210–223.
Sari, M. P., & Nugroho, R. S. (2021). Pengaruh penerapan sistem pencatatan keuangan terhadap kinerja UMKM. Jurnal Akuntansi dan Manajemen, 18(3), 201–214.
Utami, S. R., Wibowo, A., & Santoso, I. (2021). Sistem akuntansi sederhana berbasis Excel sebagai solusi pengelolaan keuangan UMKM. Jurnal Pengabdian dan Pemberdayaan Masyarakat, 5(2), 167–175.
Wahyuni, S., & Setiawan, D. (2021). Analisis kelemahan pencatatan keuangan manual pada UMKM dan dampaknya terhadap pengambilan keputusan. Jurnal Ekonomi dan Bisnis, 24(1), 33–45..
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Budi Harsono, Vivian Carolina (Author)
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
