MENGHADIRKAN CLICK EXCEL ACCOUNTING SEBAGAI MITRA BISNIS & SOLUSI KREATIF DALAM MENGHADAPI TANTANGAN DIERA DIGITAL
DOI:
https://doi.org/10.71315/jtpkm.v1i1.2Kata Kunci:
Excel Accounting, Community Services, Lin Boutique, MSMEAbstrak
Micro, Small and Medium Units (MSMEs) require system-based processing of accounting records, so that the information presented is more accurate, fast and precise. One of the simple accounting systems that can help MSMEs is CEA (Click Excel Accounting) which is Microsoft Excel that has been specially designed. The object of this research is Lin Boutique, which was founded on April 14, 2020, a business engaged in the rental and buying and selling of clothing. Financial transactions that were transferred from manual to CEA occurred in August 2023.The research methods used include observation, interviews, introduction and use of CEA and evaluation.The results of the initial observations made show that Recording of company transactions is done manually.Recording only explains about income without involving other expenses and expenses related to boutique operations.CEA helps them to process transactions easily and produce reports not only journaling but also up to the balance sheet. This computerization task aims to optimize the use of CEA in preparing financial statements for Micro, Small, and Medium Enterprises (MSMEs). In this task we help MSME Lin Boutique in digital bookkeeping.
Referensi
Gasperzs, J., Limba, F. B., Engko, C., Layn, Y., Gainau, P. C., Bonara, R., & Putuhena, H. (2022). Peningkatan Keterampilan Penyusunan Laporan Keuangan Ukm Menggunakan Aplikasi Berbasis Android. Jurnal Pengabdian Kepada Masyarakat, 28(1), 44–49. https://doi.org/https://doi.org/10.54082/jamsi.547
Lathifa, D. (2019). Meninjau Perkembangan UMKM di Indonesia, Bagaimana Kondisinya.
Limba, F. B., & Sapulette, S. G. (2023). Sistem Infomasi Akuntansi (1st ed.). Widina Media Utama. https://repository.penerbitwidina.com/media/publications/564573-sistem-informasi-akuntansi-ecf4abf5.pdf
Jamkrindo. (2015). KRITERIA USAHA MIKRO, KECIL DAN MENENGAH MENURUT UU NO. 20 TAHUN 2008 TENTANG UMKM. BUMN.Go.Id.
Nita, R. A., & Ahmar, N. (2015). The Writing, Observing and Getting Approach dalam Menciptakan Keunggulan Kompetitif Praktik Akuntansi Berbasis Excel for Accounting. JRAP (Jurnal Riset Akuntansi dan Perpajakan), 2(02), 181-192.
Novita, S. M., & Wulanditya, P. (2020). Desain microsoft excel for accounting bagi UMKM (studi kasus pada LS Farm Mojokerto). Jurnal Riset Terapan Akuntansi, 4(2), 192-205.
Yuliantoro, H. R. (2015). Penyusunan Laporan Keuangan Menggunakan MYOB Accounting Versi 18 Pada Toko Sepatu Heri. Jurnal Akuntansi Keuangan Dan Bisnis.
Yusmaniarti, Y., & Ekowati, S. (2019). Laporan Keuangan Koperasi Berbasis Media Excel For Accounting (EFA). Jurnal Pengabdian Masyarakat Bumi Raflesia. https://doi.org/10.36085/jpmbr.v2i1.294
