Most people got huge water bills after some time due to COVID-19. I wanted to double-check the calculation because the amount was somewhat big. Unlucky I didn’t find any online calculator that get the job done (there was a one in waterboard, but it has a maximum limit of 60 days). So I went with the default option, Excel. I thought of sharing the excel workbook I used as It might be helpful to others. I really don’t know how the VAT calculation is done, so I used 8%. (Thanks to Madura for the suggested edit)

These are the supporting document I used.

Last updated by .

7 thoughts on “Water Bill Calculator – Sri Lanka”

  1. How do they calculate the unit price for bulk units for residential apartments?
    If they have the internal meters for the houses how could they divide the unit price?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.