Utilization of Microsoft Excel in Assisting the Preparation of Financial Reports at MI Ngalian Tirto Pekalongan

Authors

  • Rikko Aji Setiawan
  • Rizqi Mursalina
  • Novianti Putri Rahmadani Rahmadani
  • Hendri Hermawan Adinugraha

DOI:

https://doi.org/10.28932/ice.v3i3.4904

Keywords:

financial statements, Excel, MI, accounting

Abstract

The role of Information and Communication Technology is very much needed for school institutions as their provision in dealing with the changes and demands of the times in the era of the Industrial Revolution 4.0. Operating a computer is part of the hard skills. Students and teachers need to have skills in operating the programs contained in Microsoft Windows and the program that is most often used is Microsoft Excel. This particular program can support daily work as it makes processing data and compiling financial reports easier. Through Microsoft Excel, financial reports can be prepared simply with a shorter cycle, from journaling to simple financial reports. The purpose of this community service is to provide training on the process of preparing financial reports through Microsoft Excel in order to streamline administrative performance. The method used in this service is in the form of training and direct practice. The subject of this training is the financial treasurer section of MI Ngalian Tirto. The results of this service indicate that this training provides knowledge for school treasurers regarding simple accounting processes by utilizing excel so that in preparing financial reports can be better.

References

Ari Waluyo, Hamid Nasrullah, & Sotya Partiwi Ediwijoyo. (2020). Pelatihan Penggunaan Aplikasi Microsoft Office (Word, Excel, Power Point) 2010 untuk Peningkatan Kemampuan SDM PEMDES Desa Kebakalan, Karanggayam, Kebumen. JURPIKAT (Jurnal Pengabdian Kepada Masyarakat), 1(1), 21–28. https://doi.org/10.37339/jurpikat.v1i1.273

Diba, F., & Marini. (2020). Penerapan Laporan Keuangan Berbasis Excel pada Bengkel Las Bina Logam. Prosiding Seminar Nasional Akuntansi (SENA) III, 3(1), 257–266.

Febriandirza, A., & Saraswati, A. M. (2022). Pelatihan Microsoft Excel Dalam Penyusunan Laporan Keuangan Bagi Siswa Sma Muhammadiyah 4 Depok. Jurnal Abdi Reksa, 3(1), 9–15. https://ejournal.unib.ac.id/index.php/abdireksa/article/view/17206

Hariani, P. P., & Sihotang, I. M. (2020). Excel Mempermudah Penyusunan Laporan Keuangan. PRODIKMAS, 4, 50–58.

Mutiarni, R., Utomo, L. P., & Zuhroh, S. (2017). Pendampingan Pencatatan Transaksi Keuangan Pada Koperasi Bunga Harapan Desa Ceweng. Comvice : Journal of Community Service, 1(1), 33–38. https://doi.org/10.26533/comvice.v1i1.118

Petro, S., & Swatan, K. H. (2019). Pelatihan Microsoft Excel Sebagai Penunjang Ketrampilan Hard Skill Bagi Siswa Pada Smk Ypsei Palangka Raya. Jurnal Abdimas BSI: Jurnal Pengabdian Kepada Masyarakat, 2(2), 280–286. https://doi.org/10.31294/jabdimas.v2i2.6011

Pipit Putri Hariani MD, I. M. S. (2020). Excel Mempermudah Penyusunan Laporan Keuangan. JURNAL PRODIKMAS Hasil Pengabdian Kepada Masyarakat, 4, 50–58. https://doi.org/10.30596/jp.v4i2.6321

Rizki, M., Islam, U., Raden, N., Palembang, F., Yayasan, S., Insan, N., & Excel, M. (2021). Pendampingan Penyusunan Laporan Keuangan Nirlaba Sekolah Yayasan Nurul Insan Dengan Microsoft Excel. Jurnal Pengabdian Kepada Masyarakat Indonesia, 1(2).

Shohabatussa’adah, S., & Muasomah, M. (2021). Pemanfaatan Microsoft Excel Dalam Membantu Penyusunan Laporan Keuangan Di Tpq an-Najah Tirto Pekalongan. Al-Khidmat, 4(1), 28–35. https://doi.org/10.15575/jak.v4i1.11637

Triandi, & Agustin, M. (2020). Penggunaan Microsoft Excel Dalam Penyusunan Laporan Keuangan Untuk Meningkatkan Kualitas Informasi Laporan Keuangan. Jurnal Ilmiah Akuntansi Kesatuan, 4(1), 035–047. https://doi.org/10.37641/jiakes.v2i1.100

Downloads

Published

2022-08-23

How to Cite

Setiawan, R. A., Mursalina, R., Rahmadani, N. P., & Adinugraha, H. H. (2022). Utilization of Microsoft Excel in Assisting the Preparation of Financial Reports at MI Ngalian Tirto Pekalongan. Journal of Innovation and Community Engagement, 3(3), 189–198. https://doi.org/10.28932/ice.v3i3.4904

Issue

Section

Articles