Architecture of the Village Budget Reporting Information System Utilizing the CodeIgniter Framework and a Multi-User Role-Based Access Control Approach

I Gusti Agung Oka Sudiadnyani; Made Pradnyana Ambara; I Made Riyan Adi Nugroho; I Made Agus Oka Gunawan

doi:10.24036/jtip.v20i1.1158

Authors

I Gusti Agung Oka Sudiadnyani Politeknik Negeri Bali
Made Pradnyana Ambara Politeknik Negeri Bali
I Made Riyan Adi Nugroho Politeknik Negeri Bali
I Made Agus Oka Gunawan Politeknik Negeri Bali

DOI:

https://doi.org/10.24036/jtip.v20i1.1158

Keywords:

APBDesa, Public Accountability, Digital Audit Trail, CodeIgniter Framework, Role-Based Access Control

Abstract

Digital transformation in village financial management requires a reporting system with high data integrity to support transparent supervisory functions. In Karangasem Regency, particularly in the pilot locus of Sibetan Village, the management of the Village Revenue and Expenditure Budget (APBDesa) faced challenges with data synchronization, administrative errors, and barriers to conventional audits. This study developed an audit-oriented APBDesa reporting information system architecture that integrates Multi-User Role-Based Access Control (RBAC) and automated logging mechanisms. System requirements were identified and validated through direct observation involving three key stakeholders representing the main reporting roles: the Head of Financial Affairs, the Village Head, and the External Auditor. System development followed four sequential Waterfall phases (requirements, design, implementation, and verification). The system was implemented using the CodeIgniter framework with a Model-View-Controller architecture. Black-box evaluation by five technical testers was organized into seven principal module-level test cases corresponding to authentication, dashboard, revenue management, expenditure management, verification and approval, RBAC, and external-auditor monitoring; all achieved a 100% functional success rate. The system enforced segregation of duties among the Head of Financial Affairs, the Village Head, and the External Auditor while supporting a structured digital audit workflow. These results indicate that embedded role controls and audit stages can strengthen data integrity, traceability, and accountability in APBDesa reporting.

References

M. Lavenia and M. T. Hidayat, “Analisis Transfaransi dan Akuntabilitas Pengelolaan Anggaran Pendapatan Belanja Desa (APBDes) di Desa Sirapan Kecamatan Madium Kabupaten Madium,” vol. 10, no. 204, pp. 2217–2227, 2025.

A. Haris, “Transformasi Digital Pengelolaan Anggaran Dana Desa ; Studi Tentang E- Budgeting , Transparansi dan Partisipasi Masyarakat Pendahuluan,” vol. 5, no. 1, pp. 28–37, 2025.

Anisa, A. Handayani, and K. Faozi, “Digitalisasi Pengelolaan Keuangan Desa : Analisis Implementasi Aplikasi Keuangan pada BUMDes Bebedahan Berkah,” J. Akuntansi, Ekon. dan Manaj. Bisnis, 2025.

S. Kadoka, J. Wolu, and Y. Rada, “Development of a Financial Management Information System for Village Income and Expenditure Budgets Based on Object Oriented Analysis and Design Pengembangan Sistem Informasi Pengelolaan Keuangan Anggaran Pendapatan dan Belanja Desa Berbasis Object Orient,” Indones. J. Mach. Learn. Comput. Sci., vol. 4, no. April, pp. 443–451, 2024.

S. Purwanti and B. Architecture, “Perancangan Arsitektur Enterprise Pendahuluan Kajian Teori,” vol. 13, no. 01, pp. 81–91, 2026.

M. Efrina, “Prosedur Sistem Pengendalian Intern Atas Nota Kredit Divisi Umum Pada PT Bank Pembangunan Daerah Jambi Kantor Pusat,” J. Media Akad., vol. 4, no. 6, 2026.

A. K. Nasich, S. A. Wicaksono, and M. C. Saputra, “Implementasi Role Based Access Control ( RBAC ) dalam Sistem Informasi Manajemen Pelanggan dan Pembayaran Air Berbasis Web ( studi pada PT Tirta Wangi Sejahtera ),” J. Pengemb. Teknol. Inf. dan Ilmu Komput., vol. 9, no. 9, pp. 1–9, 2025.

E. R. Susanto et al., “Analisis Implementasi Sistem Keamanan Basis Data Berbasis Role-Based Access Control ( RBAC ) pada Aplikasi Enterprise Resource Planning,” J. Sains Teknol. dan Sist. Inf., vol. 5, no. 1, pp. 105–116, 2025, doi: 10.54259/satesi.v5i1.3997.

E. N. and Yanti, “Sistem Informasi Akuntansi Berbasis WEB sebagai Transparansi dan Sinkronisasi dalam Pengelolaan BUMDES Kabupaten Karawang,” J. Akunt. Akuisisi, vol. 18, no. 1, pp. 74–85, 2022.

B. O. Perdiyana and R. Alit, “Penerapan Metode Rapid Application Development ( RAD ) Pada Aplikasi Administrasi Desa Tunjungmekar Berbasis,” vol. 07, pp. 382–388, 2025.

D. Pratmanto, S. Aji, I. Tazali, M. Hasani, and Y. P. L, “Pengembangan Sistem Informasi Anggaran Desa Berbasis Cloud untuk Meningkatkan Transparansi dan Partisipasi Masyarakat dalam Pengelolaan Keuangan Desa,” Indones. J. Softw. Eng., vol. 10, no. 2, pp. 123–130, 2024.

Y. S. Rahayu, Y. Saputra, and D. Irawan, “Implementasi Metode Waterfall Pada Pengembangan Sistem Informasi Mobile E-Disarpus,” J. Sist. Inf., vol. 6, no. 2, pp. 523–534, 2024.

L. F. Ulya, Z. Ruscitasari, and J. J. Ekonomi, “Digitalisasi Keuangan Desa dan Akuntabilitas : Menilai Dampak Implementasi Siskeudes di Desa Dawung Kecamatan Tegalrejo Kabupaten Magelang Abstrak,” J. Ekon. Manajemen, dan Akunt., vol. 11, no. 5, pp. 3464–3477, 2025.

A. Sansprayada, R. A. Aziz, K. Mariskhana, and I. D. Sintawati, “Implementasi Internal System Menggunakan Framework CodeIgniter ( CI ) Studi Kasus PT Ampera Abadi,” J. Minfo Polgan, vol. 14, pp. 2295–2302, 2025.

I. K. Naryasa, G. Ngurah, M. Nata, and J. Santoso, “Sistem Informasi Manajemen Desa Berbasis Web Menggunakan Framework Codeigniter4,” Pros. Semin. Has. Penelit. Inform. dan Komput., vol. 1, no. 2, pp. 754–759, 2024.

Y. Anis, A. B. Mukti, and A. N. Rosyid, “Penerapan Model Waterfall Dalam Pengembangan Sistem Informasi Aset Destinasi Wisata Berbasis Website,” Kaji. Ilm. Inform. dan Komput. ISSN 2723-3898 (Media Online) Vol 4, No 2, Oktober 2023, Hal 1134-1142 DOI 10.30865/klik.v4i2.1287, vol. 4, no. 2, pp. 1134–1142, 2023, doi: 10.30865/klik.v4i2.1287.

dan F. Maria Sri Wulandari, Rahayu Noveandini, “Penerapan Model View Controller Berbasis Framework Codeigniter Pada Sistem Penjualan (Studi Kasus : Toko Jaya Motor),” J. Ilm. KOMPUTASI, Vol. 23 No 2, Juni 2024, p-ISSN 1412-9434/e-ISSN 2549-7227, vol. 21, no. 4, pp. 319–330, 2024.