Spreadsheet: 727947d1618227373-index-and-match-formula-error-b1-accounts-apr-2021
Sheet: Flatwise Acct

1 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 5 | 6 |  |  | 10 | 11
 |  |  |  |  |  |  |  |  | 1 BHK | B1-101 | B1-101 Mr. [NAME]
Month & Year | Payment Cut off Date | Maint for 1 BHK | Maint for 2 BHK | Non Occupancy | Covered Parking Charge | Open Parking Charge | Any Other Charge | Reason in Brief for Other Charge | Flat Rented Out? | Non Occupancy Charge | Paid Covered Parking? | Paid Parking Charge | Paid Open Parking? | Open Parking Charge | Any Other Charge? | Maint For the Month | Previous Balance | B1-101 Due This Month | B1-101 Paid This Month | Paid on Date | Payment Details  (EFT, Cheque, Cash) | Cash Receipt Number | Balance | Late Fee | Total Balance
2021-04-01 00:00:00 | 2021-04-26 00:00:00 | 1800 | 2500 | 150 | 500 |  |  |  | Yes |  | None
2021-05-01 00:00:00 | 2021-05-26 00:00:00 | 1800 | 2500 | 150 | 500 |  |  |  | Yes |  | None
2021-06-01 00:00:00 | 2021-06-26 00:00:00 | 1800 | 2500 | 150 | 500 |  |  |  | Yes
2021-07-01 00:00:00 | 2021-07-26 00:00:00 | 1800 | 2500 | 150 | 500
2021-08-01 00:00:00 | 2021-08-26 00:00:00 | 1800 | 2500 | 150 | 500
2021-09-01 00:00:00 | 2021-09-26 00:00:00 | 1800 | 2500 | 150 | 500
2021-10-01 00:00:00 | 2021-10-26 00:00:00 | 1800 | 2500 | 150 | 500
2021-11-01 00:00:00 | 2021-11-26 00:00:00 | 1800 | 2500 | 150 | 500
2021-12-01 00:00:00 | 2021-12-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-01-01 00:00:00 | 2022-01-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-02-01 00:00:00 | 2022-02-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-03-01 00:00:00 | 2022-03-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-04-01 00:00:00 | 2022-04-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-05-01 00:00:00 | 2022-05-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-06-01 00:00:00 | 2022-06-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-07-01 00:00:00 | 2022-07-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-08-01 00:00:00 | 2022-08-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-09-01 00:00:00 | 2022-09-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-10-01 00:00:00 | 2022-10-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-11-01 00:00:00 | 2022-11-26 00:00:00 | 1800 | 2500 | 150 | 500
2022-12-01 00:00:00 | 2022-12-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-01-01 00:00:00 | 2023-01-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-02-01 00:00:00 | 2023-02-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-03-01 00:00:00 | 2023-03-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-04-01 00:00:00 | 2023-04-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-05-01 00:00:00 | 2023-05-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-06-01 00:00:00 | 2023-06-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-07-01 00:00:00 | 2023-07-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-08-01 00:00:00 | 2023-08-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-09-01 00:00:00 | 2023-09-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-10-01 00:00:00 | 2023-10-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-11-01 00:00:00 | 2023-11-26 00:00:00 | 1800 | 2500 | 150 | 500
2023-12-01 00:00:00 | 2023-12-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-01-01 00:00:00 | 2024-01-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-02-01 00:00:00 | 2024-02-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-03-01 00:00:00 | 2024-03-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-04-01 00:00:00 | 2024-04-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-05-01 00:00:00 | 2024-05-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-06-01 00:00:00 | 2024-06-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-07-01 00:00:00 | 2024-07-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-08-01 00:00:00 | 2024-08-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-09-01 00:00:00 | 2024-09-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-10-01 00:00:00 | 2024-10-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-11-01 00:00:00 | 2024-11-26 00:00:00 | 1800 | 2500 | 150 | 500
2024-12-01 00:00:00 | 2024-12-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-01-01 00:00:00 | 2025-01-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-02-01 00:00:00 | 2025-02-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-03-01 00:00:00 | 2025-03-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-04-01 00:00:00 | 2025-04-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-05-01 00:00:00 | 2025-05-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-06-01 00:00:00 | 2025-06-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-07-01 00:00:00 | 2025-07-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-08-01 00:00:00 | 2025-08-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-09-01 00:00:00 | 2025-09-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-10-01 00:00:00 | 2025-10-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-11-01 00:00:00 | 2025-11-26 00:00:00 | 1800 | 2500 | 150 | 500
2025-12-01 00:00:00 | 2025-12-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-01-01 00:00:00 | 2026-01-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-02-01 00:00:00 | 2026-02-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-03-01 00:00:00 | 2026-03-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-04-01 00:00:00 | 2026-04-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-05-01 00:00:00 | 2026-05-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-06-01 00:00:00 | 2026-06-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-07-01 00:00:00 | 2026-07-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-08-01 00:00:00 | 2026-08-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-09-01 00:00:00 | 2026-09-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-10-01 00:00:00 | 2026-10-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-11-01 00:00:00 | 2026-11-26 00:00:00 | 1800 | 2500 | 150 | 500
2026-12-01 00:00:00 | 2026-12-26 00:00:00 | 1800 | 2500 | 150 | 500
2027-01-01 00:00:00 | 2027-01-26 00:00:00 | 1800 | 2500 | 150 | 500
2027-02-01 00:00:00 | 2027-02-26 00:00:00 | 1800 | 2500 | 150 | 500
2027-03-01 00:00:00 | 2027-03-26 00:00:00 | 1800 | 2500 | 150 | 500
 |  | Yes |  | None
 |  | No |  | One
 |  |  |  | Two
 |  |  |  | Three