Implementation Of Using The Microsoft Office Excel Application For Simple Cash Flow Recording For Msmes Fostered By Ns Creative House

Authors

  • Heni Rohaeni Prodi Manajemen, Fakultas Ekonomi dan Bisnis Universitas Bhayangkara Jakarta Raya, Jakarta, Indonesia.
  • Murti Wijayarti Prodi Manajemen, Fakultas Ekonomi dan Bisnis Universitas Bhayangkara Jakarta Raya, Jakarta, Indonesia
  • Tyna Yunita Prodi Manajemen, Fakultas Ekonomi dan Bisnis Universitas Bhayangkara Jakarta Raya, Jakarta, Indonesia.
  • Julianto Sihar Pardamean Prodi Manajemen, Fakultas Ekonomi dan Bisnis Universitas Bhayangkara Jakarta Raya, Jakarta, Indonesia.

DOI:

https://doi.org/10.51601/ijcs.v2i4.145

Abstract

Many companies use bookkeeping, but MSMEs are also in dire need of
bookkeeping in their business. Bookkeeping does not have to be complicated and
confusing. Simple bookkeeping is enough for small businesses to know the profit
and loss earned. This research is intended to assist MSMEs in designing
appropriate steps to be taken in the future and minimizing losses through the
preparation of good bookkeeping using Microsoft Office Excel Applications. The
crucial problem often found in MSMEs, especially the fostered partners of NS
Creative House, is the problem of financial management. Due to the lack of
ability of MSMEs owners to manage and record business finances, financial
income and expenditure are not recorded clearly and neatly. After participating
in this training, MSMEs fostered partners to become able to implement
Microsoft Office Excel applications in doing simple records, which significantly
affects business development. Through bookkeeping, MSMEs owners can see the
condition and development of the business, including the company's profits and
losses. With this, bookkeeping can be used as a benchmark for future business
strategies.
Keywords: Implement

Downloads

Download data is not yet available.

References

Holandari A. Apa Itu Pembukuan dan Pentingnya bagi UMKM [Internet]. www.sobatpajak.com. 2020.

Available from: https://www.sobatpajak.com/article/5fd70d5d3db9e02f1b42b359/Apa itu Pembukuan dan

Pentingnya bagi UMKM

Zahir. Contoh Pembukuan Sederhana dengan Excel [Internet]. Available from:

https://zahiraccounting.com/id/blog/contoh-pembukuan-sederhana-dengan-excel/

Sari CT, Indriani E. Pentingnya Pembukuan Sederhana Bagi Kelompok UMKM KUB Murakabi Desa

Ngargoyoso. Wasana Nyata. 2017;1(1):17–21.

Gramedia Blog. Pengertian UMKM: Kriteria, Aturan, Peran dan Contoh. Gramedia. [Internet]. 2022. Available

from: https://www.gramedia.com/literasi/umkm/

DQLab. Mengapa UMKM Perlu Belajar Excel [Internet]. DIGINATION.id. 2022. Available from:

https://www.digination.id/read/018449/mengapa-umkm-perlu-belajar-excel

Kememkopukm. Pelatihan Digital Marketing Untuk Pelaku Usaha Mikro Yang Terkendala Pandemi [Internet].

Available from: https://smesta.kemenkopukm.go.id/pelatihan-digital-marketing-untuk-pelaku-usahamikro-yang-terkendala-pandemi/

Febriyanto DP, Soegiono L, Kristanto AB. Pemanfaatan Informasi Keuangan dan Akses Pembiayaan Bagi

Usaha Mikro Kecil dan Menengah. J Ilm Akunt dan Humanika. 2019;9(2).

Akuntansi. Apa itu Cash Flow? Bagaimana Cara Menghitungnya? [Internet]. 2022. Available from:

https://www.jurnal.id/id/blog/contoh-cash-flow/

Firmansyah R, Iqbal M, Zarkasyi MI, Aminy MIA, Arifianto MR, Qinthara MYD, et al. Pemanfaatan Excel

dalam Penyusunan Laporan Keuangan TK Dusun Trajeng. Jumat Ekon J Pengabdi Masy. 2022;3(1):23–31.

Machfuzhoh A, Widyaningsih IU, others. Pelatihan Pembukuan Sederhana Bagi UMKM Menuju UMKM Naik

Kelas Di Kecamatan Grogol. J Pengabdi dan Peningkatan Mutu Masy. 2020;1(2).

Sugiyono D. Metode penelitian pendidikan pendekatan kuantitatif, kualitatif dan R&D. 2013;

Taniredja T, Mustafidah H. Penelitian Kuantitatif (sebuah pengantar). Bandung Alf. 2011;

Rizal MF, Randy A, Dami D. Pelatihan Penerapan Microsoft Excel Sebagai Usaha Untuk Meningkatkan

Pengelolaan Keuangan Pada Usaha Kecil Menengah Dan Mikro (Umkm) Kedai Papa Krenyeszzz Di Kota

Pontianak. J Pengabdi Kpd Masy Manaj. 2022;2(1):13–7.

Koerniawan I, Aqham AA, Wahyuni S. Sistem Informasi Arus Kas Berbasis Multiuser Pada PT Xpresindo

Logistik Utama Semarang. J Inform dan Teknol Komput. 2022;2(1):73–9.

Erikka E. Analisis Implementasi Sistem Informasi Akuntansi Dengan Menggunakan Software Akuntansi Pada

PT Cahaya Pulau Pura. Prodi Akuntansi; 2021.

Nurhasanah S, Setiaji BW, Saputra B, others. Penerapan Aplikasi Akuntansi Ukm Pada Perusahaan/Umkm. J

Ilmu Siber. 2022;1(5):173–9.

Downloads

Published

2022-11-28

How to Cite

Rohaeni, H. ., Wijayarti, M. ., Yunita, T. ., & Sihar Pardamean, J. . (2022). Implementation Of Using The Microsoft Office Excel Application For Simple Cash Flow Recording For Msmes Fostered By Ns Creative House. International Journal Of Community Service, 2(4), 442–446. https://doi.org/10.51601/ijcs.v2i4.145