Training For The Preparation of Financial Statements By Using Microsoft Excel For Students of SMK Muhammadiyah 9 Jakarta

Authors

  • Reni Hariyani Akademi Sekretari Budi Luhur
  • Eny Retnoningrum Universitas Budi Luhur
  • Tio Prasetio Universitas Budi Luhur

Keywords:

Laporan Keuangan, Microsoft Excel, SMK Muhammadiyah 9 Jakarta

Abstract

The preparation of financial reports follows the development of Information and Communication Technology (ICT) in today's digital era. The availability of various features and formula formulas that are presented in spreadsheet form in Microsoft Excel can help in completing the accounting cycle process. This training was given before the Covid-19 pandemic hit Indonesia. The training participants were students of the XI class of Accounting Department Muhammadiyah 9 Vocational High School (SMK) Jakarta. The problem that exists in the partner's place is that the development of ICT has not been optimally utilized in teaching and learning activities in the field of accounting. The methods provided in this training are by giving lectures and practical methods in operating Microsoft Excel to compile financial reports. The purpose of this Community Service activity is to provide practical knowledge in using Microsoft Excel to compile a company's financial statements. The result of the implementation of this training activity is that students can compile general journals, ledgers, trial balances and financial reports using Microsoft Excel. Participants have benefited greatly from this training in making financial reports using Microsoft Excel faster, easier, more accurate and efficient.

References

Chandra, Novrina, S. (2015). Rancangan Pembukuan Akuntansi Berbasis Excel for Accounting Pada Koperasi Jasa Keuangan Syariah (KJKS). Jurnal Akuntansi Dan Manajemen, 10(1), 13–24.

Diba, F., & Marini, M.-. (2020). Penerapan Laporan Keuangan Berbasis Excel pada Bengkel Las Bina Logam. Prosiding Seminar Nasional Akuntansi (SENA) III, 3(1), 257–266. http://openjournal.unpam.ac.id/index.php/SNU/article/view/7700/4993

Triandi, & Agustin, M. (2016). 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

Zahara, Sukartini, Amy, F., Eliyanora, & Yossi, S. (2013). Perancangan Model Penyusunan Laporan Keuangan Perusahaan dengan Program Excell For Accounting(EFA). Simposium Nasional Akuntansi Vokasi Ke-2, 648–660.

Downloads

Published

2021-03-23

Issue

Section

Articles