Web-based Billing and Collection System for a Municipal Water and Services Unit


Web-Based Billing and Collection System for a Municipal Water and Services Unit is a system that sought to address the problem of a municipal water unit. Using the technology, meter reading will be paperless. It can be accessible through the Internet; end-users and water consumers/customers could connect and perform
transactions enabling them to become efficient on their daily tasks whether in the office or at home. The head of the unit can make overall viewing of the status of daily transactions and can be viewed using desktop, laptop computers and android mobile devices connected to the internet. The water consumers/customers may
receive email and short messaging system showing their current water consumption and water bill. Added/unique features such as graphical chart showing regular water consumptions on the end-users and consumers/customers dashboard as well as on their billing statements are provided. On the level of satisfaction of the respondents on the features of the proposed billing and collection system; result show that efficiency
earned the highest weighted mean (4.43) interpreted as “satisfied”. Functionality posed weighted arithmetic mean (4.33) verbally interpreted as “satisfied”. Portability and reliability followed next. On the level of acceptance of the proposed billing and collection system; respondents’ acceptance according to consumer accounts updating gauged at 4.35 weighted arithmetic mean with verbal interpretation of “acceptable”.
Auto-reminding the consumers for bills due for payment posed a 4.37 weighted arithmetic mean and was also “acceptable”. According to billing statement printing and free format report generation, respondents recorded 4.45 weighted arithmetic mean and interpreted as “acceptable”.

Keywords: billing system, ewater, municipal water, web-based billing, collection system.

[1] Agrawal, P. C. (2008). Developing Effective Billing and Collection Practices. India: WSP - Water and Sanitation Program.

[2] APA Quick Citation Guide. (2016 updated, February 12). Retrieved 2 2016, March, from psu.libguides.com: http://psu.libguides.com/apaquickguide/intext

[3] Berners-Lee, T. (2009). Net Neutrality and the Freedom of the Internet. Retrieved June 12, 2009, from youtube.com: https://www.youtube.com/watch?v= Jev2Um-4_TQ

[4] Beverungen, D., Matzner, M., & Janiesch, C. (2016). Information systems for smart services. Retrieved from springer.com: https://link.springer.com/article/10.1007/ s10257-017-0365-8

[5] Billing and Payment Management. (2016). Retrieved March 1, 2016, from cusi.com: http://www.cusi.com/software/cisutility-billing/

[6] Chua, B. B., & Dyson, L. E. (2004, November 22). Applying the ISO 9126 model to the evaluation of an e-learning system. Retrieved March 6, 2016, from http://www. ascilite.org/: http://www.ascilite.org.au/conferences/perth04/procs/chua.html

[7] CodeIgniter. (2006). Retrieved March 16, 2016, from ellislab.com: https://ellislab. com/codeigniter

[8] Ecclesiastes 1:9. (2011). Electronic Filipino Bible. Philippines: The Philippine Bible Society.

[9] Enriquez, J. R. (2014). A Cloud-Based Billing and Monitoring System for an Electric Company. Manila, Philippines: Unpublished Masteral Thesis.

[10] Guillermo, J. B. (2013, March 23). Water district improves billing, collection system. The Daily Guardian, p. 1.

[11] Idioms. (n.d.). Retrieved March 16, 2016, from thefreedictionary.com: http://idioms. thefreedictionary.com/

[12] Integrated Billing and Collection System. (2002). Retrieved March 13, 2016, from infodynamics.com.ph: http://infodynamics.com.ph/ integrated-billing-and-collection-system/

[13] LIWAD (2003). Retrieved March 13, 2016, from LIWAD: http://www.liwad.gov.ph/ services/technology.php

[14] MySQL. (2016). Retrieved March 16, 2016, from MySQL.com: http://www.mysql. com/about/

[15] MyWaterBill. (2009). Retrieved March 2, 2016, from mywaterbill.maynilad.com.ph: https://mywaterbill.mayniladwater.com.ph/

[16] Naval, Victoria C. Dr.; Mercado, Joseph, Dr.; Bautista, Leodegario SM., Engr.; Reyes, Danilo T., Dr. (2009). Table-2 Sample Sizes Required for Given Population Sizes. In Module on RSH 631 - Research Seminar II (pp. 24-25).

[17] Newborn, P. (2011). Pipes and people: Progress in water supply in Burkina Faso’s cities. Burkina Faso, Africa: Overseas Development Institute.

[18] Organizing the Review. (2016 updated, January 21). Retrieved March 16, 2016, from libguides.bc.edu: http://libguides.bc.edu/litreview/phase5

[19] QuikWater. (2015). Retrieved January 10, 2016, from quikwaters.com: http:// quikwaters.com/

[20] SDLC - Software Prototype Model. (2016). Retrieved March 1, 2016, from tutorialspoint.com: http://www.tutorialspoint.com/sdlc/sdlc_software_prototyping.htm

[21] Spot Billing Machine. (2015). Retrieved December 11, 2016, from www.reiljp.com: www.reiljp.com

[22] UBSplus® ”Lite” Water Billing Software. (2009). Retrieved March 12, 2016, from utility-billing.net: http://www.utility-billing.net/water-billing-software-lite.htm

[23] Water & Sewer Billing & Collections. (2009). Retrieved March 16, 2016, from waterbilling.fultoncountyga.gov: https://waterbilling.fultoncountyga.gov/

[24] Water Bill. (2015). Retrieved March 14, 2016, from ccwd.com: http://www.ccwd. com.ph/Water_Bill.html

[25] Water Billing & Collection. (n.d.). Retrieved March 14, 2016, from cityofgoosecreek.com: http://www.cityofgoosecreek.com/137/Water-Billing-Collection

[26] Weighted Arithmetic Mean. (2015). Retrieved March 18, 2016, from emathzone.com: http://www.emathzone.com/tutorials/basic-statistics/ weighted-arithmetic-mean.html

[27] What is PHP? (2001-2016). Retrieved March 1, 2016, from PHP.net: http://php.net/ manual/en/intro -whatis.php