Skip to main content
journal@msti-indonesia.com 081377790601
Register
Articles

Development of a Water Bill Arrears Information System Based on Microsoft Access and Visual Basic 6.0 for PDAM Tirta Mon Krueng Baro

  • 1* STMIK Indonesia Banda Aceh

* Corresponding Author: M. Yasir Aulia

Open Access
DOI
https://doi.org/10.59431/jda.v3i1.526
Published
Pages
32–42

Issue

Vol. 3 No. 1 (2024)

Journal Dekstop Application (JDA)
June

Abstract

This study addresses the development of an automated water bill arrears management system for PDAM Tirta Mon Krueng Baro, aiming to replace the previous manual method that relied on Microsoft Excel. The old system resulted in errors, delays in report generation, and difficulties in tracking overdue payments, which impacted both financial management and customer service. The newly designed system utilizes Microsoft Access and Visual Basic 6.0 to streamline data entry, reduce errors, and enable efficient tracking of overdue bills. With a structured database and normalized tables, the system improves data accuracy, eliminates redundancy, and speeds up reporting processes. The adoption of this system ensures real-time updates and quicker decision-making, which enhances financial management. The user-friendly interface and automated features facilitate smooth implementation and greater user acceptance. By transitioning to a computerized system, PDAM Tirta Mon Krueng Baro can enhance operational efficiency, minimize errors, and improve customer satisfaction. The study demonstrates the positive impact of adopting modern technology to optimize service delivery in public utilities, offering a more effective approach to managing billing processes and overdue payments. 

Keywords

Water Bill Arrears Information System Development PDAM Microsoft Access Visual Basic 6.0 System Automation

How to Cite

Aulia, M. Y. (2024). Development of a Water Bill Arrears Information System Based on Microsoft Access and Visual Basic 6.0 for PDAM Tirta Mon Krueng Baro. Journal Dekstop Application (JDA), 3(1), 32–42. https://doi.org/10.59431/jda.v3i1.526

References

  • Alfaris, L., Gustian, D., Setyorini, R., Romli, I., Putri, A. Y. P., Herjuna, S. A. S., Syamsiyah, N., Yuniansyah, Aziza, N., Muhammad, A. C., Umar, N., & Wali, M. (2022). Riset Operasi. Indie Press.
  • Anam, C., Susanto, H., Yanto, D., & R.G., F. (2023). Pengembangan sistem informasi pelayanan masyarakat desa (simpelmase) berbasis web. Jeecom Journal of Electrical Engineering and Computer, 5(2), 310-318. https://doi.org/10.33650/jeecom.v5i2.6966
  • Aviska, A. (2022). Analisis pengelolaan dan pengendalian piutang pada perusahaan umum daerah air minum tirta dharma purbaya kabupaten madiun. JAPP, 2(2). https://doi.org/10.24269/japp.v2i2.5687
  • Ayuningbumi, N. and Julianto, I. (2023). Sistem informasi akuntansi dalam prosedur penagihan pembayaran rekening air pelanggan pada perusahaan umum daerah air minum tirta hita buleleng. Jurnal Ilmiah Akuntansi Dan Humanika, 13(2), 299-311. https://doi.org/10.23887/jiah.v13i2.61475
  • Baskoro, D., Maipita, I., Fitrawaty, F., & Dongoran, F. (2023). Digitalisasi sistem informasi dan administrasi desa sebagai upaya menuju desa cerdas di desa kolam, percut sei tuan, deli serdang, sumatera utara. Dinamisia Jurnal Pengabdian Kepada Masyarakat, 7(3), 624-635. https://doi.org/10.31849/dinamisia.v7i3.14339
  • Cut, B., Nazar, N., & Husna, J. (2023). Sistem informasi pembayaran tagihan air pada desa baet meusago kecamatan sukamakmur berbasis web. Jurnal Sintaks Logika, 3(2), 1-5.
  • Humairoh, A. P., Listari, S., & Syarif, R. (2021). Sistem Penagihan Rekening Air Pelanggan Pada Perusahaan Umum Daerah Air Minum Tirta Pakuan Kota Bogor. Jurnal Aplikasi Bisnis Kesatuan, 1(1), 41-50.
  • Humairoh, A., Listari, S., & Syarif, R. (2021). Sistem penagihan rekening air pelanggan pada perusahaan umum daerah air minum tirta pakuan kota bogor. Jurnal Aplikasi Bisnis Kesatuan, 1(1), 41-50. https://doi.org/10.37641/jabkes.v1i1.566
  • Karyaningsih, D., Hakim, Z., & Pratama, A. G. (2020). Rancang Bangun Sistem Informasi Tagihan Rekening Air pada PDAM pandeglang. SITUSTIKA FIKUNMA, 9(1), 310-315.
  • Kurniawan, R., Rifaâ€TMi, J., & Muslim, M. (2018). Analisis dan perancangan sistem informasi penerbitan surat di pdam tirta moedal kota semarang cabang timur. Techno Com, 17(2), 145-157. https://doi.org/10.33633/tc.v17i2.1646
  • Mahendra, G. S., Wali, M., Idwan, H., Listartha, I. M. E., Yuliastuti, G. E., Sasongko, D., Saskara, G. A. J., & Jude, G. A. (2022, Oktober 1). Keamanan Komputer. Galiono Digdaya.
  • Malau, E. P., & Lahagu, R. S. E. (2017). Pengembangan Ssistem Pembayaran Rekening Air Pada Desa Bandar Baru. Jurnal Teknik Informatika UNIKA Santo Thomas, 72-78.
  • Mirza, D., Suryani, L., Latip, L., & Aditiya, V. (2023). Literature riview: peran teknologi informasi dalam meningkatkan efisiensi dan efektivitas birokrasi. Jurnal Administrasi Publik Dan Bisnis, 5(1), 51-55. https://doi.org/10.36917/japabis.v5i1.84
  • Pratama, A., Piarsa, I., & Wibawa, K. (2020). Prototipe sistem prabayar pdam terpadu menerapkan teknologi internet of thing. Jusikom Jurnal Sistem Komputer Musirawas, 5(2), 82-95. https://doi.org/10.32767/jusikom.v5i2.1002
  • Prawira, T., Hasdiana, H., & Tarawiru, Y. (2024). Pengaruh pengendalian intern terhadap tunggakan tagihan rekening air pada pam tirta karajae kota parepare. ak99, 4(1), 73-82. https://doi.org/10.31850/ak99.v4i1.3071
  • Rahmaniar, R. (2023). Optimalisasi sistem penagihan air untuk pelanggan menunggak di pdam tirta daroy kota banda aceh. EKALAYA, 1(4), 73-80. https://doi.org/10.59966/ekalaya.v1i4.1104
  • Tarmon, R. I., & Inggi, R. (2021). Perancangan sistem informasi pembayaran tagihan rekening pdam kota kendari secara online. Jurnal Sistem Informasi dan Sistem Komputer, 6(2), 83-94.
  • Wali, M. (2017). Membangun Aplikasi Windows dengan Visual BASIC .NET® 2015 Teori dan Praktikum. Lembaga KITA.
  • Wali, M. (2018). Add-ins Microsoft Office: Add-ins Microsoft Office. Kita Publisher.
  • Wali, M. (2020). Modul Praktikum Rekayasa Perangkat Lunak. Ellunar Publisher.
  • Wali, M., Nengsih, T. A., Gunawan Hts, D. I., Choirina, P., Awaludin, A. A. R., Yusuf, M., Aminuddin, F. H., Purwandari, N., & Baradja, A. (2023, Maret 3). Pengantar 15 Bahasa Pemrograman Terbaik Di Masa Depan (Referensi & Coding Untuk Pemula). PT. Sonpedia Publishing Indonesia.
  • Wijayanto, G., Jushermi, Sakkir, G., Sukmasetya, P., Arikarani, Y., Leo, M., Safitri, N. M., Wali, M., Luthfiana, D., Zaenurrohman, J. A., Vikaliana, R., Madiawati, P. N., & Sianipar, M. Y. (2022). Analisis dan Interpretasi Data Riset Berbasis Digital. Dalam Metode Riset Berbasis Digital: Penelitian Pasca Pandemi. Media Sains Indonesia.

Author Biographies

  • M. Yasir Aulia, STMIK Indonesia Banda Aceh

    Informatics Management Study Program, STMIK Indonesia Banda Aceh, Banda Aceh City, Aceh Province, Indonesia

License

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

This is an open-access journal. All articles are distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

Under this license, you are free to:

  • Share: Copy and redistribute the material in any medium or format.
  • Adapt: Remix, transform, and build upon the material for any purpose, even commercially.

Attribution Requirements:
You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.

Copyright and Retention:
Authors retain copyright without restrictions and grant this journal the right of first publication under an open-access model. The journal retains non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

Usage Statistics