scholarly journals PEMANFAATAN MICROSOFT EXCEL DALAM MEMBANTU PENYUSUNAN LAPORAN KEUANGAN DI TPQ AN-NAJAH TIRTO PEKALONGAN

Al-Khidmat ◽  
2021 ◽  
Vol 4 (1) ◽  
pp. 28-35
Author(s):  
Shohabatussa’adah Shohabatussa’adah ◽  
Muasomah Muasomah
Keyword(s):  
Information Technology ◽  
Learning Process ◽  
Financial Statements ◽  
Education Sector ◽  
Educational Institutions ◽  
Microsoft Excel ◽  
Financial Reports ◽  
Financial Report ◽  
Education Services ◽  
Question And Answer

AbstrakKemajuan  IPTEK  menuntut  sebuah  kewajiban  pada penguasaan  ilmu  di  bidang  tekonologi  informasi  untuk  menghadapi  era globalisasi  ini. Artikel ini membahas mengenai pemanfaatan excel dalam membantu penyusunan laporan keuangan .  Untuk  menunjang  kelancaran  proses pembelajaran  di  lembaga  pendidikan  dalam hal ini di Taman Pendidikan Al-Qur’an (TPQ) diperlukan  suatu  bagian  yang mendukung  kegiatan  tersebut  yaitu  tata  usaha.  Tata  usaha lembaga  pendidikan  merupakan  ujung  tombak  pelayanan  jasa pendidikan  suatu  lembaga yang secara  langsung menangani pelayanan di dalam  internal maupun eksternal. Akan tetapi tenaga tata usaha masih belum cukup baik melayani  administrasi  ketatausahaan karena beberapa hal yang menjadi kendala.Tidak terkecuali bagi bidang pendidikan. Melalui Microsoft Excel,  laporan  keuangan  dapat  disusun  secara  sederhana  dengan siklus yang lebih pendek yaitu dari penyusunan jurnal menjadi laporan keuangan sederhana. Adapun  tujuan  dari  tulisan  ini adalah untuk memberikan pelatihan  mengenai proses penyusunan laporan keuangan melalui Microsoft Excel  agar mengefisiensikan  kinerja  tata  usaha. Metode yang digunakan dalam pengabdian ini meliputi ceramah, tanya jawab dan simulasi. Adapun hasil dari pengabdian ini menunjukkan bahwa pelatihan ini memberikan pengetahuan khususnya bagi tata usaha mengenai proses akuntansi sederhana dengan memanfaatkan excel seperti perekapan, pengelompokan akun, penjurnalan, posting ke buku besar bahkan sampai pada pembuatan laporan keuangan yang dipraktekan secara langsung. AbstractScience and Technology Progress requires an obligation to mastery of science in the field of information technology to face this era of globalization. This article discusses the utilization of Excel in assisting the preparation of financial statements. To support the smoothness of the learning process in educational institutions in this case in the Al-Qur'an Education Park (TPQ), a part that supports the activity, namely administration. Administration of educational institutions is the spearhead of the education services of an institution that directly handles services within the internal and external. However, administration workers are still not quite good at serving the administration of work and some things become obstacles. Not except for the education sector. Through Microsoft Excel, financial statements can be arranged simply with a shorter cycle, namely from the drafting of journals into a simple financial report. The purpose of this paper is to provide training on the process of preparing financial statements through Microsoft Excel to streamline the performance of administration. The method used in this service includes lectures, question and answer and simulation. The results of this service show that this training provides knowledge especially for administration regarding simple accounting processes by utilizing excel such as recipates, grouping accounts, transvuncurements, posts to ledgers even to the manufacture of financial reports directly practiced.

scholarly journals PENDAMPINGAN PENYUSUNAN APLIKASI LAPORAN KEUANGAN MASJID YANG AKUNTABEL SESUAI PSAK 45

2019 ◽  
pp. 139
Author(s):  
Suratman Suratman ◽  
Yulianti Yulianti ◽  
Nirsetyo Wahdi
Keyword(s):  
Accounting Standards ◽  
Financial Statements ◽  
Financial Accounting ◽  
Microsoft Excel ◽  
Financial Reports ◽  
Non Profit ◽  
Financial Report ◽  
The Public ◽  
The People ◽  
Accounting Reports

Abstrak: Tujuan dalam pengabdian ini untuk merancang Aplikasi Laporan Keuangan Masjid  sesuai dengan Standart Akuntansi Keuangan (PSAK-45) agar laporan keungan tersebut dapat dipertanggungjawabkan ada akuntabel  kepada umat yang menginfaqkan sebagain hartanya ke masjid tersebut. Hal tersebut sebagai salah satu pertanggungjawaban ke padada masyarakat pemberi infaq. Tetapi selain itu pengurus masjid juga harus membuat laporan keuangan yang nantinya akan dilaporkan kepada takmir masjid dan kepada semua pengelola tersebut, sehingga harapannya laporan keuangan tersebut dapat disusun secara transparan sehingga tidak ada kecurigaan dari pihak manapun dan lebih-lebih sebagai pertanggungjawaban kepada  Allah SWT. Dalam penyusunan laporan  laporan akuntansi untuk entitas nirlaba telah diatur dalam Pedoman Standar Akuntansi Keuangan (PSAK-45) yang telah disusun oleh Ikatan Akuntan Indonesia (IAI) sebagai penyusun stantar laporan akuntansi, agar laporan keungan tersebut dapat dipertanggungjawabkan kepada masyarakat dan dapat di baca oleh pihak-pihak yang berkepentingan terhadap laporan keuangan tersebut. Kegiatan ini dilaksanakan dalam bentuk penyuluhan dan pendampingan pembuatan laporan keuangan masjid dengan aplikasi laporan keuangan yang  sistematis dengan menggunakan program Microsoft Excel. Dari hasil evaluasi yang telah dailakukan bahwa hasil dari kegiatan ini sudah mampu meningkatan pemahaman dan ketrampilan dalam menyusun laporan keuangan masjid yaitu berupa Laporan Posisi Keuangan, Laporan Aktivitas, Laporan Arus Kas, dan laporan Perubahan Ekuitas.Kata Kunci: Laporan Akuntansi; Akuntabilitas; Keuangan Masjid; PSAK45 Abstract: The purpose of this dedication is to design the Mosque Financial Report Application in accordance with the Financial Accounting Standards (PSAK-45) so that the financial report can be held accountable to the people who make a part of their wealth available to the mosque. This is one of the responsibilities given to the community giving infaq. But besides that the mosque management must also make financial reports that will later be reported to the mosque takmir and to all the managers, so that the financial statements can be arranged transparently so that there is no suspicion from any party and moreover as an accountability to Allah SWT. In preparing the accounting reports for non-profit entities, it has been regulated in the Financial Accounting Standards Guidelines (PSAK-45) that have been prepared by the Indonesian Institute of Accountants (IAI) as a compiler of accounting reports, so that the financial statements can be accountable to the public and can be read by parties parties with an interest in the financial statements. This activity was carried out in the form of outreach and assistance in making mosque financial reports with the systematic application of financial reports using the Microsoft Excel program. From the evaluation results that have been carried out that the results of this activity have been able to increase understanding and skills in preparing the mosque's financial statements in the form of Financial Position Reports, Activity Reports, Cash Flow Statements, and Equity Change reports.Keywords: Accounting Reports; Accountability; Mosque Finance; PSAK45.

scholarly journals Penggunaan Microsoft Excel Dalam Penyusunan Laporan Keuangan Untuk Meningkatkan Kualitas Informasi Laporan Keuangan

2020 ◽  
Vol 4 (1) ◽  
pp. 035-047
Author(s):  
Triandi . ◽  
Marina Agustin
Keyword(s):  
Financial Statements ◽  
Daily Basis ◽  
Financial Statement ◽  
Managerial Decision ◽  
Microsoft Excel ◽  
Financial Reports ◽  
Financial Report ◽  
Financial Conditions ◽  
User Friendly ◽  
Qualitative Characteristics

Compiling a financial reportis important because through this statement both external and internal parties may acquire informations about the firm’s financial conditions and its performance. These informations can then be used to make managerial decision for the sake of the firm’s future.   Building an accounting program corresponding to the company’s specific needs can be very expensive and time consuming, not to mention the trials and errors along the way. It takes great efforts to finally come up with ideal accounting program. To solve this issue, Microsoft Excel application provides affordable, simple, fast and accountable accounting program. The aim of this research are to investigate a proper qualitative characteristics of a financial report, to maximize the function of Microsoft Excel application in smaller firms for the purpose of providing a financial statement. The results show that Excel can enchance the informations contained in CV Inovasi Infinita’s financial statements. This application helps with its fast, accurate, complete, user friendly and details. Thus the owner can easily analyse each transaction on the daily basis. The application helps contributing in providing better financial reports.

scholarly journals PEMBERDAYAAN PENGELOLA LEMBAGA EKONOMI KOMUNITAS ADAT MELALUI PENGUASAAN TEKNOLOGI INFORMASI DI DESA JUNGUT KABUPATEN KLUNGKUNG, BALI

2019 ◽  
Vol 2 (1) ◽  
pp. 21-34
Author(s):  
IDA AYU WIDANI SUGIANINGRAT ◽  
PUTU KRISNA ADWITYA SANJAYA ◽  
PUTU NURATAMA
Keyword(s):  
Information Technology ◽  
Human Resources ◽  
Significant Contribution ◽  
Industrial Revolution ◽  
Financial Statements ◽  
Microfinance Institutions ◽  
Financial Reports ◽  
Financial Report ◽  
Long Run ◽  
Implementation Method

Village Credit Institutions are quite capable of accelerating the economy of traditional village manners to advance and make a significant contribution to village development. But in the midst of the frenzy of the era of digitalitation revolution 4.0 characterized by automation demanding a movement for renewal in the LPD in order to be able to compete with similar institutions. The fundamental problems of LPD that are most prominent are the capacity of Human Resources in terms of management, use of information technology, especially in the preparation of financial statements. In the digitalization era, every business actor must prepare himself to enter the 4.0 industrial revolution. For this reason, business actors are expected to maximize the use of information technology, one of which is in the preparation of financial statements. However, currently there are not many microfinance institutions that use information technology to carry out the recording of their financial statements. LPD still records finance conventionally. Of course this if it is not immediately followed up will pose a risk of loss in the future. Solution to problem solving is done by conducting socialization, mentoring the preparation of financial statements. The implementation method is carried out in several stages, beginning to provide an understanding of the importance of the use of information technology, conducting training in information technology-based financial report training, lastly assisted to solve problems related to the preparation of financial statements. The hope after this activity ends is that LPD is able to carry out its business activities independently to prepare financial reports and carry out evaluations of business activities and in the long run the LPD will develop and be able to torch accelerate the economy of the local village.

scholarly journals EFFECT OF VILLAGE APPARATUS PERFORMANCE, INTERNAL CONTROL, INFORMATION TECHNOLOGY UTILIZATION ON VILLAGE FUND ACCOUNTABILITY AND IMPLICATIONS ON QUALITY VILLAGE FINANCIAL REPORT

2021 ◽  
Vol 2 (4) ◽  
pp. 569-580
Author(s):  
Budi Hendaris ◽  
Romli Romli
Keyword(s):  
Information Technology ◽  
Internal Control ◽  
Technology Use ◽  
Financial Statements ◽  
Fund Management ◽  
Financial Reports ◽  
Financial Report ◽  
Survey Techniques ◽  
The Village

Village Fund is a new policy, so it needs good accountability. As a form of responsibility for village fund management, it is necessary to make quality financial statements. This study aims to analyze the effect of village apparatus performance, internal control, and information technology on fund management accountability and its implications for the quality of financial reports. This research used quantitative and retrieval methods using survey techniques. It was conducted using 117 respondents as officials in charge of compiling financial reports in West Bandung Regency villages. Furthermore, data analysis was performed using  SEM PLS with PLS 3.0. The results showed that the village apparatus performance, internal control, and information technology use affected fund management accountability and the quality of financial reports. The research results imply that creating quality village financial statements required village apparatus performance, internal control, use of information technology, and fair accountability

scholarly journals Literasi Pelaporan Keuangan Pengurus Masjid Untuk Meningkatkan Transparansi Dan Akuntabilitas Keuangan Masjid

1970 ◽  
Vol 13 (2) ◽  
pp. 25-39
Author(s):  
Ulfi Maryati ◽  
Sukartini ◽  
Amy Fontanella ◽  
Armel Yentifa ◽  
Ermataty Hatta5
Keyword(s):  
Community Service ◽  
Financial Literacy ◽  
Financial Statements ◽  
Microsoft Excel ◽  
Financial Reports ◽  
Non Profit ◽  
Financial Report ◽  
Hr Management ◽  
Managed Funds ◽  
Preparation Module

Increasing the financial literacy of mosque administrators plays an important role to increase accountability and transparency in managing mosque finance. It is caused the mosque functions not only as a place of worship but also as a center for social activities of the community using funds originating from the community. Every rupiah of community funds used must be accounted to the community. Therefore, the existence of accounting used in the process of recording and preparing mosque financial reports is very vital. This Community service is held at the Imaduddin Mosque, which is one of the educational reference mosques in Padang. All this time, the mosque administrators managed funds in a very large amount. However, the management of these funds has not been supported by adequate financial recording and reporting, which make dissatisfaction to the funders. This is due to the limited competence of HR management and lack of understanding about  recording and financial statements. To solve this problems, training will be provided for recording and preparing financial reports and simple applications for preparing financial statements. The output of this community service is to increase financial literacy and to train mosque administrators in recording and preparing financial reports. The approach offered to the partner is workshops and financial report training for non-profit organizations using Microsoft Excel. It is also produced a financial report preparation module which can be guided by the mosque management.

scholarly journals Design of financial statement preparation based on SAK EMKM using microsoft excel

2020 ◽  
Vol 2 (1) ◽  
pp. 141
Author(s):  
Ifa Rosania Afif ◽  
Nawirah Nawirah
Keyword(s):  
Qualitative Data ◽  
Market Access ◽  
Financial Statements ◽  
Financial Statement ◽  
Affecting Factors ◽  
Microsoft Excel ◽  
Financial Reports ◽  
Financial Report ◽  
Financial Position ◽  
Income Statement

<p class="IABSSS"><strong>Purpose</strong> - Micro, Small and Medium-sized Enterprises (MSMEs) are a pillar of the Indonesian economy, as evidenced by the ability of MSMEs to save the economy in Indonesia during the monetary crisis in 1998. There was a significant increase in the number of MSMEs in Indonesia, inseparable from the problems that caused the failure of MSME actors. Among the affecting factors are the simple management, lack of supervision of the production process and the quality caused by the system on the entity, the simple recording of financial statements, and limited market access. The purpose of this study is to facilitate the MSMEs XXX in preparing financial statements based on SAK EMKM using Microsoft Excel software.</p><p class="IABSSS"><strong>Method </strong>- This research uses a qualitative approach. The location of this research is MSMEs XXX which is located on Sunan Muria II Street No. 16 Malang. The data collection uses observation and interview techniques directly to researchers, the analytical method used is hermeneutics which means an approach to analyze and interpret data centered on the meaning of qualitative data.</p><p class="IABSSS"><strong>Result</strong> - The design of financial report preparation based on SAK EMKM using Microsoft Excel in MSMEs XXX includes income statement, financial position report, and notes on financial statements. The MSMEs found problems in preparing the financial statements because of the lack of adequate resources and supporting software.</p><p class="IABSSS"><strong>Implication</strong> - UMKM xxx is expected to be able compile financial statements based on SAK EMKM with microsoft excel software.</p><strong>Originality</strong> - This research is the first study at UMKM xxx by making financial reports based on SAK EMKM with microsoft excel software .

scholarly journals Pendampingan Penyusunan Laporan Keuangan Akuntansi Pesantren

2021 ◽  
Vol 1 (1) ◽  
pp. 84-88
Author(s):  
Valentina Monoarfa
Keyword(s):  
Financial Management ◽  
Boarding School ◽  
Boarding Schools ◽  
Religious Organizations ◽  
Educational Institutions ◽  
Financial Reports ◽  
Non Profit ◽  
Question And Answer

Islamic boarding school is one of the educational institutions of non-governmental non-profit religious organizations that prioritizes a service to external parties. The financial management of Islamic boarding schools still uses simple methods, accounting that has been used so far has not used financial reports that are in accordance with Islamic boarding school accounting guidelines. The purpose of this service is to provide additional knowledge to financial managers in compiling financial reports using software in order to provide transparent, accountable and accountable reporting. The method of implementing the activity is counseling, discussion and question and answer, which begins with providing knowledge about how to prepare Islamic boarding school accounting financial reports.

scholarly journals The Improving Model of the Quality of Financial Statements and Successful Implementation of Local Financial Information Systems

2020 ◽  
Vol 1 (2) ◽  
pp. 128-144
Author(s):  
Irfan Irfan ◽  
◽  
Eka Nurmala Sari ◽  
Muhyarsyah Muhyarsyah ◽  
Siti Irafah ◽  
...  
Keyword(s):  
Information System ◽  
Internal Audit ◽  
Financial Statements ◽  
Financial Information ◽  
Successful Implementation ◽  
City Governments ◽  
Financial Reports ◽  
Financial Report

his study aims to (1) examine and analyze the influence of Human Resource (SDM) competence and the role of internal audit on the successful implementation of the Local Financial Information System (SKID) partially and simultaneously, (2) examine and analyze the competence of SDM and the role of internal audit on the quality of financial report partially and simultaneously,(3) examine and analyze the influence of SDM competence and the role of internal audit on the quality of financial reports on the successful implementation of the SKID. The object of this study is all provincials and district / city governments throughout North Sumatera. The sample of this study was 34 (thirty four). The data was collected by questionnaire, documentation, and interview methods. The analysis method used was path analysis using SPSS Program. The results of this study indicate that (1) SDM competence and the role of internal audit have no partial effect on the successful implementation of SKID (2) SDM competence, the role of internal audit doesn’t simultaneously affect the successful implementation of SKID (3) SDM competence and the role of internal audit have a significant effect partially to the quality of financial reports (4) the successful implementation of SKID has no effect on the quality of financial reports (5) SDM competence, the role of internal audit, the successful implementation of SKID simultaneously affects the quality of financial reports (6) SDM competence and the role of internal audit have no effect on quality financial reports through the successful implementation of the local financial information system.

scholarly journals Faktor Determinan Ketepatan Waktu Penyampaian Laporan Keuangan Perusahaan Pertambangan di Indonesia

2021 ◽  
Vol 9 (1) ◽  
pp. 80
Author(s):  
Marfuah Marfuah ◽  
Sakilah Sakilah ◽  
Priyono Puji Prasetyo
Keyword(s):  
Audit Committee ◽  
Sampling Method ◽  
Stock Exchange ◽  
Institutional Ownership ◽  
Financial Statements ◽  
Financial Reports ◽  
Audit Opinion ◽  
Financial Report ◽  
Mining Companies ◽  
Positive Effect

This study aims to analyze the effect of profitability, firm size, institutional ownership, audit committee, audit opinion, and company age on the timeliness of financial report submission. The sample used in this study consisted of 26 mining companies listed on the Indonesia Stock Exchange for the period 2015-2018. The sampling method in this study was using purposive sampling method, so 104 samples were selected for 4 years. Hypothesis testing is done using logistic regression. The results of this study indicate that profitability has a significant positive effect on the timeliness of submitting financial statements, while company size, institutional ownership, audit committee, audit opinion and company age have no significant effect on the timeliness of submitting financial reports to mining companies in Indonesia. The results of this study contribute to report users that profitability is an important factor in encouraging the timeliness of the submission of corporate financial reports. Keywords: Audit Committee; Audit Opinion; Institutional Ownership; Profitability; Timeliness.

scholarly journals FINANCIAL REPORT PREPARATION TRAINING FOR RT (NEIGBOHOOD UNIT) DEVICES IN RW (HAMLET UNIT) ENVIRONMENT 16 BAROS CITY CIMAHI VILLAGE

Competitive ◽  
2018 ◽  
Vol 13 (1) ◽  
pp. 87
Author(s):  
Kharaningrum Mulyanti ◽  
Riani Tanjung ◽  
Yohanes Casmadi
Keyword(s):  
Community Service ◽  
Central Government ◽  
Good Governance ◽  
Financial Statements ◽  
Social Institution ◽  
Governance System ◽  
Financial Reports ◽  
Financial Report ◽  
Neighborhood Association ◽  
Government Accounting

A good governance system is not only a responsibility that must be carried out by the central government, Neighborhood association as the smallest social institution even responsible for implementing the good governance. One form of implementation can be implemented in the form of financial statements in the area. The implementation of good governance has not been fully realized in all RT neighborhoods in Cimahi City, one of them in RW 16, Baros Village. The Community Service activities are expected to increase the awareness of the neighborhood administrators to prepare financial reports in accordance with the rules of simple government accounting standards. The methods used in this activity include lectures, tutorials, and discussions. This PKM activity went well and got good enthusiasm from the RT administrators, and it was hoped that this activity would be the beginning of the implementation of a good governance system.   Sistem pemerintahan yang baik bukan hanya tanggung jawab yang harus diemban oleh pemerintah pusat, Rukun tetangga sebagai Lembaga kemasyarakatan terkecil sekalipun bertanggung jawab dalam pelaksanaan good governance tersebut. Salah satu bentuk dari pelaksanaannya dapat diimplementasikan dalam bentuk pelaporan keuangan yang ada di area-nya. Pelaksanaan good governance belum sepenuhnya terwujud di seluruh lingkungan RT di Kota Cimahi, salah satunya di RW 16 Kelurahan Baros. Kegiatan Pengabdian Kepada Masyarakat ini diharapkan dapat meningkatkan kesadaran para pengurus RT untuk menyusun laporan keuangan sesuai dengan kaidah standar akuntansi pemerintahan yang sederhana. Metode yang digunakan dalam kegiatan ini meliputi ceramah, tutorial, dan diskusi. Kegiatan PKM ini berjalan lancar dan mendapatkan antusias yang baik dari para pengurus RT, dan diharapkan kegiatan ini menjadi awal dari terlaksananya sistem pemerintahan yang baik

Sign in / Sign up

Export Citation Format

Share Document