Billing and Collections system was analyzed, designed and developed with an in-house programmer last October 2006. The system passes through many renovations until it meets the requirements of the district.

The system comprises of three (3) modules: Frontdesk Account, Teller Account, and the Server Account. These three modules are connected using local area networking (LAN). Every module except the server account can be installed in one or more computer.

Frontdesk module covers the posting of different accomplished job orders like new water service connection, reconnection, recalibration, disconnection, change water meter, reclassification, transfer of tapping, etc. Upon posting, the server or the main database was also updated. The system also generates different reports like Daily Accomplishment Report, Summary List of Customers for Disconnection, Disconnection Orders, etc.

The Teller module accepts and post payments, these updates were also transferred to the main database at the server account. Upon posting of payments, an Official Receipt and Statement of Account were automatically printed. The system can also generate Daily Collection Report and Daily Summary Report.

The server module is the administrator's module. This account is compatible to the Meter Reading Management System (MRMS) of the Computer Handheld device used in reading. This system uploads and downloads information the computer handheld device. Billing reports can be generated from the system such as Billing List, Daily Billing Summary, Daily Transaction Summary, Penalty List, Arrears List, High and Low Report, Aging of Accounts, etc.

This system with the integration of the Read and Bill System cuts the billing cycle from 45-day cycle to 25-day cycle. This also reduces the labor force used in the billing process, hence eliminating work redundancy and promoting work efficiency.