Executive Dashboard

Overview of key performance indicators and system status

🔔3
A
Admin
👤Active Connections
28,456
▲ 4.2% from last month
💰Revenue Collected
৳12,458,760
▲ 8.6%
📄Pending Bills
৳3,245,670
▼ 2.1%
📊Collection Eff.
86.3%
▲ 5.3%
⚠️Complaints
342
▼ 6.3%
Resolved
298
▲ 10.8%
📝New Applications
156
▲ 7.1%
🏘️LIC Households
8,756
▲ 12.4%

Revenue Collection Trend (৳)

Payment Channel Distribution

Complaint Status Overview

Open
78
78
In Progress
64
64
Resolved
298
298
Escalated
12
12

Connections by Ward (Top 5)

Ward 27
4,256
Ward 12
3,842
Ward 18
3,256
Ward 09
2,987
Ward 03
2,765

Pending Bills (Top 5)

View All →
Customer IDNameWardDue (৳)Days
CUST-001254MD. Abu Taher274,85045
CUST-001768Nasima Begum123,25038
CUST-002332Jamal Uddin182,98032
CUST-000987Rina Akter092,45031
CUST-002118Selina Parvin032,25030

Long Due Pending (Over 90 Days)

View All →
Customer IDNameWardDue (৳)Days
CUST-000345Abdul Karim277,850128
CUST-000567Shahinur Alam126,240112
CUST-000789Musa Miah185,730105
CUST-000246Halim Ahamed095,210101
CUST-000135Monowara Begum034,98096

Budget Overview

💵
Budget Received
৳120,000,000
📤
Budget Utilized
৳76,540,000
Budget Pending
৳43,460,000
📊
Utilization %
63.78%
📋
Bills Generated This Month
32,845
Bills Paid This Month
28,356
🎯
Collection Efficiency
86.3%
Total Arrears Outstanding
৳3,245,670
🗂️
Avg. Complaint Resolution
2.4 Days
Avg. Application Processing
3.6 Days
Customer IDNameWardAddressMeter No.Connection TypeBalance (৳)StatusActions
CUST-001254MD. Abu Taher27House 12, Road 4, CumillaMTR-2254Residential-4,850Overdue
CUST-001768Nasima Begum12Flat 3B, Shasongacha, CumillaMTR-1768Residential-3,250Overdue
CUST-003012Rahman Trading Co.18Plot 8, Industrial ZoneMTR-3012Commercial+1,200Active
CUST-000345Abdul Karim27Village Chandina, Ward 27MTR-0345Residential-7,850Defaulter
CUST-004501City Hospital09Medical Road, Cumilla CityMTR-4501Institutional+500Active
CUST-005890Fatema Khatun03House 5, Kotwali, CumillaMTR-5890LIC0LIC

New Water Connection Application

Fill in all required fields to submit a new connection request

👤 Applicant Information

📍 Connection Address

🔧 Connection Details

Generate Water Bill

Enter meter reading and usage details to generate a bill

🔍 Customer Lookup

📊 Customer Details (Auto-filled)

💲 Tariff & Charges

Collect Payment

Process bill payment for a customer

🔍 Find Customer Bill

💳 Payment Details

🏦
Bank / Cash
📱
bKash / Nagad
💳
Card
🌐
Online Portal

Outstanding Amount

৳ 4,850
Bill No: BILL-2025-21254 | Due: 15 Apr 2025

👤 Customer Info

Customer IDCUST-001254
NameMD. Abu Taher
WardWard 27
Meter No.MTR-2254
ConnectionResidential
Mobile01712-XXXXXX
Overdue Since45 days
Previous PaymentsOn time (8/12)
All Complaints
Lodge New
In Progress
Resolved

No water supply for 3 days

CUST-001254 — MD. Abu Taher, Ward 27

Open

Water supply has been completely cut for 3 consecutive days. Family of 5 heavily affected.

📅 Received: 18 May 2025🔖 CMP-2025-342Category: Supply Disruption

Meter reading dispute

CUST-003012 — Rahman Trading Co., Ward 18

In Progress

Bill amount for April unusually high. Suspect meter malfunction. Requesting re-inspection.

📅 Received: 15 May 2025🔖 CMP-2025-338Category: Billing Dispute

Pipeline leak near Road 4

CUST-002332 — Jamal Uddin, Ward 18

Resolved

Major pipeline leak causing road damage. Resolved on 10 May 2025 by maintenance team.

📅 Received: 08 May 2025🔖 CMP-2025-320Resolved in: 2 days

Water quality issue – brown/discolored water

CUST-004501 — City Hospital, Ward 09

Escalated

Discolored water received since 16 May. Critical issue for hospital operations. Escalated to senior management.

📅 Received: 16 May 2025🔖 CMP-2025-341⚡ Escalated to: Chief Engineer

Lodge New Complaint

Register a customer complaint for follow-up and resolution

👤 Complainant Details

📝 Complaint Details

Pending Bills

All outstanding and overdue water bills

Bill No.CustomerWardBill MonthAmount (৳)Due DateOverdue DaysStatusAction
BILL-2025-21254MD. Abu Taher (CUST-001254)27March 20254,85015 Apr 202545Overdue
BILL-2025-18768Nasima Begum (CUST-001768)12April 20253,25022 Apr 202538Overdue
BILL-2025-23320Jamal Uddin (CUST-002332)18April 20252,98028 Apr 202532Pending
BILL-2025-20987Rina Akter (CUST-000987)09April 20252,45029 Apr 202531Pending
BILL-2025-00345Abdul Karim (CUST-000345)27Jan 20257,85010 Feb 2025128Defaulter

Reports

Generate and download system reports

📊

Monthly Revenue Report

Revenue collection, channel-wise breakdown, and trends

📋

Pending Bills Report

List of all overdue and outstanding bills by ward

⚠️

Complaint Analysis

Complaint category-wise breakdown and resolution time

🔌

Connection Status Report

Active, inactive, and new connections by ward

🏘️

LIC Households Report

Low-income household connections and subsidy usage

💰

Budget Utilization Report

Budget allocation, spend, and variance analysis

Bank Reconciliation

Match and reconcile payment records with bank statements

📥 Import Bank Statement

📋 Reconciliation Summary – May 2025
Transaction IDDateCustomerSystem Amount (৳)Bank Amount (৳)StatusAction
TXN-0520-00120 May 2025Rahman Trading Co.3,5003,500Matched
TXN-0519-04819 May 2025City Hospital8,2008,200Matched
TXN-0518-01218 May 2025Rina Akter2,4502,400Mismatch
TXN-0517-03317 May 2025Fatema Khatun800Missing

Inclusion & LIC Program

Low Income Community water supply management

🏘️LIC Households
8,756
▲ 12.4%
💧Subsidized Connections
6,230
▲ 8.1%
💵Subsidy Amount (৳)
1,245,000
▲ 3.5%
Payment Rate
72.4%
▼ 1.2%

➕ Register New LIC Household

System Admin

Manage users, roles, and system configuration

👤 Add New User

🔧 Tariff Configuration

CategorySlab (m³)Rate (৳/m³)
Residential0 – 10
Residential11 – 20
CommercialAll
IndustrialAll
LIC / Subsidized0 – 5

System Settings

Configure system preferences and notifications

🏢 Organization Settings

🔔 Notification Settings