863/C - I.M. Niyas (20 points)
Water Consumer Ledger
| # | Billing Month | Reading Date | Previous Reading | Current Reading | Consumption Unit | Month Amount | Extra Charges | Payable Amount | Discount | Paid Amount | Balance | Payment Type | Billing Round | Status | Action | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amount | Bill Number | |||||||||||||||
| 1 | April 2024 | 2024-05-30 | 16 | 29 | 13 | 5.00 | 0.00 | 1,600.00 | 0.00 |
0 |
0.00 | May-2024 | Pending | |||
| 2 | May 2024 | 2024-06-29 | 29 | 40 | 11 | 5.00 | 0.00 | 2,350.00 | 0.00 |
0 |
0.00 | June-2024 | Pending | |||
| 3 | June 2024 | 2024-07-29 | 40 | 52 | 12 | 800.00 | 0.00 | 3,150.00 | 0.00 |
2,350 |
B2168093606 |
800.00 |
Bank |
July-2024 | Partial | |
| 4 | July 2024 | 2024-08-28 | 52 | 67 | 15 | 950.00 | 0.00 | 1,750.00 | 0.00 |
0 |
0.00 | August-2024 | Pending | |||
| 5 | August 2024 | 2024-09-28 | 67 | 96 | 29 | 2,050.00 | 0.00 | 3,800.00 | 0.00 |
0 |
0.00 | September-2024 | Pending | |||
| 6 | September 2024 | 2024-10-29 | 96 | 192 | 96 | 8,750.00 | 0.00 | 12,550.00 | 0.00 |
0 |
0.00 | October-2024 | Red | |||
| 7 | October 2024 | 2024-11-28 | 192 | 205 | 13 | 850.00 | 0.00 | 13,400.00 | 0.00 |
0 |
0.00 | November-2024 | Red | |||
| 8 | November 2024 | 2024-12-30 | 205 | 220 | 15 | 950.00 | 0.00 | 14,350.00 | 0.00 |
5,000 |
B9042113656 |
9,350.00 |
Bank |
December-2024 | Partial | |
| 9 | December 2024 | 2025-01-28 | 220 | 233 | 13 | 850.00 | 0.00 | 10,200.00 | 0.00 |
5,200 |
H16846 |
5,000.00 |
Cash |
January-2025 | Partial | |
| 10 | January 2025 | 2025-02-26 | 233 | 248 | 15 | 950.00 | 0.00 | 5,950.00 | 0.00 |
0 |
0.00 | February-2025 | Pending | |||
| 11 | March 2025 | 2025-03-29 | 248 | 263 | 15 | 950.00 | 0.00 | 6,900.00 | 0.00 |
0 |
0.00 | March-2025 | Pending | |||
| 12 | March 2025 | 2025-04-28 | 263 | 278 | 15 | 950.00 | 0.00 | 7,850.00 | 0.00 |
0 |
0.00 | April-2025 | Red | |||
| 13 | April 2025 | 2025-05-28 | 278 | 292 | 14 | 900.00 | 0.00 | 8,750.00 | 0.00 |
10,000 |
C16865120741 |
-250.00 |
Cash |
May-2025 | Paid | |
| 14 | May 2025 | 2025-06-30 | 292 | 311 | 19 | 1,190.00 | 0.00 | 940.00 | 0.00 |
1,000 |
C18253093650 |
-60.00 |
Cash |
June-2025 | Paid | |
| 15 | June 2025 | 2025-07-28 | 311 | 329 | 18 | 1,130.00 | 0.00 | 1,070.00 | 0.00 |
0 |
0.00 | July-2025 | Pending | |||
| 16 | July 2025 | 2025-08-29 | 329 | 346 | 17 | 1,070.00 | 0.00 | 2,140.00 | 0.00 |
0 |
0.00 | August-2025 | Pending | |||
| 17 | August 2025 | 2025-09-29 | 346 | 360 | 14 | 900.00 | 0.00 | 3,040.00 | 0.00 |
3,040 |
C21270144529 |
0.00 |
Cash |
September-2025 | Paid | |
| 18 | September 2025 | 2025-10-29 | 360 | 371 | 11 | 750.00 | 0.00 | 750.00 | 0.00 |
0 |
0.00 | Octomber-2025 | Pending | |||
| 19 | October 2025 | 2025-11-29 | 371 | 385 | 14 | 900.00 | 0.00 | 1,650.00 | 0.00 |
0 |
0.00 | November-2025 | Pending | |||
| 20 | November 2025 | 2025-12-29 | 385 | 396 | 11 | 750.00 | 0.00 | 2,400.00 | 0.00 |
2,450 |
C24257091514 |
-50.00 |
Cash |
December-2025 | Paid | |
| 21 | December 2025 | 2026-01-29 | 396 | 401 | 5 | 500.00 | 0.00 | 450.00 | 0.00 |
500 |
C25283133057 |
-50.00 |
Cash |
January-2026 | Paid | |
| 22 | January 2026 | 2026-02-28 | 401 | 402 | 1 | 380.00 | 0.00 | 330.00 | 0.00 |
400 |
C26369113048 |
-70.00 |
Cash |
February-2026 | Paid | |
| 23 | March 2026 | 2026-03-30 | 402 | 402 | 0 | 350.00 | 0.00 | 280.00 | 0.00 |
0 |
0.00 | March-2026 | Pending | |||
| 24 | March 2026 | 2026-04-29 | 402 | 411 | 9 | 660.00 | 0.00 | 940.00 | 0.00 |
1,000 |
C28405094932 |
-60.00 |
Cash |
April - 2026 | Paid | |
| 25 | April 2026 | 2026-05-29 | 411 | 427 | 16 | 1,010.00 | 0.00 | 950.00 | 0.00 |
950 |
C29443092231 |
0.00 |
Cash |
May - 2026 | Paid | |
| 26 | May 2026 | 2026-06-27 | 427 | 429 | 2 | 410.00 | 0.00 | 410.00 | 0.00 |
0 |
0.00 | June - 2026 | Pending | |||
| 27 | June 2026 | 2026-07-30 | 429 | 445 | 16 | 1,010.00 | 0.00 | 1,420.00 | 0.00 |
1,450 |
C31519120241 |
-30.00 |
Cash |
July - 2026 | Paid | |
| 28 | July 2026 | 2026-08-28 | 445 | 470 | 25 | 1,650.00 | 0.00 | 1,620.00 | 0.00 |
0 |
0.00 | August- 2026 | Pending | |||
| 29 | August 2026 | 2026-09-28 | 470 | 494 | 24 | 1,570.00 | 0.00 | 3,190.00 | 0.00 |
0 |
0.00 | September-2026 | Pending | |||
| 30 | September 2026 | 2026-10-28 | 494 | 523 | 29 | 2,050.00 | 0.00 | 5,240.00 | 0.00 |
0 |
0.00 | Octomber-2026 | Red | |||