Introduction
Penalty is levied from on the consumer if in case the consumer fails to make the payment for the bill raised before a the specified due date. The consumer has to make the full payment before due date to avoid penalty charges. The number of days after which the penalty is applicable should be is configurable at the ULB level. The penalty calculation logic may differ from one state or ULB to another.
The penalty can be -
Fixed amount
Percentage: When it is a percentage, it can be levied on
Entire bill amount
Balance pending when partial payments have been made
Data Table
Sr. No. | *Penalty based on (Bill amount/Balance pending) | *Grace period (days) | *Penalty flat amount (Rs) | *Penalty (%) |
|---|---|---|---|---|
1 | Balance Pending | 15 | 40 | 10 |
Note: Data given in the The above table is a contains sample water penalty rate data.
Procedure
Data Definition
Sr. No. | Column Name | Data Type | Data Size | Mandatory | Description |
|---|---|---|---|---|---|
1 | Grace period | Integer | 2 | Yes | After the bill is generated, certain days are provided to the citizen for making the payment |
2 | Penalty flat amount | Decimal | (3,2) | Yes | If penalty is not levied on percentage basis, it is generally a flat fee which is penalty charges amount |
3 | Penalty based on | Text | 64 | Yes | Penalty can be a certain percentage of the bill amount or balance pending, if partial payments are made against the bill |
4 | Penalty (%) | Decimal | (3,2) | Yes | Penalty is calculated as a percentage amount based on either Bill amount or Balance pending |
Steps to create Water Penalty Rates master data table
Download the data template attached to this page.
Get a good understanding of all the headers in the Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.In case of any doubt, please .
Please reach out to the person who has shared this template with you to discuss and clear your doubts.
Get information about the type of penalty calculation logic that is followed
Get information about the grace period
Get information about flat fee(if applicable), penalty percentage, and what is penalty based onEnter an appropriate value for Penalty Based On.
Enter a value for the Grace Period.
Enter the Penalty Flat Amount.
Enter the Penalty value in percent.
Verify the data once again by going through the checklist and making sure that each and every point mentioned in the checklist is covered.
Checklist
The checklist is contains a set of activities to be performed one once the data is filled into a template to ensure data type, size, and format of data is as per the expectationentry requirements are met. These activities have been divided into 2 groups as given below.
Common Checklist
This checklist covers all the activities which are common across the entities.
Sr. No. | Checklist Parameter | Example |
|---|---|---|
1 | Make sure that each and every point in this reference list has been taken care of. |
Entity Specific Checklist
Entry Separate Entity Specific Checklist is not required separatelyfor this module data.