RANCANGAN SISTEM INFORMASI AKUNTANSI PERSEDIAAN KOPERASI PAGUYUBAN KARYAWAN DEKABE JAWA TIMUR
DOI:
https://doi.org/10.26593/be.v27i2.6132.161-176Abstract
The rapid development of information technology has brought changes to all aspects of individuals and organizations, one of which is cooperatives. The Cooperative Association of Pakar Dekabe employees (Pakar Dekabe Cooperative), has trading and service business activities. Its trading business activities are related to buying, selling, and managing merchandise inventory that require recording and reporting. Recording sales as inventory expenditure is still done manually. Inventory is updated at the end of the current month period. This has an impact on inventory information that is not up-to-date and there is the potential for physical discrepancies to occur in recording. In this regard, the purpose of this study is to develop an inventory accounting information system through the Excel for Accounting (EFA) application to produce financial information accurately and qualified for stakeholders. The result of this study is the design of the EFA with the development of the number of working sheets from three become 11 sheets in order to detail the recording transactions, avoid the occurrence of physical discrepancies and recording inventory and also simplify the process of preparing financial reports as part of the internal control implementation.
References
Ahmar, N. (2021). Aplikasi EFA (Excel For Accounting) untuk Laporan Keuangan Pesantren. CAPACITAREA : Jurnal Pengabdian Kepada Masyarakat, 1(02), 104–109. https://doi.org/10.35814/capacitarea.v1i02.2022
Al-Delawi, A. S., & Ramo, W. M. (2020). The Impact of Accounting Information System on Performance Management. Polish Journal of Management Studies, 21(2), 36–48. https://doi.org/10.17512/pjms.2020.21.2.03
Ali, B. J. A. (2020). Information Quality and Data Quality in Accounting Information System: Implications on the Organization Performance. International Journal of Psychosocial Rehabilitation, 24(5), 3258–3269. https://doi.org/10.37200/ijpr/v24i5/pr202034
Ali, B. J. A., & Abu-AlSondos, I. A. (2020). Operational Efficiency and The Adoption of Accounting Information System (AIS): A Comprehensive Review of The Banking Sectors. International Journal of Management, 11(6), 221–235.
Aprilia Nita, R., & Ahmar, N. (2015). The Writing, Observing and Getting Approach dalam Menciptakan Keunggulan Kompetitif Praktik Akuntansi Berbasis Excel for Accounting. Jurnal Riset Akuntansi & Perpajakan (JRAP), 2(02). https://doi.org/10.35838/jrap.v2i02.109
Arlindayani, E. V., Yutanto, H., & Sihotang, E. T. (2022). Nominal: Barometer Riset Akuntansi dan Manajemen. 11(1).
Carter, N., Bryant-Lukosius, D., Dicenso, A., Blythe, J., & Neville, A. J. (2014). The Use of Triangulation in Qualitative Research. Oncology Nursing Forum, 41(5), 545–547. https://doi.org/10.1188/14.ONF.545-547
Cooper, D. R., & Schindler, P. S. (2014). Business Research Methods 12th Edition. In Business Research Methods (Twelfth Ed). McGraw-Hill Companies, Inc, NY.
Farquhar, J., Michels, N., & Robson, J. (2020). Triangulation in Industrial Qualitative Case Study Research: Widening The Scope. Industrial Marketing Management, 87(5), 160–170. https://doi.org/10.1016/j.indmarman.2020.02.001
Fitrios, R. (2016). Factors That Influence Accounting Information System Implementation And Accounting Information Quality. International Journal of Scientific & Technology Research, 5(4), 192–198.
Ikatan Akuntan Indonesia. (2018). Pernyataan Standar Akuntansi Keuangan No. 14 Persediaan. Jakarta: Dewan Standar Akuntansi Keuangan, 14(14).
Jusoh, S. N., & Ahmad, H. (2019). Usage Of Microsoft Excel Spreadsheet As Accounting Tools In SME Company. INWASCON Technology Magazine, 1, 23–25. https://doi.org/10.26480/itechmag.01.2019.23.25
Kania, E., & Irawan, A. (2021). Penyusunan Laporan Keuangan UMKM Berdasarkan SAK EMKM Berbantuan Microsoft Excel Pada UMKM Uncal Co. Indonesian Accounting Literacy Journal, 01(02), 338–352.
Khan, D. A. K., Faisal, Dr. S. M., & Aboud, D. O. A. Al. (2018). An Analysis of Optimal Inventory Accounting Models - Pros and Cons. European Journal of Accounting, Auditing and Finance Research, 6(3), 65–77.
Kieso, D. E., Kimmel, P. D., & Weygandt, J. J. (2018). Financial Accounting: Tools for Business Decision Making (4th ed.). John Wiley & Sons, Inc.
Lucy Onyekwelu, U., Lucy, U., & Ugwuanyi Boniface, U. (2014). Effects of IFRS Adoption on Inventory Valuation and Financial Reporting In Nigeria. European Journal of Business and Management, 6(8), 29–34.
Marliani, R., & Santoso, K. (2018). Perancangan Sistem Informasi Persediaan di Koperasi Brimob Polda Jabar Jatinangor I. AIMS: Jurnal Accounting Information System, 1(1), 32–48. https://doi.org/10.32627/aims.v1i1.24
Monarasi, S., & Yutanto, H. (2021). Rancang Bangun Penyusunan Laporan Keuangan Bagi UMKM Somano Berbasis EFA (Excel For Accounting). Wahana, 73(2), 103–118. https://doi.org/10.36456/wahana.v73i2.4358
Perdana, A J, Anjaswani, M, Prasetyo, A, Solecha, K. (2022). Rancang Bangun Sistem Informasi Akuntansi Dengan Metode Waterfall Untuk Memudahkan Laporan Pada Koperasi Warung Kita Pamijahan Bogor. Journal of Accounting Information System, 2(1), 10–17.
Sari, N., & Purwanegara, H. (2016). The Effect of Quality Accounting Information System in Indonesian Government (BUMD at Bandung Area). Decision-Making, 7(2), 176–187.
Thottoli, M. M. (2021). Knowledge and Use of Accounting Software: Evidence From Oman. Journal of Industry-University Collaboration, 3(1), 2–14. https://doi.org/10.1108/jiuc-04-2020-0005
Undang-Undang Republik Indonesia Nomor 25 Tahun 1992 Tentang Perkoperasian, Lembaran Negara Republik Indonesia (1992).
Willis, V. F. (2016). A Model for Teaching Technology: Using Excel in an Accounting Information Systems Course. Journal of Accounting Education, 36(9), 87–99. https://doi.org/10.1016/j.jaccedu.2016.05.002
Wulanditya, P., & Aprillianita, R. (2018). The Development Of Accounting Information System Based On Excel in Helping CV. Ladi Collection Preparing Their Financial Statement. JEMA: Jurnal Ilmiah Bidang Akuntansi Dan Manajemen, 15(01), 71–84. https://doi.org/10.31106/jema.v15i01.778
Yusmaniarti, Y., & Ekowati, S. (2019). Laporan Keuangan Koperasi Berbasis Media Excel For Accounting (EFA). Jurnal Pengabdian Masyarakat Bumi Raflesia, 2(1), 127–137. https://doi.org/10.36085/jpmbr.v2i1.294