20 - M.S Rapayadeen (10 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-01 | 373 | 379 | 6 | 5.00 | 0.00 | 1,630.00 | 0.00 |
0 |
0.00 | May-2024 | Pending | |||
| 2 | May 2024 | 2024-06-17 | 379 | 384 | 5 | 0.00 | 0.00 | 2,130.00 | 0.00 |
2,130 |
C936044308 |
0.00 |
Cash |
June-2024 | Paid | |
| 3 | June 2024 | 2024-07-03 | 384 | 391 | 7 | 580.00 | 0.00 | 580.00 | 0.00 |
0 |
0.00 | July-2024 | Pending | |||
| 4 | July 2024 | 2024-08-01 | 391 | 422 | 31 | 2,250.00 | 0.00 | 2,830.00 | 0.00 |
0 |
0.00 | August-2024 | Pending | |||
| 5 | August 2024 | 2024-09-01 | 422 | 464 | 42 | 3,350.00 | 0.00 | 6,180.00 | 0.00 |
6,500 |
C3593115546 |
-320.00 |
Cash |
September-2024 | Paid | |
| 6 | September 2024 | 2024-10-02 | 464 | 518 | 54 | 4,550.00 | 0.00 | 4,230.00 | 0.00 |
0 |
0.00 | October-2024 | Pending | |||
| 7 | October 2024 | 2024-11-01 | 518 | 550 | 32 | 2,350.00 | 0.00 | 6,580.00 | 0.00 |
0 |
0.00 | November-2024 | Pending | |||
| 8 | November 2024 | 2024-12-02 | 550 | 582 | 32 | 2,350.00 | 0.00 | 8,930.00 | 0.00 |
9,000 |
C7486085013 |
-70.00 |
Cash |
December-2024 | Paid | |
| 9 | December 2024 | 2025-01-03 | 582 | 623 | 41 | 3,250.00 | 0.00 | 3,180.00 | 0.00 |
0 |
0.00 | January-2025 | Pending | |||
| 10 | January 2025 | 2025-02-01 | 623 | 648 | 25 | 1,650.00 | 0.00 | 4,830.00 | 0.00 |
0 |
0.00 | February-2025 | Pending | |||
| 11 | February 2025 | 2025-03-04 | 648 | 693 | 45 | 3,650.00 | 0.00 | 8,480.00 | 0.00 |
8,480 |
C13300114701 |
0.00 |
Cash |
March-2025 | Paid | |
| 12 | March 2025 | 2025-04-01 | 693 | 740 | 47 | 3,850.00 | 0.00 | 3,850.00 | 0.00 |
0 |
0.00 | April-2025 | Pending | |||
| 13 | April 2025 | 2025-05-02 | 740 | 772 | 32 | 2,350.00 | 0.00 | 6,200.00 | 0.00 |
0 |
0.00 | May-2025 | Pending | |||
| 14 | May 2025 | 2025-06-03 | 772 | 805 | 33 | 2,450.00 | 0.00 | 8,650.00 | 0.00 |
0 |
0.00 | June-2025 | Red | |||
| 15 | June 2025 | 2025-07-02 | 805 | 836 | 31 | 2,250.00 | 0.00 | 10,900.00 | 0.00 |
10,000 |
C18347135820 |
1,900.00 |
Cash |
July-2025 | Partial | |
| 16 | July 2025 | 2025-08-01 | 836 | 873 | 37 | 2,850.00 | 0.00 | 4,750.00 | 0.00 |
0 |
0.00 | August-2025 | Pending | |||
| 17 | August 2025 | 2025-09-02 | 873 | 918 | 45 | 3,650.00 | 0.00 | 8,400.00 | 0.00 |
0 |
0.00 | September-2025 | Pending | |||
| 18 | September 2025 | 2025-10-02 | 918 | 1,051 | 133 | 12,450.00 | 0.00 | 20,850.00 | 0.00 |
0 |
0.00 | Octomber-2025 | Red | |||
| 19 | October 2025 | 2025-11-02 | 1,051 | 1,081 | 30 | 2,150.00 | 0.00 | 23,000.00 | 0.00 |
24,000 |
C22358101551 |
0.00 |
Cash |
November-2025 | Paid | |
| 20 | November 2025 | 2025-12-01 | 1,081 | 1,119 | 38 | 2,950.00 | 0.00 | 2,950.00 | 0.00 |
0 |
0.00 | December-2025 | Pending | |||
| 21 | December 2025 | 2026-01-03 | 1,119 | 1,150 | 31 | 2,250.00 | 0.00 | 5,200.00 | 0.00 |
0 |
0.00 | January-2026 | Pending | |||
| 22 | January 2026 | 2026-02-03 | 1,150 | 1,194 | 44 | 3,550.00 | 0.00 | 8,750.00 | 0.00 |
0 |
0.00 | February-2026 | Red | |||
| 23 | February 2026 | 2026-03-03 | 1,194 | 1,246 | 52 | 4,350.00 | 0.00 | 13,100.00 | 0.00 |
14,100 |
H17332 |
0.00 |
Cash |
March-2026 | Paid | |
| 24 | March 2026 | 2026-04-05 | 1,246 | 1,317 | 71 | 6,250.00 | 0.00 | 6,250.00 | 0.00 |
0 |
0.00 | April - 2026 | Pending | |||
| 25 | April 2026 | 2026-05-02 | 1,317 | 1,367 | 50 | 4,150.00 | 0.00 | 10,400.00 | 0.00 |
0 |
0.00 | May - 2026 | Pending | |||
| 26 | May 2026 | 2026-06-01 | 1,367 | 1,432 | 65 | 5,650.00 | 0.00 | 16,050.00 | 0.00 |
17,050 |
C29539151726 |
0.00 |
Cash |
June - 2026 | Paid | |
| 27 | June 2026 | 2026-07-02 | 1,432 | 1,475 | 43 | 3,450.00 | 0.00 | 3,450.00 | 0.00 |
3,500 |
C30545090407 |
-50.00 |
Cash |
July - 2026 | Paid | |
| 28 | July 2026 | 2026-08-01 | 1,475 | 1,514 | 39 | 3,050.00 | 0.00 | 3,000.00 | 0.00 |
0 |
0.00 | August- 2026 | Pending | |||